The Locking File Data Set
The locking file data set creates a sequential data set of formatted DB2® locking detail records that can be loaded into the OMEGAMON® for Db2 PE performance database using the DB2 load utility.
Use the performance database to produce tailored reports using a reporting facility such as Query Management Facility (QMF).
The locking file data set contains a record for each occurrence
of the following events:
- A LOCK, UNLOCK, CHANGE, or QUERY request processed by DB2
- A request to acquire a claim, change a claim duration, or release a claim
- A request to release a drain on a claim class
- Whenever lock avoidance is successful
The output of the FILE command is a sequential variable blocked data set.
The content of the output data set is determined by the FILE command options you specify, and by the input SMF/GTF records processed.
Descriptions of the layouts of these records can be found in the RKO2SAMP library. The member name is DGOLDFIL.
Note: For an introduction to the Locking report set and general locking
information refer to the Reporting User's Guide.