This table is for system identification. It contains one row. It also provides MUF-wide information which is not provided through the startup options.
|
Column Name |
SQL Data Type |
Nullable |
Description |
|---|---|---|---|
|
CURRENT_DATETIME |
TIMESTAMP |
No |
Contains the current date and time from the MUF. |
|
DIR_NAME |
CHAR(8) |
No |
The Directory (CXX) name being used by this MUF. |
|
ENABLE_TIME |
TIMESTAMP |
No |
The date and time that the MUF was enabled. |
|
MUF_JOBID |
CHAR(8) |
No |
Contains the MUF JOB ID if z/OS or blanks if z/VSE. |
|
MUF_JOBNAME |
CHAR(8) |
No |
The MUF job name provided by the operating system. |
|
MUF_NAME |
CHAR(8) |
No |
Name of the MUF specified in the MUF Multi-User startup option or the name of the MUF job name. |
|
MUF_SYSTEM_NAME |
Char (8) |
No |
Name of the system on which MUF is running if z/OS, or blanks if z/VSE. |
|
NODE_NAME |
CHAR(8) |
No |
Contains either the CA Datacom STAR node name or blanks. |
|
PC |
Char (1) |
No |
In z/OS, this column contains a P if the production PC is being used, or T if the test PC is being used. This is specified in the DBSYSID macro, PC parameter and normally is P. For z/VSE, it contains the SUBID of the DBSYSID macro. |
|
SECURITY_DD |
CHAR(8) |
No |
CA Datacom Datadictionary security is being done through EXTERNAL security checking or INTERNAL CA Datacom Datadictionary coding. |
|
SECURITY_DQ |
CHAR(8) |
No |
CA Dataquery security is being done through EXTERNAL security checking or INTERNAL CA Dataquery coding. |
|
SECURITY_DQR_CICS |
CHAR(2) |
No |
Occurs with table used for externally securing DQ RAAT requests in CICS. |
|
SECURITY_DQS_CICS |
CHAR(2) |
No |
Occurs with table used for externally securing DQ SQL requests in CICS. |
|
SECURITY_DQR_OTHER |
CHAR(2) |
No |
Occurs with table used for externally securing DQ RAAT requests not in CICS. |
|
SECURITY_DQS_OTHER |
CHAR(2) |
No |
Occurs with table used for externally securing DQ SQL requests not in CICS. |
|
SECURITY_RAT_CICS |
CHAR(2) |
No |
Defines external security for record-at-a-time and set-at-a-time calls made through CA Datacom CICS Services. Contains NO if not externally secured or two characters indicating which external security table is to be used for checking authorizations. |
|
SECURITY_RAT_SRVR |
CHAR(2) |
No |
Defines external security for record-at-a-time and set-at-a-time calls made through CA Datacom Server or Windows ODBC or gateway access. Contains NO if not externally secured or two characters indicating which external security table is to be used for checking authorizations. |
|
SECURITY_RAT_OTHER |
CHAR(2) |
No |
Defines external security for record-at-a-time and set-at-a-time calls made through any interface that is not one of the preceding two (SECURITY_RAT_CICS or SECURITY_RAT_SRVR). Contains NO if not externally secured or two characters indicating which external security table is to be used for checking authorizations. |
|
SECURITY_SQL_CICS |
CHAR(2) |
No |
Defines external security for SQL calls made through CA Datacom CICS Services. Contains NO if not externally secured or two characters indicating which external security table is to be used for checking authorizations. |
|
SECURITY_SQL_SRVR |
CHAR(2) |
No |
Defines external security for SQL calls made through CA Datacom Server or Windows ODBC or gateway access. Contains NO if not externally secured or two characters indicating which external security table is to be used for checking authorizations. |
|
SECURITY_SQL_OTHER |
CHAR(2) |
No |
Defines external security for SQL calls made through any interface that is not one of the preceding two (SECURITY_SQL_CICS or SECURITY_SQL_SRVR). Contains NO if not externally secured or two characters indicating which external security table is to be used for checking authorizations. |
|
SERVICE_PACK |
CHAR(2) |
No |
Set to blank, column exists for compatibility with prior versions. |
|
VERSION_LEVEL
|
CHAR(6) |
No |
Version level of CA Datacom/DB, for example, '14.0 ' (that is 14.0 plus two blanks to make six characters). |
|
Copyright © 2014 CA.
All rights reserved.
|
|