Poor Performance Updating PS_GPGB_PSLIP_BL_W in DB2 (Doc ID 2014806.1)

Last updated on SEPTEMBER 07, 2021

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.