My Oracle Support Banner

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.

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

To view full details, 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 a vibrant support community of peers and Oracle experts.