Log:
valutazioni - 0, GPA: 0 ( )

Istruzioni per l'uso HP, Modello HP Integrity NonStop H-Series

Produttore : HP
File Size : 1.76 mb
File Nome :
Lingua di insegnamento: itenesro
Vai a scaricare



da questo dispositivo ha anche altre istruzioni :

Facilità d'uso


Querying SQL/MX Metadata
SQL/MX Metadata Tables
SQL/MX Metadata Tables
Figure 8-1 shows the SQL/MX metadata table structure.
Figure 8-1. SQL/MX Metadata Table Structure
Catalog
NONSTOP_SQLMX_nodename
Note: User catalogs
are not shown.
Schemas
SYSTEM_SCHEMA
MXCS_SCHEMA
DEFINITION_SCHEMA_VERSION_1200
SYSTEM_SQLJ_SCHEMA
SYSTEM_DEFAULTS_SCHEMA
ALL_UIDS
SYSTEM DEFAULTS
ASSOC2DS
CATSYS
DATASOURCES
CAT_REFERENCES
ENVIRONMENTVALUES
SCHEMATA
Tables
NAME2ID
SCHEMA_REPLICAS
RESOURCEPOLICIES
ACCESS_PATHS
MVS
TBL_CONSTRAINTS
ACCESS_PATH_COLS
MVS_COLS
TBL_PRIVILEGES
CK_COL_USAGE
MVS_JOIN_COLS
TEXT
CK_TBL_USAGE
MVS_TABLE_INFO
TRIGGERS
COLS
MVS_USED
TRIGGERS_CAT_USAGE
COL_PRIVILEGES
OBJECTS
TRIGGER_USED
DDL_LOCKS
PARTITIONS
VWS
DDL_PARTITION_LOCKS
REF_CONSTRAINTS
VW_COL_TBLS
KEY_COL_USAGE
REPLICAS
VW_COL_TBL_COLS
MODULES
RI_UNIQUE_USAGE
VW_COL_USAGE
MP_PARTITIONS
ROUTINES
VW_TBL_USAGE
MV_GROUPS
vst003.vsd
Some important concepts to note are:
• SQL/MX metadata tables are quite different from SQL/MP catalogs.
• Each node contains a single NONSTOP_SQLMX_nodename catalog. This catalog
contains metadata pertinent to the node as a whole. Figure 8-1 shows the
metadata schemas and catalogs in the NONSTOP_SQLMX_nodename catalog.
• Typically, a node has additional user catalogs; Figure 8-1 does not show these
user catalogs. A user catalog also contains a
DEFINITION_SCHEMA_VERSION_1200 schema, along with the tables shown in
HP NonStop SQL/MX Installation and Management Guide540436-001
8 -5


...


Scrivi la tua opinione del dispositivo



Il messaggio
Il tuo nome :
Inserire le due cifre :
capcha





categorie