Comparing table structures for 100s of tables



IBM's flagship relational database management system

Comparing table structures for 100s of tables

Postby vsgurunath » Thu Jan 17, 2019 11:06 pm

Hello 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
vsgurunath
 
Posts: 7
Joined: Fri Feb 08, 2013 12:04 pm
Has thanked: 0 time
Been thanked: 0 time

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post