cancel
Showing results for 
Search instead for 
Did you mean: 

Optimizer Statistics

Former Member
0 Kudos

hello all,

any one help me hw can i schedule update statistics other than by db13, what are the other way i can do this task?

thanks,

jansi

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi ,

You can use BRtools for Update Database statistice .

su - orasid

brtools

choose Option 7 ---> Database statistics

and choose Option 1 for Database Statistice .

Processing database statistics

1 = Update database statistics

2 - Collect missing statistics

3 - Delete harmful statistics

4 - Manage database statistics

5 - Collect dictionary statistics

6 - Collect system statistics

7 - Reset program status

Regards

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi shivjansi ,

YOu can not schedule the update stats other than DB13 but you can run immediately with the command

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

or else you can run using BRtools options as satheesh0812 explained.

Thanks,

Chaitanya.

Former Member
0 Kudos

in this is the case, iis there any way i could see the same in DB13 as schduled?

Former Member
0 Kudos

Hi Shiv,

By brtools DBstats will not be scheduled, It will be executed at the same time so in DB13 you will get its log as scheduled.

But in DB14 we can check its logs.

Shivam

Former Member
0 Kudos

hi shivam,

but i could see tat from DB13 as "update stats scheduled"........ i tried to view the parameters it says as

""

This action has not been scheduled via DB13.

Therefore parameter settings are not available.

""

so noother way from R3 hw can i see.. which are the tables and indexes inclueded for this ..


shivjansi

Former Member
0 Kudos

Hi,

Once you schedule "Update statistics" job from DB13, you can check the details in SM37.

Find the job starting with DBA: XXXXXXX.

Another way to schedule this job at operating system level, is use cron job (in UNIX) or Task Schedular in (Windows).

But there is no point scheduling the job at OS level, when you can do it in SAP using DB13 t-code.

Regards.

Rajesh Narkhede

volker_borowski2
Active Contributor
0 Kudos

> so noother way from R3 hw can i see.. which are the tables and indexes inclueded for this ..

In each log of any BR-Program is a "command_line" value that shows how this specific

program has been called. You'll see all option given to the command in this line.

Volker