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.

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.


Work ID Maintenance panel

 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

Adding a log scan step to a work ID

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

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

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

Adding an execute SQL or DDL step to a work ID

Information about generating and executing SQL statements

SQL output files

SQL code handling

Running SQL

Automated drop recovery step

The Log Master automated drop recovery feature works with the BMC RECOVER PLUS 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.

Note

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

Adding an automated drop recovery step to a work ID

Information about drop recovery

Overview of automated 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.

Note

A work ID that contains a High-speed Apply JCL generation 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 execute SQL step to a work ID

Adding a High-speed Apply JCL generation step to a work ID

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

Examples using 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).

With PTF BQU1717 applied, 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

  • (PTF BQU1717 applied) 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
    • (with PTF BQU1717 applied) ALPSYSCP
    • (with PTF BQU1717 applied) 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

Adding a Repository maintenance step to a work ID

Tables in the Repository

Log Master Repository tables

Related topics

High-speed Apply Engine documentation

Overview of work IDs

Creating and managing work IDs

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

Comments