DB01332I

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

DB01332I

c1 c2 c3 c4 c5

Reason:

This message is an online report line numbered DB01332I. This message provides columns of lock data information in response to an online COMM STATUS request. The columns are defined as shown in the following list. Correlate the columns in this list with the column headings shown in DB01331I.

c1

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

c2

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

c3

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

c4

This is the task number that owns the resource. If MUFPLEX and it is remote, then the Mufplex number (y) where the task is executing is also included.

c5

VALUE/RID indicates a value lock or record lock. The following table identifies the types of locks that can occur. If a task status is WAIT E/C or WAIT TASK, different types of locks can be responsible for the wait. When the lock is a record lock or a table lock, DBUTLTY prints a record ID in the text of a report message line numbered DB01329I to indicate the resource causing the lock that is responsible for the wait, as described in the following chart:

Lock Type	RID Format	Meaning
Record	RID-ddddtttrrrrrrrrrrrrrrr	In the RID format, dddd is the Database ID, ttt is the Table name, and rrrrrrrrrrrrrrr is the Record ID.
Table	TTT-00000000-00	TTT is the table ID. The remaining five bytes contain zeros.

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 queue/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.

Action:

None. This message is for information only.