Previous Topic: 4.4.4.5.2 Symptom Descriptions

Next Topic: 4.4.4.5.4 Database Delete (DBHDELET)

4.4.4.5.3 Sample Output

A sample report listing for the Database Modification Report follows:


CA MICS Database Health Check 14:00 Monday, September 19, yyyy Symptom Summary Database Title: MICS PRIMARY DATA BASE Database ID and Prefix: P - MDI.U3PUN Count Symptom --------------------------------------------------------------------------- | 115 | Residual database update file | +----------+--------------------------------------------------------------+ | 5 | Dummy file found | +----------+--------------------------------------------------------------+ | 3 | Defined cycles exceeded (dead cycle) | +----------+--------------------------------------------------------------+ | 3 | Incorrect File Location | +----------+--------------------------------------------------------------+ | 3 | Files flagged for deletion | +----------+--------------------------------------------------------------+ | 2 | File not active in unit | +----------+--------------------------------------------------------------+ | 8 | Format found in multiple catalogs of same Library | +----------+--------------------------------------------------------------+ | 1 | Invalid Cycle | +----------+--------------------------------------------------------------+ | 1 | Invalid Incremental Checkpoint dataset | ---------------------------------------------------------------------------

CA MICS Database Health Check 14:00 Monday, September 19, yyyy Delete Report Database Title: MICS PRIMARY DATA BASE Database ID and Prefix: P - MDI.U3PUN Member Timespan Libname Name Delete Reason -------------------------------------------------------------------------------------------- DETAIL PDETAIL BATJOB99 Defined cycles exceeded (dead cycle) BATSFA04 Defined cycles exceeded (dead cycle) HARCPU10 Defined cycles exceeded (dead cycle)

CA MICS Database Health Check 14:00 Monday, September 19, yyyy Symptom Detail Database Title: MICS PRIMARY DATA BASE Database ID and Prefix: P - MDI.U3PUN Timespan(DDNAME): DETAIL(PDETAIL); Dataset Name: MDI.U3PUN.DETAIL Symptom Detail ------------------------------------------------------------------------------------------------------------------ Defined cycles exceeded (dead cycle) File=BATJOB99 Defined Cycles=10 File=BATSFA04 Defined Cycles=01 File=HARCPU10 Defined Cycles=01 Residual database update file File=ACTJCS00 File=ACTJMG00 File=ACTJRN00 File=BATJOB00 File=HARCCU00 File=HARCFC00 File=HARCFD00 File=HARCFH00 File=HARCFP00 File=HARCFR00 Invalid Cycle File=BATJOBQ0 File not active in unit File=AUMTTA00 Invalid Incremental Checkpoint dataset File=RMFCKPTX Dummy file found File=DUMMY Residual database update file File=HARCCU00 File=HARCFC00 File=HARCFD00 File=HARCFH00 File=HARCFP00 Incorrect File Location File=ADMEXC01 should be in PDAYS1 File=ADMEXC02 should be in PDAYS1 File=ADMIHL01 should be in PDAYS1 Residual database update file File=HARCCUW0 File=HARCFPW0 File=HARCFRW0 File=HARCPUW0 Dummy file found File=DUMMY Residual database update file File=BAT_TPM0 File=BATATPM0 File=BATRENM0 File=IMS_ISM0 File=PWRPDAM0 File=PWRPRAM0 File not active in unit File=ACTRSL01 Dummy file found File=DUMMY

CA MICS Database Health Check 14:00 Monday, September 19, yyyy Symptom Detail Database Title: MICS PRIMARY DATA BASE Database ID and Prefix: P - MDI.U3PUN Timespan(DDNAME): OTHER(MCOLIB) Symptom Detail ------------------------------------------------------------------------------------------------------------------ Format found in multiple catalogs of same Library Format=CPLXSID Catalogs=MICSFMTS and USERFMT1 Format=CPLXSIN Catalogs=MICSFMTS and USERFMT1 Format=CPLXZNM Catalogs=MICSFMTS and USERFMT1 Format=DEVTYPS Catalogs=MICSFMTS and USERFMT1 Format=DSORG Catalogs=MICSFMTS and USERFMT1 Format=MONEY Catalogs=MICSFMTS and USERFMT1 Format=TAW Catalogs=USERFMT1 and USERFMT2 Format=YR Catalogs=MICSFMTS and USERFMT1