A tabela SYSDYNQRYDEP contém informações sobre dependências para pacotes de consulta dinâmica.
O esquema é SYSIBM.
Os caminhos de acesso para instruções SQL podem depender de objetos que o Db2 não usa de fato quando processa os caminhos de acesso selecionados.
Essas dependências são registradas na tabela do catálogo SYSDYNQRYDEP, mas não são mostradas na saída EXPLAIN.
The SYSDYNQRYDEP table contains information about dependencies for dynamic query packages.
The schema is SYSIBM.
Access paths for SQL statements might depend on objects that Db2 does not actually use when it processes the selected access paths.
Such dependencies are recorded in the SYSDYNQRYDEP catalog table, but they are not be shown in EXPLAIN output.
| Column name |
Data type |
Description |
Use |
| SDQ_STMT_ID |
BIGINT NOT NULL |
The identifier of the stabilized dynamic SQL statement. |
G |
| COPYID |
SMALLINT NOT NULL |
The copy type of the stabilized runtime structures for the query in this row:
- 0
- The current copy.
- 1
- The previous copy.
- 2
- The original copy.
|
G |
| BQUALIFIER |
VARCHAR(128) NOT NULL |
The value of the column depends on the type of object:
- If BNAME identifies a table space (BTYPE is ' R'), the value is the name of its database.
- If BNAME identifies a table on which a period is defined (BTYPE is 'W' or 'Z'), the value is the qualifier of that table.
- If BNAME identifies user-defined function, a cast function, a stored procedure, or a sequence (BTYPE is 'F', 'O', or 'Q'), the value is the schema name.
- If BNAME identifies a role, the value is blank.
- Otherwise, the value is the schema of BNAME.
|
G |
| BNAME |
VARCHAR(128) NOT NULL |
The name of the object that the query depends on. |
G |
| BTYPE |
CHAR(1) NOT NULL |
Type of object identified by BNAME and BQUALIFIER:
- 'E'
- INSTEAD OF trigger
- 'F'
- User-defined function or cast function
- 'G'
- Global temporary table.
- 'I'
- Index.
- 'M'
- Materialized query table
- 'O'
- Stored procedure
- 'P'
- Partitioned table space if it is defined as LARGE or with the DSSIZE parameter
- 'Q'
- Sequence object
- 'R'
- Table space
- 'S'
- Synonym
- 'T'
- Table
- 'U'
- Distinct type
- 'V'
- View
- 'W'
- SYSTEM_TIME period
- 'Z'
- BUSINESS_TIME period
- '0' (zero)
- Alias
|
G |
| CLASS |
CHAR(1) NOT NULL |
- 'A'
- Authorization dependency
- 'D'
- Data Definition Language dependency
|
G |
| BAUTH |
SMALLINT NOT NULL WITH DEFAULT |
The privilege that is held on the object on which the query depends. The privilege applies only when CLASS is 'A'.
- 50
- SELECTAUTH
- 51
- INSERTAUTH
- 52
- DELETEAUTH
- 53
- UDPATEAUTH
- 64
- EXECUTEAUTH
- 263
- USAGEAUTH
- 291
- READAUTH
- 292
- WRITEAUTH
- 0
- The column is not used. CLASS is 'D'.
|
G |
| AUTHID_TYPE |
CHAR(1) NOT NULL WITH DEFAULT |
The type of authorization indicated by AUTHID.
- '' (blank)
- The value of CLASS is 'D', or the value of CLASS is 'A' and AUTHID contains the name of an authorization ID.
- 'L'
- AUTHID contains the name of a role.
|
G |
| AUTHID |
VARCHAR(128) NOT NULL WITH DEFAULT |
The owner of the privilege on the object on which the query is dependent, or a zero-length string if the value of CLASS is 'D'. |
G |
| DBNAME |
VARCHAR(128) NOT NULL WITH DEFAULT |
If the value of SDBADMAUTH is 'Y', DBNAME contains the name of the database on which the user or role indicated by AUTHID holds DBADM authority.
Otherwise the value is blank. |
G |
| BADMINAUTH |
CHAR(1) NOT NULL |
The authority that allowed access to the object on which the query is dependent.
The admin authority only applies when CLASS is 'A'.
- 'B'
- SDBADMAUTH
- 'D'
- DBADMAUTH
- 'G'
- ACCESSCTRLAUTH
- 'K'
- SQLADMAUTH
- 'L'
- SYSCTRLAUTH
- 'S'
- SYSADMAUTH
- 'T'
- DATAACCESSAUTH
- ''
- Authority not held
|
G |
| PUBLICAUTH |
CHAR(1) NOT NULL WITH DEFAULT |
- 'Y'
- This privilege is held by PUBLIC by the user or role indicated in AUTHID.
- ' ' (blank)
- This privilege is not held by PUBLIC, or the value of CLASS is 'D'.
|
G |
| ALLOBJAUTH |
CHAR(1) NOT NULL WITH DEFAULT |
- 'Y'
- The privilege is held on all objects within the schema by the user or role indicated in AUTHID.
- ' ' (blank)
- This privilege is not held on all objects within the schema, or the value of CLASS is 'D'.
|
G |
| QUERYHASH |
BINARY(16) WITH DEFAULT |
The hash key of the statement text if the value of CLASS is 'D', otherwise hexadecimal zeros. |
G |
| — |
CLOB(2M) NOT NULL WITH DEFAULT |
Internal use only. |
I |
| — |
CHAR(8) NOT NULL FOR BIT DATA |
Internal use only. |
I |
