Journal messages

The journal messages in this topic display criteria details for the reports. If you used WHERE clauses or Exceptions records, the journal messages display information about them, too. The product reports the details in the journal only.

To display the journal, perform one of the following actions:

  • Add //JOURNAL DD DUMMY to the NGTUTIL JCL.

    The product sends the journal details to //NGTPRINT DD.

  • Select +JOURNAL(YES) in //UTLPARMS

    The product sends the journal details to //JRNLOUT DD.

You do not need to include either the NGTPRINT DD or the JRNLOUT DD in your JCL. The product adds these DDs to you JCL dynamically.

Note

The journal provides details about all NGT processing. Specific to NGT Utility Manager, the journal details:

  • Results of reading the DB2 RTS tables
  • Results of reading the NGT Utility Manager tables
  • Which NGT Utility Manager records are in use
  • Results of checking of each individual threshold
  • Whether each object has been selected for processing

When a threshold is met, NGT Utility Manager stops checking criteria for that object, selects it for processing, and evaluates the next object.


Journal messages

13:51:45.80 PSVR.COM8ORTS NGTZ315 RTS TABLESPACESTATS TABLE SUCCESSFULLY READ (2 ROWS FOUND).

13:51:45.81 PSVR.SVRDOSQL NGTZ307 RTS CRITERIA DEFINITION SUCCESSFULLY READ:
13:51:45.81 PSVR.SVRDOSQL NGTZ307 TB=BMCNGT.NGT_RTS_CRITERIA

13:51:45.81 PSVR.COM8ORTS NGTZ232 RTS CRITERIA TABLE SUCCESSFULLY READ (34 ROWS FOUND).

13:51:45.81 PSVR.SVRDOSQL NGTZ309 RTS EXCEPTION DEFINITION SUCCESSFULLY READ:
13:51:45.81 PSVR.SVRDOSQL NGTZ309 TB=BMCNGT.NGT_RTS_EXCEPTIONS

13:51:45.81 PSVR.COM8ORTS NGTZ234 RTS EXCEPTION TABLE DOES NOT EXIST OR IS EMPTY.
13:51:45.81 PSVR.COM8ORTS NGTZ235 OBJECT SELECTED FOR RTS PROCESSING:
13:51:45.81 PSVR.COM8ORTS NGTZ235 TS=MVSDXWB.PART0040
13:51:45.81 PSVR.COM8ORTS NGTZ242 RTS CRITERIA TABLE ENTRY (TYPE TS) FOUND FOR OBJECT:
13:51:45.81 PSVR.COM8ORTS NGTZ242 NAME=%.%
13:51:45.81 PSVR.COM8ORTS NGTZ242 PARTITION=0
13:51:45.81 PSVR.COM8ORTS NGTZ244 RTS VALUES FOUND FOR OBJECT (PART 1). RTS TIMESTAMP = 2018-03-19-13.46.06.944424.

13:51:45.81 PSVR.COM8ORTS NGTC096 "-DISPLAY DB(MVSDXWB) SPACE(PART0040) LIMIT(*)"
13:51:45.81 PSVR.COM8ORTS NGTR808 DB.MVSDXWB "RW",TS.PART0040 "",TS.PART0040(1:2) "RW"
13:51:45.81 PSVR.COM8ORTS NGTZ253 RTS REORG TS CRITERIA (AREO): NOT AREO
13:51:45.81 PSVR.COM8ORTS NGTZ253 RTS REORG TS CRITERIA (LAST_PERFORMED_REORG): REORG WAS PERFORMED (2018-03-19-13.46.06.618361).
13:51:45.81 PSVR.COM8ORTS NGTZ253 RTS REORG TS CRITERIA (LAST_PERFORMED_LOADR): NOT CHECKED.
13:51:45.81 PSVR.COM8ORTS NGTZ253 RTS REORG TS CRITERIA (EMPTY_TABLESPACE): NOT EMPTY (200 ROWS).
13:51:45.81 PSVR.COM8ORTS NGTZ253 RTS REORG TS CRITERIA (MAXIMUM_SIZE_PERCENTAGE): NOT CHECKED.
13:51:45.81 PSVR.COM8ORTS NGTZ253 RTS REORG TS CRITERIA (INSERTS_PERCENTAGE): PERCENTAGE (0 %) <= CRITERIA (25 %).
13:51:45.81 PSVR.COM8ORTS NGTZ253 RTS REORG TS CRITERIA (DELETES_PERCENTAGE): PERCENTAGE (0 %) <= CRITERIA (25 %).
13:51:45.81 PSVR.COM8ORTS NGTZ253 RTS REORG TS CRITERIA (UPDATES_PERCENTAGE): NOT CHECKED.
13:51:45.81 PSVR.COM8ORTS NGTZ253 RTS REORG TS CRITERIA (INSERT/DELETE/UPDATE_PERCENTAGE): NOT CHECKED.
13:51:45.81 PSVR.COM8ORTS NGTZ253 RTS REORG TS CRITERIA (CLUSTER SENSITIVITY): <= 0
13:51:45.81 PSVR.COM8ORTS NGTZ253 RTS REORG TS CRITERIA (DISORGED_LOB_PERCENTAGE): PERCENTAGE (0 %) <= CRITERIA (10 %).
13:51:45.81 PSVR.COM8ORTS NGTZ253 RTS REORG TS CRITERIA (INDREF_PERCENTAGE): PERCENTAGE (0 %) <= CRITERIA (10 %).
13:51:45.81 PSVR.COM8ORTS NGTZ253 RTS REORG TS CRITERIA (MASS_DELETE_VALUE): VALUE (0) <= CRITERIA (0).
13:51:45.81 PSVR.COM8ORTS NGTZ253 RTS REORG TS CRITERIA (EXTENTS_VALUE): VALUE (1) <= CRITERIA (200).
13:51:45.81 PSVR.COM8ORTS NGTZ253 RTS REORG TS CRITERIA (ALLOCATED/USED_RATIO): NOT CHECKED.
13:51:45.81 PSVR.COM8ORTS NGTZ253 RTS REORG TS CRITERIA (HASH_OVERFLOW_RATIO): NOT CHECKED.
13:51:45.81 PSVR.COM8ORTS NGTZ253 RTS REORG TS CRITERIA (WHERE_CLAUSE): NOT CHECKED.

13:51:45.82 PSVR.COM8ORTS NGTZ245 OBJECT (PART 1) WILL NOT BE PROCESSED BY REORG: PASSED ALL RTS CRITERIA.
13:51:45.82 PSVR.COM8ORTS NGTZ269 CHKINDEX=Y SPECIFIED. INDEXES WILL BE CHECKED AGAINST RTS CRITERIA.

13:51:45.85 PSVR.COM8ORTS NGTZ316 RTS INDEXSPACESTATS TABLE SUCCESSFULLY READ (1,968 ROWS FOUND).
13:51:45.85 PSVR.COM8ORTS NGTZ270 1 INDEXES ADDED FOR RTS CRITERIA PROCESSING.
13:51:45.85 PSVR.COM8ORTS NGTZ271 CHKINDEX=Y PROCESSING COMPLETED FOR OBJECT.
13:51:45.85 PSVR.COM8ORTS NGTZ311 FORCECOPY=N SPECIFIED. COPIES WILL NOT BE FORCED.

13:51:45.85 PSVR.COM8ORTS NGTZ244 RTS VALUES FOUND FOR OBJECT (PART 2). RTS TIMESTAMP = 2018-03-19-13.46.06.969509.
13:51:45.85 PSVR.COM8ORTS NGTZ253 RTS REORG TS CRITERIA (AREO): NOT AREO
13:51:45.85 PSVR.COM8ORTS NGTZ253 RTS REORG TS CRITERIA (LAST_PERFORMED_REORG): REORG WAS PERFORMED (2018-03-19-13.46.06.618361).
13:51:45.85 PSVR.COM8ORTS NGTZ253 RTS REORG TS CRITERIA (LAST_PERFORMED_LOADR): NOT CHECKED.
13:51:45.85 PSVR.COM8ORTS NGTZ253 RTS REORG TS CRITERIA (EMPTY_TABLESPACE): NOT EMPTY (850 ROWS).
13:51:45.85 PSVR.COM8ORTS NGTZ253 RTS REORG TS CRITERIA (MAXIMUM_SIZE_PERCENTAGE): NOT CHECKED.
13:51:45.85 PSVR.COM8ORTS NGTZ253 RTS REORG TS CRITERIA (INSERTS_PERCENTAGE): PERCENTAGE (0 %) <= CRITERIA (25 %).
13:51:45.85 PSVR.COM8ORTS NGTZ253 RTS REORG TS CRITERIA (DELETES_PERCENTAGE): PERCENTAGE (0 %) <= CRITERIA (25 %).
13:51:45.85 PSVR.COM8ORTS NGTZ253 RTS REORG TS CRITERIA (UPDATES_PERCENTAGE): NOT CHECKED.
13:51:45.85 PSVR.COM8ORTS NGTZ253 RTS REORG TS CRITERIA (INSERT/DELETE/UPDATE_PERCENTAGE): NOT CHECKED.
13:51:45.85 PSVR.COM8ORTS NGTZ253 RTS REORG TS CRITERIA (UNCLUSTERED_INSERTS_PERCENTAGE): PERCENTAGE (59 %) > CRITERIA (10 %).
13:51:45.85 PSVR.COM8ORTS NGTZ248 OBJECT (PART 2) WILL BE PROCESSED BY REORG: RTS CRITERIA SATISFIED.

13:51:45.85 PSVR.COM8ORTS NGTZ235 OBJECT SELECTED FOR RTS PROCESSING:
13:51:45.85 PSVR.COM8ORTS NGTZ235 IX=MVSDXW.C040IX01
13:51:45.85 PSVR.COM8ORTS NGTZ242 RTS CRITERIA TABLE ENTRY (TYPE IX) FOUND FOR OBJECT:
13:51:45.85 PSVR.COM8ORTS NGTZ242 NAME=%.%
13:51:45.85 PSVR.COM8ORTS NGTZ242 PARTITION=0
13:51:45.85 PSVR.COM8ORTS NGTZ244 RTS VALUES FOUND FOR OBJECT (PART 1). RTS TIMESTAMP = 2018-03-19-13.46.06.618361.
13:51:45.85 PSVR.COM8ORTS NGTZ253 RTS REORG IX CRITERIA (AREO): NOT CHECKED
13:51:45.85 PSVR.COM8ORTS NGTZ253 RTS REORG IX CRITERIA (LAST_PERFORMED_REORG): REORG WAS PERFORMED (2018-03-19-13.46.06.618361).
13:51:45.85 PSVR.COM8ORTS NGTZ253 RTS REORG IX CRITERIA (LAST_PERFORMED_REBUILD): NOT CHECKED.
13:51:45.85 PSVR.COM8ORTS NGTZ253 RTS REORG IX CRITERIA (INSERTS_PERCENTAGE): PERCENTAGE (0 %) <= CRITERIA (25 %).
13:51:45.85 PSVR.COM8ORTS NGTZ253 RTS REORG IX CRITERIA (DELETES_PERCENTAGE): PERCENTAGE (0 %) <= CRITERIA (25 %).
13:51:45.85 PSVR.COM8ORTS NGTZ253 RTS REORG IX CRITERIA (INSERT/DELETE_PERCENTAGE): NOT CHECKED.
13:51:45.85 PSVR.COM8ORTS NGTZ253 RTS REORG IX CRITERIA (APPENDED_INSERTS_PERCENTAGE): PERCENTAGE (0 %) <= CRITERIA (20 %).
13:51:45.85 PSVR.COM8ORTS NGTZ253 RTS REORG IX CRITERIA (PSEUDO-DELETED_PERCENTAGE): PERCENTAGE (0 %) <= CRITERIA (10 %).
13:51:45.85 PSVR.COM8ORTS NGTZ253 RTS REORG IX CRITERIA (MASS_DELETE_VALUE): VALUE (0) <= CRITERIA (0).
13:51:45.85 PSVR.COM8ORTS NGTZ253 RTS REORG IX CRITERIA (LEAF_LIMIT_PERCENTAGE): PERCENTAGE (0 %) <= CRITERIA (10 %).
13:51:45.85 PSVR.COM8ORTS NGTZ253 RTS REORG IX CRITERIA (NUMBER_OF_LEVELS_VALUE): VALUE (0) <= CRITERIA (0).
13:51:45.85 PSVR.COM8ORTS NGTZ253 RTS REORG IX CRITERIA (EXTENTS_VALUE): VALUE (1) <= CRITERIA (200).
13:51:45.85 PSVR.COM8ORTS NGTZ253 RTS REORG IX CRITERIA (PSEUDO_EMPTY_LEAF_PERCENTAGE): NOT CHECKED.
13:51:45.85 PSVR.COM8ORTS NGTZ253 RTS REORG IX CRITERIA (MAXIMUM_SIZE_PERCENTAGE): NOT CHECKED.
13:51:45.85 PSVR.COM8ORTS NGTZ253 RTS REORG IX CRITERIA (WHERE_CLAUSE): NOT CHECKED.

13:51:45.85 PSVR.COM8ORTS NGTZ245 OBJECT (PART 1) WILL NOT BE PROCESSED BY REORG: PASSED ALL RTS CRITERIA.
13:51:45.85 PSVR.COM8ORTS NGTZ267 REORG WILL NOT BE PERFORMED ON OBJECT: ALL PARTITIONS EXCLUDED BY RTS PROCESSING.
13:51:45.85 PSVR.COM8ORTS NGTZ249 RTS CRITERIA PROCESSING COMPLETED (1 OBJECTS TO BE PROCESSED, 2 OBJECTS EXCLUDED).

13:51:46.77 CTRL.SVRDOSQL NGTZ369 RTS SCHEDULE DEFINITION SUCCESSFULLY READ:
13:51:46.77 CTRL.SVRDOSQL NGTZ369 TB=BMCNGT.NGT_RTS_SCHEDULE

13:51:46.77 CTRL.COM8SCHD NGTZ371 RTS SCHEDULE TABLE SUCCESSFULLY READ (1 ROWS FOUND).
13:51:46.77 CTRL.COM8SCHD NGTZ396 OBJECT HAS PASSED RTS SCHEDULE TABLE PROCESSING.

Was this page helpful? Yes No Submitting... Thank you

Comments