Virtual storage—statement cache and XPROC detail (BSTATSTX)
Total 31-bit xPROC for Dyn SQl active threads 0 MB
Alloc 31-bit XProc strg for Dyn SQl active thds 0 MB
Total 31-bit XPROC strg for static SQL stmts 1 MB
HWM # of Stmt in 64bit agnt local pools 0
Number of statements 64bit agent local pools 0
HWM of # Stmt in 64bit agent local pool at high Strg 0
Allocated statement cache strg in 64 bit agent local 0 MB
HWM Alloc stmt cache strg 64 bit local pools 0 MB
Time Stamp of HWM for Stor alloc in 64 bit Pools 13:35:10
Total 64 bit STMT Cache blks 2G Storage 216 MB
Following table describes the fields in the Virtual storage—statement cache and XPROC detail section.
Field | Description |
|---|---|
Total 31-bit xPROC for Dyn SQl active threads | Total 31-bit xPROC storage for dynamic SQL used by active threads (31-bit DBM1 private variable pool) (QW0225SC) |
Alloc 31-bit xPROC strg for Dyn SQl active thds | Allocated 31-bit xPROC storage for dynamic SQL used by active threads (QW0225LS) |
Total 31-bit xPROC strg for static SQL stmts | Total 31-bit xPROC storage for static SQL (31-bit DBM1 private variable pool) (QW0225SX) |
HWM # of Stmt in 64-bit agnt local pools | High water mark allocated for 31-bit xPROC storage for dynamic SQL used by active threads (QW0225HS) |
Number of statements 64-bit agent local pools | Number of statements in 64-bit agent local pools (64-bit shared agent local variable pools) (QW0225LC) |
HWM of # Stmt in 64-bit agent local pool at high Strg | High water mark for statements in 64-bit agent local pools at high storage time (64-bit shared agent local variable pools) (QW0225HC) |
Allocated statement cache strg in 64 bit agent local | Allocated statement cache storage in 64-bit shared agent local variable pools (QW0225L2) |
HWM Alloc stmt cache strg 64 bit local pools | High water mark for allocated statement cache storage in 64-bit shared agent local variable pools (QW0225H2) |
Time Stamp of HWM for Stor alloc in 64 bit Pools | Time stamp of high water mark for storage allocated in 64-bit shared agent local variable pools since the last IFCID 225 was written (QW0225HT) |
Total 64 bit STMT Cache blks 2G Storage | Total 64-bit STMT CACHE BLOCKS 2G storage (64-bit shared variable pool) (QW0225S2) |