brtool cannot update table stat in ebub eban table

[Former Member]

Hi ,

I want to update database statistics with brtool for table ebub and eban . Howevere , I found no statistics update after brtool finish and below is message

0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRCONNECT time stamp: 2008-04-23 16.47.24

BR0817I Number of monitored/modified tables in schema of owner SAPDEV: 1/0

BR0280I BRCONNECT time stamp: 2008-04-23 16.47.24

BR0877I Checking and collecting table and index statistics...

BR0280I BRCONNECT time stamp: 2008-04-23 16.47.24

BR0879I Statistics checked for 1 table

BR0878I Number of tables selected to collect statistics after check: 0

BR0880I Statistics collected for 0/0 tables/indexes

BR0806I End of BRCONNECT processing: cdxtnpik.sta 2008-04-23 16.47.24

BR0280I BRCONNECT time stamp: 2008-04-23 16.47.24

BR0802I BRCONNECT completed successfully

It show Statistics collected for 0/0 tables/indexes. Can anyone tell me what had been missing in my steps ?

remarks

I try "brconnect -u / -c -o sapdev -t "eban" " . this is not also update the statistics

Thanks

Felix

[lbreddemann]

Hi Felix,

when you call brconnect like you did, than it will check if it's necessary to gather new statistics by checking how much of the data in it changed since the last time the statistics have been gathered.

To make sure brconnect gathers new statistics you've to use the -force option.

Also see SAP Note

#588668 FAQ: Database statistics,

Point 19. "How can I force the creation of statistics with BRCONNECT for a table?":

So you're call should look like this:

brconnect -u / -c -f stats -f collect,allsel,keep -o sapdev -t "EBAN"

KR Lars

[stefan_koehler]

Hello Felix,

try this:

brconnect -u / -c -f stats -f collect,allsel -o sapdev -t eban
brconnect -u / -c -f stats -f collect,allsel -o sapdev -t ebub

http://help.sap.com/saphelp_nw70/helpdata/en/cb/f1e33a5bd8e934e10000000a114084/content.htm

-> allsel: Updates statistics for all selected objects (option -t or the stats_table parameter), including pool and cluster tables (relevant in Oracle 9i), or deletes statistics for selected objects, including non-pool and non-cluster tables

-> collect: Update statistics without checking them first

The BR*Tools are checking (default), if the statistic data needs to be updated.. here are the rules for that:

http://help.sap.com/saphelp_nw70/helpdata/en/f4/81e93a637bfd70e10000000a11402f/content.htm

Regards

Stefan

[Former Member]

It Works ! Thank You !