SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Metadata Tables
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
10-7
VALIDATEROUTINE: Schema
SYSTEM_SQLJ_SCHEMA
This table lists SQL/MP histogram tables:
For detailed descriptions of histogram tables, see User Metadata Tables (UMD):
Histogram Tables on page 10-84.
VALIDATEROUTINE: Schema SYSTEM_SQLJ_SCHEMA
This schema contains only the stored procedure VALIDATEROUTINE, which is for
internal use.
Security Schema Tables: Schema
SYSTEM_SECURITY_SCHEMA
The SYSTEM_SECURITY_SCHEMA contains system metadata that holds node-wide
security related information.
There is one system security schema per node where NonStop SQL/MX has been
initialized or upgraded with schema version 3100 or later.
This table lists system security schema tables in NONSTOP_SQLMX_nodename.
SYSTEM_SECURITY_SCHEMA for each node
HISTOGRM Table
on
page 10-89
Columns, interval count, total number of rows and unique
rows, and the low and high values of column distribution for
the table for which the histogram is created
HISTINTS Table on
page 10-90
For each interval of the table for which the histogram is
created, the number of rows and unique rows and the value
of the interval upper boundary
MGM_PRIVILEGE
S on page 10-11
Contains information about system and catalog wide privileges.
PRIVILEGED_USE
RS TABLE on
page 10-11
Contains information about the users who are members of security
administrators group.