Provides information about the last (up to 10) Master List dumps that were requested in the MUF. One row exists for each dump with identifying information. Once the maximum (of 10 rows) is reached, each additional row that is added forces the oldest row to be deleted. The Statistics and Diagnostics Area (PXX) becoming full has no effect on the rows being added to this table. Additionally, clearing the PXX (or optionally, the PXXML in an z/OS environment) has no effect on the rows of this table. The column data and rules match the MUF_ML_DUMPS_PXX (MFE) 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 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 normally 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.
|
|