PH07377: FIX CATSYNC EXCESSIVE CPU PROBLEM DELETING ROWS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR improves the performance of the Catsync program,
  when cleaning up records from the ITOM database.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: CATSYNC BATCH USERS                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR improves the performance of   *
  *                      the Catsync program , when cleaning up  *
  *                      records from the ITOM database          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Catsync excessive CPU problem deleting rows from BJTSOA
  

Problem conclusion

• Avoiding the SORTS and limiting the JOINS and introducing new
  table BJTCS_DAT_DELETE enhancing the performance and giving
  solution to the time out abend.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI61633

Modules/Macros

• BJT$INDX BJT@INCD BJT@INCR BJT@INDR BJT@JCLD
  BJT@TBCR BJT@TBDR BJT@TBGR BJT@TBVO BJT@TSC1 BJT@TSD1 BJTACOND
  BJTAEMAI BJTAESPI BJTALPRS BJTALRTL BJTALTKN BJTALT11 BJTAZLCR
  BJTBIXCR BJTBLALI BJTBLHLI BJTBLRLI BJTBLTIA BJTBLWLI BJTCEMAC
  BJTFILE  BJTFPLCY BJTIAAID BJTIADMA BJTIADMB BJTIADMD BJTIADMJ
  BJTIADMK BJTIADML BJTIADMM BJTIADMN BJTIADMT BJTIADTR BJTIADTV
  BJTIAIF  BJTIANNO BJTIANNP BJTIANNR BJTIAPRT BJTIARS1 BJTIATSA
  BJTIATST BJTIATTD BJTIATTP BJTIATTR BJTIAUTH BJTIBANI BJTIBANP
  BJTIBANR BJTIBHI  BJTIBHP  BJTIBHR  BJTIBRPR BJTIBSET BJTIBUN
  BJTIBUNE BJTIBUNP BJTIBUNR BJTICFGP BJTICFGR BJTICNDI BJTICNDP
  BJTUUSDA BJTUUWRI BJTVRPTR BJTWIXCR BJTXATT1 BJTXMAIN BJTXRPT7
  BJTX211  BJT3JCWT BJT3JGRO BJT3RGEI BJT3RRRU
  

Fix information

• Fixed component name

  OUTPUT MANAGER

• Fixed component ID

  5698A2600

Applicable component levels

• R310 PSY UI61633

     UP19/03/19 P F903

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.