Current executing batches
(KPID, BATCHID)
| Name | Data Type | Description |
|---|---|---|
| INSTANCEID | long | Instance ID; 0 = non-CE |
| SPID | long | Session process ID |
| KPID | long | Kernel process ID |
| BATCHID | long | Batch ID |
| CONTEXTID | long | Context ID |
| STMTSTARTTIME | time | Start time of the current statement in the batch |
| NOWTIME | time | Current time |
| PROCDBNAME | string(32) | Database name of the current procedure, if applicable |
| PROCEDURENAME | string(64) | Name of the current procedure, if applicable |
| LINENUMBER | long | Line number in the batch |
| TEMPDBNAME | string(32) | TempDB name |
| MERGESTATUS | long | Internal-use merge status; created by Surveillance |
| STARTTIME | double | Start time of the batch, in time_t format |
| ELAPSEDTIME | double | Elapsed time of the batch, in seconds |
| Attributes: | MDA |
|---|---|
| Minimum database version: | 12.5.0.3 |