How to identify when a CA Utility has run?

Document ID : KB000020949
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

I am trying to identify tables in our shop against which we use CA Fast Load.

Although CA Fast Load makes a SYSCOPY entry for a load, it's not distinguishable from an entry made by IBM Load, and since we use both CA Fast Load and IBM Load in our shop, that is not very useful.

Solution:

CA Utilities are able to write log records to this table each time they execute.

PTI.PTGL500_HISTORY

If the the history parm in hlq.CDBAPARM(UTIL) member is set to YES.

HISTORY (YES) /* CREATE HISTORY TABLE ROWS (NO/YES)

Then each time a CA utility like Fastload, Fast Unload, Rapid Reorg, Quick Copy, RECOVER and others executes a log record is written such as this one:


For Table   => PTI.PTGL500_HISTORY          >    Row number=> 2704 OF 2704
Browse Mode => F                                 Max Char  => 256
SSID: D91A ----------FETCH STATUS: COMPLETE-------------------------- AUTHID
##.COLUMN NAME        NULL  DATA FOR ROW # 2704
A1.PUT_JOBNAME              AUTHIDA
A2.PUT_JOBID                JOB47746
A3.PUT_USER                 
A4.PUT_STEPNAME             UTIL0001
A5.PUT_SYSID                D91A
A6.PUT_UTIL                 LOAD
A7.PUT_CREATOR              AUTHID3
A8.PUT_DBNAME               DBCORP1
A9.PUT_TSNAME               TSEMP
B1.PUT_TBNAME               TBEMP
B2.PUT_IXNAME
B3.PUT_PARTNUM              0
B4.PUT_DB2_LVL              910
B5.PUT_SMFID                ssid
B6.PUT_START_DATETIME       2012-12-14-00.10.51.000000
B7.PUT_END_DATETIME         2012-12-14-00.11.03.000000
B8.PUT_ELAPSED_TIME         0.2
B9.PUT_CPU_TIME             2.92
C1.PUT_ELAPSED_WIND         0.0
C2.PUT_CPU_WIND             0.0
C3.PUT_AVG_CPU_BUSY         0.0
C4.PUT_RC                   0
C5.PUT_EXCP                 0
C6.PUT_UTIL_ID              
C7.PUT_UTIL_SOURCE          PFL
C8.PUT_UTIL_VERSION         150
C9.PUT_HASH                 .................................................>
D1.PUT_CMD_TEXT             FASTLOAD.COPY-BUFFERS 10.SPACE-DEFN
NO.DISPLAY-ST>
D2.PUT_UTILITY_DATA

Any utility jobs will display a message like this one:

PUT0050I - History LOG Record created - UTILITY ID: AUTHID.AUTHIDA

As can be seen from the above log record it does record a lot about the utility execution. You can look up the table to obtain the information you need.