DB2THREAD2 is a SAP table coming under BC module and SAP_BASIS component.View details, Fields & related tables of DB2THREAD2 in SAP.
- Table description :
- Module : BC-DB-DB2
- Parent Module : BC
- Package : STU3
- Software Component : SAP_BASIS
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP DB2THREAD2 Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| MEMB_NAME | DB2 member name in data sharing environment | DB2MEMN | DB2CHAR08 |
| ACE | Field type raw, length 8, 4 bytes | DB2RAW04 | DB2INT4 |
| BPNAME | DB2 buffer pool name | DB2BPNAME | DB2BPNAME |
| QBACPID | Buffer pool ID | DB2BACPID | DB2INT4U |
| QBACGET | Number of Getpage Requests | DB2BACGET | DB2INT4U |
| QBACSWS | The number of times a buffer update occurs for the agent | DB2BACSWS | DB2INT4U |
| QBACRIO | Number of synchronous read I/O operations | DB2BACRIO | DB2INT4U |
| QBACSEQ | Number of sequential prefetch requests | DB2BACSEQ | DB2INT4U |
| QBACIMW | Number of immediate (synchronous) write I/Os | DB2BACIMW | DB2INT4U |
| QBACLPF | Number of list prefetch requests | DB2BACLPF | DB2INT4U |
| QBACDPF | Number of dynamic prefetch requests | DB2BACDPF | DB2INT4U |
| QBACHRE | Number of Successful Synchronous Hiperpool Reads | DB2BACHRE | DB2INT4U |
| QBACHRF | Number of Unsuccessful Synchronous Hiperpool Reads | DB2BACHRF | DB2INT4U |
| QBACHWF | Number of Unsuccessful Synchronous Hiperpool Writes | DB2BACHWF | DB2INT4U |
| QBACHWR | Number of Successful Synchronous Hiperpool Writes | DB2BACHWR | DB2INT4U |
| QBACNGT | Unsuccesful Page at Conditional Getpage Request | DB2BACNGT | DB2INT4U |
| QBACSIO | Asynchronous pages read | DB2BACSIO | DB2INT4U |
| QBACHPG | Number of Pages Read Asynchronously | DB2BACHPG | DB2INT4U |
| HPSRWRATE | Ratio of synch. reads vs synch. writes for the hiperpool | DB2HPSRWRA | DB2CHAR10 |
| HPUNSUCC | No. of Unsuccessful Sync. Hiperpool Read or Write Requests | DB2HPUNSUC | DB2INT4U |
DB2THREAD2 related tables
| Table | Note |
|---|