ACCTPRM_ANN_DBID

SMALLINT

No

Contains zero or the database ID which contains the Accounting data areas.

ACCTPRM_CPU_TIME

CHAR(1)

No

Indicates whether CPU time is accumulated when Accounting is enabled.

ACCTPRM_PRM_DBID

SMALLINT

No

Contains zero or the database ID of the Accounting parameter table.

AGENT

CHAR(1)

No

This column is provided for prior version compatibility and contains an N.

AGENT_LOG_LEVEL

SMALLINT

No

This column is provided for prior version compatibility and contains a 0 (zero).

AGENT_USE_CONFIG

CHAR(1)

No

This column is provided for prior version compatibility and contains an N.

BREAK

INTEGER

No

Contains the current value of the BREAK Multi-User startup option.

CBS_BUFFER

INTEGER

No

Contains the size of the CBS buffer.

CBS_DBID_HEURISTIC

SMALLINT

No

Contains database used for heuristic information or 0 (zero) if no DBID has been specified.

CBS_DBID_TEMP

INTEGER

No

Contains the database ID where CBS stores various index information.

CBS_MAXSTEN

INTEGER

No

Contains the CBS temporary index entry limit.

CBS_MAXSTIO

INTEGER

No

Contains the CBS set I/O limit.

CBS_TIME_DELETE

SMALLINT

No

Age of set not referenced where it can be deleted.

CSAFREE

CHAR(1)

No

This column is provided for prior version compatibility and contains an N.

DATAPOOL_DATALN

SMALLINT

No

Specifies the data buffer size for normal data buffers.

DATAPOOL_DATALN2

SMALLINT

No

Specifies zero or the data buffer size for large data buffers.

DATAPOOL_DATANO

INTEGER

No

Specifies the number of normal data buffers.

DATAPOOL_DATANO2

INTEGER

No

Specifies the number of large data buffers.

DATASPACE_CONNECT

CHAR(1)

No

In z/OS, this is a Y indicating that a data space is used to connect between address spaces. In z/VSE, the only value is N.

DATASPACE_SIZE

INTEGER

No

Contains the size, in bytes, for any data spaces defined. Zero indicates the maximum of 2-GB.

DATETIME_DATE

CHAR(3)

No

Format for SQL date usage.

DATETIME_TIME

CHAR(3)

No

Format for SQL time usage.

DICTIONARY_DD_DBID

SMALLINT

No

The database ID for the primary DATA-DICT database.

DICTIONARY_DDDDBID

SMALLINT

No

The database ID for the primary Data Definition Directory database.

EXCTLNO

INTEGER

No

Zero or record exclusive control limit.

EXPAND_LENGTH

INTEGER

No

This column is provided for prior version compatibility and contains a 0 (zero).

EXPAND_NUMBER

INTEGER

No

This column is provided for prior version compatibility and contains a 0 (zero).

FLEXPOOL_DATANO

INTEGER

No

Number of current data FLEXPOOL buffers.

FLEXPOOL_DATANO2

INTEGER

No

Number of current large data FLEXPOOL buffers.

FLEXPOOL_DXXNO

INTEGER

No

Number of current DXX FLEXPOOL buffers.

FLEXPOOL_IXXNO

INTEGER

No

Number of current IXX FLEXPOOL buffers.

IOTASK_CURRENT

SMALLINT

No

Current number of usable I/O tasks.

IOTASK_MAXIMUM

SMALLINT

No

Maximum number of I/O tasks.

LOGOPTION_OPN_CLS

CHAR(1)

No

Force writing OPEN and CLOSE records to the Log Area (LXX) for maintenance run units if Y. N indicates no OPEN on the log and only CLOSE if it is a commit.

LOGPEND

SMALLINT

No

Size of pipeline of DXX and data buffers, based upon number of log blocks.

LOGPOOL

SMALLINT

No

Number of log buffers for transaction backout.

LOGRCV

CHAR(5)

No

Specifies which logging recovery option was selected.

LOGRSYS

SMALLINT

No

The z/VSE SYS number for the Recovery File (RXX).

LOGSPILL_A

SMALLINT

No

Log percent for console message.

LOGSPILL_B

SMALLINT

No

Log percent for force spill.

LOGSPILL_C

SMALLINT

No

Log percent for starting spill.

LOGSPILL_D

SMALLINT

No

Log percent to force from log scan.

LOGSPILL_E

SMALLINT

No

Log percent to force from log redo.

MAXELRQ

SMALLINT

No

Maximum elements per request.

MUF_ENDED_NO_LOG

CHAR(1)

No

Y or N, with N as the default. With N set or defaulted, a console message (DB00102I) only occurs in MUF if the job ending did maintenance which was logged. With Y set, a console ended message occurs for all jobs. The N option is recommended to reduce the console clutter.

MUF_NAME

CHAR(8)

No

Logical name for this MUF.

MUF_RUN_UNIT_GROUP

SMALLINT

No

Number of run units to group during MUF execution to reduce CXX I/O.

MUFMSG_A

CHAR(1)

No

Include MUF job name as message prefix.

MUFMSG_B

CHAR(1)

No

Include SVC number as message prefix.

MUFMSG_C

CHAR(1)

No

Include SUBID number as message prefix.

MUFPLEX_NAME

CHAR(8)

No

If running with full Data Sharing as a MUFplex, name of the group.

MUFPLEX_NUMBER

SMALLINT

No

Number of this specific MUF within this MUFplex group.

MUFPLEX_LOCKS

INTEGER

No

Number of lock hash entries to control performance in Data Sharing.

MUFPLEX_MAX_TASKS

SMALLINT

No

Maximum number of tasks per MUF within this MUFplex group.

NONSWAP

CHAR(1)

No

Request MUF be set nonswappable (z/OS).

PLANSEC_CHECKPLAN

CHAR(1)

No

SQL plan security.

PLANSEC_CHECKWHEN

CHAR(8)

No

SQL plan security, when to check.

PLANSEC_CHECKWHO

CHAR(8)

No

SQL plan security, who to check.

PROCEDURE_CACHE

INTEGER

No

Size of cache used to save information about the execution of procedures.

PROCEDURE_NESTS

SMALLINT

No

Number representing the depth of ability for a procedure that is executing to issue SQL statements that cause another procedure to run.

PROCEDURE_TCBS

SMALLINT

No

Number of operating system subtasks to attach to support the procedure processing.

PXX_STATS

CHAR(6)

No

Level of statistics information in PXX.

READAHD

CHAR(8)

No

Type of sequential reading ahead (pre-8.1 URTs).

RESTART_ACCESS_OFF

CHAR(1)

No

Contains a Y if errors are ignored (as described in RESTART_IGNORE), and additionally indicates that the database ID with the errors is to be set to ACCESS OFF to prevent it from being easily opened until the errors are corrected.

RESTART_IGNORE

CHAR(1)

No

Contains a Y if errors during the reprocessing of the restart phase of the MUF startup are to be ignored and the MUF enabled (not all errors are ignorable). Contains an N if errors are to stop the enable so that users can correct the problem and rerun the MUF for correct results.

RRS

CHAR(8)

No

Contains blanks if not specified, CONTINUE if specified as continue, or FAIL if specified as fail.

RXX_UNIT_COUNT

SMALLINT

No

Count of units for RXX (z/OS).

RXX_UNIT_NAME

CHAR(8)

No

Name for RXX unit (z/OS).

RXX_VOLUME_COUNT

SMALLINT

No

Number of volumes to request.

RXXROLLBACK

CHAR(1)

No

Specifies force spill at Log Area full (Y) versus force checkpoint at Log Area full (N).

SMPTASK_CURRENT

SMALLINT

No

Current number of SMP tasks.

SMPTASK_MAXIMUM

SMALLINT

No

Maximum number of SMP tasks.

SMPTASK_READY_TASK

SMALLINT

No

Ready-to-run work required to start another SMP task.

SQLDEFAULT_DBID

SMALLINT

No

Zero or the database ID for the default database for SQL tables.

SQLDEFAULT_NAME

CHAR(32)

No

Default area name for SQL tables.

SQLOPTION_BOTH

CHAR(1)

No

A Y indicates that both update and read-only cursors are allowed in a plan. An N indicates that either an update or read-only cursor is allowed in a plan.

SQLOPTION_MODE

CHAR(7)

No

Mode of SQL support.

SQLOPTION_OPTION

CHAR(1)

No

SQL activation option.

SQLOPTION_TIMEOUT

SMALLINT

No

Minutes before a CICS SQL logical unit of work is closed.

SQLOPTION_TTMID

SMALLINT

No

Zero or the database ID of the SQL TTM database.

SQLOPTION_VIEW

CHAR(1)

No

External security checking at the view-level default. All plans which have a specified selection of view security or table-level are excluded from this default. It applies on every compile or rebind as the default. If Y is specified, all security within the plan for a view is done through view security. If N is specified, all security within the plan is done with table-level security.

STAR_MAX_NODES

SMALLINT

No

Maximum number of nodes with which CA Datacom STAR can connect.

STAR_NODE

CHAR(8)

No

Name of the node which this MUF is known as, for (DST) usage.

STAR_SIZE

INTEGER

No

Size of working storage for CA Datacom STAR usage.

STAR_TASKS

SMALLINT

No

Number of tasks (RWTSAs) to reserve for remote CA Datacom STAR requests.

STAR_TIME_BATCH

SMALLINT

No

Seconds CA Datacom STAR waits for a remote request for record locking in batch.

STAR_TIME_CICS

SMALLINT

No

Seconds CA Datacom STAR waits for a remote request for record locking in CICS.

STATBFR

INTEGER

No

This column is provided for prior version compatibility and contains as 0 (zero).

SUBTASK

CHAR(8)

No

Blanks or name of a subtask to run with MUF.

SYSOUT_CLASS

CHAR(1)

No

z/OS throw-away class.

SYSPOOL_CXXNO

SMALLINT

No

Number of Directory (CXX) buffers.

SYSPOOL_DXXNO

INTEGER

No

Current number of DXX buffers.

SYSPOOL_INDEX

SMALLINT

No

Provides the index buffer size.

SYSPOOL_IXXNO

INTEGER

No

Current number of IXX buffers.

SYSTEMDBID_DBID

SMALLINT

No

Zero or the database ID of the database containing the Dynamic System Tables.

SYSTEMDBID_SYSOUT

CHAR(1)

No

In z/OS, Y indicates that changes are written to SYSOUT, but N indicates that changes are not written to SYSOUT. In z/VSE, changes are written to the PXX.

TASKS_NUMBER

SMALLINT

No

Number of tasks (RWTSAs).

TASKS_SIZE

INTEGER

No

Size of the task area.

TASKS_VAE_NUMBER

SMALLINT

No

Number of tasks in the MUF which support XPCC connection (z/VSE).

TASKS_VM_NUMBER

SMALLINT

No

Number of tasks in the MUF which support VM IUCV connection.

TASKS_XCF_NUMBER

SMALLINT

No

Number of tasks in the MUF which support XCF connection (z/OS).