Skip to Content

R3szchk long running time

I am doing export of 4.7x200 production on windows. I skipped update statistics step, R3szchk ran for 8 hours without progress. I checked R3szchk but no process activity found, like it hanged. So I aborted the process. All R3 progs are of latest version. Couple of days ago I ran export but I did not skip step to update statistics and it went ok, but update of statistics took a long time to finish, about 9 hours, but this was not production system so it was alright.

- is it possible to run the same update of statistics manually (as in update statistics step)?

brconnect -u / -c -f stats -o SAPSID -t all -m +I -s P10 -f allset,collect,method,precision,keep -p 4

- will it be harmful for productive system during office hours for end users?

- do I have to be in some special directory when I start update of statistics manually?


If I can do this, I will update statistics manually during office hours and after I can bring productive down for export, start export but skip update of statistics process since I already ran it manually. Is this viable scenario for export?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Feb 05, 2014 at 02:37 PM

    Hello

    - is it possible to run the same update of statistics manually (as in update statistics step)?

    brconnect -u / -c -f stats -o SAPSID -t all -m +I -s P10 -f allset,collect,method,precision,keep -p 4

    Yes

    - will it be harmful for productive system during office hours for end users?

    No

    - do I have to be in some special directory when I start update of statistics manually?

    No. The standard one is enough. /oracle/SID/sapcheck

    Regards

    RB

    Add comment
    10|10000 characters needed characters exceeded

    • You don't need to shutdown SAP for these activities.

      Statistics can be create when the system is up and users working on it.

      But if you are not confident enough then wait until you get a downtime.

      I personally wouldn't wait for a downtime for the statistics collection.

      Regards

      RB

  • Feb 05, 2014 at 09:14 AM

    Hi Sasa,

    Are you using the latest versions of r3trans, r3szchk and r3ta before running the export prepartion and export db steps ?

    If not it is recommendation to downloaded the latest version and then perform export and import.

    Updating the statistics can be done online before you bring the system down. There is no impact on production users.

    Hope this helps.

    Regards,

    Deepak Kori

    Add comment
    10|10000 characters needed characters exceeded

    • Yes r3 programs are in latest version.

      We are doing update of statistics from db13. But I do not think those statistics are useful for export process and R3szchk. Calls for update of statistics in db13 (brconnect -c -f stats -t ALL) differs from sapinst export process update of statistics (brconnect -u / -c -f stats -o SAPSID -t all -m +I -s P10 -f allset,collect,method,precision,keep -p 4)

      During export process the last step is deleting collected statistics.

  • avatar image
    Former Member
    Feb 05, 2014 at 09:16 AM

    Hi,

    As said by Deepak, update statistics can be done online and it should be done periodically to have better database performance.

    Regards,

    Nick Loy

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Sasa Mirkovic

      Hi,

      Here you want to update statistics manually and skip the phase during export?

      Yes, you can do that. You can run the update statistics first (before downtime phase) and then export the database.

      Regards,

      Nick Loy