Overview of helpful administration statements

The table below lists all administration statements that are helpful for generating diagnostics documents. The last column in the table refers you to detailed descriptions of the administration statements and commands in the alphabetical reference section of the manual.

Administration statement (SDF format)	Administration command (ISP format)	Administration of	Brief description	See
CREATE-DUMP	DUMP	DBH and SESDCN	Dump created	link
SET-DBH-MSG-TRACE	TRACE	DBH	Controls the message trace.	link
SET-DIAGNOSIS- DUMP-PARAMETER	OPT,DIAG,diag-spec	DBH	Controls the creation of a user dump file.	link
SET-SESSION- DIAGNOSIS	-	DBH	Switches deadlock analysis on and off	link
SET-TUNING-TRACE	COS	DBH	Controls request logging	link
SET-USER-CALL-TRACE	TRACE=PAR, TYPE=CALL... TRACE={ON|OFF...}	SESDCN	Controls the logging of the statements of selected users	link
SET-USER-MSG-TRACE	TRACE=PAR, TYPE=MSG... TRACE={ON|OFF...}	SESDCN	Controls the message trace of selected users	link

Table 41: Administration statements for creating diagnostics documents