LOCKING command with FILE subcommand

This section describes the LOCKING command with the FILE subcommand.

Usage

Use the FILE subcommand to format unreduced Db2 data and store it in sequential data sets suitable for use by the Db2 load utility. The records can be placed in Db2 tables and you can produce reports by using a reporting facility such as IBM® Query Management Facility (QMF).

Usage notes

  • FILE is used to format lock detail records (from IFCIDs 21, 211, 212, and 223) describing Internal Resource Lock Manager (IRLM) requests, claim and drain requests, and successful lock avoidance events.
  • Only one file data set can be generated in a job step.

Syntax of the FILE subcommand

Read syntax diagramSkip visual syntax diagram FILEFROM/TO blockDDNAME(LOFILDD1ddname)INCLUDE/EXCLUDE block

Subcommand options

The syntax diagram shows the options that are available with this subcommand. See Subcommand options for comprehensive descriptions of these options.

Example using FILE with INCLUDE option

This command generates a data set on the default ddname LOFILDD1. The data set contains detailed information about the locking requests made by the primary authorization ID SYSADM.

 
FILE
   INCLUDE (PRIMAUTH(SYSADM))