BR0871W Pool or cluster table selected to check/collect statistics: SAPCPP.EPIDXC
BR0871W Pool or cluster table selected to check/collect statistics: SAPCPP.GLSP
BR0871W Pool or cluster table selected to check/collect statistics: SAPCPP.GLTP
BR0871W Pool or cluster table selected to check/collect statistics: SAPCPP.KAPOL
BR0871W Pool or cluster table selected to check/collect statistics: SAPCPP.KOCLU
BR0871W Pool or cluster table selected to check/collect statistics: SAPCPP.M_IFLM
BR0871W Pool or cluster table selected to check/collect statistics: SAPCPP.VBCLU
BR0871W Pool or cluster table selected to check/collect statistics: SAPCPP.VBFCL
Reference Notes: 411773
TCODE: DB21
Symptom
When the statistics are updated using the BRCONNECT function "-f stats", the warning BR871W is issued for a number of tables, for example: BR871W Pool or cluster table selected to check/collect statistics: <TAB>Where <TAB> is often filled by the following tables: EPIDXB, EPIDXC, GLSP, GLTP, KAPOL, KOCLU, M_IFLM, M_KKEB, M_MEOR, M_REBL, M_REVN, M_VMVA, M_VMVL, VBCLU, VBFCL.
Other termsCBO, update statistics
Reason and PrerequisitesThis is caused by a delivery problem.
The tables issued are entered in the DBSTATC tax table with ACTIVE indicator "A" or "P", even though they are pool or cluster tables. Tables such as these are not usually permitted to have any statistics.
Use Transaction DB21 to change the ACTIVE flag for these tables to "R". Statistics are then only created for these for a short period of time, saved in Table DBSTATTORA and then deleted immediately afterwards.
However, if you are absolutely certain that the table should have statistics, set the customer flag in DBSTATC for the table.
'IT > SAP' 카테고리의 다른 글
To do for After Installed Oracle 10g (0) | 2011.12.24 |
---|---|
Does not Start After Latest SAP Kernel Patch 7.20 (0) | 2011.12.12 |
R/3 won't start after database restore or database copy (0) | 2011.06.23 |
Netweaver CE 7.2 Install 중 JAVA IMPORT Error (0) | 2011.06.10 |
ECC EHP4 Upgrade중 XPRASUPG단계 에러 (2) | 2011.06.10 |