Log Master CLIST and how to run the online interface
To execute from Interactive System Productivity Facility (ISPF) Option 6, enter one of the following TSO commands, depending on whether you want to pass the Db2 subsystem ID (SSID):
EX ' clistLibName (ALPISPF)'
EX ' clistLibName(ALPISPF)' 'SSID (ssid)'To execute from an ISPF panel, add an option to the panel that executes ALPISPF. For example, if you use LM as the option name, enter one of the following lines in the panel definition, depending on whether you want to pass the SSID:
LM, 'CMD(EX 'clistLibName (ALPISPF)')'
LM, 'CMD(EX 'clistLibName(ALPISPF)' SSID(ssid) )'
The following figure shows the
BMC AMI Log Master for Db2
Main Menu panel of the interface:
BMC AMI Log Master for Db2 - V13.01.00 - Main Menu
Option ===>
Select an option then press enter. DB2 System . . . DXW
Actions: View:
0. Analyze Problem Transactions 30. Previously Created Outputs
1. Generate UNDO SQL 31. DB2 System Log Information
2. Generate REDO SQL 32. LRSN/Timestamp Conversion Panel
3. Generate MIGRATE SQL
4. Generate MIGRATE DDL Options and Defaults:
5. Create Log Reports 40. Online Interface Options
6. Create Logical Log Files 41. Product Options
7. Create Audit Report 42. Output Defaults
8. Generate Automated Drop Recovery 43. Automated Drop Recovery Defaults
9. Generate High-speed Apply JCL 44. Alternate Index Names Defaults
10. Create Catalog Activity Report 45. SQL Execution Codes Defaults
11. Generate REPOS UPDATE JCL 46. Display Default Options
12. Generate REPOS DELETE JCL 47. Display PTF Maintenance Applied
Repository Options:
20. Create or Edit Work IDs
21. Create or Edit Filters
22. Create or Edit Templates
23. Create or Delete Log Marks
24. Delete/Display Repository Tables
Enter X to exit
Option ===>
Select an option then press enter. DB2 System . . . DXW
Actions: View:
0. Analyze Problem Transactions 30. Previously Created Outputs
1. Generate UNDO SQL 31. DB2 System Log Information
2. Generate REDO SQL 32. LRSN/Timestamp Conversion Panel
3. Generate MIGRATE SQL
4. Generate MIGRATE DDL Options and Defaults:
5. Create Log Reports 40. Online Interface Options
6. Create Logical Log Files 41. Product Options
7. Create Audit Report 42. Output Defaults
8. Generate Automated Drop Recovery 43. Automated Drop Recovery Defaults
9. Generate High-speed Apply JCL 44. Alternate Index Names Defaults
10. Create Catalog Activity Report 45. SQL Execution Codes Defaults
11. Generate REPOS UPDATE JCL 46. Display Default Options
12. Generate REPOS DELETE JCL 47. Display PTF Maintenance Applied
Repository Options:
20. Create or Edit Work IDs
21. Create or Edit Filters
22. Create or Edit Templates
23. Create or Delete Log Marks
24. Delete/Display Repository Tables
Enter X to exit
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*