Db2 12 for z/OS Catalog Tables - BMC Blogs
Sarah Rodriguez news
One row for each table, view, or alias.
| NAME | VARCHAR(128) |
| CREATOR | VARCHAR(128) |
| TYPE | CHAR(1) |
| DBNAME | VARCHAR(24) |
| TSNAME | VARCHAR(24) |
| DBID | SMALLINT |
| OBID | SMALLINT |
| COLCOUNT | SMALLINT |
| EDPROC | VARCHAR(24) |
| VALPROC | VARCHAR(24) |
| CLUSTERTYPE | CHAR(1) |
| NPAGES | INTEGER |
| PCTPAGES | SMALLINT |
| IBMREQD | CHAR(1) |
| REMARKS | VARCHAR(254) |
| PARENTS | SMALLINT |
| CHILDREN | SMALLINT |
| KEYCOLUMNS | SMALLINT |
| RECLENGTH | SMALLINT |
| STATUS | CHAR(1) |
| KEYOBID | SMALLINT |
| LABEL | VARCHAR(90) |
| CHECKFLAG | CHAR(1) |
| CHECKRID | CHAR(4) |
| AUDITING | CHAR(1) |
| CREATEDBY | VARCHAR(128) |
| LOCATION | VARCHAR(128) |
| TBCREATOR | VARCHAR(128) |
| TBNAME | VARCHAR(128) |
| CREATEDTS | TIMESTAMP |
| ALTEREDTS | TIMESTAMP |
| DATACAPTURE | CHAR(1) |
| RBA1 | CHAR(10) |
| RBA2 | CHAR(10) |
| PCTROWCOMP | SMALLINT |
| STATSTIME | TIMESTAMP |
| CHECKS | SMALLINT |
| CARDF | FLOAT |
| CHECKRID5B | CHAR(5) |
| ENCODING_SCHEME | CHAR(1) |
| TABLESTATUS | VARCHAR(30) |
| NPAGESF | FLOAT(8) |
| SPACEF | FLOAT(8) |
| AVGROWLEN | INTEGER |
| RELCREATED | CHAR(1) |
| NUM_DEPT_MQTS | SMALLINT |
| VERSION | SMALLINT |
| PARTKEYCOLNUM | SMALLINT |
| SPLIT_ROWS | CHAR(16) |
| SECURITY_LABEL | CHAR(1) |
| OWNER | VARCHAR(128) |
| APPEND | CHAR(1) |
| OWNERTYPE | CHAR(1) |
| CONTROL | CHAR(1) |
| VERSIONING_SCHEMA | VARCHAR(128) |
| VERSIONING_TABLE | VARCHAR(128) |
| HASHKEYCOLUMNS | SMALLINT |
| ARCHIVING_SCHEMA | VARCHAR(128) |
| ARCHIVING_TABLE | VARCHAR(128) |
| STATS_FEEDBACK | CHAR(1) |
| REGENERATETS | TIMESTAMP(12) |