Poor Performance Updating PS_GPGB_PSLIP_BL_W in DB2
(Doc ID 2014806.1)
Last updated on MAY 02, 2018
Applies to:PeopleSoft Enterprise HCM Global Payroll United States - Version 9.1 and later
Information in this document applies to any platform.
How to resolve performance issue in Update of PS_GPGB_R_A_TMP temp table in GP UK Payroll processing.
When performing an Update on the PS_GPGB_PSLIP_BL_W table in DB2 zOS performance is poor and consumes excessive CPU resources.
The following update statement performs poorly in DB2 (and possibly other platforms) in GP Great Britain:
SET GPGB_RSLT_VAL_YTD = (
SELECT TRUNC ( C.CALC_RSLT_VAL , 2 )
FROM PS_GPGB_R_A_TMP1 C
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!