Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Log Master for Db2 13.1.

Reports from the log scan


Log Master

 provides a comprehensive reporting facility.

You can select from the following report types:

  • Audit
  • Detail
  • Summary
  • Object Activity Summary
  • Catalog Activity
  • Commit
  • Rollback
  • Data Capture Analysis
  • Image Copy
  • Backout Integrity
  • Quiet Point
  • Open Transaction
  • Commands
  • Log Bytes
  • Column Update Frequency

Reports and output files that correspond to a particular task are automatically selected when you use a task dialog to perform the following actions:

  • Back out application transactions
  • Migrate data changes
  • Perform an audit

You can also define customized reports by using report templates. With report templates, you can:

  • Control the content of the report
  • Control the format of the report, by defining the content and placement of headers, footers, text constants, data elements, and other report characteristics
  • Use additional report data elements or sort capabilities that are available only in customized reports

If you use application programs to extract information from Log Master reports, you can use templates to optimize the report data for your program.

The following figure shows Output Options panel  lists the types of reports and outputs that you can generate. The individual reports are grouped into the categories Log Information, Performance, and Miscellaneous. The File Outputs category refers to forms of output other than reports.

OUTPUTS                         Report and File Outputs                        
C .-------------------------------------------------------------------. > HALF
  |                                 Output Options                    | : DJV  
W |                                                                   |        
D | Options(D) . . .                                                  |        
  | File Outputs                     Performance Reports              |        
E |    1. SQL (Dataset, Execution)     12. Commit                     |        
  |    2. Logical Log File Outputs     13. Rollback                   |        
A |    3. Load File Outputs            14. Image Copy                 |        
* |    4. DDL File Outputs             15. Data Capture Analysis      | ***    
  |    5. Command File Outputs       Miscellaneous Reports            |        
  | Log Information Reports            16. Quiet Point                |        
  |    6. Audit                        17. Open Transaction           |        
  |    7. Detail                       18. Backout Integrity          |        
  |    8. Summary                      19. Commands                   |        
  |    9. Object Activity Summary      20. Log Bytes                  |        
  |   10. Catalog Activity              *. Drop Recovery              |        
  |   11. Column Update Frequency      22. Status Changes             |        
  |                                                                   |        
  |  F1=Help   F12=Cancel                                             |        
  '-------------------------------------------------------------------'        
                                                                              
                                                                              
 F1=Help      F3=Exit      F7=Backward  F8=Forward  F12=Cancel

In addition to using the default reports for a task dialog, you can change the report, or add additional reports to a log scan. You can also view or get information about previously created reports. For a description of reports and the steps necessary to create or view them, see Auditing-data-changes.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*