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