hi

Alter a table like adding a column increase the size of datatype is stored in system tables,
kindly suggest
regds
paul

Not sure what you are asking, but if you alter a table to add a new column to a table, a row will be inserted into the sysibm.syscolumns catalog table (better to view it via syscat.columns view if using DB2 LUW). There may be some other rows added to the DB2 catalog if you do a certain kind of runstats or if you create any indexes, constraints, FK's etc on the new column.

marcus

i have a sql replication of db whenever there is changes in structure in source ex: column addition etc same has to be done in target means drop and recreate the table,
there are lot of changes in different tables in source to bring same structure in target
want to know which all tables was modified recently in source.
regds
Paul

any way to find out when the table ddl was modified

regds
Paul

I would track the ALTER_TIME value for each table in the DB2 catalog.