Eastwood
Active Member
We are on XE (SP22), DB2 400, co-existence. I need help to make UBEs run faster on the server. The same UBE that runs approximately in 50 seconds locally takes about 3.5 minutes on the AS400 server. We are trying to go live and this is critical to go live.
In order to solve this we have tried the following but could not improve the performance.
1. Deleted the *SQLPKG
2. Checked the value for *PURGE of the QSYS/QPWFSERVER job class which is set to *NO (as recommended)
3. Checked the value of RequestedService=NONE in JDE.ini on server
4. Checked the TCP/IP configuration
5. Checked the mapping for BSFN objects in the OCM which is disabled.
Did anyone ever ecounter this problem?
Thanks-
In order to solve this we have tried the following but could not improve the performance.
1. Deleted the *SQLPKG
2. Checked the value for *PURGE of the QSYS/QPWFSERVER job class which is set to *NO (as recommended)
3. Checked the value of RequestedService=NONE in JDE.ini on server
4. Checked the TCP/IP configuration
5. Checked the mapping for BSFN objects in the OCM which is disabled.
Did anyone ever ecounter this problem?
Thanks-