ADDI - Improve Import IWS Applications with AD Connect

In our test-environment we are currently testing the import of TWS applications into our projects. The performance of this import is very poor.

After runstats etc. we see that one query stands out in “Average getpages” (216779,00). Just like the “Make Project” process this is a DELETE query.

Below some data from the query monitor:

DELETE
FROM TWS_Applications
WHERE TWS_Applications.AppID in (SELECT TWS_Applications.AppID
FROM TWS_Applications INNER JOIN SESSION.TWS_TempTbl ON TWS_Applications.ApplicationName = SESSION.TWS_TempTbl.AppID) AND LparID = 0


SQL Text DELETE FROM TWS_Applications WHERE TWS_Applications.AppID in (SELECT TWS_Applica
Execution Count 7

SQL Calls 7
DB2 Subsystem ID
Plan
Program
Current Schema
Section
Collection ID
Consistency Token
Package Version
Elapsed Time 39,920625
%Elap 96,46
AvgX Elapsed 5,702946
Elapsed time standard deviation N/A
CPU time 13,955302
%CPU 99,61
AvgX Cpu 1,993614
CPU time standard deviation N/A
<%CPU> 34,96
Total Delay Time 0,388514
%Delay 23,44
AvgX Delays 0,055502
<%DLY> 0,97
<%UAT> 64,07
Total Getpages 1.517.453
AvgX Getpages 216779,00
Getpages standard deviation N/A
zIIP DB2 CPU 21,769264
<%zIIP> 60,94
Avg CPU 1,993614
Avg Elapsed 5,702946
Avg Delay 0,055502
Average Getpages 216779,00
Accel Elig Elapsed 0,000000
Accel Elig CPU 0,000000
Accel Elig zIIP 0,000000