Overview of the commands

Use the information in the table to understand the commands and their related subcommands and subcommand options. There are three types of commands: report set commands, auxiliary commands, and troubleshooting commands.

Report set command - ACCOUNTING

This section gives a short overview of the commands, subcommands, and subcommand options. For details, refer to the corresponding detailed sections.

ACCOUNTING commands - Subcommands and subcommand options

The table lists all ACCOUNTING commands, subcommands, and subcommand options.

REPORT - For details refer to ACCOUNTING command with REPORT subcommand


1  REPORT?  
2.1 %FROM/TO block
2.1  SCOPE (
2.2.1! MEMBER
2.2.1 GROUP
2.1 )
2.1  LAYOUT (
2.2.1! SHORT
2.2.1 LONG
2.2.1 name
2.1 )
2.2.1! NOEXCEPTION
2.2.1 EXCEPTION
2.1  TOP (
2.2.1 number
2.2.1! 10
2.1 ? ONLY? TOTAL
2.1 
2.2.1 keyword
2.2.1! INAPPLET
2.1 )
2.1  DDNAME (
2.2.1 ddname
2.2.1! ACRPTDD
2.1 )
2.1 %ORDER block
2.1 %INCLUDE/EXCLUDE block

REDUCE - For details refer to ACCOUNTING command with REDUCE subcommand


1  REDUCE?  
2.1 %FROM/TO block
2.1  INTERVAL (
2.2.1 minutes
2.2.1! 0
2.1 )
2.1  INTERSEC (
2.2.1 seconds
2.2.1 1
2.2.1! 59
2.1 )
2.1  BOUNDARY (
2.2.1 minutes
2.2.1 0
2.2.1! 60
2.1 )
2.1  CALCULATE
2.1 %INCLUDE/EXCLUDE block

RESTORE - For details refer to ACCOUNTING command with RESTORE subcommand


1  RESTORE?  DDNAME (
2.1 ddname
2.1! ACRSTDD
1 )

SAVE - For details refer to ACCOUNTING command with SAVE subcommand


1  SAVE?  CONVERT
1! DATATYPE(ALL)
1? DATATYPE(GENERAL?,BP?,GBP?,DDF?,RLF?,PACKAGE?,ACCEL?,BPTOTAL?,GBPTOTAL)
2?  DDNAME (
3.1 ddname
3.1! ACSAVDD
2 )

TRACE - For details refer to ACCOUNTING command with TRACE subcommand


1  TRACE?  
2.1 %FROM/TO block
2.1  LAYOUT (
2.2.1! SHORT
2.2.1 LONG
2.2.1 name
2.1 )
2.2.1! NOEXCEPTION
2.2.1 EXCEPTION
2.1  TOP (
2.2.1 number
2.2.1! 10
2.1 ? ONLY
2.1 
2.2.1 keyword
2.2.1! INAPPLET
2.1 )
2.1  DDNAME (
2.2.1 ddname
2.2.1! ACTRCDD*
2.1 )
2.1 %INCLUDE/EXCLUDE block

FILE - For details refer to ACCOUNTING command with FILE subcommand


1  FILE?  
2.1 %FROM/TO block
2.2.1! NOEXCEPTION
2.2.1 EXCEPTION
2.2.1! DATATYPE(ALL)
2.2.1? DATATYPE(?GENERAL?,BP?,GBP?,DDF?,PACKAGE?,ACCEL?,BPTOTAL?,GBPTOTAL)
2.1 %INCLUDE/EXCLUDE block
2.1  DDNAME (
2.2.1 ddname
2.2.1! ACFILDD1
2.1 )

Commands, subcommands, and subcommand options

Table 1. Commands, subcommands, and subcommand options table

This table shows and all possible subcommands and subcommand options for each command type and command name.
Command types Commands Subcommands Subcommand options
Report set command ACCOUNTING REPORT TO, FROM, DDNAME, ORDER, INCLUDE, EXCLUDE, EXCEPTION, NOEXCEPTION, LAYOUT, TOP, SCOPE
REDUCE TO, FROM, INTERVAL, BOUNDARY, INCLUDE, EXCLUDE
SAVE DDNAME, DATATYPE
RESTORE DDNAME
TRACE TO, FROM, DDNAME, INCLUDE, EXCLUDE, EXCEPTION, NOEXCEPTION, LAYOUT, TOP
FILE TO, FROM, DDNAME, INCLUDE, EXCLUDE, EXCEPTION, NOEXCEPTION
Report set command AUDIT REPORT TO, FROM, DDNAME, TYPE, LEVEL, ORDER, INCLUDE, EXCLUDE, SCOPE
REDUCE TO, FROM, INCLUDE, EXCLUDE, SCOPE
TRACE TO, FROM, DDNAME, TYPE, INCLUDE, EXCLUDE, SCOPE
FILE TO, FROM; DDNAME, TYPE, INCLUDE, EXCLUDE
Report set command EXEC N/A N/A
Report set command EXPLAIN ACCTYPE MATCHING, NONMATCH, TABSCAN
DBRM N/A
DEGREE ANY, DSJ, ESJ
FIRST/LAST N/A
FORCE NO, YES
FORMAT NO, YES
GEN N/A
HOSTVAR NO, YES
INDEX ALL, NO, YES
LEVEL N/A
Report set command IOACTIVITY REPORT TO, FROM, DDNAME, LEVEL, ORDER, INCLUDE, EXCLUDE
REDUCE TO, FROM, INTERVAL, BOUNDARY, INCLUDE, EXCLUDE
Report set command LOCKING REPORT TO, FROM, DDNAME, LEVEL, ORDER, INCLUDE, EXCLUDE, SCOPE, SPREADSHEETDD
REDUCE TO, FROM, INTERVAL, BOUNDARY, INCLUDE, EXCLUDE
TRACE TO, FROM, DDNAME, LEVEL, INCLUDE, EXCLUDE, SCOPE
FILE TO, FROM, DDNAME, INCLUDE, EXCLUDE
Report set command RETRACE TRACE TO, FROM, DDNAME, LEVEL, INCLUDE, EXCLUDE, SORTBY
FILE TO, FROM, DDNAME, INCLUDE, EXCLUDE
Report set command SQLACTIVITY REPORT TO, FROM, DDNAME, ORDER, INCLUDE, EXCLUDE, SORTBY, SUMMARIZEBY, WORKLOAD
TRACE TO, FROM, DDNAME, INCLUDE, EXCLUDE, LIMIT, SORTBY, SUMMARIZEBY, WORKLOAD, SQLTEXT
Report set command STATISTICS REPORT TO, FROM, DDNAME, ORDER, INCLUDE, EXCLUDE, EXCEPTION, NOEXCEPTION, LAYOUT, SCOPE, DSETSTAT
REDUCE TO, FROM, INTERVAL, BOUNDARY, INCLUDE, EXCLUDE
SAVE DDNAME, DSETSTAT
RESTORE DDNAME
TRACE TO, FROM, DDNAME, INCLUDE, EXCLUDE, EXCEPTION, NOEXCEPTION, LAYOUT, DSETSTAT
FILE TO, FROM, DDNAME, INCLUDE, EXCLUDE, EXCEPTION, NOEXCEPTION, DSETSTAT
Report set command SYSPARMS TRACE DDNAME
FILE DDNAME
Report set command UTILITY REPORT TO, FROM, DDNAME, TYPE, ORDER, INCLUDE, EXCLUDE
REDUCE TO, FROM, INTERVAL, BOUNDARY, INCLUDE, EXCLUDE
TRACE TO, FROM, DDNAME, TYPE, ORDER, INCLUDE, EXCLUDE, WORKLOAD
Auxiliary commands CASE N/A SENSITIVE, ANY
FIELD N/A N/A
GLOBAL N/A FROM, TO, INTERVAL, PRESORTED, SPANINC, BOUNDARY, INPUTDD, PAGESIZE, TIMEZONE, EXPLAIN, INCLUDE, EXCLUDE
GROUP N/A L, G, R
LIST N/A L, G, R
Troubleshooting commands DUMP N/A EXEC, OFFSET, CODES, SKIP, STOPAFT, MAXDUMP
TAPECOPY N/A EXEC, OFFSET, CODES, SKIP, STOPAFT, NEWCOPY