Defining a default report
For a step-by-step procedure, see To define a report.
The following figure shows the Report Output panel for a Detail report. Slight variations of this panel occur depending on the type of report that you request.
. . . . . . . . . . . . . . . . . . . . . . . . . . . ALPP054 Report Output Command ===> __________________________________________________________________ SSID : DEHJ Report Type . . . . . . . . . . . : Detail Report Destination . . . . . . . . SYSOUT: CLASS(*) Edit Destination . . . . . . . . : _ (E=Edit) Print REDO Information. . . . . . : N (Y=Yes, N=No) Include Rollback. . . . . . . . . : N (Y=Yes, O=Only, N=No) Include LOBS. . . . . . . . . . . : I (Y=Yes, N=No, I=Inline) Include XML . . . . . . . . . . . : N (Y=Yes, N=No) Edit Order By . . . . . . . . . . : _ (E=Edit) 1. Table Name 2. Unit of Recovery Create Include/Exclude Columns . : _ (E=Edit)
. . . . . . . . . . . . . . . . . . . . . . . . . . . ALPP054 Report Output Command ===> __________________________________________________________________ SSID : DEHJ Report Type . . . . . . . . . . . : Detail Report Destination . . . . . . . . SYSOUT: CLASS(*) Edit Destination . . . . . . . . : _ (E=Edit) Print REDO Information. . . . . . : N (Y=Yes, N=No) Include Rollback. . . . . . . . . : N (Y=Yes, O=Only, N=No) Select the report ordering options: Default Order . . . . . . . . . 9 1 Order By . . . . . . . . . . . . : 1. Unit of Recovery 10. Dsnum *. Activity Type 2. Plan Name 11. DBID *. Object Type 3. Auth ID 12. PSID *. Command 4. Connection Type 13. OBID *. Column Name 5. Connection ID 14. Primary Key *. Column Number 6. Correlation ID *. Activity (Desc) *. Status 7. Database Name 16. DS Member Name *. Utility 8. Tablespace Name 17. DS Member Id 9. Table Name 18. SSID Create Include/Exclude Columns . : _ (E=Edit)
Defining the report destination. You can save reports in a data set or write them directly to SYSOUT. You can also specify an easily identifiable DD name to which Log Master directs report output. When generating reports, you can specify that Log Master save multiple reports to a single partitioned data set if the reports are produced from within the same log scan.
You can define a default report destination by choosing Output Dataset Defaults from the Main Menu. You can also define a model data set name to use for report data sets through this option. In addition, you can specify certain default values for the online interface by using a product options file (POF). For more information, see the description of the ALPOFDSN installation option in the Installation option descriptions.
Defining overall report content. To control the content of your report, use your time frame and filter, and set values for fields on the Report Output panel. For descriptions of the options on this panel, press F1 to access the online Help.
Ordering report information. Each report type has a default ordering. When you edit a report output file, you can change the report ordering. For most reports, you can specify up to three report ordering fields. For more information, see the Report Ordering section of each report in this section.
You cannot change the ordering of a Backout Integrity report or the standard default version of a Quiet Point report. If you use a report template to customize the Quiet Point report, you can direct Log Master to sort the quiet ranges based on duration or number of open transactions. A different sorting order can change the quiet range that Log Master uses as the point to insert a quiesce record in SYSIBM.SYSCOPY.
Saving the report request. You can save report definitions as part of a log scan step under a work ID. Log Master does not limit the number of report requests that you can save in a work ID, including reports generated from report templates.
Browsing reports and viewing report information. You can view the contents of (or get information about) reports that are saved to a data set. From the Main Menu, select Previously Created Outputs to generate a list of report requests and to browse the contents of (or get information about) a report.
Considerations for defining a report are as follows:
Log Master reports frequently include Db2 object names. On Db2 Version 8.1 and later versions, the object names can be long enough to affect the format of report information. When an object name in a report is longer than the logical record length (LRECL) of the report, Log Master 'wraps' the name and continues it on the next line of output (as shown in Example Audit report by table name and URID). Log Master does not use a continuation character. The report contains as many lines of output as required for the complete Db2 object name.
The position of other data in the report can change, depending on whether object names are long enough to require additional lines. Applications that read report information must be able to tolerate changes in the position of report data (some programs or processes might require modification).
Log Master attempts to translate Unicode characters to EBCDIC in output reports. If a Unicode character in a report is not translatable to EBCDIC, Log Master writes a substitute character as defined by the applicable CCSID conversion information (for example,
x'3F') in the report where one or more untranslatable characters occur. The substitute character is not printable. When untranslatable characters occur in column data, Log Master writes additional lines in the report to note the untranslated characters and includes hexadecimal representation of the original Unicode characters (as shown in Example Audit report by table name and URID and Example Detail report, with long names and untranslatable Unicode data).
When you use Create Log Reports from the Main Menu, Log Master does not define any default reports. As a result, after you select Define Report and File Outputs, Log Master immediately displays the Output Options panel. At a minimum, you must also define a time frame when you use this task dialog to define reports.
Most Log Master reports present only the completed transactions (committed or aborted) that are defined by your time frame and filter. If a report that you generate does not contain the data that you expect, ensure that you have specified your time frame and filter correctly.
This procedure uses the Migrate Data Changes task dialog and provides an overview of defining a report using the online interface. All of the options described in these steps are also provided in other task dialogs (options 0 through 7 in the Actions category on the Main Menu).
To define a report
- From the Actions category on the Main Menu, select Generate MIGRATE SQL and press Enter.
Log Master displays the Generate Migrate SQL panel.
- Select Define Report and File Outputs and press Enter.
Log Master displays the Report and File Outputs panel.
- In the ACT column beside any existing output, type I and press Enter.
Log Master displays the Output Options panel.
- Select the type of report that you want to define and press Enter.
Log Master displays the Report Format panel. This example uses a standard default report. For information about report templates, see Creating a customized report template.
- Select Standard Default and press Enter.
Log Master displays the Report Output panel for the type of report that you selected (in this example, a Detail report).
- Edit the report’s destination, the columns used for report ordering, and the columns included in the report, as necessary.
For more information about the options on this panel, press F1 to access the online Help.
- Press F3 until you return to the Report and File Outputs panel and verify that Log Master has added your report request to the list.