Description: Contains zero or more rows for every plan. Each row for a given plan represents one or more connections to an environment in which the plan could be used.
Tablespace: SYSPLAN
Indexes(Fields):
None
| Column name | Description | Data type |
|---|---|---|
| NAME | Name of the DBRM. | NOT NULL |
| TIMESTAMP | Consistency token. | NOT NULL WITH DEFAULT FOR BIT DATA |
| PDSNAME | Name of the partitioned data set of which the DBRM is a member. | NOT NULL |
| PLNAME | Name of the application plan of which this DBRM is a part. | NOT NULL |
| PLCREATOR | Authorization ID of the owner of the application plan. | NOT NULL |
| Not used | NOT NULL | |
| Not used | NOT NULL | |
| QUOTE | SQL string delimiter for the SQL statements in the DBRM: ; N
|
NOT NULL |
| COMMA | Decimal point representation for SQL statements in the DBRM: ; N
|
NOT NULL |
| HOSTLANG | The host language used: ; B
|
NOT NULL |
| IBMREQD | A value of Y indicates that the row came from the basic machine-readable material (MRM) tape. | NOT NULL |
| CHARSET | Indicates whether the system CCSID for SBCS data was 290 (Katakana) when the program was precompiled: ; A
|
NOT NULL WITH DEFAULT |
| MIXED | Indicates if mixed data was in effect when the application program was precompiled: ; N
|
NOT NULL WITH DEFAULT |
| DEC31 | Indicates whether DEC31 was in effect when the program was precompiled: ; blank
|
NOT NULL WITH DEFAULT |
| VERSION | Version identifier for the DBRM. | NOT NULL WITH DEFAULT |
| PRECOMPTS | Time when the DBRM was precompiled. | NOT NULL WITH DEFAULT |
Adapted from material found in the IBM DB2 Universal Database for z/OS V8 SQL Reference (SC18-7426-02).