Provides information about Master List dumps (up to 10) that are currently in the Statistics and Diagnostics Area (PXX) (or the optional PXXML in an z/OS environment). One row exists for each dump with identifying information. Once 10 rows have been added, rows for additional dumps are not written to this table. Clearing the PXX (or PXXML) removes the actual Master List dumps and deletes the corresponding row(s) from this table. Printing the PXX has no effect on the rows of this table. The column data and rules match the MUF_ML_DUMPS_PREV (MFF) table.
|
Column Name |
SQL Data Type |
Nullable |
Description |
|---|---|---|---|
|
DB_COMMAND
|
CHAR(5) |
No |
The five-character record-at-a-time or set-at-a-time command being executed or last executed. This field can contain certain internal commands that are only to be used by CA Support. |
|
DBID |
SMALLINT |
No |
Contains the database ID. |
|
DUMP_NUMBER |
INTEGER |
No |
Dumps are numbered from one as the first after the MUF has been enabled. |
|
DUMP_REASON |
CHAR(1) |
No |
The DUMP_REASON can be: T TEST (CA Datacom/DB record-at-a-time command). S SNAP console or DBUTLTY COMM option. D Internal condition (not error) needing a Master List dump. Typically done in a patch used in debugging. Not typically seen in the GA version. M Special multi-tasking error dump. Should not occur. E Error with return code requesting a Master List dump. |
|
EXTERNAL_CODE |
CHAR(2) |
No |
The EXTERNAL_CODE is blanks if the reason is not E. |
|
INTERNAL_CODE |
CHAR(3) |
No |
The INTERNAL_CODE is 000 if the reason is not E. |
|
JOB_NAME |
CHAR(8) |
No |
The job name for a console SNAP request is ***DBCOM. |
|
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. |
|
PROGRAM_NAME |
CHAR(4) |
No |
The PROGRAM_NAME is blanks if the reason is not E or D. |
|
PROGRAM_OFFSET |
CHAR(4) |
No |
The PROGRAM_OFFSET is blanks if the reason is not E or D. For a few conditions the offset is 0000. |
|
R15_CODE |
SMALLINT |
No |
The R15_CODE is 0 if the reason is not E. The R15 is useful to CA Support, if that becomes necessary. |
|
RUN_UNIT |
INTEGER |
No |
The run unit number (zero for console SNAP). |
|
TABLE_NAME |
CHAR(3) |
No |
Name of the table. |
|
TASK_NUMBER |
SMALLINT |
No |
The number of the task area being used for this request, also known as the RWTSA number. The low numbers are allocated for user applications based upon the TASKS Multi-User startup option. Next are CA Datacom STAR task areas, if any, followed by internal CA Datacom/DB system task areas. |
|
Copyright © 2014 CA.
All rights reserved.
|
|