Please enhance the CATMAINT output to actually show what has been done.
Currently when we execute CATMAINT to change the catalog level, the following output is produced:
DSNU000I 083 15:07:58.39 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RELODCAT
DSNU1044I 083 15:07:58.40 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
DSNU050I 083 15:07:58.40 DSNUGUTC - CATMAINT UPDATE LEVEL V13R1M501
DSNU750I 083 15:07:58.43 DSNUECM0 - CATMAINT UPDATE PHASE 1 STARTED
DSNU777I 083 15:07:58.43 DSNUECM0 - CATMAINT UPDATE STATUS - VERIFYING CATALOG IS AT CORRECT LEVEL FOR MIGRATION.
DSNU777I 083 15:07:58.43 DSNUECM0 - CATMAINT UPDATE STATUS - BEGINNING MIGRATION SQL PROCESSING PHASE.
DSNU777I 083 15:08:01.61 DSNUECM0 - CATMAINT UPDATE STATUS - UPDATING DIRECTORY WITH NEW RELEASE MARKER.
DSNU752I 083 15:08:01.67 DSNUECM0 - CATMAINT UPDATE PHASE 1 COMPLETED
DSNU010I 083 15:08:01.96 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
This output doesn't provide any indication as to what has changed in the DB2 catalog or directory.
In order to determine what has changed, we have to execute a BMC Log Master report which provides the following output:
ALTER TABLE SYSIBM.SYSPACKAGE ADD COLUMN: DEPLEVEL CHAR(1) NOT NULL
ALTER TABLE SYSIBM.SYSPACKCOPY ADD COLUMN: DEPLEVEL CHAR(1) NOT NULL
ALTER TABLE SYSIBM.SYSPACKSTMT ADD COLUMN: VALID CHAR(1)
ALTER TABLE SYSIBM.SYSINDEXSPACESTATS ADD COLUMN: REORGTOTALSPLITS INTEGER
ALTER TABLE SYSIBM.SYSINDEXSPACESTATS ADD COLUMN: REORGSPLITTIME BIGINT
ALTER TABLE SYSIBM.SYSINDEXSPACESTATS ADD COLUMN: REORGEXCSPLITS INTEGER
ALTER TABLE SYSIBM.SYSIXSPACESTATS_H ADD COLUMN: REORGTOTALSPLITS INTEGER
ALTER TABLE SYSIBM.SYSIXSPACESTATS_H ADD COLUMN: REORGSPLITTIME BIGINT
ALTER TABLE SYSIBM.SYSIXSPACESTATS_H ADD COLUMN: REORGEXCSPLITS INTEGER
ALTER TABLE SYSIBM.SYSCOPY ADD COLUMN: EVENTID BIGINT
ALTER TABLESPACE DSNDB06.SYSTSTSS LOCKMAX: 0
ALTER TABLESPACE DSNDB06.SYSTSISS LOCKMAX: 0
ALTER TABLESPACE DSNDB06.SYSTSTSH LOCKMAX: 0
ALTER TABLESPACE DSNDB06.SYSTSISS LOCKMAX: 0
ALTER TABLESPACE DSNDB06.SYSTSTSH LOCKMAX: 0
ALTER TABLESPACE DSNDB06.SYSTSISH LOCKMAX: 0
CREATE TABLESPACE DSNDB06.SYSTSPSC CREATOR: SYSIBM PGSIZE: 4 TYPE: UNIVERSAL NUMPARTS: 1 SEGSIZE: 32 MAXPART
CREATE TABLESPACE DSNDB06.SYSTSPSD CREATOR: SYSIBM PGSIZE: 4 TYPE: UNIVERSAL NUMPARTS: 1 SEGSIZE: 32 MAXPAR
CREATE TABLE SYSIBM.SYSPACKSTMTCOPY IN: DSNDB06.SYSTSPSC COLUMNS: 16
CREATE TABLE SYSIBM.SYSPACKSTMTDEP IN: DSNDB06.SYSTSPSD COLUMNS: 13
CREATE INDEX SYSIBM.DSNKTX01 ON: SYSIBM.SYSPACKSTMTCOPY IN: DSNDB06.DSNKTX01 TYPE: NPSI UNIQUE RULE: U
CREATE INDEX SYSIBM.DSNKTX02 ON: SYSIBM.SYSPACKSTMTCOPY IN: DSNDB06.DSNKTX02 TYPE: NPSI UNIQUE RULE: U
CREATE INDEX SYSIBM.DSNKNX01 ON: SYSIBM.SYSPACKSTMTDEP IN: DSNDB06.DSNKNX01 TYPE: NPSI UNIQUE RULE: D
CREATE INDEX SYSIBM.DSNKNX02 ON: SYSIBM.SYSPACKSTMTDEP IN: DSNDB06.DSNKNX02 TYPE: NPSI UNIQUE RULE: D
CREATE TABLESPACE DSNDB06.SYSTSUTL CREATOR: SYSIBM PGSIZE: 16 TYPE: UNIVERSAL NUMPARTS: 1 SEGSIZE: 32 MAXPAR
CREATE TABLE SYSIBM.SYSUTILITIES IN: DSNDB06.SYSTSUTL COLUMNS: 91
CREATE INDEX SYSIBM.DSNULX01 ON: SYSIBM.SYSUTILITIES IN: DSNDB06.DSNULX01 TYPE: NPSI UNIQUE RULE: U
CREATE INDEX SYSIBM.DSNULX02 ON: SYSIBM.SYSUTILITIES IN: DSNDB06.DSNULX02 TYPE: NPSI UNIQUE RULE: D
DROP INDEX SYSIBM.DSNKDX02 ON: SYSIBM.SYSPACKDEP IN: DSNDB06.DSNKDX02 TYPE: NPSI UNIQUE RULE: D
ALTER COMMENT CREATE DROP GRANT LABEL RENAME REVOKE BIND FREE REBIND TRANSFER TOTAL
INDEX 0 0 6 1 0 0 0 0 0 0 0 0 7
TABLE 10 0 3 0 0 0 0 0 0 0 0 0 13
TABLESPACE 4 0 3 0 0 0 0 0 0 0 0 0 7
-------------------------------------------------------------------------------------------------------
TOTAL 14 0 12 1 0 0 0 0 0 0 0 0 27
=======================================================================================================
Is there any chance that CATMAINT can be amended to produce something similar to the above BMC Log Master report please?
Thank you for your help.
Neil Dyer
