SAP ABAP Data Element DB2W0148AI (The status of the thread)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-DB2 (Application Component) DB2 for z/OS
⤷
STU2 (Package) CCMS for DB2 for OS/390
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-DB2 (Application Component) DB2 for z/OS⤷
STU2 (Package) CCMS for DB2 for OS/390
Basic Data
| Data Element | DB2W0148AI |
| Short Description | The status of the thread |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | DB2CHAR16 | |
| Data Type | CHAR | Character String |
| Length | 16 | |
| Decimal Places | 0 | |
| Output Length | 16 | |
| Value Table |
Further Characteristics
| Search Help: Name | ||
| Search Help: Parameters | ||
| Parameter ID | ||
| Default Component name | ||
| Change document | ||
| No Input History | ||
| Basic direction is set to LTR | ||
| No BIDI Filtering |
Field Label
| Length | Field Label | |
| Short | 10 | Thd status |
| Medium | 15 | Status |
| Long | 20 | Status |
| Heading | 0 |
Documentation
Definition
The status of the DB2 thread may be one of the following.
- In DB2: The thread is processing work.
- I/O suspension: The thread performs either a read I/O operation (from data set on DASD into the buffer pool) or a synchronous write I/O operation. (Also, see IFCID 6, 8)
- Lock suspension: The IRLM does not immediately satisfy a lock request of the thread. (Also, see IFCID 44)
- Latch suspension: This status indicates either a shared latch resume or an exclusive latch wait. (Also, see IFCID 51, 56)
- Archive read: There are two possibilities. The thread experiences an archive read I/O wait or the thread waits for the log I/O done by a service task. (Also, see IFCID 114, 117)
- Other read suspension: The thread is ready to be suspended so it can wait for a page for which I/O is in progress by a service task. (Also, see IFCID 127)
- Archive quiesce: A BEGIN-UR request of the thread is suspended, because an ARCHIVE LOG MODE(QUIESCE) command is active. (Also, see IFCID 174)
- Drain lock: The thread waits for a drain lock. (Also, see IFCID 213)
- Claim release: The thread waits for the number of claims to go to zero. (Also, see IFCID 215)
- Page latch: The thread is suspended to wait for a page latch that is currently held under another agent. (Also, see IFCID 226)
- Service task: Others
For more detailed information, see the IBM documentation on DB2.
History
| Last changed by/on | SAP | 20070813 |
| SAP Release Created in |
