The EEEWORK table
The EEEWORK table is used internally to find all of the indexes used by a given plan or
package if a parameter of INDEX=Condensed has been specified.
The first three columns of the EEEWORK table are also used for defining the database and table space names for the location of the PLAN_TABLE tables that are created.
| Column name | Data type | Description |
|---|---|---|
| Location | Char(16) NNWD | Location name for Db2® subsystem, or blank |
| Creator | Char(8) Not Null | Authorization ID for row creation |
| Tabcreator | Char(8) Not Null | Authorization ID of table owner |
| Tabname | Varchar(18) NNWD | Table name |
| Timestamp | Timestamp NNWD | Timestamp for creation or change for row |
| Type | Char(1) NNWD | Internal indicator |