What type of DB2 DDL activity is reported in a CA Log Analyzer for DB2 for z/OS DDL Detail Report?

Document ID : KB000022177
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

What type of DB2 DDL activity will be shown in a CA Log Analyzer for DB2 for z/OS DDL Detail Report?

Environment:

CA DB2 tools Release levels R16 through R19.

Answer:

The following is a list of DB2 DDL activity currently supported by the DDL Detail Reporting in CA Log Analyzer:

Alter:   
========================   
TABLE ADD COLUMN   
TABLE ADD CHECK CONSTRAINT   
TABLE DROP CHECK CONSTRAINT   
TABLE ADD PRIMARY KEY   
TABLE DROP PRIMARY KEY   
TABLE ADD UNIQUE KEY   
TABLE DROP UNIQUE KEY  
Create/Drop:    
================
TABLE 
DATABASE    
STOGROUP    
INDEX
VIEW     
ALIAS   
AUX TABLE     
TRIGGER   
CLONE
GLOBAL TEMPORARY TABLE TABLESPACE SYNONYM FUNCTION SEQUENCE
GRANT/REVOKE: 
=========================    
TABLE OR VIEW PRIVILEGE    
DATABASE PRIVILEGE    
COLLECTION PRIVILEGE    
DISTINCT TYPE PRIVILEGE    
JAVA ARCHIVE FILE PRIVILEGE    
USE OF STOGROUP PRIVILEGE    
USE OF TABLESPACE PRIVILEGE    
USE OF BUFFERPOOL PRIVILEGE    
PACKAGE PRIVILEGE    
PLAN PRIVILEGE 
SCHEMA PRIVILEGE    
SEQUENCE PRIVILEGE   
SYSTEM PRIVILEGE  
BIND/REBIND/FREE:   
==============   
PLAN   
PACKAGE