Report to identify "FREE PACKAGE" commands

book

Article ID: 140898

calendar_today

Updated On:

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.