on 07-22-2010 7:28 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
in this is the case, iis there any way i could see the same in DB13 as schduled?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.