Identify when a utility has executed when utilizing Database Management for Db2 for z/OS utilities
Article ID: 20949
Updated On:
Products
Issue/Introduction
Identify tables against which Fast Load for DB2 for z/OS has been used.
Although Fast Load makes a SYSCOPY entry for a load, it's not distinguishable from an entry made by IBM Load, and since both Fast Load and IBM Load are used, that is not very useful.
Environment
Release: R20
Component: PUT
Resolution
Database Management for Db2 for z/OS 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)
Online help for this field:
Field: Create History Table Rows
Description: Indicate whether to create history table rows containing utility history information. (HISTORY)
YES Create utility history table rows containing utility history information.
NO (Default) Do not create history table rows.
Then each time a utility like Fast Load, Rapid Reorg, Quick Copy, Fast Recover and others executes a log record is written.
Fast Unload uses a parameter in hlq.CDBAPARM(PFU) called : PFU-HISTORY—Generate a Record in the History Table to set up the output of the record to the PTI.PTGL500_HISTORY table.
Example : This is a record produces from an execution of a Fastload job.
RUBROWF 20.0 ---------- RC/Browse: Form Mode ---------- yyyy/mm/dd hh:mm:ss
COMMAND ===> SCROLL ===> CSR
For Table => PTI.PTGL500_HISTORY > Row number=> 1 OF 10386
Browse Mode => F Max Char => 256
SSID: ssid ----------FETCH STATUS: COMPLETE-------------------------- authid
##.COLUMN NAME NULL DATA FOR ROW # 1
A1.PUT_JOBNAME PFLJOBB
A2.PUT_JOBID JOB53131
A3.PUT_USER <authid >
A4.PUT_STEPNAME <PFL >
A5.PUT_SYSID ssid
A6.PUT_UTIL LOAD
A7.PUT_CREATOR creator
A8.PUT_DBNAME dbname
A9.PUT_TSNAME tsname
B1.PUT_TBNAME tablename
B2.PUT_IXNAME
B3.PUT_PARTNUM 0
B4.PUT_DB2_LVL 1210
B5.PUT_SMFID ssid
B6.PUT_START_DATETIME yyyy-mm-dd-hh.mm.ss.msmsms
B7.PUT_END_DATETIME yyyy-mm-dd-hh.mm.ss.msmsms
B8.PUT_ELAPSED_TIME 1.4
B9.PUT_CPU_TIME 4.74
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 <authid >
C7.PUT_UTIL_SOURCE PFL
C8.PUT_UTIL_VERSION 200
C9.PUT_HASH ................................
D1.PUT_CMD_TEXT FASTLOAD.ENABLE-PFL20 YES.OUTPUT-CONTROL BUILD.SE>
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 extensive information regarding the utility execution.
SQL can be used to interrogate the table to obtain the information required.
See also : Quick Copy Records in the History Table
From a maintenance point of view, the growth in records sent to this table should be monitored as there is no formal mechanism to remove old/unwanted records other than the use of SQL or if RC/Extract for Db2 for Z/OS(RCX) is available, records could be archived to another table selectively by RCX.
Additional Information
If Database Analyzer for Db2 for z/os (PDA) is installed , there is a report able to interrogate the PTI.PTGL500_HISTORY table.
View the Utility History Using the Query Facility
On the PDA menu it is QF Query Facility, 3) Utility History Queries
Feedback
