Previous Topic: DBUTLTY External SecurityNext Topic: Reporting Facility Enhancements


Dynamic System Tables Enhancements

The following tables have been updated:

DIR_DIRECTORY

New columns:

Column Name

SQL Data
Type

Nullable

Description

SIMPLIFY_MODE

Char (1)

No

This column contains a Y if the CXX was initiated with SIMPLIFY mode as Yes, otherwise, it is N.

DIR_TABLE

New columns:

Column Name

SQL Data
Type

Nullable

Description

ENCRYPTION_METHOD

Char (1)

No

Indicates the method of encryption to be used. Contains one of the following:

- Blank no encryption

- A - AES-128

- B - AES-192

- C - AES-256

ENCRYPTION_TYPE

Char (1)

No

Indicates the type of encryption to be used. Contains one of the following:

- Blank - No encryption

- B - Basic encryption performed by Datacom/DB with no key management

MUF_ACCOUNTING

Changed columns:

TOTAL_REQUESTS is now DEC (13,0).

MUF_ACTIVE_TASKS

Changed column:

The description of the OWNER_TASK column for Version 14.0 has been changed to read as follows

If the status is WAIT E/C, the number of the task which owns the lock is reported. Some locks have an owner which is the MUF itself and not a specific task, in which case the OWNER_TASK is reported as a zero (0). This does not occur for data row locks but does for some of the value locks.

New columns:

Column Name

SQL Data
Type

Nullable

Description

EOJ_OK

Char (1)

No

For single task area connections, EOJ_OK contains a Y if the URT used to connect to the MUF specified EOJ_OK=YES, otherwise contains an N. The EOJ_OK option allows MUF to EOJ without the application closing all URTs.

For multiple task area connections EOJ_OK contains a ‘S’ if the application driving the multiple task area connection connected with an option EOJ_OK_S, otherwise contains an N.

MUF_AREA_STATS

A row for the PXX Area is now included in this table.

MUF_BUF_USE

Changed columns:

BUFFER_USED_1 is now DEC (13,0).

BUFFER_USED_5 is now DEC (13,0).

MUF_IDENTITY

New columns:

Column Name

SQL Data
Type

Nullable

Description

MUF_JOBID

Char (8)

No

This column contains the MUF JOB ID if z/OS, or blanks if z/VSE.

MUF_SYSTEM_NAME

Char (8)

No

Name of the system on which MUF is running if z/OS, or blanks if z/VSE.

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.

Removed columns:

SUB_ID

SVC

MUF_INTERNAL _STATS

Changed columns:

BREAKS_DONE is now DEC (11,0).

MRDF_IXX_DIRECT is now DEC (11,0).

MUF_OPTIONS

Changed descriptions:

EXPAND_LENGTH, this column is provided for prior release compatibility and contains a 0 (zero).

EXPAND_NUMBER, this column is provided for prior release compatibility and contains a 0 (zero).

MUF_SMP _STATS

Changed columns:

POSTED_0 is now DEC (11,0).

POSTED_1_5 is now DEC (11,0).

MUF_SMP _TASK

Changed columns:

TIMES_USED is now DEC (13,0).

MUF_SYSTEMS_STATS (MSS)

The MUF_SYSTEMS_STATS (MSS) table is designed as a replacement table for MUF-SYS_STATS (MFS). It has many columns with a larger capacity than the old table and removes obsolete columns that are in other dynamic systems tables or provide no value and may lead to confusion. We recommend that you start using this table to collect systems statistics even though the MFS table still exists.

MUF_TCB_OR_SRB

Changed columns:

TIMES_POSTED is now DEC (13,0).

TIMES_USED is now DEC (13,0).

MUF_XCF

Changed columns:

REQUESTS_TOTAL is now DEC (11,0).

New columns:

Column Name

SQL Data
Type

Nullable

Description

CURRENT_STATUS

Char (6)

No

Either DELETE, NO, or YES, as specified with the XCF_FROM option.

JOBNAME

Char (8)

No

Job name from which this MUF can accept requests, as specified with the XCF_FROM option.

SYSTEM_NAME

Char (8)

No

System from which this MUF can accept requests, as specified with the XCF_FROM option.

Removed Columns:

DIRECTION

XCF_MUF_NAME

For more information, see the CA Datacom/DB System Tables Reference Guide.