Dynamic SQL Cache Text Attributes

Use these attributes to view dynamic SQL cache text information.

DB2 Subsystem The DB2 subsystem ID.

DB2 Version The DB2 version.

DSG Member Name The Data Sharing Group (DSG) member name.

Data Sharing Group The Data Sharing Group name.

Interval Start The start time of this interval.

MVS System ID The MVS identifier.

Originating System The managed system name of the agent. It is an alphanumeric text string, with a maximum of 32 characters; for example, DB91:SYS1:DB2.

Statement Text The text of the SQL statement (Field name: QW0317TX).

Statement Name The name of the SQL statement (Field name: QW0317NM).

Unique Identifier The identifier of the SQL statement in hexadecimal (Field name: QW0317ID).