SAP ABAP Table DB6PMSBP (DB6: Calculated Buffer Pool Snapshot Data)
Hierarchy
SAP_BASIS (Software Component) SAP Basis Component
   BC-DB-DB6 (Application Component) DB2 Universal Database for UNIX / NT
     STU6 (Package) DB6: Performance-Monitor (UNIX/Windows)
Basic Data
Table Category INTTAB    Structure 
Structure DB6PMSBP   Table Relationship Diagram
Short Description DB6: Calculated Buffer Pool Snapshot Data    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 DBMSTRTTME DB6DATETIM   CHAR 26   0   DBA: ISO conform timestamp with ms precission  
2 COMPTIME DB6DATETIM   CHAR 26   0   DBA: ISO conform timestamp with ms precission  
3 PARTITN     INT4 10   0    
4 BP_NAME DB6IDENT   CHAR 20   0   DB6: General identifier  
5 BP_NUM     DEC 22   0    
6 BUFFPAGE     DEC 22   0    
7 BP_SZ     DEC 22   0    
8 BP_QAL     DEC 8   2    
9 BP_AV_RTM     DEC 22   2    
10 BP_AV_WTM     DEC 22   2    
11 BP_D_HITRT     DEC 8   2    
12 BP_I_HITRT     DEC 8   2    
13 PL_D_LRS     DEC 22   0    
14 PL_D_PRS     DEC 22   0    
15 PL_D_WS     DEC 22   0    
16 BP_D_SPRS     DEC 22   0    
17 BP_D_SWS     DEC 22   0    
18 PL_I_LRS     DEC 22   0    
19 PL_I_PRS     DEC 22   0    
20 PL_I_WS     DEC 22   0    
21 BP_I_SPRS     DEC 22   0    
22 BP_I_SWS     DEC 22   0    
23 PL_RD_TM     DEC 22   0    
24 PL_WT_TM     DEC 22   0    
25 AV_ASP_RTM     DEC 22   2    
26 AV_ASP_WTM     DEC 22   2    
27 PL_A_DRS     DEC 22   0    
28 PL_A_DWS     DEC 22   0    
29 PL_A_IRS     DEC 22   0    
30 PL_A_IWS     DEC 22   0    
31 PL_A_RTM     DEC 22   0    
32 PL_A_WTM     DEC 22   0    
33 DIRCT_RDS     DEC 22   0    
34 DIRCT_WTS     DEC 22   0    
35 DIRCT_RTM     DEC 22   0    
36 DIRCT_WTM     DEC 22   0    
37 DIRCT_RRQS     DEC 22   0    
38 DIRCT_WRQS     DEC 22   0    
39 AV_DCT_RTM     DEC 22   2    
40 AV_DCT_WTM     DEC 22   2    
41 AV_DCT_RDS     DEC 22   2    
42 AV_DCT_WTS     DEC 22   2    
43 PL_D_TE     DEC 22   0    
44 PL_D_FE     DEC 22   0    
45 PL_I_TE     DEC 22   0    
46 PL_I_FE     DEC 22   0    
47 PL_TD_LRS     DEC 22   0    
48 PL_TD_PRS     DEC 22   0    
49 PL_TI_LRS     DEC 22   0    
50 PL_TI_PRS     DEC 22   0    
51 PL_A_DRRQ     DEC 22   0    
52 PL_A_IRRQ     DEC 22   0    
53 CURBUFFSZ     DEC 22   0    
54 NEWBUFFSZ     DEC 22   0    
55 AUTOSIZE_LABEL     CHAR 3   0    
56 AUTOSIZE     CHAR 1   0    
57 PGS_FROM_BLOCKIO     DEC 22   0    
58 PGS_FROM_VECTRIO     DEC 22   0    
59 PHYS_PAGE_MAPS     DEC 22   0    
60 PL_ASYNC_XDA_RD     DEC 22   0    
61 PL_ASYNC_XDA_RRQ     DEC 22   0    
62 PL_ASYNC_XDA_WRT     DEC 22   0    
63 PL_NO_VICTIM_BUF     DEC 22   0    
64 POOL_XDA_L_READS     DEC 22   0    
65 POOL_XDA_P_READS     DEC 22   0    
66 POOL_XDA_WRITES     DEC 22   0    
67 PL_TEMP_XDA_L_RD     DEC 22   0    
68 PL_TEMP_XDA_P_RD     DEC 22   0    
69 VECTORED_IOS     DEC 22   0    
70 BP_PAGES_LEFT     DEC 22   0    
71 BP_TBSP_USE_CNT     DEC 22   0    
72 PCT_SIZE     DEC 8   0    
73 PCT_LREADS     DEC 8   0    
74 PCT_PREADS     DEC 8   0    
75 PCT_ASYNC_READS     DEC 8   0    
76 UNREADPFPG     DEC 22   0    
77 PREFETCH_WAITS     DEC 22   0    
78 PREFETCH_WAIT_TIME     DEC 22   0    
79 SKP_PRF_DATA_P_READS     DEC 22   0    
80 SKP_PRF_INDEX_P_READS     DEC 22   0    
81 SKP_PRF_TEMP_DATA_P_READS     DEC 22   0    
82 SKP_PRF_TEMP_INDEX_P_READS     DEC 22   0    
83 SKP_PRF_TEMP_XDA_P_READS     DEC 22   0    
84 SKP_PRF_UOW_DATA_P_READS     DEC 22   0    
85 SKP_PRF_UOW_INDEX_P_READS     DEC 22   0    
86 SKP_PRF_UOW_TEMP_DATA_P_READS     DEC 22   0    
87 SKP_PRF_UOW_TEMP_INDEX_P_READS     DEC 22   0    
88 SKP_PRF_UOW_TEMP_XDA_P_READS     DEC 22   0    
89 SKP_PRF_UOW_XDA_P_READS     DEC 22   0    
90 SKP_PRF_XDA_P_READS     DEC 22   0    
91 PL_QUED_ASYNC_DATA_PAGES     DEC 22   0    
92 PL_QUED_ASYNC_DATA_REQS     DEC 22   0    
93 PL_QUED_ASYNC_INDEX_PAGES     DEC 22   0    
94 PL_QUED_ASYNC_INDEX_REQS     DEC 22   0    
95 PL_QUED_ASYNC_OTHER_REQS     DEC 22   0    
96 PL_QUED_ASYNC_TEMP_DATA_PAGES     DEC 22   0    
97 PL_QUED_ASYNC_TEMP_DATA_REQS     DEC 22   0    
98 PL_QUED_ASYNC_TEMP_INDEX_PAGES     DEC 22   0    
99 PL_QUED_ASYNC_TEMP_INDEX_REQS     DEC 22   0    
100 PL_QUED_ASYNC_TEMP_XDA_PAGES     DEC 22   0    
101 PL_QUED_ASYNC_TEMP_XDA_REQS     DEC 22   0    
102 PL_QUED_ASYNC_XDA_PAGES     DEC 22   0    
103 PL_QUED_ASYNC_XDA_REQS     DEC 22   0    
104 PL_FAILED_ASYNC_DATA_REQS     DEC 22   0    
105 PL_FAILED_ASYNC_INDEX_REQS     DEC 22   0    
106 PL_FAILED_ASYNC_OTHER_REQS     DEC 22   0    
107 PL_FAILED_ASYNC_TEMP_DATA_REQS     DEC 22   0    
108 PL_FAILED_ASYNC_TEMP_INDEX_REQ     DEC 22   0    
109 PL_FAILED_ASYNC_TEMP_XDA_REQS     DEC 22   0    
110 PL_FAILED_ASYNC_XDA_REQS     DEC 22   0    
111 .INCLUDE       0   0   DB6: Global Buffer Pool Metrics  
112 .INCLUDE       0   0   DB6: Global Buffer Pool Metrics - Direct Reads  
113 PL_D_GBP_INDEP_PAGES_FND_LBP     DEC 22   0    
114 PL_D_GBP_INVALID_PAGES     DEC 22   0    
115 PL_D_GBP_L_READS     DEC 22   0    
116 PL_D_GBP_P_READS     DEC 22   0    
117 PL_D_LBP_PAGES_FOUND     DEC 22   0    
118 PL_I_GBP_INDEP_PAGES_FND_LBP     DEC 22   0    
119 PL_I_GBP_INVALID_PAGES     DEC 22   0    
120 PL_I_GBP_L_READS     DEC 22   0    
121 PL_I_GBP_P_READS     DEC 22   0    
122 PL_I_LBP_PAGES_FOUND     DEC 22   0    
123 PL_X_GBP_INDEP_PAGES_FND_LBP     DEC 22   0    
124 PL_X_GBP_INVALID_PAGES     DEC 22   0    
125 PL_X_GBP_L_READS     DEC 22   0    
126 PL_X_GBP_P_READS     DEC 22   0    
127 PL_X_LBP_PAGES_FOUND     DEC 22   0    
128 PL_C_GBP_INDEP_PAGES_FND_LBP     DEC 22   0    
129 PL_C_GBP_INVALID_PAGES     DEC 22   0    
130 PL_C_GBP_L_READS     DEC 22   0    
131 PL_C_GBP_P_READS     DEC 22   0    
132 PL_C_LBP_PAGES_FOUND     DEC 22   0    
133 LBP_GBP_DEP_HIT_RATIO     DEC 22   2    
134 LBP_GBP_IND_HIT_RATIO     DEC 22   2    
135 GBP_HIT_RATIO     DEC 22   2    
136 D_LBP_GBP_DEP_HIT_RATIO     DEC 22   2    
137 D_LBP_GBP_IND_HIT_RATIO     DEC 22   2    
138 D_GBP_HIT_RATIO     DEC 22   2    
139 I_LBP_GBP_DEP_HIT_RATIO     DEC 22   2    
140 I_LBP_GBP_IND_HIT_RATIO     DEC 22   2    
141 I_GBP_HIT_RATIO     DEC 22   2    
142 X_LBP_GBP_DEP_HIT_RATIO     DEC 22   2    
143 X_LBP_GBP_IND_HIT_RATIO     DEC 22   2    
144 X_GBP_HIT_RATIO     DEC 22   2    
145 C_LBP_GBP_DEP_HIT_RATIO     DEC 22   2    
146 C_LBP_GBP_IND_HIT_RATIO     DEC 22   2    
147 C_GBP_HIT_RATIO     DEC 22   2    
148 .INCLUDE       0   0   DB6: Global Buffer Pool Metrics  
149 PL_A_D_GBP_INDEP_PAGES_FND_LBP     DEC 22   0    
150 PL_A_D_GBP_INVALID_PAGES     DEC 22   0    
151 PL_A_D_GBP_L_READS     DEC 22   0    
152 PL_A_D_GBP_P_READS     DEC 22   0    
153 PL_A_D_LBP_PAGES_FOUND     DEC 22   0    
154 PL_A_I_GBP_INDEP_PAGES_FND_LBP     DEC 22   0    
155 PL_A_I_GBP_INVALID_PAGES     DEC 22   0    
156 PL_A_I_GBP_L_READS     DEC 22   0    
157 PL_A_I_GBP_P_READS     DEC 22   0    
158 PL_A_I_LBP_PAGES_FOUND     DEC 22   0    
159 PL_A_X_GBP_INDEP_PAGES_FND_LBP     DEC 22   0    
160 PL_A_X_GBP_INVALID_PAGES     DEC 22   0    
161 PL_A_X_GBP_L_READS     DEC 22   0    
162 PL_A_X_GBP_P_READS     DEC 22   0    
163 PL_A_X_LBP_PAGES_FOUND     DEC 22   0    
164 LBP_HIT_RATIO     DEC 22   2    
165 PREFETCH_PAGES_FOUND_GBP     DEC 22   2    
166 D_LBP_HIT_RATIO     DEC 22   2    
167 D_PREFETCH_PAGES_FOUND_GBP     DEC 22   2    
168 I_LBP_HIT_RATIO     DEC 22   2    
169 I_PREFETCH_PAGES_FOUND_GBP     DEC 22   2    
170 X_LBP_HIT_RATIO     DEC 22   2    
171 X_PREFETCH_PAGES_FOUND_GBP     DEC 22   2    
172 PL_A_C_GBP_INDEP_PAGES_FND_LBP     DEC 22   0    
173 PL_A_C_GBP_INVALID_PAGES     DEC 22   0    
174 PL_A_C_GBP_L_READS     DEC 22   0    
175 PL_A_C_GBP_P_READS     DEC 22   0    
176 PL_A_C_LBP_PAGES_FOUND     DEC 22   0    
177 C_LBP_HIT_RATIO     DEC 22   2    
178 C_PREFETCH_PAGES_FOUND_GBP     DEC 22   2    
179 SIZE_MB     DEC 22   2    
180 POOL_COL_L_READS     DEC 22   0    
181 POOL_COL_P_READS     DEC 22   0    
182 POOL_TEMP_COL_L_READS     DEC 22   0    
183 POOL_TEMP_COL_P_READS     DEC 22   0    
184 POOL_COL_WRITES     DEC 22   0    
185 PL_QUED_ASYNC_COL_PAGES     DEC 22   0    
186 PL_QUED_ASYNC_COL_REQS     DEC 22   0    
187 PL_QUED_ASYNC_TEMP_COL_PAGES     DEC 22   0    
188 PL_QUED_ASYNC_TEMP_COL_REQS     DEC 22   0    
189 PL_FAILED_ASYNC_COL_REQS     DEC 22   0    
190 PL_FAILED_ASYNC_TEMP_COL_REQS     DEC 22   0    
191 SKP_PRF_COL_P_READS     DEC 22   0    
192 SKP_PRF_TEMP_COL_P_READS     DEC 22   0    
193 SKP_PRF_UOW_COL_P_READS     DEC 22   0    
194 SKP_PRF_UOW_TEMP_COL_P_READS     DEC 22   0    
195 BP_C_HITRT     DEC 8   0    
196 BP_C_SPRS     DEC 22   0    
197 BP_C_SWS     DEC 22   0    
198 PL_ASYNC_COL_RDS     DEC 22   0    
199 PL_ASYNC_COL_RRQ     DEC 22   0    
200 PL_ASYNC_COL_WRT     DEC 22   0    
History
Last changed by/on SAP  20140117 
SAP Release Created in 46C