PK42634: SUPPORT FOR DB2 APAR PK28561/PTF UK18090

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 APAR PK28561/PTF UK18090 introduces changes to the
  availability of package related accounting information. A new
  trace class, 10,
  is created that must be started to gather information that was
  previously available.
  

Local fix

• If possible defer applying DB2 APAR PK28561/PTF UK18090 until
  this fix is available.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 - Classic Interface                          *
  *                 - ICAT                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1.1 For V310 + V410:                    *
  *                      APAR PK28561 / PTF UK18090 for          *
  *                      DB2 V810 introduces changes to the      *
  *                      availability of package related         *
  *                      accounting information. IFCID239 will   *
  *                      no longer collect package detail info   *
  *                      by default. Now a new trace class has   *
  *                      to be started (accounting class 10)     *
  *                      to get package detail information.      *
  *                                                              *
  *                      2.1 For V310:                           *
  *                      IFCID63 collects only the first 5000    *
  *                      bytes of an SQL statement. To allow     *
  *                      the collection of the complete          *
  *                      SQL statements the new option FULL      *
  *                      is introduced which is currently not    *
  *                      supported for batch mode install.       *
  *                                                              *
  *                      2.2 For V410:                           *
  *                      IFCID63 collects only the first 5000    *
  *                      bytes of an SQL statement. To allow     *
  *                      the collection of the complete          *
  *                      SQL statements the new option FULL      *
  *                      is introduced.                          *
  *                                                              *
  *                      3.1 For V410:                           *
  *                      When stepping through all DB2           *
  *                      subsystem configuration panel by        *
  *                      specifying ALL on the command line on   *
  *                      the DB2 subsystem configuration menu    *
  *                      and not having PE Client support        *
  *                      enabled you get stuck when step         *
  *                      backward by pressing F3.                *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  ****************************************************************
  1.1 For V310 + V410:
  To collect package detail data in Near-Term History the
  accounting class 10 that was introduced by DB2 has to be
  supported.
  
  2.1 For V310:
  To collect long SQL statements the option DYNAMICSQL(FULL)
  has to be supported also by batch mode install.
  
  2.2 For V410:
  To collect long SQL statements the option DYNAMICSQL(FULL)
  has to be supported in Near-Term History.
  
  3.1 For V410:
  One gets stuck when navigating backwards through the
  DB2 subsystem configuration panels with the ALL option.
  

Problem conclusion

• 1.1 For V310 + V410:
  Program has been changed to have the possibility to start
  accounting trace class 10 via acctg startup parameter
  
  1.2 For V310 + V410:
  ICAT: A new variable to enable the collection of accounting
  class 10 information in NTH is added.
  
  2.1 For V310:
  ICAT: The option FULL for Dynamic SQL in NTH was enabled
  for batch mode install.
  
  2.2 For V410:
  ICAT: To allow the collection of complete SQL statements
  (even if these are longer than 5000 bytes) the option FULL
  is introduced for Dynamic SQL.
  
  3.1 For V410:
  ICAT: The panel flow control is adjusted to let you navigate
  backwards when PE Client support is not enabled.
  
  KEYWORDS: INCORROUT DYNAMICSQL FULL ACCOUNTING TRACE CLASS 10
  PACKAGE DETAIL PK28561 UK18090
  

Temporary fix

Comments

APAR Information

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

  OA19393

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

  UK29478 UK29479

Modules/Macros

•    KDBZC04  KD2BHELP KD2CTBEX KD2DDICT KD260CVA
  KD260H9C KD260PB  KD260SO2 KD261CVA KD261CV1 KD261HA  KD261HAA
  KD261HAB KD261HAC KD261HB  KD261HBA KD261HH  KD261HHA KD261HHB
  KD261HHC KD261HK  KD261HM  KD261HMA KD261HN  KD261HNA KD261HNB
  KD261HNC KD261HND KD261HNE KD261HNF KD261HNG KD261HNH KD261HNM
  KD261HNO KD261HNP KD261HNQ KD261HNR KD261HQ  KD261HS  KD261HSA
  KD261HSB KD261HSC KD261HSD KD261HSE KD261HSF KD261HSG KD261HSH
  KD261HSI KD261HSJ KD261HSM KD261HSN KD261HSO KD261HV  KD261HVA
  KD261HVB KD261HVC KD261HW  KD261HWA KD261HWB KD261HWC KD261HWD
  KD261HX  KD261H0  KD261H0A KD261H0B KD261H0C KD261H0D KD261H0E
  KD261H0F KD261H2  KD261H9  KD261H9A KD261H9B KD261H9C KD261PB
  KD261PU  KD261SO2 KO2ACAPA KO2ACAPS KO2ACAP2 KO2CMVSC KO2CMVSF
  KO2CNSRB KO2DAUDA KO2DAUDS KO2DAUD2 KO2DDSBA KO2DDSBS KO2DDSB2
  KO2DMSCA KO2DMSCS KO2DMSC2 KO2DTHDA KO2DTHDS KO2DTHD2 KO2DXSTB
  KO2DXS1A KO2DXS1S KO2DXS12 KO2DXS2A KO2DXS2S KO2DXS22 KO2HDTIB
  KO2HDTPB KO2HINTB KO2HPRCB KO2HPR1B KO2HPR2B KO2HSQIB KO2HSQPB
  KO2HVINB KO2HWLMB KO2ICOLA KO2ICOLS KO2ICOL2 KO2IINTB KO2LCAPB
  KO2MSBDB KO2MSB1B KO2MSB2B KO2MSB3B KO2MSB4B KO2MSUMB KO2OH2IB
  KO2ONTAB KO2TSB1B KO2TSB2B KO2TSB3B KO2TSB4B KO2WGETB
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R310 PSY UK29478

     UP07/09/26 P F709

• R410 PSY UK29479

     UP07/09/26 P F709

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.