SMIGR_CREATE_DDL HANG

[Former Member]

Dear all,

I am doing System copy on linux / oracle through export-import meothed ...when i am trying to generate DDL statements using abap report SMIGR_CREATE_DDL in Se38 it got hang its executing from the long time(2500 seconds) but showing no result ..i am running out of time...my database is only of 60 GB and average datafile size is 2 GB ...

Please help.

Regards.

[Former Member]

Hi,

Just in case -- check DB01 or SM66 for any database locks. During a Unicode conversion I did some time ago SMIGR_CREATE_DDL went into an extremely long Oracle wait as it collided with one of the UC prep reports. I know this does not match your situation but it doesn't do any harm checking.

Regards,

Mark

[markus_doehr2]

Execute it in the background. Make sure your database statistics are up-to-date.

Markus

[martimmendes]

Mine already at 17000secs....

Statistics up-to-date, log area just at 1% occupied.

database size 100GB, about 14GB free, my sapdata filesystem is almost full tough 98%...

Any thoughts ?

BR's

Martim Mendes

[Former Member]

>> Mine already at 17000secs....

>

> Statistics up-to-date, log area just at 1% occupied.

>

> database size 100GB, about 14GB free, my sapdata filesystem is almost full tough 98%...

>

> Any thoughts ?

>

Hi Martim,

Is your system is B/w ? this report is mainly use for B/w system .... if your system is not B/w system then you can leave this step.

My system was Ecc5.0 and I also did the same(skip this step)

-Rohit

[Former Member]

Hi Markus,

Thanks for that hint about making ht eJob run in Background.

Is there any possibility to check if the process run OK as a Background process?

Greatings,

Niklas

[markus_doehr2]

> Is there any possibility to check if the process run OK as a Background process?

SM37

SM66

SM50

Markus

[Former Member]

Thank you very much for the fast answer Markus

[andreas_herzog]

is it still running? 2500 seconds is not that much...i had systems in which the job took more than one hour (= 3600 seconds)

GreetZ, AH