IT/SAP

BR0871W Pool or cluster table selected to check/collect statistics

SAP_BASIS 2011. 10. 31. 14:06
Warnig Text

BR0871W Pool or cluster table selected to check/collect statistics: SAPCPP.EPIDXB
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 terms

CBO, update statistics

Reason and Prerequisites

This 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.

Solution

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.