ADVISE_PARTITION table
The ADVISE_PARTITION table contains information about database partitions recommended by the Design Advisor, and can only be populated in a partitioned database environment.
| Column Name | Data Type | Nullable? | Key? | Description |
|---|---|---|---|---|
| EXPLAIN_REQUESTER | VARCHAR(128) | No | No | Authorization ID of initiator of this Explain request. |
| EXPLAIN_TIME | TIMESTAMP | No | No | Time of initiation for Explain request. |
| SOURCE_NAME | VARCHAR(128) | No | No | Name of the package running when the dynamic statement was explained or name of the source file when the static SQL was explained. |
| SOURCE_SCHEMA | VARCHAR(128) | No | No | Schema, or qualifier, of source of Explain request. |
| SOURCE_VERSION | VARCHAR(64) | No | No | Version of the source of the Explain request. |
| EXPLAIN_LEVEL | CHAR(1) | No | No | Level of Explain information for which this row is relevant. |
| STMTNO | INTEGER | No | No | Statement number within package to which this Explain information is related. |
| SECTNO | INTEGER | No | No | Statement number within package to which this Explain information is related. |
| QUERYNO | INTEGER | No | No | Numeric identifier for explained SQL statement. For dynamic SQL statements (excluding the EXPLAIN SQL statement) issued through CLP or CLI, the default value is a sequentially incremented value. Otherwise, the default value is the value of STMTNO for static SQL statements and 1 for dynamic SQL statements. |
| QUERYTAG | CHAR(20) | No | No | Identifier tag for each explained SQL statement. For dynamic SQL statements issued through CLP (excluding the EXPLAIN SQL statement), the default value is 'CLP'. For dynamic SQL statements issued through CLI (excluding the EXPLAIN SQL statement), the default value is 'CLI'. Otherwise, the default value used is blanks. |
| TBNAME | VARCHAR(128) | Yes | No | Specifies the table name. |
| TBCREATOR | VARCHAR(128) | Yes | No | Specifies the table creator name. |
| PMID | SMALLINT | Yes | No | Specifies the distribution map ID. |
| TBSPACE | VARCHAR(128) | Yes | No | Specifies the table space in which the table resides. |
| COLNAMES | CLOB(2M) | Yes | No | Specifies database partition column names, separated by commas. |
| COLCOUNT | SMALLINT | Yes | No | Specifies the number of database partitioning columns. |
| REPLICATE | CHAR(1) | Yes | No | Specifies whether or not the database partition is replicated. |
| COST | DOUBLE | Yes | No | Specifies the cost of using the database partition. |
| USEIT | CHAR(1) | Yes | No | Specifies whether or not the database partition is used in EVALUATE PARTITION mode. A database partition is used if USEIT is set to 'Y' or 'y'. |
| RUN_ID | TIMESTAMP | Yes | FK | A value corresponding to the START_TIME of a row in the ADVISE_INSTANCE table, linking it to the same Design Advisor run. |