PH04335: IF AN EXTERNAL REFRESH IS SCHEDULED WHILE THE CONNECTION TO DB2 ENDS AND IS RESTARTED, RESTARTING SUBSCRIPTION MAY HANG.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• If an external refresh is being scheduled using the
  DMMD_SIGNALS meta-data table, and the connection to DB2 ends
  and is reestablished, then when the subscription restarts it
  will attempt to perform any refreshes that are indicated in the
  meta-data.  For an external refresh, which doesn't start until
  the external action is taken, the subscription will continue to
  attempt to initiate the refresh, causing a stream of
  initialization messages to be sent to the target.  In this
  state, the subscription will not end, and shutdown of the
  address space will be inhibited.
  

Local fix

• Clear the DMMD_SIGNALS table and change the table Method:State
  to Mirror:Active or Mirror:Idle.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IIDR CDC for z/OS who employ the    *
  *                 Continuous Operation feature to administer   *
  *                 subscriptions.                               *
  ****************************************************************
  * PROBLEM DESCRIPTION: If a subscription table is being set to *
  *                      refresh using the Continuous Operation  *
  *                      capability, and the connection to DB2   *
  *                      is broken before the refresh can start, *
  *                      then when the subscription is restarted *
  *                      it will continually send initialization *
  *                      messages to the target.  It will not    *
  *                      progress to either refreshing the table *
  *                      or mirroring any tables.  When directed *
  *                      to end, the subscription will not end.  *
  *                      This can impede the shut down of the    *
  *                      address space.                          *
  ****************************************************************
  * RECOMMENDATION: APPLY CORRECTIVE SERVICE                     *
  ****************************************************************
  
  Using Continuous Operation to refresh a table as the connection
  to DB2 is broken can cause the subscription to be unresponsive
  and impede the ability to shut down the address space.
  

Problem conclusion

• A restarted subscription will detect an interrupted Continuous
  Operation activity that did not complete prior to the interrupt
  and take action accordingly to permit the restart to succeed.
  

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:

  UI59301

Modules/Macros

•    CHCDLSGP CHCSDTPF
  

Fix information

• Fixed component name

  INFO SRVR CDC Z

• Fixed component ID

  5655U7600

Applicable component levels

• RA21 PSY UI59301

     UP18/11/07 P F811

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.