Database Import

[Former Member]

Hello,

We are doing a Database Migration of our Production system from Informix 10 to Oracle 9 with SAP R/3 4.6B...

I am doing the database import and would like to know whether it is possible to skip the update statistics...

We have a 4 TB database and it takes days to run update statistics... We do run an update stats before the start of export...

How should i skip the update statistic step and will i face any issue because of that...

Thanks,

RaHuL...

[stefan_koehler · Accepted solution]

Hello Rahul,

the newer SAPINST versions give you the possibility to deselect the "Update statistics" step.

If you have to use an old SAPINST, you can replace brconnect by a little shell script that returns the return code 0. Then the SAPINST thinks that the statistic update was successfull.

Regards

Stefan

[Former Member · Accepted solution]

Thanks,

We are using SAP R/3 4.6 B with Kernel 4.6D and use R3Setup...

What changes are required to be done in that file...

Thanks,

RaHuL...

[stefan_koehler · Accepted solution]

Hell Rahul,

something like this.

shell> su - <SID>adm
shell> cdexe
shell> mv brconnect brconnect.org
shell> vi brconnect
#!/usr/bin/ksh
return 0
shell> chmod 777 brconnect
.....
continue your sapinst
......
shell> mv brconnect.org brconnect

Regards

Stefan

[former_member204746 · Accepted solution]

Nice workaround Stefan!

[Former Member · Accepted solution]

Thanks a lot...

I will try this and revert....

Thanks,

RaHuL...

[markus_doehr2]

I would start the import, run as usual and then stop R3SETUP when the update statistics starts. Then I´d open DBMIG.R3S and set the ERROR state to OK and continue.

Markus

[Former Member]

Thanks...

I did try it once, but it didnt work... The application didnt start up because update stats didnt run...I think it was for some system level table... That was some time back...

I will try it once again and then get back...

Thanks,

RaHuL...