Table stats not updated by brconnect -u / -c -f stats -t missing

[benoit-schmid]

Hello,

Could you please explain why the following stats are not updated by brconnect -u / -c -f stats -t missing:

BR0851I Number of tables/partitions with missing statistics: 0/38

Owner SAPSR3: */38

/BI0/F0ORA_C01H./BI0/F0ORA_C01H0000000043 /BI0/F0ORA_C01H./BI0/F0ORA_C01H0000000044 /BI0/F0ORA_C01H./BI0/F0ORA_C01H0000000045 /BI0/F0ORA_C01H./BI0/F0ORA_C01H0000000046 /BI0/F0ORA_C01H./BI0/F0ORA_C01H0000000047 /BI0/F0ORA_C02H./BI0/F0ORA_C02H0000000043 /BI0/F0ORA_C02H./BI0/F0ORA_C02H0000000044 /BI0/F0ORA_C02H./BI0/F0ORA_C02H0000000045 /BI0/F0ORA_C02H./BI0/F0ORA_C02H0000000046 /BI0/F0ORA_C02H./BI0/F0ORA_C02H0000000047

/BI0/F0ORA_C03H./BI0/F0ORA_C03H0000000043 /BI0/F0ORA_C03H./BI0/F0ORA_C03H0000000044 /BI0/F0ORA_C03H./BI0/F0ORA_C03H0000000045 /BI0/F0ORA_C03H./BI0/F0ORA_C03H0000000046 /BI0/F0ORA_C03H./BI0/F0ORA_C03H0000000047 /BI0/F0SMD_EA1H./BI0/F0SMD_EA1H0000000043 /BI0/F0SMD_EA1H./BI0/F0SMD_EA1H0000000044 /BI0/F0SMD_EA1H./BI0/F0SMD_EA1H0000000045 /BI0/F0SMD_EA1H./BI0/F0SMD_EA1H0000000046 /BI0/F0SMD_EA1H./BI0/F0SMD_EA1H0000000047

/BI0/F0SMD_PE2H./BI0/F0SMD_PE2H0000000049 /BI0/F0SMD_PE2H./BI0/F0SMD_PE2H0000000050 /BI0/F0SMD_PE2H./BI0/F0SMD_PE2H0000000051 /BI0/F0SMD_PE2H./BI0/F0SMD_PE2H0000000052 /BI0/F0SMD_PE2H./BI0/F0SMD_PE2H0000000053 /BI0/F0SM_ESRC2./BI0/F0SM_ESRC20000000007 /BI0/F0SM_ESRCV./BI0/F0SM_ESRCV0000000048 /BI0/F0SM_ESRIS./BI0/F0SM_ESRIS0000000009 /BI0/F0SM_ESRLM./BI0/F0SM_ESRLM0000000050 /BI0/F0SM_ESRMC./BI0/F0SM_ESRMC0000000048

/BI0/F0SM_ESRNS./BI0/F0SM_ESRNS0000000009 /BI0/F0SM_ESRP2./BI0/F0SM_ESRP20000000009 /BI0/F0SM_ESRPC./BI0/F0SM_ESRPC0000000009 /BI0/F0SM_ESRRE./BI0/F0SM_ESRRE0000000048 /BI0/F0SM_ESRSC./BI0/F0SM_ESRSC0000000048 /BI0/F0SM_ESRST./BI0/F0SM_ESRST0000000009 /BI0/F0SM_ESRUS./BI0/F0SM_ESRUS0000000006 /BI0/F0SM_ESRUS./BI0/F0SM_ESRUS0000000007

Thanks in advance for your answer.

[Former Member · Accepted solution]

Hello Benoit,

These are BW temporary tables and thus seem to be excuded.  Check the following:

http://wiki.sdn.sap.com/wiki/display/BI/BW+temporary+database+objects

Regards,

Graham

[benoit-schmid · Accepted solution]

Hello,

1. Has These are temporary tables why does brconnect check the stats for these tables?

2. Is possible to run the stats for these tables only?

If yes, how do you proceed?

3. Is it possible to configure brconnect to skip the checking of these tables?

Thanks in advance for your answers.

[Reagan · Accepted solution]

Hello

Check these:

Note 428212 - Using BRCONNECT to update InfoCube statistics

http://help.sap.com/saphelp_nwpi71/helpdata/en/47/31b9b9bfc30c4ee10000000a11466f/content.htm

Regards

RB

[benoit-schmid · Accepted solution]

Hello Reagan,

Thanks for the note.

I have updated the stats with the options provided in the Note 428212.

It works.

The problem is more complex than I thought.

This SolMan 7.1 keep creating new tables.

For example yesterday, I have run the stats.

Then, I have run a check.

It was ok.

But during the next three hours, it has created the following:

celqtgvz.chk:BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index partition) SAPSR3./BI0/F0SM_ESRLM~06./BI0/F0SM_ESRLM0000000070

Is there a way to prevent these intensive table creation?

Thanks in advance for your answers.

[Reagan · Accepted solution]

Good Day Benoît

I don't have much information about these tables and how they are created in the Solution Manager system. May be some reporting functionality of Solution Manager is creating these tables in the Solution Manager system.

Regards

RB