Not able to capture ALTER statement In LOG Analyzer
book
Article ID: 73069
calendar_today
Updated On:
Products
Log Analyzer for DB2 for z/OS
Issue/Introduction
We are trying to run Log Analyzer: DDL Activity report for specific ALTER statement but we are not able to find the ALTER statement details in the report. But the Table was altered within the specified time frame.
Environment
z/od DB2
Resolution
Log Analyzer doesn't support reporting on all alters currently. But if you are interested in some particular information like AUTHID and maybe a type of an ALTER we would recommend to run a DML report of DETAIL level for catalog tables eg. specify a database filter to include just DSNDB06 database. You also need to make sure to flip CATALOG (INCLUDE) miscellaneous option on.