SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Contents
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
xliii
10. Metadata Tables
Considerations for AUDITCOMPRESS 9-3
Index Default 9-3
Difference Between Compressed and Uncompressed Row Images 9-3
BLOCKSIZE 9-4
CLEARONPURGE 9-5
Considerations for CLEARONPURGE 9-5
Purpose of CLEARONPURGE 9-5
Effect Within Transactions 9-5
EXTENT 9-6
Considerations for EXTENT 9-6
MAXEXTENTS 9-7
Considerations for MAXEXTENTS 9-7
10. Metadata Tables
SQL/MX Metadata Catalogs 10-2
SQL/MX Metadata Schemas and Tables 10-3
System Schema Tables: Schema SYSTEM_SCHEMA 10-3
Definition Schema Tables: Schema
DEFINITION_SCHEMA_VERSION_vernum 10-3
System Defaults Tables (User Metadata Tables): Schema
SYSTEM_DEFAULTS_SCHEMA 10-5
MXCS Metadata Tables: Schema MXCS_SCHEMA 10-5
Histogram Tables 10-6
VALIDATEROUTINE: Schema SYSTEM_SQLJ_SCHEMA 10-6
Security Schema Tables: Schema SYSTEM_SECURITY_SCHEMA 10-7
System Schema Tables 10-8
ALL_UIDS Table 10-8
CATSYS Table
10-9
CAT_REFERENCES Table 10-9
SCHEMATA Table 10-10
SCHEMA_REPLICAS Table
10-11
System Security Schema Tables
10-11
MGM_PRIVILEGES 10-11
PRIVILEGED_USERS TABLE
10-11
Definition Schema Tables
10-12
ACCESS_PATHS Table
10-12
ACCESS_PATH_COLS Table
10-14
CK_COL_USAGE Table 10-15
CK_TBL_USAGE Table
10-15
COLS Table 10-15