SET-DIAGNOSIS-DUMP-PARAMETER

Controls the creation of a dump

Scope of validity

DBH administration

Function

You use the SET-DIAGNOSIS-DUMP-PARAMETER administration statement to specify for which user, and after which DBH replies, a dump file is to be created.

As soon as the execution of a statement has been completed, the DBH returns the result of processing (see the “ Messages” manual). What the DBH returns depends on whether the statement is an SQL or CALL DML statement:

• after SQL statements, the DBH returns an SQLSTATE

• after CALL DML statements, the DBH returns a status.

You can use the SET-DIAGNOSIS-DUMP-PARAMETER administration statement to cause returned SQLSTATEs or statuses to be checked against an SQLSTATE or status defined in the administration statement. If the two values are the same, the DBH outputs message SES6016 and creates a dump file (see also chapter “Error handling”ff).

SET-DIAGNOSIS-DUMP-PARAMETER

DUMP = *ON(...) / *OFF(...) / *INIT
	*ON(...)
		|	SELECT = *SQL(...) / *CALL-DML(...)
		|		*SQL(...)
		|			|	SQLSTATE = <alphanum-name 5..5>
		|		*CALL-DML(...)
		|			|	STATE = <alphanum-name 2..2>
		|	,USER = *ALL / <user-identification>
	*OFF(...)
		|	SELECT = *SQL / *CALL-DML

Operands

DUMP =

Turns checking of the SQLSTATE or CALL DML status on/off.

DUMP = *ON(...)
Turns on the checking of the SQLSTATE or CALL DML status.

SELECT =
Specifies if the check of the SQLSTATE or of the CALL DML status is to be turned on.

SELECT = *SQL(...)
Turns on checking of the SQLSTATE.

SQLSTATE = <alphanum-name 5..5>
Specifies the SQLSTATE upon whose occurrence a user dump file is created.

SELECT = *CALL-DML(...)
Turns on checking of the CALL DML status.

STATE = <alphanum-name 2..2>
Specifies the CALL DML status upon whose occurrence a user dump file is created.

USER =
Specifies for which users or which group of users (for partial qualification) the checking of SQLSTATE or of the CALL DML status is to be turned on.

USER = *ALL
Turns on checking of the SQLSTATE or CALL DML status for all users.

USER = <user-identification>
Identifies one or more users for whom the checking of the SQLSTATE or of the CALL DML status is to be turned on. The syntax of the parameter is described in section “Syntax for the identification of users”. The identification entered here is valid until the administration statement is issued again.

DUMP = *OFF(...)

Turns off checking of the SQLSTATE or CALL DML status.

SELECT =
Specifies if the check of the SQLSTATE or of the CALL DML status is to be turned off.

SELECT = *SQL
Turns off checking of the SQLSTATE.

SELECT = *CALL-DML
Turns off checking of the CALL DML status.

DUMP = *INIT
Reinitializes dump control. A dump is always output when the next consistency check takes place, see section “Main-memory dump”.

Administration command in ISP format and at the CALL DML interface

The OPT,DIAG administration command corresponds to the SET-DIAGNOSIS-DUMP-PARAMETER administration command here.

OPT,DIAG,{diag-spec[,user-identification]|NOSTATUS|NOSQLSTATE|INITDUMP}

diag-spec ::= {STATUS=y|SQLSTATE=z}