Loading...
Select Version
Heading | Meaning |
DBC# | Identification number of the database |
S# | Identification number of the space |
TB# | Identification number of the table |
Catalog-Name | Logical database name |
Space-Name | Space name |
COPY-# | Copy number of the space |
Schema-Name | Schema name |
Table-Name | Table name |
Table 31: Catalog-space table assignment table
Example
SESCOSP/SQL VERS. <version> TSN:9H16 ID.:SQLDB112 *** Catalog-Space-Table-Assignment <date> <time> PAGE 1 DBC# S# TB# Catalog-Name Space-Name COPY-# Schema-Name Table-Name 0001 01 0005 KON1CATALOG CATALOG DEFINITION_SCHEMA SYSTEM_ENTRIES 0001 01 0007 KON1CATALOG CATALOG DEFINITION_SCHEMA TABLES 0001 01 000B KON1CATALOG CATALOG DEFINITION_SCHEMA UNIQUE_CONSTRAINTS 0001 01 000F KON1CATALOG CATALOG DEFINITION_SCHEMA PRIVILEGES 0001 01 0012 KON1CATALOG CATALOG DEFINITION_SCHEMA INDEXES 0001 02 0002 KON1CATALOG SPACE0001 KON1GESAMT KON1SDB0 0002 01 0005 KON3CATALOG CATALOG DEFINITION_SCHEMA SYSTEM_ENTRIES 0002 01 0007 KON3CATALOG CATALOG DEFINITION_SCHEMA TABLES 0002 01 000B KON3CATALOG CATALOG DEFINITION_SCHEMA UNIQUE_CONSTRAINTS 0002 01 000F KON3CATALOG CATALOG DEFINITION_SCHEMA PRIVILEGES 0002 01 0012 KON3CATALOG CATALOG DEFINITION_SCHEMA INDEXES 0002 02 0002 KON3CATALOG SPACE0001 KON3GESAMT KON3SDB0 0003 01 0005 KON4CATALOG CATALOG DEFINITION_SCHEMA SYSTEM_ENTRIES 0003 01 0007 KON4CATALOG CATALOG DEFINITION_SCHEMA TABLES 0003 01 000B KON4CATALOG CATALOG DEFINITION_SCHEMA UNIQUE_CONSTRAINTS 0003 01 000F KON4CATALOG CATALOG DEFINITION_SCHEMA PRIVILEGES 0003 01 0012 KON4CATALOG CATALOG DEFINITION_SCHEMA INDEXES 0003 04 0002 KON4CATALOG SPACE0003 KON4NETZ KON4SDB0