DB2 10.5 for Linux, UNIX, and Windows
DB2 10.5 for Linux, UNIX, and Windows
The EXPLAIN_ACTUALS table contains Explain section actuals information.
| Column Name | Data Type | Nullable? | Key? | Description |
|---|---|---|---|---|
| EXPLAIN_REQUESTER | VARCHAR(128) | No | FK | Authorization ID of initiator of this Explain request. |
| EXPLAIN_TIME | TIMESTAMP | No | FK | Time of initiation for Explain request. |
| SOURCE_NAME | VARCHAR(128) | No | FK | Name of the package running when the dynamic statement was explained or name of the source file when static SQL was explained. |
| SOURCE_SCHEMA | VARCHAR(128) | No | FK | Schema, or qualifier, of source of Explain request. |
| SOURCE_VERSION | VARCHAR(64) | No | FK | Version of the source of the Explain request. |
| EXPLAIN_LEVEL | CHAR(1) | No | FK | Level of Explain information for which this row is relevant. |
| STMTNO | INTEGER | No | FK | Statement number within package to which this Explain information is related. |
| SECTNO | INTEGER | No | FK | Section number within package to which this Explain information is related. |
| OPERATOR_ID | INTEGER | No | FK | Unique ID for this operator within this query. |
| DBPARTITIONNUM | INTEGER | No | No | The partition number of the database partition where the operator has run. |
| PREDICATE_ID | INTEGER | Yes | No | ID of the predicate applied on this operator. NULL if the actuals are operator actuals. |
| HOW_APPLIED | CHAR(10) | Yes | No | How predicate is used by this operator. NULL if PREDICATE_ID is NULL. |
| ACTUAL_TYPE | VARCHAR(12) | No | No | The type of the actual. |
| ACTUAL_VALUE | DOUBLE | Yes | No | The value of the actual. NULL if actual is not available for this operator. |