Update statistics for Java which is running in a separate host

[Former Member]

Hi All,

we have recently installed SAP CRM 7.0 and ABAP and JAVA is running in 2 different hosts.

Scheduling of Update Statistics for ABAP has been done in DB13 and it is working fine.

Could anyone let me know how to schedule Update Statistics for Java as it is running in separate host.

Though I can use brtools, I want the same to be scheduled, so as to run automatically.

SAP Component : SAP CRM 7.0

Operating System : HPUX 11i - V3(64)

Database : Oracle 10.2.0.4.0

Regards,

Joe

[JPReyes]

I think you can use Java Scheduler also you could use crontab with the br command

Regards

Juan

[Former Member]

Hi Juan,

There are no options available in Java scheduler for Update statistics.

Do u have any idea how to schedule crontab using brconnect.

Do I need to create a script to inculde this brconnect?

Regards,

Joe

[JPReyes]

Yes, you can create a simple scripts that call ora<sid> and then execute the brconnect line like brconnect -u / -c -f stats -t all, then create a line in crontab to execute the script as periodically as you want

Regards

Juan