LAYOUT subcommand option

The LAYOUT subcommand option specifies the name of a report layout.

Usage

You can select the layout of Accounting and Statistics model reports and traces.

Usage notes

Options

You can specify one of the supplied layouts or one that you have previously tailored:

SHORT
Provides a short layout. SHORT is used by default.
Note:
If a report does not contain the details that you are looking for (such as thread-related data), run the job again using the LAYOUT subcommand option LONG. You can also use other functions such as Record Trace and SQL Activity to find detailed DB2 trace data.
LONG
Provides detailed thread-related data.
migration layouts
Supplied migration layouts to help you identify OMEGAMON XE for DB2 PE data that was previously shown in the reports of the OMEGAMON Historical Reporter. The migration layouts include:
user-defined layouts
You can customize your own report layouts by specifying which blocks of data and which fields within the blocks are included, and their relative order. To adapt the reports according to your requirements, you use user-tailored reporting (UTR). With UTR, you can control the volume, contents, and layout of Statistics traces and reports.

For information about tailoring report layouts, see the Reporting User's Guide.

Options for OMEGAMON Historical Reporter Accounting reports

To find information that was previously contained in the Accounting reports of the OMEGAMON Historical Reporter use the LAYOUT subcommand options shown in the following table.

Table 5. LAYOUT subcommand options for Accounting reports of the OMEGAMON Historical Reporter
LAYOUT subcommand option OMEGAMON XE for DB2 PE blocks which contain information previously provided in OMEGAMON Historical Reporter
DDF The Distributed Activity - Requester and Distributed Activity - Server blocks contain information previously provided in OMEGAMON Historical Reporter:
  • DISTRIBUTED_DATA_FACILITY_ACTIVITY
  • DETAIL
LOCK The Locking block contains information previously provided in OMEGAMON Historical Reporter:
  • LOCK_ACTIVITY
  • DETAIL
  • SUMMARY
The Drain/Claim block contains information previously provided in OMEGAMON Historical Reporter:
  • LOCK_ACTIVITY
  • DETAIL
The Data Sharing Locking block contains information previously provided in OMEGAMON Historical Reporter:
  • GLOBAL_LOCK_ACTIVITY
PACK The following blocks:
  • Package Identification
  • Times - Class 7 - Package Times
  • Package Suspensions
  • Global Locking L-Locks (Package)
  • Global Locking P-Locks (Package)
  • SQL Activity (Package)
  • Buffer Pool Activity (Package)
  • Locking Activity (Package)
contain information previously provided in OMEGAMON Historical Reporter:
  • DETAIL
  • PACKAGE_DETAIL
POOL The Buffer Pool Activity block contains information previously provided in OMEGAMON Historical Reporter:
  • BUFFER_POOL_ACTIVITY
  • DETAIL
  • SUMMARY
The Group Buffer Pool Activity block contains information previously provided in OMEGAMON Historical Reporter:
  • GROUP_BUFFER_POOL_ACTIVITY
PTA The Query Parallelism block contains information previously provided in OMEGAMON Historical Reporter:
  • PARALLEL_TASKS
  • Query Parallelism (SQL_ACTIVITY)
  • DETAIL
The Times - Class 1 - Application Time block contains information previously provided in OMEGAMON Historical Reporter:
  • PARALLEL_TASKS
  • DETAIL
  • TIME_SUMMARY
The Times - Class 2 - DB2 Time block contains information previously provided in OMEGAMON Historical Reporter:
  • PARALLEL_TASKS
  • DETAIL
  • TIME_SUMMARY
The Times - Class 3 - Suspensions block contains information previously provided in OMEGAMON Historical Reporter:
  • SUMMARY
  • TIME_SUMMARY
The Highlights block contains information previously provided in OMEGAMON Historical Reporter:
  • Miscellaneous Statements (SQL_ACTIVITY), only traces
  • TERMINATION_SUMMARY
RID The RID List block contains information previously provided in OMEGAMON Historical Reporter:
  • RID Pool Access (SQL_ACTIVITY)
  • DETAIL
RLF The Resource Limit Facility block contains information previously provided in OMEGAMON Historical Reporter:
  • Limit Origin (RESOURCE_LIMIT_FACILITY_SUMMARY)
  • DETAIL
STP The Times - Class 1 - Application Time block contains information previously provided in OMEGAMON Historical Reporter:
  • PARALLEL_TASKS
  • DETAIL
  • TIME_SUMMARY
The Times - Class 2 - DB2 Time block contains information previously provided in OMEGAMON Historical Reporter:
  • PARALLEL_TASKS
  • DETAIL
  • TIME_SUMMARY
The Times - Class 3 - Suspensions block contains information previously provided in OMEGAMON Historical Reporter:
  • SUMMARY
  • TIME_SUMMARY
The Stored Procedures block contains information previously provided in OMEGAMON Historical Reporter:
  • Stored Procedures (SQL_ACTIVITY)
  • DETAIL
SQL The SQL DCL block contains information previously provided in OMEGAMON Historical Reporter:
  • DCL Statements (SQL_ACTIVITY)
  • DETAIL
The SQL DDL block contains information previously provided in OMEGAMON Historical Reporter:
  • DDL Statements (SQL_ACTIVITY)
  • Miscellaneous Statements (SQL_ACTIVITY)
  • DETAIL
The SQL DML block contains information previously provided in OMEGAMON Historical Reporter:
  • DML Statements (SQL_ACTIVITY)
  • DETAIL
TERM The Application Termination block contains information previously provided in OMEGAMON Historical Reporter:
  • TERMINATION_SUMMARY
TIME The Times - Class 1 - Application Time block contains information previously provided in OMEGAMON Historical Reporter:
  • PARALLEL_TASKS
  • DETAIL
  • TIME_SUMMARY
The Times - Class 2 - DB2 Time block contains information previously provided in OMEGAMON Historical Reporter:
  • PARALLEL_TASKS
  • DETAIL
  • TIME_SUMMARY
The Times - Class 3 - Suspensions block contains information previously provided in OMEGAMON Historical Reporter:
  • SUMMARY
  • TIME_SUMMARY
The Highlights block contains information previously provided in OMEGAMON Historical Reporter:
  • Miscellaneous Statements (SQL_ACTIVITY), only traces
  • TERMINATION_SUMMARY
The Global Locking L-Locks (Plan) block contains information previously provided in OMEGAMON Historical Reporter:
  • SUMMARY
  • TIME_SUMMARY
The Global Locking P-Locks (Plan) block contains information previously provided in OMEGAMON Historical Reporter:
  • SUMMARY
  • TIME_SUMMARY

Options for OMEGAMON Historical Reporter Statistics reports

To find information that was previously contained in the Statistics reports of the OMEGAMON Historical Reporter use the LAYOUT subcommand options shown in the following table.

Table 6. LAYOUT subcommand options for Statistics reports of the OMEGAMON Historical Reporter
LAYOUT subcommand option OMEGAMON XE for DB2 PE PE blocks which contain information previously provided in OMEGAMON Historical Reporter
BIND The Plan/Package Processing block contains information previously provided in OMEGAMON Historical Reporter:
  • DETAIL
  • Miscellaneous Statements (SQL_ACTIVITY)
  • Plan (BIND_ACTIVITY)
  • Package (BIND_ACTIVITY)
The Authorization Management block contains information previously provided in OMEGAMON Historical Reporter:
  • Auth Chk (BIND_ACTIVITY)
CMD The DB2 commands block contains information previously provided in OMEGAMON Historical Reporter:
  • COMMAND_ACTIVITY
  • DETAIL
DDF The DRDA® Remote Locations block contains information previously provided in OMEGAMON Historical Reporter:
  • 2-Phase Commits (DISTRIBUTED_DATA_FACILITY_ACTIVITY)
  • DETAIL
The Global DDF Activity block contains information previously provided in OMEGAMON Historical Reporter:
  • DETAIL
LOCK The Locking Activity block contains information previously provided in OMEGAMON Historical Reporter:
  • LOCK_ACTIVITY
  • DETAIL
  • SUMMARY
The Data Sharing Locking block contains information previously provided in OMEGAMON Historical Reporter:
  • GLOBAL_LOCK_ACTIVITY
LOG The Log Activity block contains information previously provided in OMEGAMON Historical Reporter:
  • LOCK_ACTIVITY
  • DETAIL
OPCL The Open/Close Activity block contains information previously provided in OMEGAMON Historical Reporter:
  • OPEN_CLOSE_ACTIVITY
  • DETAIL
POOL The Buffer Pool General block contains information previously provided in OMEGAMON Historical Reporter:
  • General (BUFFER_POOL_ACTIVITY)
  • Query Parallelism (BUFFER_POOL_ACTIVITY)
  • DETAIL
  • SUMMARY
The Buffer Pool Read block contains information previously provided in OMEGAMON Historical Reporter:
  • Read Operations (BUFFER_POOL_ACTIVITY)
  • DETAIL
  • SUMMARY
The Buffer Pool Sort/Merge block contains information previously provided in OMEGAMON Historical Reporter:
  • Sort/Merge (BUFFER_POOL_ACTIVITY)
  • DETAIL
  • SUMMARY
The Buffer Pool Write block contains information previously provided in OMEGAMON Historical Reporter:
  • Write Operations (BUFFER_POOL_ACTIVITY)
  • DETAIL
  • SUMMARY
The Group Buffer Pool Activity block contains information previously provided in OMEGAMON Historical Reporter:
  • GROUP_BUFFER_POOL_ACTIVITY
The EDM Pool Activity block contains information previously provided in OMEGAMON Historical Reporter:
  • EDM_POOL_ACTIVITY
  • DETAIL
QP The Query Parallelism block contains information previously provided in OMEGAMON Historical Reporter:
  • Query Parallelism (SQL_ACTIVITY)
  • DETAIL
STP The Stored Procedures block contains information previously provided in OMEGAMON Historical Reporter:
  • Stored Procedures (SQL_ACTIVITY)
  • DETAIL
SQL The SQL DCL block contains information previously provided in OMEGAMON Historical Reporter:
  • DCL Statements (SQL_ACTIVITY)
  • DETAIL
  • SUMMARY
The SQL DDL block contains information previously provided in OMEGAMON Historical Reporter:
  • DDL Statements (SQL_ACTIVITY)
  • DETAIL
  • SUMMARY
  • Miscellaneous Statements (SQL_ACTIVITY)
The SQL DML block contains information previously provided in OMEGAMON Historical Reporter:
  • DML Statements (SQL_ACTIVITY)
  • DETAIL
  • SUMMARY
SUBS The Subsystem Services block contains information previously provided in OMEGAMON Historical Reporter:
  • SUBSYSTEM_ACTIVITY
  • DETAIL
TIME The CPU Times block contains information previously provided in OMEGAMON Historical Reporter:
  • CPU_TIME_SUMMARY
  • DETAIL