Comparing table structures (columns & indexes) for huge number of tables

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
Posts: 6
Joined: Fri Sep 09, 2011 9:45 pm
Location: Chennai, India

Comparing table structures (columns & indexes) for huge number of tables

Post by sivaguru » Thu Jan 17, 2019 10:23 pm

Hello team,

For copying data in a large number of DB2 tables in one Mainframe region to another, 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.

Thank you for sharing your expertise,

Post Reply


Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Mainframe Interview questions

Other References
Mainframe Tools and others