DML at Bind Access Detail (Type BIND)

This topic shows detailed information about DML at Bind Access Detail (Type BIND).

When you select the BIND type, the data is retrieved from IFCID 145, and the following fields are printed: 
TYPE                                  DETAIL                                          
-------- -------------------------------------------------------------------------------
BIND     PACKAGE: PMO1D811.DSNREXX.DSNREXX.X'174B9CF31C56B7C2'                          
         TYPE: INSERT                    STMT#     0  ISOLATION(CS)  KEEP UPD LOCKS:  NO
         TEXT: INSERT INTO PRL.AUDTB1 OVERRIDING USER VALUE VALUES(NULL,                
               'HEIDI', 'AXEL', 1)                                                      
         DATABASE: 264               TABLE OBID:      3     STMT ID:                   0
         ACCESS CTRL SCHEMA: N/P                                                        
         ACCESS CTRL OBJECT: N/P

Field description

PACKAGE/DBRM NAME
The name of the database request module (DBRM) or package containing the DML statement being bound.
A package name is made up of the following parts:
Location
The location name is applicable only to packages, otherwise 'BLANK' is printed.
Collection ID
The package collection ID is applicable only to packages, otherwise 'BLANK' is printed.
Package ID
The program name for DBRMs or the package ID for packages.
Consistency token
A hexadecimal dump of the Db2® timestamp of the program during precompilation. This field contains the value in the TIMESTAMP column of SYSIBM.SYSDBRM. The value represents the time of the precompilation in internal format, that is, modified store clock (STCK) format.
TYPE
The type of statement being bound.
STMT#
The statement number in the program or DBRM involved in the bind.
ISOLATION
The isolation of the bind. Possible values are:
CS
Cursor stability
RR
Repeatable read
RS
Read stability
UR
Uncommitted read
KEEP UPD LOCKS
Indicates if an update lock is kept. YES is only valid if the value in the TYPE field is SQL OPEN CURSOR and the value in the ISOLATION field is RR or RS.
TEXT
The SQL statement text associated with the BIND. If SQL text is not present, N/P is printed. Long SQL text can be truncated.
DATABASE
Either the name or the decimal DBID of the database that contains the auditable Db2 table. The name is printed if known, otherwise OMEGAMON for Db2 Performance Expert reports a decimal DBID.
TABLE OBID
The object identifier (OBID) of the Db2 table.
Note: DATABASE and TABLE OBID are repeating fields and can have more than one entry in the report or trace. Two or more occurrences result from a DML statement that refers to two or more Db2 tables.
STMT ID
The SQL unique statement ID.
ACCESS CTRL SCHEMA
The name of the access control schema.
ACCESS CTRL OBJECT
The name of the access control object.