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,
Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.
1 post • Page 1 of 1
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 Tools and others
- XPEDITER Reference
Explains how we can debug a program
- FILEAID Reference
Explains how to browse , edit and delete datasets
- Change Man Reference
Quick Start tutorial on Changeman
- Abend Reference
Important Abend codes explained
- FaceBook Page
MainframeGurukul FaceBook Page
- LinkedIn Page
MainframeGurkul Linkedin Page