Poor Performance Updating PS_GPGB_PSLIP_BL_W in DB2 (Doc ID 2014806.1)

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.

Goal

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:

UPDATE  PS_GPGB_PSLIP_BL_W                                  
   SET GPGB_RSLT_VAL_YTD = (                              
SELECT  TRUNC ( C.CALC_RSLT_VAL , 2 )
FROM PS_GPGB_R_A_TMP1 C



 

Solution

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