SQL/MX 3.2 Management Manual (H06.25+, J06.14+)

HISTOGRAM_INTERVALS
HISTOGRAM_INTERVALS_62116
OTHER
OTHER
BT
NN
TA
CN
HISTOGRAM_INTERVALS_83646 OTHERPKCN
MVS_TABLE_INFO_UMD OTHERBTTA
MVS_TABLE_INFO_UMD_231635 OTHERNNCN
MVS_TABLE_INFO_UMD_782835 OTHERPKCN
MVS_UMD OTHERBTTA
MVS_UMD_326725152_5188 OTHERNNCN
MVS_UMD_462235152_5188 OTHERPKCN
MVS_USED_UMD OTHERBTTA
MVS_USED_UMD_251445152_51 OTHERNNCN
MVS_USED_UMD_343845152_51 OTHERPKCN
ODETAIL User TableBTTA
ODETAIL_545675672_5188 User TablePKCN
ODETAIL_793765672_5188 User TableNNCN
ORDERS User TableBTTA
ORDERS_347711272_5188 User TableNNCN
ORDERS_917521272_5188 User TablePKCN
ORDREP User TableVITA
PARTS User TableBTTA
PARTS_386351772_5188 User TableNNCN
PARTS_836161772_5188 User TablePKCN
XCUSTNAM User TableIXIX
XORDCUS User TableIXIX
XORDREP
XPARTDES
User Table
User Table
IX
IX
IX
IX
Displaying the Attributes of a Schema
This example displays most of the attributes (in other words, SCHEMA_OWNER,
SCHEMA_VERSION, SCHEMA_SUBVOLUME, and others) for the schema SAMDBCAT. SALES:
>> set schema nonstop_sqlmx_<system name>.system_schema;
--- SQL operation complete.
>> select
substring(s.schema_name, 1, 15) as name,
s.schema_owner as owner,
s.schema_version as version,
s.schema_subvolume as subvol,
case s.current_operation
when ' ' then 'NONE'
when 'UG' then 'UPGRADE'
when 'DG' then 'DOWNGRADE'
when 'RP' then 'REPLICATE'
when 'UR' then 'UNREPLICATE'
else 'UNKNOWN'
end as CUR_OP
from schemata s
where
s.schema_name = 'SALES' and
cat_uid =
(select cat_uid from catsys where cat_name='SAMDBCAT')
for read uncommitted access;
CUR_OP
-----------
SUBVOL
--------
VERSION
-----------
OWNER
-----------
NAME
---------------
NONEZSDS53DQ300065535SALES
Displaying the Owner of a Schema
This example queries the SCHEMATA system schema table and returns the owner ID:
>> set schema nonstop_sqlmx_<system name>.system_schema;
--- SQL operation complete.
>> select substring(schema_name, 1, 30) as schema_name,
schema_owner
Displaying Schema Information 123