Defining a default report

• 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 BMC AMI Log Master directs report output. When generating reports, you can specify that BMC AMI 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 BMC AMI Log Master to sort the quiet ranges based on duration or number of open transactions. Different sorting orders can change the quiet range that BMC AMI 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. BMC AMI 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:

• BMC AMI Log Master reports frequently include Db2 object names. 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, BMC AMI 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). BMC AMI 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).

• BMC AMI Log Master attempts to translate Unicode characters to EBCDIC in output reports. If a Unicode character in a report is not translatable to EBCDIC, BMC AMI 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, BMC AMI Log Master writes additional lines in the report to note the untranslated characters and include 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, BMC AMI Log Master does not define any default reports. As a result, after you select Define Report and File Outputs, BMC AMI Log Master immediately display the Output Options panel. At a minimum, you must also define a time frame when you use this task dialog to define reports.
• Most BMC AMI 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

1. From the Actions category on the Main Menu, select Generate MIGRATE SQL and press Enter.BMC AMI Log Master displays the Generate Migrate SQL panel.
2. Select Define Report and File Outputs and press Enter.BMC AMI Log Master displays the Report and File Outputs panel.
3. In the ACT column beside any existing output, type I and press Enter.BMC AMI Log Master displays the Output Options panel.
4. Select the type of report that you want to define and press Enter.BMC AMI 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.
5. Select Standard Default and press Enter.BMC AMI Log Master displays the Report Output panel for the type of report that you selected (in this example, a Detail report).
6. 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.
7. Press F3 until you return to the Report and File Outputs panel and verify that BMC AMI Log Master has added your report request to the list.