PH58161: NEW FUNCTION FOR DB2 FOR Z/OS

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• e24538
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Db2 13 for z/OS users.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: Event notification 80 (ENF80)           *
  *                      listener support                        *
  ****************************************************************
  When IPV4 or IPV6 IP addresses are specified for Db2 in the
  BSDS, Db2 issues a TCP/IP dynamic VIPA (virtual IP address)
  operation to create its member or subsystem IP address.
  However, when TCP/IP can manually or operationally leave the
  sysplex, all dynamic VIPA facilities are terminated, including
  the Db2 IP address. To be aware of such an event, Db2 creates
  a no-depth, ephemeral socket value, listen port bound to its
  IP address. When TCP/IP leaves the sysplex, an error is then
  driven against this listen port, such that Db2 terminates
  its TCP/IP listener and then periodically checks for the
  capability to create its IP address so that its TCP/IP
  listener can be restarted. However, the presence of the
  ephemeral socket value, no-depth listen port has caused some
  customers who run periodic socket probes to have issues
  with the presence of this listen port.
  

Problem conclusion

Temporary fix

Comments

• Db2 is changed to utilize the ENF80 event notification
  facility capability, that is available with z/OS
  Communications Server to provide interested parties with
  knowledge that TCP/IP leaves and joins the sysplex. Db2
  will use this ENF80 capability so that it does not have to
  create an ephemeral socket value, no-depth listen port to
  monitor the status of the TCP/IP connection in the sysplex.
  
  When DDF is started and its IPV4 or IPV6 IP address has
  been specified in the BSDS, Db2 will register its interest
  in ENF80 signals, which indicate that TCP/IP is leaving or
  joining the sysplex.
  
  If the registration fails, Db2 will issue the new message
  DSNL525I specifying the return code from the ENF80
  registration attempt, and then continue with its creation
  of an ephemeral socket value, no-depth listen port bound to
  its IP address. The registration failure should be reported
  for investigation by IBM Support.
  
  When the registration succeeds, the TCP/IP listener
  completes its setup, which includes the creation of its
  IP address. When the ENF80 listen is driven due to TCP/IP
  leaving the sysplex, the Db2 TCP/IP listener will take the
  following actions:
  - issue new message DSNL524I, specifying that its IP
    address has become UNAVAILABLE
  - remove the member from WLM sysplex routing services,
    when the subsystem is a member of a data sharing group
  - continue polling its various listen ports
  When the ENF80 listen is driven due to TCP/IP joining the
  sysplex, the Db2 TCP/IP listener will take the following
  actions:
  - create its IP address via TCP/IP dynamic VIPA capabilities
  - register the member with WLM sysplex routing services,
    when the subsystem is a member of a data sharing group
  - issue new message DSNL524I, specifying its IP address has
    become AVAILABLE
  - and continue polling its various listen ports
  
  While TCP/IP remains not joined to the sysplex, the Db2
  -DISPLAY DDF command will display that its IP address is
  -UNAVAILABLE via message DSNL085I, and if a member of a
  data sharing group, that its member IP address is
  -UNAVAILABLE via message DSNL089I.
  
  The online product documentation for Db2 13 is updated
  for the new function in this APAR, and can be consulted to
  understand the full details of the changes by searching on
  "PH58161" or the following  keywords:
  - DSNL524I
  - DSNL525I
  - DSNL085I
  - DSNL089I
  

APAR Information

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

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

  UI97426

Modules/Macros

• DSNFCDIR DSNFLDIR DSNLIGLM DSNLIIN1 DSNLIIN2 DSNLILNR DSNLISKM
  DSNLTDDF
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RD10 PSY UI97426

     UP24/07/02 I 1000  

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.