Skip to Content
0
Jun 01, 2009 at 10:31 AM

SAP database check finished with warning(s)

363 Views

Hello All,

db check finished with lot of LOT of warnings

sapcheck folder >> latesh .chk file

BR0837W Table /BI0/0200000287 not found for index SAPBP5./BI0/0200000287~0 - ignoring index

BR0840W Index /BIC/FCSIM_R3900 not found for partition SAPBP5./BIC/FCSIM_R3900./BIC/FCSIM_R30 - ignoring partition

BR0840W Index /BIC/FCSIM_R3900 not found for partition SAPBP5./BIC/FCSIM_R3900./BIC/FCSIM_R30000000008 - ignoring partition

BR0840W Index /BIC/FCSIM_R3900 not found for partition SAPBP5./BIC/FCSIM_R3900./BIC/FCSIM_R30000000009 - ignoring partition

.

.

.

.

BR0840W Index /BIC/FCSIM_R3900 not found for partition SAPBP5./BIC/FCSIM_R3900./BIC/FCSIM_R30000005050 - ignoring partition

BR0840W Index /BIC/FCSIM_R3900 not found for partition SAPBP5./BIC/FCSIM_R3900./BIC/FCSIM_R30000005057 - ignoring partition

BR0840W Index /BIC/FCSIM_R3900 not found for partition SAPBP5./BIC/FCSIM_R3900./BIC/FCSIM_R30000005059 - ignoring partition

BR1328W Partitioned index SAPBP5./BIC/E100608~010 has no partitions - ignoring partitioning

BR1328W Partitioned index SAPBP5./BIC/E100608~020 has no partitions - ignoring partitioning

BR1328W Partitioned index SAPBP5./BIC/E100608~030 has no partitions - ignoring partitioning

.

.

.

BR1328W Partitioned index SAPBP5./BIC/E100608~P has no partitions - ignoring partitioning

BR1328W Partitioned index SAPBP5./BIC/FCDRCCODA~080 has no partitions - ignoring partitioning

BR1328W Partitioned index SAPBP5./BIC/FCDRCCODA~090 has no partitions - ignoring partitioning

BR1328W Partitioned index SAPBP5./BIC/FCDRCREAA~080 has no partitions - ignoring partitioning

BR1328W Partitioned index SAPBP5./BIC/FCDRCREAA~090 has no partitions - ignoring partitioning

BR1328W Partitioned index SAPBP5./BIC/FCISP2SNA1~02 has no partitions - ignoring partitioning

BR1328W Partitioned index SAPBP5./BIC/FCISP2SNA1~03 has no partitions - ignoring partitioning

.

.

BR0815I Number of indexes/partitions in schema of owner SYSTEM: 174/32

BR0838W Table /BI0/0200000287 not found for segment SAPBP5./BI0/0200000287 - ignoring segment

BR0838W Index /BI0/02000002870 not found for segment SAPBP5./BI0/02000002870 - ignoring segment

BR0838W Table /BI0/0600000103 not found for segment SAPBP5./BI0/0600000103 - ignoring segment

BR0838W Table /BI0/0600000273 not found for segment SAPBP5./BI0/0600000273 - ignoring segment

BR0841W Table partition /BIC/E10060892000001 not found for segment SAPBP5./BIC/E100608./BIC/E10060892000001 - ignoring segment

BR0841W Table partition /BIC/E10060892000002 not found for segment SAPBP5./BIC/E100608./BIC/E10060892000002 - ignoring segment

BR0841W Table partition /BIC/E10060892000003 not found for segment SAPBP5./BIC/E100608./BIC/E10060892000003 - ignoring segment

BR0841W Table partition /BIC/E10060892000004 not found for segment SAPBP5./BIC/E100608./BIC/E10060892000004 - ignoring segment

.

.

BR0838W Index /BIC/FCSIM_R3900 not found for segment SAPBP5./BIC/FCSIM_R3900./BIC/FCSIM_R30 - ignoring segment

BR0838W Index /BIC/FCSIM_R3900 not found for segment SAPBP5./BIC/FCSIM_R3900./BIC/FCSIM_R30000000008 - ignoring segment

BR0838W Index /BIC/FCSIM_R3900 not found for segment SAPBP5./BIC/FCSIM_R3900./BIC/FCSIM_R30000000009 - ignoring segment

BR0838W Index /BIC/FCSIM_R3900 not found for segment SAPBP5./BIC/FCSIM_R3900./BIC/FCSIM_R30000000010 - ignoring segment

BR0838W Index /BIC/FCSIM_R3900 not found for segment SAPBP5./BIC/FCSIM_R3900./BIC/FCSIM_R30000000011 - ignoring segment

BR0838W Index /BIC/FCSIM_R3900 not found for segment SAPBP5./BIC/FCSIM_R3900./BIC/FCSIM_R30000000012 - ignoring segment

BR0838W Index /BIC/FCSIM_R3900 not found for segment SAPBP5./BIC/FCSIM_R3900./BIC/FCSIM_R30000000013 - ignoring segment

.

.

..

BR0969I Checking database administration...

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (table) SAPBP5./BIC/B0000994000

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (table) SAPBP5./BIC/FCCS3_FDP1

(I have collected missing statistics from Brtools)

Please help me to resolve the issue

Regards

Mohsin M

Edited by: mohsin m on Jun 1, 2009 12:31 PM