SAP ABAP Table DB6PMSTBS (DB6: Calculated Tablespace 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 DB6PMSTBS   Table Relationship Diagram
Short Description DB6: Calculated Tablespace 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 TBS_NAME DB6TSPNAME   CHAR 30   0   DB6: Tablespace Name  
5 BP_QAL     DEC 8   2    
6 BP_AV_RTM     DEC 22   2    
7 BP_AV_WTM     DEC 22   2    
8 BP_D_HITRT     DEC 8   2    
9 BP_I_HITRT     DEC 8   2    
10 PL_D_LRS     DEC 22   0    
11 PL_D_PRS     DEC 22   0    
12 PL_D_WS     DEC 22   0    
13 BP_D_SPRS     DEC 22   0    
14 BP_D_SWS     DEC 22   0    
15 PL_I_LRS     DEC 22   0    
16 PL_I_PRS     DEC 22   0    
17 PL_I_WS     DEC 22   0    
18 BP_I_SPRS     DEC 22   0    
19 BP_I_SWS     DEC 22   0    
20 PL_RD_TM     DEC 22   0    
21 PL_WT_TM     DEC 22   0    
22 AV_ASP_RTM     DEC 22   2    
23 AV_ASP_WTM     DEC 22   2    
24 PL_A_DRS     DEC 22   0    
25 PL_A_DWS     DEC 22   0    
26 PL_A_IRS     DEC 22   0    
27 PL_A_IWS     DEC 22   0    
28 PL_A_RTM     DEC 22   0    
29 PL_A_WTM     DEC 22   0    
30 DIRCT_RDS     DEC 22   0    
31 DIRCT_WTS     DEC 22   0    
32 DIRCT_RTM     DEC 22   0    
33 DIRCT_WTM     DEC 22   0    
34 DIRCT_RRQS     DEC 22   0    
35 DIRCT_WRQS     DEC 22   0    
36 AVG_DIRECT_WTM     DEC 22   2    
37 AVG_DIRECT_RTM     DEC 22   2    
38 AVG_PHYSICAL_WTM     DEC 22   2    
39 AVG_PHYSICAL_RTM     DEC 22   2    
40 POOL_PHYSICAL_WRITES     DEC 22   0    
41 POOL_PHYSICAL_READS     DEC 22   0    
42 AV_DCT_RTM     DEC 22   2    
43 AV_DCT_WTM     DEC 22   2    
44 AV_DCT_RDS     DEC 22   2    
45 AV_DCT_WTS     DEC 22   2    
46 PL_D_TE     DEC 22   0    
47 PL_D_FE     DEC 22   0    
48 PL_I_TE     DEC 22   0    
49 PL_I_FE     DEC 22   0    
50 PL_TD_LRS     DEC 22   0    
51 PL_TD_PRS     DEC 22   0    
52 PL_TI_LRS     DEC 22   0    
53 PL_TI_PRS     DEC 22   0    
54 PL_A_DRRQ     DEC 22   0    
55 PL_A_IRRQ     DEC 22   0    
56 PL_ASYNC_XDA_RDS     DEC 22   0    
57 PL_ASYNC_XDA_RRQ     DEC 22   0    
58 PL_ASYNC_XDA_WRT     DEC 22   0    
59 PL_TEMP_XDA_L_RD     DEC 22   0    
60 PL_TEMP_XDA_P_RD     DEC 22   0    
61 POOL_XDA_L_READS     DEC 22   0    
62 POOL_XDA_P_READS     DEC 22   0    
63 POOL_XDA_WRITES     DEC 22   0    
64 PL_NO_VICTIM_BUF     DEC 22   0    
65 COLOR LVC_CIFNM CHAR30 CHAR 30   0   ALV control: Field name with simple row color coding  
66 BPNAME DB6TABNAML   CHAR 128   0   DB6: long table name  
67 UNREADPFPG     DEC 22   0    
68 TOTAL_IO     DEC 22   0    
69 TOTAL_READ_IO     DEC 22   0    
70 TOTAL_WRITE_IO     DEC 22   0    
71 PREFETCH_WAITS     DEC 22   0    
72 PREFETCH_WAIT_TIME     DEC 22   0    
73 SKP_PRF_DATA_P_READS     DEC 22   0    
74 SKP_PRF_INDEX_P_READS     DEC 22   0    
75 SKP_PRF_TEMP_DATA_P_READS     DEC 22   0    
76 SKP_PRF_TEMP_INDEX_P_READS     DEC 22   0    
77 SKP_PRF_TEMP_XDA_P_READS     DEC 22   0    
78 SKP_PRF_UOW_DATA_P_READS     DEC 22   0    
79 SKP_PRF_UOW_INDEX_P_READS     DEC 22   0    
80 SKP_PRF_UOW_TEMP_DATA_P_READS     DEC 22   0    
81 SKP_PRF_UOW_TEMP_INDEX_P_READS     DEC 22   0    
82 SKP_PRF_UOW_TEMP_XDA_P_READS     DEC 22   0    
83 SKP_PRF_UOW_XDA_P_READS     DEC 22   0    
84 SKP_PRF_XDA_P_READS     DEC 22   0    
85 PL_QUED_ASYNC_DATA_PAGES     DEC 22   0    
86 PL_QUED_ASYNC_DATA_REQS     DEC 22   0    
87 PL_QUED_ASYNC_INDEX_PAGES     DEC 22   0    
88 PL_QUED_ASYNC_INDEX_REQS     DEC 22   0    
89 PL_QUED_ASYNC_OTHER_REQS     DEC 22   0    
90 PL_QUED_ASYNC_TEMP_DATA_PAGES     DEC 22   0    
91 PL_QUED_ASYNC_TEMP_DATA_REQS     DEC 22   0    
92 PL_QUED_ASYNC_TEMP_INDEX_PAGES     DEC 22   0    
93 PL_QUED_ASYNC_TEMP_INDEX_REQS     DEC 22   0    
94 PL_QUED_ASYNC_TEMP_XDA_PAGES     DEC 22   0    
95 PL_QUED_ASYNC_TEMP_XDA_REQS     DEC 22   0    
96 PL_QUED_ASYNC_XDA_PAGES     DEC 22   0    
97 PL_QUED_ASYNC_XDA_REQS     DEC 22   0    
98 PL_FAILED_ASYNC_DATA_REQS     DEC 22   0    
99 PL_FAILED_ASYNC_INDEX_REQS     DEC 22   0    
100 PL_FAILED_ASYNC_OTHER_REQS     DEC 22   0    
101 PL_FAILED_ASYNC_TEMP_DATA_REQS     DEC 22   0    
102 PL_FAILED_ASYNC_TEMP_INDEX_REQ     DEC 22   0    
103 PL_FAILED_ASYNC_TEMP_XDA_REQS     DEC 22   0    
104 PL_FAILED_ASYNC_XDA_REQS     DEC 22   0    
105 .INCLUDE       0   0   DB6: Global Buffer Pool Metrics  
106 .INCLUDE       0   0   DB6: Global Buffer Pool Metrics - Direct Reads  
107 PL_D_GBP_INDEP_PAGES_FND_LBP     DEC 22   0    
108 PL_D_GBP_INVALID_PAGES     DEC 22   0    
109 PL_D_GBP_L_READS     DEC 22   0    
110 PL_D_GBP_P_READS     DEC 22   0    
111 PL_D_LBP_PAGES_FOUND     DEC 22   0    
112 PL_I_GBP_INDEP_PAGES_FND_LBP     DEC 22   0    
113 PL_I_GBP_INVALID_PAGES     DEC 22   0    
114 PL_I_GBP_L_READS     DEC 22   0    
115 PL_I_GBP_P_READS     DEC 22   0    
116 PL_I_LBP_PAGES_FOUND     DEC 22   0    
117 PL_X_GBP_INDEP_PAGES_FND_LBP     DEC 22   0    
118 PL_X_GBP_INVALID_PAGES     DEC 22   0    
119 PL_X_GBP_L_READS     DEC 22   0    
120 PL_X_GBP_P_READS     DEC 22   0    
121 PL_X_LBP_PAGES_FOUND     DEC 22   0    
122 PL_C_GBP_INDEP_PAGES_FND_LBP     DEC 22   0    
123 PL_C_GBP_INVALID_PAGES     DEC 22   0    
124 PL_C_GBP_L_READS     DEC 22   0    
125 PL_C_GBP_P_READS     DEC 22   0    
126 PL_C_LBP_PAGES_FOUND     DEC 22   0    
127 LBP_GBP_DEP_HIT_RATIO     DEC 22   2    
128 LBP_GBP_IND_HIT_RATIO     DEC 22   2    
129 GBP_HIT_RATIO     DEC 22   2    
130 D_LBP_GBP_DEP_HIT_RATIO     DEC 22   2    
131 D_LBP_GBP_IND_HIT_RATIO     DEC 22   2    
132 D_GBP_HIT_RATIO     DEC 22   2    
133 I_LBP_GBP_DEP_HIT_RATIO     DEC 22   2    
134 I_LBP_GBP_IND_HIT_RATIO     DEC 22   2    
135 I_GBP_HIT_RATIO     DEC 22   2    
136 X_LBP_GBP_DEP_HIT_RATIO     DEC 22   2    
137 X_LBP_GBP_IND_HIT_RATIO     DEC 22   2    
138 X_GBP_HIT_RATIO     DEC 22   2    
139 C_LBP_GBP_DEP_HIT_RATIO     DEC 22   2    
140 C_LBP_GBP_IND_HIT_RATIO     DEC 22   2    
141 C_GBP_HIT_RATIO     DEC 22   2    
142 .INCLUDE       0   0   DB6: Global Buffer Pool Metrics  
143 PL_A_D_GBP_INDEP_PAGES_FND_LBP     DEC 22   0    
144 PL_A_D_GBP_INVALID_PAGES     DEC 22   0    
145 PL_A_D_GBP_L_READS     DEC 22   0    
146 PL_A_D_GBP_P_READS     DEC 22   0    
147 PL_A_D_LBP_PAGES_FOUND     DEC 22   0    
148 PL_A_I_GBP_INDEP_PAGES_FND_LBP     DEC 22   0    
149 PL_A_I_GBP_INVALID_PAGES     DEC 22   0    
150 PL_A_I_GBP_L_READS     DEC 22   0    
151 PL_A_I_GBP_P_READS     DEC 22   0    
152 PL_A_I_LBP_PAGES_FOUND     DEC 22   0    
153 PL_A_X_GBP_INDEP_PAGES_FND_LBP     DEC 22   0    
154 PL_A_X_GBP_INVALID_PAGES     DEC 22   0    
155 PL_A_X_GBP_L_READS     DEC 22   0    
156 PL_A_X_GBP_P_READS     DEC 22   0    
157 PL_A_X_LBP_PAGES_FOUND     DEC 22   0    
158 LBP_HIT_RATIO     DEC 22   2    
159 PREFETCH_PAGES_FOUND_GBP     DEC 22   2    
160 D_LBP_HIT_RATIO     DEC 22   2    
161 D_PREFETCH_PAGES_FOUND_GBP     DEC 22   2    
162 I_LBP_HIT_RATIO     DEC 22   2    
163 I_PREFETCH_PAGES_FOUND_GBP     DEC 22   2    
164 X_LBP_HIT_RATIO     DEC 22   2    
165 X_PREFETCH_PAGES_FOUND_GBP     DEC 22   2    
166 PL_A_C_GBP_INDEP_PAGES_FND_LBP     DEC 22   0    
167 PL_A_C_GBP_INVALID_PAGES     DEC 22   0    
168 PL_A_C_GBP_L_READS     DEC 22   0    
169 PL_A_C_GBP_P_READS     DEC 22   0    
170 PL_A_C_LBP_PAGES_FOUND     DEC 22   0    
171 C_LBP_HIT_RATIO     DEC 22   2    
172 C_PREFETCH_PAGES_FOUND_GBP     DEC 22   2    
173 POOL_COL_L_READS     DEC 22   0    
174 POOL_COL_P_READS     DEC 22   0    
175 POOL_TEMP_COL_L_READS     DEC 22   0    
176 POOL_TEMP_COL_P_READS     DEC 22   0    
177 POOL_COL_WRITES     DEC 22   0    
178 PL_QUED_ASYNC_COL_PAGES     DEC 22   0    
179 PL_QUED_ASYNC_COL_REQS     DEC 22   0    
180 PL_QUED_ASYNC_TEMP_COL_PAGES     DEC 22   0    
181 PL_QUED_ASYNC_TEMP_COL_REQS     DEC 22   0    
182 PL_FAILED_ASYNC_COL_REQS     DEC 22   0    
183 PL_FAILED_ASYNC_TEMP_COL_REQS     DEC 22   0    
184 SKP_PRF_COL_P_READS     DEC 22   0    
185 SKP_PRF_TEMP_COL_P_READS     DEC 22   0    
186 SKP_PRF_UOW_COL_P_READS     DEC 22   0    
187 SKP_PRF_UOW_TEMP_COL_P_READS     DEC 22   0    
188 PL_ASYNC_COL_RDS     DEC 22   0    
189 PL_ASYNC_COL_RRQ     DEC 22   0    
190 PL_ASYNC_COL_WRT     DEC 22   0    
191 BP_C_HITRT     DEC 8   2    
192 BP_C_SPRS     DEC 22   0    
193 BP_C_SWS     DEC 22   0    
History
Last changed by/on SAP  20140117 
SAP Release Created in 46C