SUM:MAIN_POSTCLEAN/RUN_RSAIMMERGE_TRANSFER long running

Symptom

In the postprocessing module of an upgrade or an Enhancement Package installation, you notice extreme runtimes of the phase RUN_RSAIMMERGE_TRANSFER.

Reason and Prerequisites

In the phase RUN_RSAIMMERGE_TRANSFER, selects on the table E071 need to be performed.

On some customer databases these selects on the table E071 are very slow.

Solution

1. Recreate the index 1 on the table E071 (defined for the fields PGMID, OBJECT and OBJ_NAME).

2. Refresh the statistics for the table E071.

Alternatively, if creating an additional index is an option:

1. Create an index on the table E071 for the fields TRKORR, PGMID, OBJECT and OBJ_NAME.

2. Refresh the statistics for the table E071.

Repeat the phase RUN_RSAIMMERGE_TRANSFER.

Hope this helps!!!

Abraham