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.

Work ID contents


You can name, save, and edit a work ID, and you can assign security to it. The contents of the work ID reflect the steps defined for a particular task. A work ID can contain the following types of steps, as introduced in this section:

You can add steps to a work ID in any order. Log Master processes multiple log scan steps simultaneously, but always processes any execute SQL steps last. 

Log scan step

Most tasks require that you scan the log for certain types of transactions, and then generate reports and output.

Log Master stores this type of activity in the work ID as part of the log scan step. A work ID typically contains only a single log scan step unless you create or modify it by using the Create or Edit Work IDs option.

The log scan step can include time frame, filter, report, output file, and optional log mark specifications. The log scan step includes all of the information that Log Master needs to perform a log scan, and generate reports and other output. You can also use the log scan step to update the Old Objects Table in the Repository.

Your work ID can contain a single log scan step or multiple log scan steps. The choices listed under the Actions category on the Main Menu guide you through the steps for creating a work ID with a single step.

You can also add a log scan step so that you simultaneously read the log with two different log scans, and generate two different streams of output. Work IDs that contain multiple log scan steps must use the same input source. For example, you cannot scan a logical log file and use the bootstrap data set (BSDS) to locate Db2 logs at the same time.

Example

The following figure shows the contents of the ABC.PAYROLL work ID. In this example, the work ID contains a single log scan step and uses the BSDS to obtain log files containing log records from 4:00 P.M. on November 18 to the present. The example uses a filter and specifies Summary and Audit reports as output.


 WORKID                           Work ID Maintenance               Line 1 of 6
 Command ===> ________________________________________________ Scroll ===> HALF
                                                                    SSID : DBAN
 Work ID . . : ABC.PAYROLL                                                      
 Description : ABC PAYROLL AUDIT REPORT
 Updated Version: V11.01.01                                        
                                                                               
 Work ID Batch Options  . . _  (E=Edit)                                         
                                                                               
 Type an action code. Then press Enter.                                         
   I=Insert  D=Delete  E=Edit                                                   
 ACT  STEP TYPE  DESCRIPTION                                                    
 _    Log Scan   Inputs    : DB2 Subsystem BSDS                                 
                 From      : 2013-01-18 16.00.00.000000                         
                 To        : Current                                            
                 Filter(s) : ABC.PAYROLL                                        
                 Output(s) : SUMMARY,AUDIT                                      
                 Repos Upd : None                                               
******************************** End Of List *********************************
  F1=Help      F3=Exit      F7=Backward  F8=Forward  F12=Cancel

Be aware of the following points as you add log scan steps to a work ID:

  • The Work ID Maintenance panel does not automatically generate reports and outputs. You can generate default reports and output automatically by using the task dialogs that are listed under the Actions category on the Main Menu.
  • When you generate a Catalog Activity report or an output DDL file, or update the Repository, Log Master cannot generate other forms of output in the same log scan, such as other reports or SQL. To generate any other forms of output that you need in the same work ID, add an additional, separate log scan step in your work ID.
  • Log Master processes log scan steps simultaneously. For example, you can add two log scan steps to a work ID that simultaneously scan two different portions of the Db2 log, and generate two different streams of output.
  • Log scan parameters enable you to process Db2 catalog records, or to perform overtime processing tasks.

For more information about the topics in this section, see the following references: 

Topic

Reference

Step-by-step instructions for adding a log scan step to a work ID

Information about and step-by-step instructions for defining a log scan step

 

Log mark step

Use log marks to identify a point in the Db2 log for reference. You can create log marks as part of a log scan step, or in a separate log mark step, and then save them as part of a work ID.

You can also create, delete, or view information about a log mark directly from the online interface by using the Create or Delete Log Marks choice on the Log Master Main Menu.

For more information about the topics in this section, see the following references: 

Topic

Reference

Step-by-step instructions for adding a log mark step to a work ID

Information about log marks and step-by-step instructions for defining a log mark step

 

Execute SQL step

You can open a new work ID or modify an existing work ID to add an execute SQL step that executes previously generated SQL.

This step enables you to use the High-speed Apply Engine to execute and monitor a set of SQL statements as part of your Log Master job or job step. After you add an execute SQL step, you can generate the JCL to run the work ID.

Be aware of the following points as you add an execute SQL step to your work ID:

  • In many cases, you must add an execute SQL step to a new work ID to execute SQL that you generated under a different work ID.
  • Before you select an SQL data set to execute, review its status and study its statistics. For example, you can examine the type of SQL and the number of database changes that the data set contains before you attempt to execute it.

For more information about the topics in this section, see the following references: 

Topic

Reference

Step-by-step instructions for adding an execute SQL step to a work ID

Information about generating and executing SQL statements

SQL code handling

 

Automated drop recovery step

The Log Master automated drop recovery feature works with the BMC AMI Recover product or DSN1COPY to recover dropped Db2 objects, such as tables or table spaces.

You can specify different types of output for this step, depending on the type of recovery operation that you want to perform. If you execute the generated outputs in sequence, you can recover dropped objects with a minimum of time and investigation.

Important

A work ID that contains an automated drop recovery step cannot contain other steps.

For more information about the topics in this section, see the following references: 

Topic

Reference

Step-by-step instructions for adding an automated drop recovery step to a work ID

Information about drop recovery

 

High-speed Apply JCL generation step

You can use the Log Master online interface panels to specify configuration parameters for the High-speed Apply Engine, then generate JCL for a separate job that runs High-speed Apply using your parameters.

As you learn more about High-speed Apply, you can edit the JCL to define more parameters and use more High-speed Apply features.

For more information about the topics in this section, see the following references: 

Topic

Reference

Step-by-step instructions for adding an execute SQL step to a work ID

Information about defining a work ID for generated High-speed Apply JCL

 

Repository maintenance step

Log Master uses the Repository to support many types of processing, including overtime processing, which affects the Old Objects table (ALPOLDO), and ongoing processing, which affects the Open Unit of Recovery table (ALPURID).

Log Master supports completion processing, which affects the SYSCOPY table (ALPSYSCP). You can also delete the previously created output data set history tables (ALPWHIS, ALPWLSH, ALPSQLF, ALPRPTF, ALPLODF, ALPDDLF, ALPCMDF, ALPADRF, ALPLOGF).

A Repository maintenance step generates a Log Master job that performs one of the following actions:

  • Updates the ALPOLDO table with object structure definitions or compression dictionaries
  • Updates the ALPSYSCP table with records from SYSIBM.SYSCOPY
  • Deletes information from one or more of the following tables when the information is no longer required:
    • ALPOLDO
    • ALPURID
    • ALPSYSCP
    • Output data set history tables

When you create a Repository maintenance step by using the Log Master online interface, the generated JCL actually contains specialized LOGSCAN statements.

For more information about the topics in this section, see the following references: 

Topic

Reference

Step-by-step instructions for adding a Repository maintenance step to a work ID

Tables in the Repository

 

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