PH18434: IIDR CDC FOR Z/OS REQUIRES CHANGES TO EXPLOIT NEW CAPABILITIES OF AND IMPROVEMENTS TO RECENT DB2 VERSIONS.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Over several versions, DB2 has improved aspects of the
  interfaces used by IIDR CDC for z/OS, and provided more
  flexilibity for customers to specify how DB2 will operate. Some
  examples:
  1) The RSSAF interface enables certain performance improvements
  when accessing the DB2 Log. IIDR CDC for z/OS uses the CAF
  interface, which does not.
  2) DB2 permits the customer to specify the load module names of
  certain DB2 user exits. IIDR CDC for z/OS only accesses the DB2
  user exits using the default names.
  IIDR CDC for z/OS should be modified to exploit the
  improvements in DB2.
  

Local fix

• No local fix is available.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IIDR CDC for z/OS.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 has implemented a number of         *
  *                      improvements since IIDR CDC for z/OS    *
  *                      first became available.  This SPE       *
  *                      (Small Programming Enhancement) PTF     *
  *                      implements logic that takes advantage   *
  *                      of those DB2 interface changes and      *
  *                      improvements:                           *
  *                      1 - The RRSAF is used rather than the   *
  *                      CAF to communicate with the DB2 IFI and *
  *                      to issue SQL requests.                  *
  *                      2 - The DB2 DSNHDECP module is received *
  *                      directly from DB2, rather than being    *
  *                      loaded from the STEPLIB concatenation.  *
  *                      3 - The names of the DB2 user exits     *
  *                      that IIDR CDC for z/OS will call can be *
  *                      specified, rather than loading only the *
  *                      default named DB2 user exits.           *
  *                      4 - The DB2 MONITOR Trace that is used  *
  *                      for log activity notification will no   *
  *                      longer be started.  This will reduce    *
  *                      the use of CPU for non-subscription     *
  *                      activities and improve operational      *
  *                      aspects of running IIDR CDC for z/OS.   *
  *                      It will also reduce by 2 the number of  *
  *                      DB2 plans that IIDR CDC for z/OS keeps  *
  *                      open while it is executing.             *
  *                      5 - Logic is in place to determine and  *
  *                      react to the Function Level setting of  *
  *                      DB2 V12 as it changes from time to      *
  *                      time.                                   *
  ****************************************************************
  * RECOMMENDATION: APPLY CORRECTIVE SERVICE                     *
  ****************************************************************
  
  This SPE PTF implements changes to take advantage of DB2's
  improved interfaces and facilities.
  

Problem conclusion

• IIDR CDC for z/OS is more flexible and efficient in it's use of
  DB2's interfaces.
  

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:

  UI74011

Modules/Macros

•    CHCBNDPL CHCCITTC CHCDALDB CHCDALPF CHCDBXSV
  CHCDB2DL CHCDB2GN CHCDB210 CHCDB212 CHCDDLLF CHCDDRDB CHCDDTDB
  CHCDDTUT CHCDLPMD CHCDLPPF CHCDLRDB CHCDLRGP CHCDLRIQ CHCDLRPF
  CHCDLRUT CHCDLSGP CHCDSCDB CHCDSCIQ CHCDSCPF CHCDSCUT CHCDSLDB
  CHCDSLGP CHCDSLIQ CHCDSLPF CHCDSNSW CHCDSNW  CHCDTCDB CHCDTCIQ
  CHCDTCLD CHCDTCPF CHCDTRDB CHCDTRD8 CHCIFISV CHCLCCDL CHCLGPDL
  CHCMBARA CHCMBCHS CHCMBCHT CHCMBDAN CHCMBDES CHCMBDEU CHCMBELL
  CHCMBENG CHCMBENP CHCMBENU CHCMBESP CHCMBFIN CHCMBFRA CHCMBFRB
  CHCMBFRC CHCMBFRS CHCMBHEB CHCMBISL CHCMBITA CHCMBITS CHCMBJPN
  CHCMBKOR CHCMBNLB CHCMBNLD CHCMBNOR CHCMBPTB CHCMBPTG CHCMBRMS
  CHCMBRUS CHCMBSVE CHCMBTHA CHCMBTRK CHCMDMBD CHCMDMMN CHCMDPDB
  CHCMDRDL CHCMGRSW CHCMTAMN CHCOSCIQ CHCOSCPF CHCOSCUT CHCPAACM
  CHCPAADB CHCPAAIQ CHCPAAPF CHCPAASC CHCPAATG CHCPAAUT CHCSCTDB
  CHCSCTGP CHCSDTDB CHCSDTGP CHCSDTPF CHCSECDL CHCSMFRC CHCTCTDB
  CHCTEXIT CHCTRCDL CHCTTSSV HCHCA21J
  

Fix information

• Fixed component name

  INFO SRVR CDC Z

• Fixed component ID

  5655U7600

Applicable component levels

• RA21 PSY UI74011

     UP21/03/20 P F103

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.