Previous Topic: MUF_DATA_SHARING (MFD)Next Topic: MUF_INTERNAL_STATS (MFV)


MUF_IDENTITY (MFI)

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).