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 Log Master for Db2 13.1.

Log Master CLIST and how to run the online interface


At installation, one of the installation jobs places a CLIST named ALPISPF in the library named HLQ.DBCLIB, or copies ALPISPF to the library that is specified during installation. (HLQ represents a qualifier that your environment assigns during installation.)

To run the Log Master online interface

Execute ALPISPF in one of the following ways: 

Important

clistLibName is the name of the data set where ALPISPF exists, and ssid is the identifier of the Db2 subsystem where Log Master will run.

  1. To execute from Interactive System Productivity Facility (ISPF) Option 6, enter one of the following TSO commands, depending on whether you want to pass the Db2 subsystem ID (SSID):

     EX ' clistLibName (ALPISPF)'

    EX ' clistLibName(ALPISPF)' 'SSID (ssid)'
  2. To execute from an ISPF panel, add an option to the panel that executes ALPISPF. For example, if you use LM as the option name, enter one of the following lines in the panel definition, depending on whether you want to pass the SSID:

     LM, 'CMD(EX 'clistLibName (ALPISPF)')'

    LM, 'CMD(EX 'clistLibName(ALPISPF)' SSID(ssid) )'

 The following figure shows the 

BMC AMI Log Master for Db2

 Main Menu panel of the interface:

                          BMC AMI Log Master for Db2 -  V12.01.00 - Main Menu               
Option ===>                                                                   
Select an option then press enter.                       DB2 System . . . DXW
                                                                             
Actions:                                View:                                  
    0. Analyze Problem Transactions        30. Previously Created Outputs      
    1. Generate UNDO SQL                   31. DB2 System Log Information      
    2. Generate REDO SQL                   32. LRSN/Timestamp Conversion Panel
    3. Generate MIGRATE SQL                                                    
    4. Generate MIGRATE DDL             Options and Defaults:                  
    5. Create Log Reports                  40. Online Interface Options        
    6. Create Logical Log Files            41. Product Options                 
    7. Create Audit Report                 42. Output Defaults                 
    8. Generate Automated Drop Recovery    43. Automated Drop Recovery Defaults
    9. Generate High-speed Apply JCL       44. Alternate Index Names Defaults  
   10. Create Catalog Activity Report      45. SQL Execution Codes Defaults    
   11. Generate REPOS UPDATE JCL           46. Display Default Options         
   12. Generate REPOS DELETE JCL           47. Display PTF Maintenance Applied
                                                                              
Repository Options:                                                       
   20. Create or Edit Work IDs                   
   21. Create or Edit Filters                                                  
   22. Create or Edit Templates                                                
   23. Create or Delete Log Marks                                              
   24. Delete/Display Repository Tables
                                      
Enter X to exit


 

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