Lock timeouts
(HELDSPID, WAITSPID, KEYID)
| Name | Data Type | Description |
|---|---|---|
| INSTANCEID | long | Instance ID; 0 = non-CE |
| EXPIREDATTIME | time | Time when lock expired (timed out) |
| OBJECTDBID | long | Database ID of the object involved in the lock timeout |
| OBJECTID | long | ID of the object involved in the lock timeout |
| PAGENUMBER | long | Page number involved in the lock timeout |
| ROWNUMBER | long | Row number involved in the lock timeout |
| HELDFAMILYID | long | SPID of parent process (in parallel query) of the process holding the lock involved in the lock timeout |
| HELDSPID | long | SPID of the process holding the lock involved in the lock timeout |
| HELDKPID | long | KPID of the process holding the lock involved in the lock timeout |
| HELDPROCDBID | long | Database ID of the procedure of the process holding the lock involved in the lock timeout |
| HELDPROCEDUREID | long | Object ID of the procedure of the process holding the lock involved in the lock timeout |
| HELDBATCHID | long | Batch ID of the process holding the lock involved in the lock timeout |
| HELDCONTEXTID | long | Context ID of the process holding the lock involved in the lock timeout |
| HELDLINENUMBER | long | Line number of the process holding the lock involved in the lock timeout |
| HELDSTMTNUMBER | long | Statement number (unique in a batch) of the process holding the lock involved in the lock timeout |
| HELDNUMLOCKS | long | Number of locks held by the process holding the lock involved in the lock timeout |
| HELDNUMTIMEOUTSCAUSEDBYTRAN | long | Number of timeouts caused by the transaction of the process holding the lock involved in the lock timeout |
| HELDNUMTIMEOUTSCAUSEDBYLOCK | long | Number of timeouts caused by the lock of the process holding the lock involved in the lock timeout |
| WAITFAMILYID | long | SPID of parent process (in parallel query) of the process waiting for the lock involved in the lock timeout |
| WAITSPID | long | SPID of the process waiting for the lock involved in the lock timeout |
| WAITKPID | long | KPID of the process waiting for the lock involved in the lock timeout |
| WAITPROCDBID | long | Database ID of the procedure of the process waiting for the lock involved in the lock timeout |
| WAITPROCEDUREID | long | Object ID of the procedure of the process waiting for the lock involved in the lock timeout |
| WAITBATCHID | long | Batch ID of the process waiting for the lock involved in the lock timeout |
| WAITCONTEXTID | long | Context ID of the process waiting for the lock involved in the lock timeout |
| WAITLINENUMBER | long | Line number of the process waiting for the lock involved in the lock timeout |
| WAITSTMTNUMBER | long | Statement number (unique in a batch) of the process waiting for the lock involved in the lock timeout |
| WAITNUMTIMEOUTSCAUSEDBYTRAN | long | Number of timeouts caused by the transaction of the process waiting for the lock involved in the lock timeout |
| LOCKWAITPERIOD | long | Configured duration time, in seconds, for the lock timeout |
| LOCKTIMEOUTLEVEL | string(24) | Timeout level:
|
| PARTITIONID | long | ID of the partition involved in the lock timeout |
| OBJECTDBNAME | string(256) | Database name for the object involved in the lock timeout |
| OBJECTNAME | string(32) | Name of the object involved in the lock timeout |
| HELDUSERNAME | string(32) | User name of the process holding the lock involved in the lock timeout |
| HELDAPPLNAME | string(32) | Application name of the process holding the lock involved in the lock timeout |
| HELDHOSTNAME | string(32) | Host name of the process holding the lock involved in the lock timeout |
| HELDCLIENTNAME | string(32) | Client name of the process holding the lock involved in the lock timeout |
| HELDCLIENTAPPLNAME | string(32) | Client application name of the process holding the lock involved in the lock timeout |
| HELDCLIENTHOSTNAME | string(32) | Client host name of the process holding the lock involved in the lock timeout |
| HELDTRANNAME | string(256) | Transaction name of the process holding the lock involved in the lock timeout |
| HELDCOMMAND | string(32) | General command type of the process holding the lock involved in the lock timeout |
| HELDPROCDBNAME | string(32) | Database name of the procedure of the process holding the lock involved in the lock timeout |
| HELDPROCEDURENAME | string(32) | Name of the procedure of the process holding the lock involved in the lock timeout |
| HELDLOCKTYPE | string(32) | Type of lock being held by the process holding the lock involved in the lock timeout |
| HELDSOURCECODEID | string(32) | Source code ID of the process holding the lock involved in the lock timeout |
| WAITUSERNAME | string(32) | User name of the process waiting for the lock involved in the lock timeout |
| WAITAPPLNAME | string(32) | Application name of the process waiting for the lock involved in the lock timeout |
| WAITHOSTNAME | string(32) | Host name of the process waiting for the lock involved in the lock timeout |
| WAITCLIENTNAME | string(32) | Client name of the process waiting for the lock involved in the lock timeout |
| WAITCLIENTAPPLNAME | string(32) | Client application name of the process waiting for the lock involved in the lock timeout |
| WAITCLIENTHOSTNAME | string(32) | Client host name of the process waiting for the lock involved in the lock timeout |
| WAITTRANNAME | string(256) | Transaction name of the process waiting for the lock involved in the lock timeout |
| WAITCOMMAND | string(32) | General command type of the process waiting for the lock involved in the lock timeout |
| WAITPROCDBNAME | string(32) | Database name of the procedure of the process waiting for the lock involved in the lock timeout |
| WAITPROCEDURENAME | string(32) | Name of the procedure of the process waiting for the lock involved in the lock timeout |
| WAITLOCKTYPE | string(32) | Type of lock being requested by the process waiting for the lock involved in the lock timeout |
| WAITSOURCECODEID | string(32) | Source code ID of the process waiting for the lock involved in the lock timeout |
| KEYID | string(72) | Internal-use, surrogate partial key; created by Surveillance |
| Attributes: | MDA |
|---|---|
| Minimum database version: | 15.7 |