Comparing table structures for 100s of tables
Posted: Thu Jan 17, 2019 11:06 pmHello team,
For copying data in a large number of DB2 tables in one Mainframe region to another using individual unload/load JCLs, I'm currently working on comparing the table structures (columns and indexes). I have been managing to do this in the past when there were only handful of tables to be compared. Right now, I'm supposed to do this for 100s of tables in short span of time.
I have tried accomplishing this by extracting the DDLs through BMC Catalog Manager and by fetching out the COLUMNS and INDEXES from SYSCOLUMNS and SYSINDEXES tables. However, comparing them is posing a great difficulty for me.
Please advise and help me if there is a faster way to compare the table structures.
Note: I have posted the same query on another forum. My sincere apologies if I am causing senior members of the forum to make duplicate effort in guiding me.
Thank you for sharing your expertise,
Sivaguru
For copying data in a large number of DB2 tables in one Mainframe region to another using individual unload/load JCLs, I'm currently working on comparing the table structures (columns and indexes). I have been managing to do this in the past when there were only handful of tables to be compared. Right now, I'm supposed to do this for 100s of tables in short span of time.
I have tried accomplishing this by extracting the DDLs through BMC Catalog Manager and by fetching out the COLUMNS and INDEXES from SYSCOLUMNS and SYSINDEXES tables. However, comparing them is posing a great difficulty for me.
Please advise and help me if there is a faster way to compare the table structures.
Note: I have posted the same query on another forum. My sincere apologies if I am causing senior members of the forum to make duplicate effort in guiding me.
Thank you for sharing your expertise,
Sivaguru