The EEEDBRM table
The EEEDBRM table is used internally by Plan Table to store DBRM and package information. This information is used to build the Plan Information report.
| Column name | Data type | Description |
|---|---|---|
| name | char (8) not null | DBRM name |
| plname | char (8) not null | Plan name |
| plcreator | char (8) not null | Plan creator name |
| precompdate | char (6) not null | Date for precompilation |
| precomptime | char (8) not null | Time for precompilation |
| sqlstmt | integer not null | Number of SQL statements in DBRM |
| hostlang | char (1) not null | Programming language |
| charset | char (1) not null | Character set (Alphanum or Katakana) |
| comma | char (1) not null | Comma or period |
| dec31 | char (1) not null | Decimal 31 used at precompile |
| dbrmrel | char (1) NNWD | Db2® release at precompile |
| type | char (1) NNWD | DBRM or Package |
| storedby | char (8) NNWD | Authorization ID |
| timestmp | timestamp NNWD | Timestamp for storing row |
| pdsname | char(44) NNWD | Full MVS™ pds name for DBRM |
| collid | char(18) NNWD | Collection identification |
| version | varchar(64) N null | Version identification |