Procedure stack for current executing statements
(KPID, CONTEXTID, STATEMENTNUMBER)
| Name | Data Type | Description |
|---|---|---|
| INSTANCEID | long | Instance ID; 0 = non-CE |
| SPID | long | Session process ID |
| KPID | long | Kernel process ID |
| CONTEXTID | long | Current context ID of the procedure |
| STATEMENTNUMBER | long | Current statement number (unique in a batch) of the procedure |
| OBJECTTYPE | string(36) | Type of procedure (stored procedure, etc.) in the stack |
| OBJECTNAME | string(32) | Name of the procedure in the stack |
| LINENUMBER | long | Current line number of the procedure |
| COMPILEDATE | time | Compile date of the procedure |
| MEMUSAGEB | double | Memory usage, in bytes |
| DBID | long | Database ID |
| OWNERUID | long | Owner ID of the procedure |
| OBJECTID | long | Procedure ID |
| PLANID | long | Plan ID (number) in procedure cache |
| DBNAME | string(32) | Name of the database that contains the procedure |
| OWNERNAME | string(32) | Name of the owner of the procedure |
| Attributes: | MDA |
|---|---|
| Minimum database version: | 15.0.3 |