A tabela SYSDYNQRY contém informações para a estabilização de caminhos de acesso para instruções SQL dinâmicas.
O esquema é SYSIBM.
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. |
|
| UPDATEDTS |
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. |
|
| FUNCTION_LVL |
VARCHAR(10) |
The function level of the query. |
G |
