Report to identify "FREE PACKAGE" commands

Article Id: 140898

Status: Published

Updated On: 27-11-2019 16:17

Products:

CA Fast Recover for DB2 for z/OS , CA Log Analyzer for DB2 for z/OS , CA Quick Copy for DB2 for z/OS , CA Database Management for DB2 for z/OS - Recovery Suite , CA Merge/Modify for DB2 for z/OS , CA Recovery Analyzer for DB2 for z/OS , CA Log Analyzer SMF Audit Trace Option , CA MM Backup and Recovery for DB2

Issue/Introduction:

Log Analyzer "DB2 Commands Activity" report does not identify and report "FREE PACKAGE" command.
CMDREPT = (OPTS(YES) does not work, it only reports console DB2 commands, for example -DISPLAY command.

Environment:

Release : 20.0

Component : CA Log Analyzer for DB2 for z/OS

Resolution:

The command report obviously does not display all DB2 commands, it is focused on particular record that contains a string of DB2 command which was issued.

If you would be interested in particular command like FREE PACKAGE you can use a DML DETAIL report with CATALOG INCLUDE. Then filter on DELETE statements together with a filter on the SYSIBM.SYSPACKAGE table. Specifying such a table filter in panels you allows you to set a data filter as well and with the data filter you could pick columns that you are interested in.