What is the usage of PLA_STMT_TYPE in Log Analyzer reporting

Products

• Log Analyzer for DB2 for z/OS

Issue/Introduction

Within Log Analyzer for Db2 for z/OS (PLA) reports, there is a 2 character code representing PLA_STMT_TYPE.
Attempting to determine what the codes within PLA_STMT_TYPE represent:

Example:
UA2023-06-20-04.4
UB2023-06-20-04.4
I 2023-06-20-04.5
D 2023-06-20-04.5
 

This is a piece of the load control cards which shows the PLA_STMT_TYPE:
(PLA_STMT_TYPE        POSITION(   27:   28) CHAR(    2)                  
,PLA_UPDT_TIMESTMP    POSITION(   29:   54) TIMESTAMP EXTERNAL(   26)

Resolution

The PLA_STMT_TYPE usage would be:


UA => Update After image
UB => Update Before image
I  => Insert
D  => Delete

The PLA_STMT_TYPE is a vital piece of information to determine the exact DML type executed.