Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Ops Monitor for Db2 13.1 image-2024-5-19_8-5-1.png .

Viewing all Db2 commands


The 

BMC AMI Ops Monitor for Db2

 - Data Collector provides a chronological log of Db2 commands. You can view all Db2 commands that have been issued since Db2 started.

To view all Db2 commands

  1. From the EZDB2 easy menu, select DB2 Event Traces.The System Event Traces easy menu (EZDEVENT) is displayed.

    W1 =EZDEVENT=========(DB2K=====*=======)ddmmmyyyy==17:36:11====MVDB2====D====1
                                System Event Traces Menu                           
      . Set Context to One DB2                                                     
                                +----------------------+                           
        Thread Failures         |   Place cursor on    |    DB2 Commands           
      . Authorization Failures  |    menu item and     |  . Commands Executed      
      . Asutime Failures        |     press ENTER      |                           
                                +----------------------+                           
        RID Error Processing                                Data Set Open/Close    
      . RID Failures by Time      SQL MiniPlan events     . Open/Close by Time     
      . RID Failures-Storage    . Dynamic Sql/Mini Plan   . Summary by Database    
      . RID Failures-Limit                                                         
                                                          . Return...
  2. From the EZDEVENT easy menu, hyperlink on Commands Executed.The Db2 Command History view (CMDLIST) is displayed.

    From the CMDLIST view, you can identify who has issued commands and hyperlink to the CMDTEXT view to see the complete text.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*