Start of change

SYSDYNQRY catalog table

The SYSDYNQRY table contains information for the stabilization of access paths for dynamic SQL statements. The schema is SYSIBM.

Column name Data type Description Use
SDQ_STMT_ID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY The identifier of the stabilized dynamic query.  
STBLGRP VARCHAR(128) NOT NULL The name of the stabilization group.  
COPYID SMALLINT NOT NULL WITH DEFAULT The copy type of the stabilized runtime structures for the query in this row:
0
The current copy.
4
An invalid copy.
  
CURSQLID VARCHAR (128) NOT NULL The current SQLID for the stabilized dynamic query.  
CURSCHEMA VARCHAR (128) NOT NULL Current schema for stabilized dynamic query.  
CURAPPLCOMPAT VARCHAR (10) NOT NULL Current application compatibility for stabilized dynamic query.  
QUERY_HASH CHAR(16) NOT NULL FOR BIT DATA The hash key generated by the SQL statement text of the stabilized dynamic query.  
QUERY_HASH_VERSION INTEGER NOT NULL The version of the query hash.  
VALID CHAR(1) NOT NULL Whether the stabilized dynamic query is valid.
'A'
An ALTER statement changed the description of the table or base table of a view referred to by the query. For a CREATE INDEX statement involving data sharing, VALID is also marked as 'A'. The changes do not invalidate the query.
'H'
An ALTER TABLE statement changed the description of the table or base table of a view referred to by the query. For objects that were created in Db2 releases prior to Version 5, the change invalidates the query.
'N'
The stabilized access path is not valid.
'Y'
The stabilized access path for the dynamic query is valid.
  
LASTUSED DATE WITH DEFAULT The date on which the query that uses the stabilized runtime structures was last run.  
RELBOUND CHAR(1) NOT NULL The Db2 release in which the query was stabilized. See Release dependency indicators.  
GROUP_MEMBER VARCHAR(24) NOT NULL The data sharing member name that updates the row.  
Start of changeUPDATEDTSEnd of change TIMESTAMP NOT NULL Timestamp when statement was stabilized.  
ROWID ROWID NOT NULL GENERATED ALWAYS Internal use only.  
STMTTEXT CLOB (2M) NOT NULL The text of the SQL statement and any attribute string.  
DATA1 BLOB(2G) INLINE LENGTH (32329) Internal use only.  
DATA2 BLOB(2G) NOT NULL Internal use only.  
DATA3 BLOB(2G) NOT NULL Internal use only.  
DATA4 BLOB(2G) NOT NULL Internal use only.  
DATA5 VARCHAR(128) NOT NULL Internal use only.  
DATA6 CHAR(8) NOT NULL FOR BIT DATA Internal use only.  
Start of changeFUNCTION_LVLEnd of change Start of changeVARCHAR(10)End of change Start of changeThe function level of the query.End of change Start of changeGEnd of change
End of change