Poor Performance Updating PS_GPGB_PSLIP_BL_W in DB2
Last updated on JUNE 10, 2017
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms