Index creation is taking long time, during export and import using distribution monitor

[Former Member]

Hi All,

We are trying to do Unicode Migration using  distribution monitor.

Export and import of the tables are completing in time, but at the target system unicode creation is taking very long time.

For example BSIS table export has completed in 4hrs, import completed in 1.5 hrs but index creation has taken 11hrs.

Is there any way to reduce time is index creation?

We are using parallelism 20 in DDLORA.TPL.

Regards,

Joie.

[ashish_vikas · Accepted solution]

Hi Joie,

What is the size of BSIS table ?

One possible solution can be.. you can tale out a list of index which takes maximum time. And check log file, it is being created with what SQL command ?

Now, during import, in the corresponding .TSK file, you manually mark them successful by placing OK for that index. And in the background you create them yourself by a SQL command with using more parallel degree & nologing option.

best regards

ashish

[sunny_pahuja2 · Accepted solution]

Hello,

If you have used unsorted unloading in system copy then it usually takes long time in index creation phase. However, Please refer to SAP note 936441 to optimize the process.

Thanks,

Sunny

[Reagan]

Check whether there is a possibility to add additional resources to the hardware.

Regards

RB