Chapter 3: Process Log Facility
This section contains the following topics:
Process Log Overview (see page 27) Processing Flow (see page 28)
Access the Process Log Facility (see page 30)
Access the Report Source Specifications Panel (see page 30) Output Specifications Panel (see page 38)
Report Submission Panel (see page 39)
Process Log Overview
The Process Log option on the CA Log Analyzer main menu provides the following report options:
DML Activity
Reports changes to your databases. You can also create executable SQL statements to undo or redo database activity or create a load file.
Commit Frequency Report
Analyzes DB2 log data sets to determine the number of updates that occur within the scope of each commit. Use this report to determine if local standards for performing commits are being met.
Image Copy Frequency Report
Reports how often tablespace image copies are made in relation to the amount of activity on the tablespace. This is helpful in determining if image copies are being taken at appropriate intervals for data recovery.
Rollback Activity Report
Reports on the frequency of DB2 rollbacks requested by DB2 and application programs. This feature helps you analyze system efficiency.
Recovery Point Analysis
Determines where safe recovery points are in the DB2 log. This can help you choose a good point at which to recover data.
DDL Activity
Analyzes the DB2 log for creates and drops of DB2 objects. You can also generate an executable DDL to recreate created objects onto another system and recover dropped objects that were not supposed to be dropped.
Processing Flow
28 User Guide
Change Data Capture Analysis
Analyzes the DB2 log to determine the impact of using Data Capture Changes in your DB2 subsystem. The report shows the percentage of increase or decrease in logged data that will occur if Data Capture Changes is turned on or off.
Processing Flow
All of the reports available in the Process Log facility use a consistent processing flow.
The same basic steps are performed regardless of the type of report you are generating.
The following illustration shows the processing flow for selecting Process Log reports:
Chapter 3: Process Log Facility 29 The Report Specification panel lets you select reports. This is the first panel you
encounter when generating a report.
The following panels are used in generating a report, in the order in which they are listed:
1. The Report Specification panel lets you select which reports to generate. Select the report and press Enter.
The Report Options panel appears.
2. The Report Options panel lets you specify the format of the report and define filters. Filters let you control the types of data that are included or excluded from the report. The options that appear on this panel vary depending on the report you have selected. Enter the options you want and press PF3 (End).
The Report Specification panel reappears.
3. Select additional reports. When you have finished selecting the options for the reports, press PF3 (End) to register your choices.
The Report Source Specifications panel appears.
4. The Report Source Specifications panel lets you specify the range of log data to analyze and an alternate source of log data and table information. When you have entered the options, press PF3 (End).
The Output Specifications panel appears.
5. The Output Specifications panel lets you specify the type and destination of the output files, such as the extract file, SQL file, and load file. After you specify the destinations, press PF3 (End).
The Report Submission panel appears.
6. The Report Submission panel lets you specify the execution mode for the report.
You can generatd the report online or execute as a batch job. Select the execution mode and press Enter to process your job.
If you selected the online mode, a message appears while the report is generated.
The report appears on your terminal when processing has completed. If you selected the batch mode, the Batch JCL Specification panel of the Batch Processor appears. The job can be submitted directly to JES or saved for later execution.
Access the Process Log Facility
30 User Guide
Access the Process Log Facility
This section explains how to access the Process Log facility.
Follow these steps:
1. Select 1 (Process Log) from the CA Log Analyzer Main Menu and press Enter.
The Report Specification panel appears.
This panel lets you begin the report generation process, or indicates where you can obtain information about the reports through the online help system.
2. Type S in the Sel field next to each report you want to generate. Press Enter to access the option panel for each report, or press PF3 (End) to process your selections.
Note: You can also type ? next to a report to view a description of that report.
Access the Report Source Specifications Panel
You can access the Report Source Specifications panel from the Report Options panel.
The Report Source Specifications panel lets you do the following:
■ Specify the range of log data to analyze.
■ Specify where CA Log Analyzer looks for log files and which table definitions are used to format the data.
■ Select the DB2 catalog or an alternate image copy as the source of copy information.
■ Select data sharing groups or specific members of a group as the source of DB2 data sharing.
■ Select the BSDS or an alternate log to identify log data sets.
■ Select the DB2 catalog or an alternate table as the source for table definitions.
Follow these steps:
1. Press PF3 (End).
The Report Specification panel appears.
2. Press PF3 (End) again.
The Report Source Specifications panel appears.
Chapter 3: Process Log Facility 31
Specify an Alternate Image Copy Source
CA Log Analyzer uses image copies of tablespaces to generate complete row images of log data. Image copies are also the source of decompression dictionaries that are used for compressed log records. By default, the information in the DB2 catalog determines which image copies to use.
If the Modify Recovery utility is run against a tablespace, the rows in SYSIBM.SYSCOPY containing the image copy information are deleted. The actual image copy data sets still exist, but they cannot be found through the DB2 catalog. If CA Log Analyzer cannot find the image copies, it cannot construct complete updates from the log and it cannot expand records from compressed tablespaces. In this case, you can specify an alternate image copy source. The alternate image copy mapping facility lets you specify the relevant information for those image copy data sets that still exist. These image copy maps let you correctly process log ranges that those copies cover.
Follow these steps:
1. Type Y in the Specify Other Source field on the Report Source Specifications panel and press Enter. dictionaries can be retrieved from the DB2 Catalog or from Image Copy maps.
Enter the desired source.
Source ==> C ( C - DB2 Catalog, M - Image Copy Maps, O - IC Maps Only) --- USER1 Enter the Image Copy Group name(s) below. Enter search criteria at the Creator and Group Name prompts to display a selection list of Image Copy Groups.
Group/ S O Creator Map Name Description O _ ________ ________ ______________________________ Y <== CREATE GROUP ******************************** BOTTOM OF DATA *******************************
Access the Report Source Specifications Panel
32 User Guide
2. Complete the following steps:
a. Enter one of the following values in the Source field:
C (DB2 Catalog)
Uses DB2 catalog information.
M (Image Copy Maps)
Uses both image copy maps and information from the DB2 catalog.
O (IC Maps Only)
Uses only the image copy maps specified.
Press Enter.
b. Enter one of the following commands in the O (option) field to create, update, or delete an image copy map from the list:
C (Create)
Creates an image copy group or map. This command is valid only on the create lines.
If C is typed on the Create Group line, the IC Group Editor panel appears.
The process of creating an image copy group involves selecting preexisting maps, or creating maps to include in the group. Groups allow easy
reference to a set of related image copy maps.
If C is typed on the Create Map line, the IC Map Editor panel appears. The process of creating an image copy map involves specifying the data set information for the image copy, and indicating the log point at which the copy was taken.
D (Delete Group)
Removes an image copy group or map from your selection list. The group or map is deleted only from your selection list.
U (Update Group) Edits a map or group.
L (List Maps)
Accesses a list of maps in a group. This option is valid only on a group line.
Press Enter.
c. If you are creating a map, specify a share option (Y, N, U) in the SO field.
Note: This information is applicable only when the Source is M (Image Copy Maps) or O (IC Maps Only).
Chapter 3: Process Log Facility 33
Access the Alternate Image Copy Selection List
The alternate image copy selection list lets you select which image copy maps and groups to use while completing and expanding log records during analysis.
Follow these steps:
1. Enter a creator, map, or group selection mask in the Creator or Group/Map Name fields on the Copy Source Specification panel and press Enter.
The Alternate IC Selection panel appears.
2. Enter specific names or selection criteria in the Creator and Name fields to limit the image copy map or group list and press Enter.
The maps or groups that meet your selection criteria appear on the panel.
3. Type S in the O field next to the map or groups to use and press Enter.
The maps and groups are placed in your selection queue.
4. Type S on the command line to shrink the queue to only the selected items. Press Enter.
The Selected Image Copies panel appears.
5. Either press PF3 (End), or type S and press Enter.
If you pressed PF3 (End), the Copy Source Specification panel reappears. If you typed S, the selection list reappears.
Select Members of a Data Sharing Group
The Member Selection panel lets you select data sharing groups or specific members of a group.
Follow these steps:
1. Type Y in the Specify Other Source field on the Report Source Specifications panel and press Enter.
The Member Selection panel appears.
Access the Report Source Specifications Panel
34 User Guide
2. Complete the following fields:
■ Type X next to a member to exclude that member.
■ Type S next to a member to select that member or, if already selected, the alternate BSDS of that member.
Press Enter.
Note: You can alternatively type BSDS on the command line to expand the group member list to show all of the BSDSs of each member. You can then type S next to the specific member that you want to use. The following illustration shows the BSDSs for each member:
LAMEML Log Analyzer - Member Selection COMMAND ===> SCROLL ===> PAGE Enter S to select the Data Sharing Members, X to unselect the members.
Data Sharing Group: DSNDA0G O Host Member: DXXX Member ID 01 Selected 1 BSDS1: DSNDA0G.DXXX.BSDS01 Selected BSDS2: DSNDA0G.DXXX.BSDS02 Member: DXXX Member ID 02 Selected 2 _ BSDS1: DSNDA0G.DXXX.BSDS01 _ BSDS2: DSNDA0G.DXXX.BSDS02 Selected Member: DXXX Member ID 03 Selected 1 _ BSDS1: DSNDA0G.DXXX.BSDS01 Selected _ BSDS2: DSNDA0G.DXXX.BSDS02
Specify Alternate Log Data
CA Log Analyzer can read and analyze log data sets other than the ones cataloged in the BSDS. This option is useful when you want to reread a previously created extract file. An extract file contains log data that has already been extracted for analysis. You can use data set names to specify which active or archive log files to analyze.
Follow these steps:
1. Type Y in the Specify Other Source field on the Report Source Specifications panel and press Enter.
The Log Source Specification panel appears.
Chapter 3: Process Log Facility 35 2. Enter one of the following values in the Source Type field:
B
Reads the DB2 BSDS to determine which active and archive logs are needed for the current analysis. The first copy of the active log data sets is used whenever possible. If the specified log range is not contained in the active log, the first copy of the archive log data sets is used.
X
Reads a log extract file that was created in a previous analysis. The data set names for the extract and the extract control file must match the values in the Extract Dataset Name and Extract Control DSNAME fields. Verify that the extract and extract control files are paired correctly. Do not specify a control file that was created with a different extract file.
L
Reads only the logs you specify. Enter the specific logs in the Active/Archive Log Datasets field near the bottom of the panel. Also type A (active) or R (archive) in the T field to specify the log type.
To select from a list of log data sets, type % in the Log Dataset Name field and press Enter. The Log Inventory List panel appears. Make your selections and press Enter to return to the Log Source Specification panel.
Press Enter.
3. (Optional) Use the following line commands in the O field next to the log data set names:
I[n]
Inserts a blank line in the selection list. Use the parameter n, where n is a number from 1 to 9, to insert multiple lines.
D[n]
Deletes a line from the selection list. Use the parameter n, where n is a number from 1 to 9, to delete multiple lines.
R[n]
Repeats the current line. Use the parameter n, where n is a number from 1 to 9, to repeat the line n times.
Press Enter.
4. Press PF3 (End) again.
The Report Source Specifications panel appears.
Access the Report Source Specifications Panel
36 User Guide
Specify Alternate Table Definitions
DB2 does not use table names to log changes to a table. The data changes are recorded in the log using the internal DB2 identifiers DBID and OBID. These identifiers are assigned to a table by DB2 when the table is created.
If a table has been dropped and recreated, the identifiers can change. If you analyze log data for a table with changed identifiers, CA Log Analyzer can fail to properly format the log data. The alternate table definition facility lets you specify alternate table definitions by associating a table definition with the DBID and OBID identifiers. You provide the definitions by associating CREATE TABLE SQL statements with the identifiers.
The alternate table definition facility can also generate REDO SQL statements to apply changes from one table to a duplicate, or mirror, table. By changing the table name that is associated with the OBID and DBID contained in the logs, the generated SQL applies the changes to the other table.
Follow these steps:
1. Type Y in the Specify Other Source field on the Report Source Specifications panel and press Enter.
The Table Specifications panel appears.
2. Enter one of the following values in the Source Type field:
C
Uses DB2 catalog definitions.
D
Uses table definitions from one or more DDL files to format table data. To use these definitions, map the tables defined in the specified DDL files to specific DBIDs and OBIDs. Mapping can be done directly on the Table Specifications panel (using the C option). Mapping can also be done by selecting Source Mapping (option 3) on the Main Menu and then selecting DDL File Mapping (option 1) on the Source Mapping Maintenance panel.
Chapter 3: Process Log Facility 37 M
Uses both the table definitions from the DDL file and the definitions from the DB2 catalog for the mapped DBID and OBID values. The DB2 catalog table SYSIBM.SYSTABLES contains row RBA1, which describes the log point at which this table was created. CA Log Analyzer uses this RBA1 value with the
FROMRBA values in the DDLFILE map to split the log into sections that use the definition from either the DDLFILE map or the DB2 catalog.
Note: If you specify D or M, you can create a map by typing C in the O field on the first line and specifying a creator and map name. You can also display a selection list of DDL files by entering selection criteria in the Creator and Map Name fields.
Press PF3 (End).
Note: For more information about the fields on this panel, see the online help.
Access the DDL File Selection List
The DDL file selection list lets you select which DDL file maps are used to format the tables during analysis.
Follow these steps:
1. Enter a selection mask in the Creator and Map Name fields on the Table Specifications panel and press Enter.
The Mapped DDL File Selection panel appears:
2. Enter specific names or selection criteria in the Creator and Name fields and press Enter.
The map names that match your criteria appear.
3. Type S in the O (Option) field next to the file maps you want to use for the analysis, and press Enter.
A message informing you that the selections have been queued appears.
4. (Optional) Type S (Shrink) on the command line and press Enter.
The Selected Object Queue panel appears, showing the objects that are currently selected. To delete the object from the selected queue, remove the selection character.
Note: You can alter or remove objects from the list shown in this panel. Type S in the SEL (Select) field to select an object. Delete the S to remove an object.
5. Press PF3 (End), or type S and press Enter.
If you pressed PF3 (End), the Input Specification panel reappears. If you typed S, the selection list reappears.
Output Specifications Panel
38 User Guide
Output Specifications Panel
When you use CA Log Analyzer to generate a report (or to generate SQL statements or DDL statements), the Process Log facility determines which output files are needed and displays them on the Output Specifications panel so that you can specify the
appropriate settings for each file. The following output files may be generated:
Extract file
Contains the data that was extracted for the log analysis. You control whether it is created as a cataloged data set, which can be reused for further analyses, or as a temporary work file.
Extract Control file
Is created automatically for CA Log Analyzer to use internally. You control whether the file is created as a cataloged data set, which can be reused for further analyses, or as a temporary work file.
Report file
Contains the process log report. The LRECL is 137.
SQL file
Contains the executable SQL statements, if UNDO or REDO SQL is generated. The LRECL is 80.
Load file
Contains the records for each update, insert, and delete recorded in the log. This load file can be used with a load utility or with your own programs.
DDL file
Contains the executable DDL statements, if UNDO or REDO DDL is generated. The LRECL is 80.
LOB file
Contains the LOB data that was analyzed.
Note: For more information about the fields on this panel, see the online help.
Specify File Allocation Parameters
You can specify the allocation parameters (such as record format, record length, and block size) for the extract, control, load, and report file. The allocation parameters determine the characteristics of the output data set. Each data set has its own set of allocation parameters. Changes to the parameters for one data set do not affect the parameters assigned to another.
Chapter 3: Process Log Facility 39
Chapter 3: Process Log Facility 39