DB01329I

Processing, DBUTLTY and SQL Messages › CA Datacom/DB Processing Messages (DB0xxxxc) › DB01329I

DB01329I

c1 c2 c3 c4 c5 c6 c7 c8 c9 c10

Reason:

This is an online report message line numbered DB01329I. It provides columns of information in response to an online COMM STATUS request. The columns are defined as shown in the following list. Correlate these with the column headings shown in DB01328I.

c1

This column shows TIME in a format of mmm:ss, meaning the length of time in minutes and seconds since the Multi-User Facility accepted the request. For system tasks, this is the time since the system started the current work unit. It is omitted if the request is NOT ACTIVE, TASK ACTIVE, PENDING, or POSTED. When necessary, an overflow indicator is given as +++.++.

c2

This column shows I/O as xxxx, displayed as follows:

10000 Is displayed as 1K.

19000 Is displayed as 19K.

19999 Is displayed as 19K.

I/O here refers to the number of I/O events performed during the processing of this request. I/O information is omitted if the request is NOT ACTIVE, TASK ACTIVE, PENDING, or POSTED.

c3

This is the JOBNAME of the batch job that is running and currently connected to the MUF.

c4

This is the run unit (R-UNIT) number xxxxx (given as the low order 5 digits with leading zeros suppressed). For system tasks, xxxxx is zero.

c5

This is the TASK number xxxx (DBRW ID) where the task is running.

c6

CMD-DBID-TBL

In this column:

CMD is the command in the Request Area. This is blank for a system task or omitted if the request is NOT ACTIVE, TASK ACTIVE, PENDING, or POSTED.

DBID is a database ID (not listed when not applicable).

TBL is a table ID (not listed when not applicable).

c7

Specifies SEQ, the internal CA Datacom/DB request sequence number nnnnnn. You can use this information to abort a request that is blocking other requests from executing. For a system task, SEQ is displayed as zero. SEQ is omitted if the request is NOT ACTIVE, TASK ACTIVE, PENDING, or POSTED.

c8

Gives the STATUS, where the status messages occur in groups based on task status. STATUS can be:

Status	Explanation
ABENDING	The task has detected a task abend.
ACCESS AREA SMP	An ACCESS with an AREA specified is running and interacting with processes that care about the ACCESS AREA function.
ACTIVE	A request is active (only one task can be active).
BUFFER, CXX	A task is waiting on a specific Directory (CXX) block to become available.
BUFFER, DATA	A task is waiting on a specific data area block to become available.
BUFFER, DXX	A task is waiting on a specific Index Area (DXX) block to become available.
BUFFER, IXX	A task is waiting on a specific Index Area (IXX) block to become available.
BUFFER, LXX	A task is waiting on a specific Log Area (LXX) block to become available.
CDC TSN RC14	A CDCU program is waiting for a TSN record to be added.
CICS COLD START	This task has an outstanding CICS two-phase commit, and CICS has been cold started. The task must be manually researched and then cleaned up with a REQCOMIT or REQROLBK.
CICS IN DOUBT	A task is waiting on CICS to provide resolution for a two-phase commit.
CLOSE, aaabbbbb	The task is waiting on the close of the named area-database (aaabbbb).
DEQ/UNLOCK CXX	Reflects that the task is waiting on the (z/OS only.) DEQ or z/VSE UNLOCK of the CXX.
ENQ/LOCK CXX	Reflects that the task is waiting on the (z/OS only.) ENQ or z/VSE LOCK of the CXX.
EOJ IN PROCESS	An EOJ is in process.
LOG CHAIN LOCK	A task is waiting on the log chain.
LOG FORCE BLOCK	A task is waiting for the read forced list lock in a MUFplex environment.
MUFPLEX LIST CF	A task is waiting on an outstanding XES list request.
MUFPLEX LOCK CF	A task is waiting on an outstanding XES lock request.
NOT ACTIVE	The status is not active.
OPEN, aaabbbbb	The task is waiting on the open of the named area-database (aaabbbbb).
PENDING	A request has been transmitted but has not yet been accepted by the Multi-User Facility.
PLEX LIST DBAR	Directory (CXX) area control record, MUFplex Coupling Facility lock. With this condition, the DBID field contains the specific base required, and the table name field contains the specific area required.
PLEX LIST DBCR	Directory (CXX) base control record, MUFplex Coupling Facility lock. With this condition, the DBID field contains the specific base required.
PLEX LIST DBFC	Log Force Area (FXX), MUFplex Coupling Facility lock.
PLEX LIST DBLC	Log control/current blocks, MUFplex Coupling Facility lock.
PLEX LIST DBLF	Directory (CXX) table control record, MUFplex Coupling Facility lock. With this condition, the DBID field contains the specific base required and the table name field contains the specific table required.
PLEX LIST DBLG	Log add record, MUFplex Coupling Facility lock.
PLEX LIST DBUL	Log uncertainty block, MUFplex Coupling Facility lock.
PLEX LIST DBYJ	TSN, MUFplex Coupling Facility lock.
PLEX LIST DBYR	Run unit record, MUFplex Coupling Facility lock.
PLEX LIST DBYU	Assigned lock index, MUFplex Coupling Facility lock.
PLEX MSG REPLY	A task has sent a message to another MUF in the MUFplex and is waiting on a response from that MUF.
POSTED	The Multi-User Facility has accepted the task but has not dispatched it because of priority.
PRC TCB RUNNING	A procedure is running on behalf of this task in a procedure TCB.
READY TO RUN	The resource upon which the task was waiting has become available. Task is ready to be dispatched, based on priority.
SYS STATS FLUSH	A task is waiting on a close lock that controls flushing statistics to the PXX.
TASK ACTIVE	The CICS transaction has a locked thread but is not currently waiting on a Multi-User Facility request.
WAIT ACCT ENTRY	A task is waiting to update a particular entry in the Accounting buffer.
WAIT ACCT GLOBL	A task is waiting on the Accounting global chain.
WAIT ACCT TABLE	A task is waiting on a specific Accounting table to record or remove information.
WAIT ACTG	A task is waiting on the Accounting Facility.
WAIT ADD LOG RC	A task is waiting on access to current log buffer.
WAIT BUFFER	A task is waiting for a free buffer (CXX, LXX, IXX, DXX, data).
WAIT CBS	A task is waiting on access to the CBS buffer lock.
WAIT CBSBFR SPL	A task is waiting for a set in the CBS buffer to spill to the IXX.
WAIT CDCL POLL	This Change Data Capture Listener task is waiting for work.
WAIT CICS START	A task is waiting on CICS to provide resolution for a two-phase commit, but the controlling CICS is not up.
WAIT CMPUS EXIT	A task is waiting on a non-RENT user compression exit.
WAIT DATA BF SP	A task is waiting on the data free space buffer chain lock.
WAIT DATA SP MG	A task is waiting on the Data Space Management lock.
WAIT DEFRAG	DEFRAG is running and interacting with a read backward request.
WAIT E/C	A task is waiting for a record that another task has read with exclusive control. The status is followed by OWNER- indicating the task owning the resource and by RID- indicating the type of lock. See the value locks table in CA Datacom/DB Processing Messages (DB0xxxxc).
WAIT HASH DATA	A task is waiting on the hash chain for a data area buffer.
WAIT HASH DXX	A task is waiting on the hash chain for a DXX buffer.
WAIT HASH IXX	A task is waiting on the hash chain for an Index Area buffer.
WAIT I/O	A task is waiting on an I/O event.
WAIT INDEX QUE	A task is waiting on access to the index queue.
WAIT INTERLCK D	A task is waiting on the interlock detection lock.
WAIT LOCK LIST	A task is waiting on access to the exclusive (share) list control tables.
WAIT LOG DELAY	A task is waiting on log delay based on your specifying X_LOG_DELAY_BLK.
WAIT LRU CXX	A task is waiting on the least recently used chain for a Directory (CXX) buffer.
WAIT LRU DATA	A task is waiting on the least recently used chain for a data area buffer.
WAIT LRU DXX	A task is waiting on the least recently used chain for a DXX buffer.
WAIT LRU IXX	A task is waiting on the least recently used chain for an Index Area buffer.
WAIT LRU LXXTXB	A task is waiting on the least recently used chain for a Log Area (LXX) buffer for transaction backout.
WAIT MEM-MGR	A task is waiting on access to the Memory Manager.
WAIT NEWRXX	A COMM NEWRXX function is waiting on the open/close subtask to open or close the RXX.
WAIT OFT	A task is waiting on access to the open list of tables lock.
WAIT OPEN EXIT	A task is waiting on open exit.
WAIT PLEX ABEND	A MUF is in the process of being enabled in a MUFplex environment, and it is waiting on a prior MUF to finish recovering from an ABEND.
WAIT PLEX BDE	A task is waiting on MUFplex processing for a particular BDE.
WAIT POST LIST	A task is waiting on access to the posted list.
WAIT PRC CHAIN	A task is waiting on the procedure chain processing lock.
WAIT PROC TCB	A task is waiting for a PROCEDURE TCB. All procedure TCBs are currently in use.
WAIT PXX LOCK	A task is waiting on access to the Statistics and Diagnostics Area (PXX) write module.
WAIT REQ	A task is waiting on a request in another task area to complete before executing a spill.
WAIT RL-PLEX-JN	A task is waiting on DBID that is transitioning to shared in a MUFplex.
WAIT SECURITY	A task is waiting on security validation.
WAIT SPILL	A task is waiting on a spill to complete.
WAIT SQL ATTACH	A task is waiting on access to the SQL ATTACH list lock.
WAIT SQL GLOBAL	A task is waiting on access to the SQL GLOBAL list lock.
WAIT SQL MEMORY	A task is waiting on an SMP lock around the SQL call to memory manager.
WAIT SQL MISC	A task is waiting on the SQL miscellaneous lock.
WAIT SQL PLAN	A task is waiting on access to the SQL PLAN list lock.
WAIT SQL STATUS	A task is waiting on access to the SQL STATUS list lock.
WAIT SQL TTM	A task is waiting on access to the TTM table lock.
WAIT SQL URT	A task is waiting on access to the SQL URT list lock.
WAIT STAR SCHED	A task is waiting on access to CA Datacom STAR scheduling.
WAIT STAR STOR	A task is waiting on access to CA Datacom STAR storage.
WAIT STAR	A task is waiting on CA Datacom STAR distribution.
WAIT TASK AREA	A task is waiting on the task area lock for status change.
WAIT TASK	A task is waiting on record owned by another task. The status is followed by OWNER- indicating the task owning the resource and by RID- indicating the type of lock.
WAIT TASK DELAY	QUIESCE is waiting on an active request.
WAIT TIMER LOCK	A task is waiting on the timer and cancel lock.
WAIT TSN	A task is waiting on the TSN lock to check, assign, or remove an active transaction.
WAIT USER EXIT	A task is waiting on another user exit to complete.
WAIT W/P CH DAT	A task is waiting on the write pending chain for a data area buffer.
WAIT W/P CH IDX	A task is waiting on the write pending chain for an Index Area buffer.
WAIT WAIT LIST	A task is waiting on access to the wait list.

When the lock is a value lock, CA Datacom/DB provides additional information as shown in the following table:

Type of Value Lock	Meaning	Additional Information Available from the COMM STATUS Display
CA DMS	CA Disk™ Backup and Restore (CA Disk) has serialized a process within this MUF.	Variable (format unknown to CA Datacom/DB)
DBSCXX	The Directory (CXX) is locked during URT open and close processing and during maintenance to the CXX when CXX I/O is required.	(None)
DBSDCB	CA Datacom/DB has locked this area during a dynamic extend.	Database ID Area name
DBSDDL	SQL Data Definition Language (DDL) has locked the process of choosing internal IDs for various structures.	Database ID where the created or altered table resides.
DBSDSB	CA Datacom/DB has locked a database to ACCESS OFF/READ which is open.	Database ID
DBSIXX	CA Datacom/DB has a lock while index que/backward read processing.	Database ID Block group number
DBSKEL	A table's key element data is locked during the process to bring it into memory or write it back to the Directory (CXX).	Database ID Table name
DBSKEY	CA Datacom/DB has locked a key to verify that an add or update does not violate a unique constraint.	Database ID Table ID Key ID Key value to be added/updated.
DBSMVR	A user has executed the DBUTLTY LOCK function to block moved records.	Database ID Area name
DBSOPN	CA Datacom/DB has a lock during URT open and close processing and during maintenance to the CXX.	Database ID
DBSPLN	CA Datacom/DB has locked an SQL plan for concurrency.	AUTHID Plan name
DBSPRC	The locking of a prodecure has occurred so that a NEWCOPY can be synchronized.	Eight-character procedure name
DBSRRD	CA Datacom/DB has locked a key range to assure the SQL repeatable read function.	Database ID Table ID Key ID Key range
DBSSIX	CA Datacom/DB has locked the data space management index during maintenance.	Database ID Area name Block group number
DBSSOC	CA Datacom/DB has locked a database and table to open or confirm the table for SQL processing.	Database ID Table name
DBSSPL	CA Datacom/DB has a lock during the spill.	(None)
DBSTXB	CA Datacom/DB has a lock on this transaction while waiting on the rollback to be completed using backward recovery. A previous console message DB00109W requested the recovery.	Transaction sequence number
DBSURI	CA Datacom/DB has locked an area during URI validation/assignment.	Database ID Area name
Other	Other lock values are possible.

c9

In this column, ID is displayed (xxxxxxxx or tran-term-opr-xxxxx) under the following circumstances:

Under CA Datacom Server, the ID field contains the logical terminal name (a 1- to 8-character field).
If a CICS transaction has a request active or if CICS has a transaction without an active request but a locked task area, the following are displayed:

tran	The CICS transaction identifier
term	The CICS terminal ID
opr	The CICS operator ID
xxxxx	CICS sequence number

c10: This column gives the transaction sequence number, TSN (only listed on updates).

Action:

None. This message is for information only.