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

REPORT - For details refer to ACCOUNTING command with REPORT subcommand

REDUCE - For details refer to ACCOUNTING command with REDUCE subcommand

RESTORE - For details refer to ACCOUNTING command with RESTORE subcommand

SAVE - For details refer to ACCOUNTING command with SAVE subcommand

TRACE - For details refer to ACCOUNTING command with TRACE subcommand

FILE - For details refer to ACCOUNTING command with FILE subcommand

Commands, subcommands, and subcommand options

Table 1. Commands, subcommands, and subcommand options table
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
Report set command	IOACTIVITY	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
Report set command	RETRACE	FILE	TO, FROM, DDNAME, INCLUDE, EXCLUDE
Report set command	SQLACTIVITY	REPORT	TO, FROM, DDNAME, ORDER, INCLUDE, EXCLUDE, SORTBY, SUMMARIZEBY, WORKLOAD
Report set command	SQLACTIVITY	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
Report set command	SYSPARMS	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
Troubleshooting commands	TAPECOPY	N/A	EXEC, OFFSET, CODES, SKIP, STOPAFT, NEWCOPY