Objects that are used by the sample trace stored procedures

The sample trace stored procedures use a global variable, an user-defined array type, and a declared temporary table.

Sample job DSNTEJTR creates those objects.

Global variable DSN8.DBMS_ENABLE

The DSN8.DBMS_ENABLE global variable is used to test if the trace is enabled.

Example: Test whether the trace is enabled before attempting to write to the trace buffer.

IF DSN8.DBMS_ENABLE = 'Y' THEN CALL DSN8.PUT_LINE (LINE); 
END IF;

Array type DSN8.GRPHICARR

The user-defined array type DSN8.GRPHICARR is used for the first parameter to the DSN8.GET_LINES procedure. An array variable that is declared with the DSN8.GRPHICARR type is used to hold lines that are retrieved from the message buffer.

DSN8.GRPHICARR is defined as:

VARGRAPHIC(16334) ARRAY[2147483647]

Example: Declare SQL variable LINES to hold lines that are retrieved from the message buffer.

DECLARE LINES DSN8.GRPHICARR;

Declared temporary table SESSION.DBMS_BUFFER

The SESSION.DBMS_BUFFER declared temporary table contains the message buffer.