Space announcements


This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

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:


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 initial panel of the interface:

 Log Master for DB2 Main Menu

                          Log Master for DB2          - 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:                     News:                                  
   20. Create or Edit Work IDs             90. Changes in current version      
   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

Was this page helpful? Yes No Submitting... Thank you