Managing Strategies for Reports

You can save report parameters as strategies. Strategies can be recalled for use during any session and can be edited or changed before each use. Strategies let you save and reuse parameters for reports that are frequently needed. Additionally, you can request that remember the last log RBA processed during each execution of the strategy. The next time that you use the strategy, processing can resume at the saved RBA. This resume processing makes it easy to monitor table activity. Also, you can reread the extract files created in previous executions to create other reports from the same log data.
caladb2
You can save report parameters as strategies. Strategies can be recalled for use during any session and can be edited or changed before each use. Strategies let you save and reuse parameters for reports that are frequently needed. Additionally, you can request that
CA Log Analyzer™ for DB2 for z/OS
remember the last log RBA processed during each execution of the strategy. The next time that you use the strategy, processing can resume at the saved RBA. This resume processing makes it easy to monitor table activity. Also, you can reread the extract files created in previous executions to create other reports from the same log data.
Contents
Create or Update a Strategy
This section describes how to create a strategy for a DML Activity Report. You can also create strategies for other report types.
Follow these steps:
  1. Select
    2
    (Strategy Services) from the
    CA Log Analyzer™ for DB2 for z/OS
     Main Menu.
    The Strategy Services panel appears.
  2. Create a strategy by completing the following fields:
    • Type
      C
      (Create) in the Options field.
    • Enter a name for the strategy in the Strategy field.
    • Enter a description of the strategy in the Description field.
    • Enter a subsystem ID in the Log SSID field.
    You can also type
    U
    (Update) next to an existing strategy to update it.
    Press Enter.
    The Report Specification panel appears.
  3. Select a report type and press Enter.
    The report options panel appears.
  4. Select the report options and press PF3 (End).
    The Report Specification panel reappears.
  5. Press PF3 (End).
    The Output Specification panel appears.
  6. Specify a destination for the extract data set, control data set, and report.
    • You can use symbolic variables such as %DATE, %TIME, and %USER in the data set names. To obtain a single period as a node separator in the data set name, type two periods after a symbolic. See the following example:
      D%DATE..DML.CTL
    • If you leave the data set fields blank, temporary data sets are used to create these files.
    Press PF3 (End).
    The strategy has been created. The Strategy Services panel reappears, showing the new strategy in the selection list.
Update the Resume Point
You can update a strategy to change the resume point. For example, you can set the strategy to the resume point of a prior execution and then reset back to the natural resume point.
Follow these steps:
  1. Select 
    2
     (Strategy Services) from the 
    CA Log Analyzer™ for DB2 for z/OS
     Main Menu.
    The Strategy Services panel appears.
  2. Change the resume point for the strategy:
    1. Find the strategy and type
      R
      (Display Resume Values) in the O (Option) field next to the execution with the resume point to use.
      The execution must have a resume point. If the execution was created from a resume of the strategy, it has a resume point.
      Press Enter.
      The Strategy Resume Display panel appears. This panel shows the current resume point, the in-flight URIDs of the transaction, and the resume point the strategy is set to if updated.
    2. Type
      Y
      next to the Update Resume header field and press Enter.
      The resume point is set to the resume value listed under Selected Execution Results. A Strategy Reset Confirmation window appears.
    3. Type
      Y
      and press Enter.
      The Strategy Services panel reappears. The resume point for the strategy has been changed.
  3. Execute the strategy.
  4. Reset the resume point for the strategy:
    1. Type
      R
      (Display Resume Values) in the O (Option) field on the Strategy Services panel, next to the strategy, and press Enter.
      The Strategy Resume Display panel appears. This panel now displays the current resume point, the in-flight URIDs of the transaction, and the natural resume point for the strategy.
    2. Type
      Y
      in the Update Resume field and press Enter.
      The resume point is reset to the resume value listed under Natural Resume Point. A Strategy Reset Confirmation window appears.
    3. Type
      Y
      and press Enter.
      The Strategy Services panel reappears. The resume point has been reset.
Execute a Strategy
You can execute a saved strategy to generate already configured reports on a regular basis.
You can also select a previously created extract file by selecting the appropriate execution entry under the strategy name. You can alter the strategy options to produce another report. However, the data that is in the extract file constrains your ability to generate other reports from that file. The contents of the extract file vary depending on the report type, filter options, and extract scope that were used when the file was created.
Follow these steps:
  1. Select 
    2
     (Strategy Services) from the 
    CA Log Analyzer™ for DB2 for z/OS
     Main Menu.
    The Strategy Services panel appears.
  2. Type
    S
    (Submit) in the Option field next to a strategy name or execution entry and press PF3 (End).
    The Submit Strategy panel appears.
  3. Complete the following fields:
    • Specify an execution mode in the Execution Mode field.
    • Specify whether to save the execution results in the Save Results field. If you specify Y, the execution results appear on the Strategy Services panel, indented below their parent strategy.
    • Specify whether to resume processing where the strategy last left off in the Log Resume field. If you specify Log Resume = R, also specify a value in the Resume Amount field. This value indicates how many hours of log activity to process. If you specify Log Resume = A, also specify the log range to process in the ALTERNATE LOG RANGE fields.
    • (Optional) Use the UPDATE OPTIONS fields to modify the report settings for this particular execution. You can change report settings, specify alternate data sources, change destination options, or specify the retention options.
    Press Enter.
    The strategy executes.
View the Strategy Output Files
When you execute a strategy,
CA Log Analyzer™ for DB2 for z/OS
creates output files for the extract file, report, and SQL that are generated. You can browse and edit the report and SQL data sets.
Follow these steps:
  1. Specify
    Y
    in the Save Results field.
    The execution results appear on the Strategy Services screen, indented under the strategy name.
  2. Type
    F
    (Files) next to one of the execution results. Press Enter.
    The Strategy File Display panel appears, showing the extract files that were used during the execution and the report or SQL output files that were generated.
  3. Type
    B
    (Browse) next to a file and press Enter.
    This command is not valid for extract or extract control files.
    The output file appears in browse mode. You can now view the file. This file includes an options summary that shows the log range and report options that were used to generate the output.
Copy a Strategy to Another Subsystem
This section explains how to copy a
CA Log Analyzer™ for DB2 for z/OS
strategy to another DB2 subsystem.
Follow these steps:
  1. Select 
    2
     (Strategy Services) from the 
    CA Log Analyzer™ for DB2 for z/OS
     Main Menu.
    The Strategy Services panel appears.
  2. Type
    C
    (Copy) next to a strategy and press Enter.
    The Strategy Copy SSID Confirmation window appears.
  3. Complete the following fields:
    • Specify
      B
      (Batch) or
      O
      (Online) in the Copy Mode field. If the target system is available, you can use online mode to copy the strategy immediately. If the target system is unavailable, you can use batch mode to create Log Apply control statements and to write the strategy rows to an output data set.
    • (Optional) Specify a new strategy name or creator name in the Target fields.
    • Specify the target SSID and Log SSID in the Target fields.
    Press Enter.
    The Strategy Services - Report Specification panel appears.
  4. Press PF3 (End).
    The Process Log - Output specifications panel appears.
  5. Modify the output settings on this panel as needed for the target subsystem. Press PF3 (End).
    If you specified online mode, the strategy is copied to the target subsystem. The Strategy Services panel reappears, with a message that your strategy has been saved. Skip the remaining steps in this section.
    If you specified batch mode, the Copy Strategy - Output Specifications panel appears. Go to the next step.
  6. Complete the following fields:
    • Specify an output data set for the strategy rows in the DATA File DSN field.
    • Specify an output data set for the Log Apply control statements in the CNTL Card DSN field.
    Press PF3 (End).
    The strategy rows and control statements are saved to the specified data sets. The Strategy Services panel reappears, with a message that your data sets have been created.
  7. Execute the Log Apply control statements on the target subsystem.
    The strategy is copied to the target subsystem.