PS migration in Stat has two steps,
1 - Staging, performed by Stat Central Agent.
2 - Migration from Staging to Target performed by PeopleTools CLI
The following query allows to estimate and compare the duration of each step in seconds:
SELECT A.MIGR_ID,
MOD(TRUNC(24 * 60 * 60 * (B.STAGE_DT-A.START_DT)), 60) DURATION_STAGING,
MOD(TRUNC(24 * 60 * 60 * (A.END_DT-B.STAGE_DT)), 60) DURATION_CLI,
MOD(TRUNC(24 * 60 * 60 * (A.END_DT-A.START_DT)), 60) DURATION_TOTAL
FROM CSR_MIGRATION A
JOIN CSR_MIGRATION_PS B ON A.MIGR_ID=B.MIGR_ID
Normally the CLI takes longer to execute.
The reason CLI performed faster after the first migration is that it uses cache created during the first migration.
Try to delete the cache after the first migration.
Apparently we cannot change the functionality of PeopleTools CLI
