User Master import - during System Refresh activity takes a very long time

[former_member293883]

Hi

While doing the User Master Import during a system refresh, we find that the Import process takes a very long time.

Has anyone faced such and issue and got a solution for the same.

thaks

[Former Member]

Hello Parthasarathy,

While importing the user master records by using the TP tool, you need to be patient if there are lot of records (users) which needs to be imported. There is no alternative to this.

However, you can reduce the runtime for SCC7 (Post Import Processing). All you need to do is the following (Valid only for R3 systems) :

In all R3 systems, before executing scc7, determine the storage quality of the table. If the storage quality is less than 70%, we should re-build the index. This will speedup the scc7 run considerably.

For determining the storage quality of the imported user master:

1) Logon to Production client

2) Go to ->tcode db02

3) Click on Detailed Analysis

4) Type USRBF2 as object name; this is the table for User buffer content for fast RFC logon

5) Click Table ->Indexes ; the table name and the index are displayed

6) Place the cursor on the index(USRBF2~0) and click on Detailed Analysis button

7) Check the storage quality; select Analyis Index->Storage quality from the menu

😎 If Storage quality is less than 70%, we have to rebuild index

9) For rebuilding indexes, go to Alter index->rebuild

10) After rebuild is completed, proceed to execute Scc7

You will notice that the runtime will be reduced by a very great margin, thus saving you precious time.

Hope it helps.

Regards,

Deoraj Alok.

[former_member204746]

this is normal and expected, especially if you have something like 30,000 users. THis usually happens when you have a lot of HR users.

[markus_doehr2]

How do you do that import?

Markus