SAP database check finished with warning(s)

[mohsin_m3]

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_R3_{900 not found for partition SAPBP5./BIC/FCSIM_R3}900./BIC/FCSIM_R30 - ignoring partition

BR0840W Index /BIC/FCSIM_R3_{900 not found for partition SAPBP5./BIC/FCSIM_R3}900./BIC/FCSIM_R30000000008 - ignoring partition

BR0840W Index /BIC/FCSIM_R3_{900 not found for partition SAPBP5./BIC/FCSIM_R3}900./BIC/FCSIM_R30000000009 - ignoring partition

.

.

.

.

BR0840W Index /BIC/FCSIM_R3_{900 not found for partition SAPBP5./BIC/FCSIM_R3}900./BIC/FCSIM_R30000005050 - ignoring partition

BR0840W Index /BIC/FCSIM_R3_{900 not found for partition SAPBP5./BIC/FCSIM_R3}900./BIC/FCSIM_R30000005057 - ignoring partition

BR0840W Index /BIC/FCSIM_R3_{900 not found for partition SAPBP5./BIC/FCSIM_R3}900./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/0200000287_{0 not found for segment SAPBP5./BI0/0200000287}0 - 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_R3_{900 not found for segment SAPBP5./BIC/FCSIM_R3}900./BIC/FCSIM_R30 - ignoring segment

BR0838W Index /BIC/FCSIM_R3_{900 not found for segment SAPBP5./BIC/FCSIM_R3}900./BIC/FCSIM_R30000000008 - ignoring segment

BR0838W Index /BIC/FCSIM_R3_{900 not found for segment SAPBP5./BIC/FCSIM_R3}900./BIC/FCSIM_R30000000009 - ignoring segment

BR0838W Index /BIC/FCSIM_R3_{900 not found for segment SAPBP5./BIC/FCSIM_R3}900./BIC/FCSIM_R30000000010 - ignoring segment

BR0838W Index /BIC/FCSIM_R3_{900 not found for segment SAPBP5./BIC/FCSIM_R3}900./BIC/FCSIM_R30000000011 - ignoring segment

BR0838W Index /BIC/FCSIM_R3_{900 not found for segment SAPBP5./BIC/FCSIM_R3}900./BIC/FCSIM_R30000000012 - ignoring segment

BR0838W Index /BIC/FCSIM_R3_{900 not found for segment SAPBP5./BIC/FCSIM_R3}900./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

[mohsin_m3]

brtools patch upgrade is solution

thx

[Former Member]

Run program RSAR_PSA_PARTITION_CHECK, first with the REPAIR flag deactivated. The output will tell you what to do. See note 1042182 - Secondary index is inconsistent for PSA tables.

I just did this and it solved the problem.

Kind regards,

Erik Traag

[Former Member]

run Index rebuild for all table by brtools.

after that once again run Update Database Statics.

Thanks

[Former Member]

Hi

You can update the missing statistics using the transaction ST05 (enter a query and then click on ANALYZE and you'll get the screen where you can update the missing statistics) or directly by executing a program RSANAORA in SE38. Also you can update them using BRTOOLS.

The missing statistics having ~ sign are indexes and others are tables.

I Hope this helps you.

[Former Member]

Mohsin,

Can you tell whether update stats job runs daily in your system. If yes then it might run after the Db check job. Is this is the case then you need to reschdule your update stat job before DB check job ( say 30 mins before the db check job).

You need to update stats & the rerun Db check job. If executing update stats doesnto fix this issue then you need to collect stats with below command. This will take few hours.

brconnect -u / -c -f stats -t all -f collect -p 4.

http://help.sap.com/saphelp_nw70/helpdata/EN/58/6bec38c9fa7e44b7f2163905863575/frameset.htm

Hope this helps.

Thanks,

Sushil

[mohsin_m3]

Hello Sushil,

Below is timestamp of sapcheck logs

-rw-rr 1 orabp5 dba 73819 May 29 22:28 cearldfl.sta

-rw-rr 1 orabp5 dba 8289 May 30 00:03 cearlodi.cln

-rw-rr 1 orabp5 dba 911702 May 30 07:43 cearmzdq.chk

-rw-rr 1 orabp5 dba 46775 May 30 11:16 cearmtve.sta

-rw-rr 1 orabp5 dba 72845 May 30 22:12 cearqbao.sta

-rw-rr 1 orabp5 dba 8289 May 31 00:03 cearqlyk.cln

-rw-rr 1 orabp5 dba 948004 May 31 07:40 cearrwys.chk

-rw-rr 1 orabp5 dba 953293 May 31 23:22 cearuyvq.sta

-rw-rr 1 orabp5 dba 8289 Jun 01 00:03 cearvjtm.cln

-rw-rr 1 orabp5 dba 68682 Jun 01 06:28 cearwpli.sta

-rw-rr 1 orabp5 dba 10602 Jun 01 06:52 cearwtoa.sta

-rw-rr 1 orabp5 dba 636 Jun 01 07:00 cearwutt.chk

-rw-rr 1 orabp5 dba 911266 Jun 01 07:35 cearwucr.chk

-rw-rr 1 orabp5 dba 310227 Jun 01 07:54 cearwyhw.sta

-rw-rr 1 orabp5 dba 1018484 Jun 01 09:41 cearwzyo.chk

-rw-rr 1 orabp5 dba 43486 Jun 01 10:47 cearxkaq.sta

-rwxrwxr-x 1 orabp5 dba 154864 Jun 01 13:17 connBP5.log

-rw-rr 1 orabp5 dba 940791 Jun 01 13:17 cearxxzd.chk

Please advice me for further action.

Regards

Mohsin M

[Former Member]

Mohsin,

<-rw-rr 1 orabp5 dba 43486 Jun 01 10:47 cearxkaq.sta>

<-rw-rr 1 orabp5 dba 940791 Jun 01 13:17 cearxxzd.chk>

It may possible that in between 10:47 to 13:17 any load took place.

Can you now run update stat job & the run dbcheck & check whether you are getting same warnings?

Thanks,

Sushil

[former_member204746]

your BW functional guy is probably updating/creating BW cubes at the same time you run DB13-CheckDB.

So, run DB13-checkdb when there is not activity or ask your BW guy to move his jobs.

[anindya_bose]

1.run SAP_DROP_TMPTABLES, it will remove all your unused temporary objects.

2.run DB02 and check for missing indexes, during loading usually process chains drop database indexes and after loading it recreats. Check with your BW guy whether

he builds up indexes once again through process chain. If not ask him to recreate indexes manually after loading.

3.it seems you also have some degenerated indexes.from Se14 you can "Activate and Adjust" database tables and indexex

4.then run updates stats for all tables and all indexes

now run to Database check,it should reduce the number of errors/warning

[Former Member]

hi

Update your stats through DB13 and then again run DB CHECK

Rohit

[mohsin_m3]

Hi Rohit,

from last 10 days daily I had run dbcheck but its showing same error

Pls help me

Regards

Mohsin M