Not able to capture ALTER statement In LOG Analyzer
Article ID: 73069
Log Analyzer for DB2 for z/OS
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.
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.