PI65090: DYNAMIC ALIAS REMAINS IN CANCLG STATE AFTER -MODIFY DDF ALIAS(ALIASNAME) CANCEL COMMAND

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Dynamic alias reamins in CANCLG state after
  -MODIFY DDF ALIAS(aliasname) CANCEL command.
  
  
  Additional keywords and symptoms:
  ***********************************
  DB2DDF DDF MODIFY ALIAS CANCLG
  

Local fix

• A DDF recycle will remove the CANCLG state for
  the dynamic alias.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Distributed Data Facility (DDF) users.   *
  *                 Specifically those that utilize the DB2      *
  *                 dynamic location alias support.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: A CANCELed alias remains in CANCLG      *
  *                      state or a STOPped alias remains in     *
  *                      STOPG state.                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  During the processing to either cancel or stop a dynamic
  location alias, DB2 issues a Close of the TCP/IP socket for any
  inactive client connection that utilized the location alias
  in its connection to DB2.  The intent is that DB2 will be
  notified to handle the termination of the client connection.
  However, a Close of the socket did not cause DB2 to be notified
  of a connection termination.  This causes the location alias
  (being canceled or stopped) to remain in a CANCeLinG or
  STOPpinG state.  Since DB2 cannot fully terminate the client
  connections which have used the location alias, a canceled or
  stopped location alias will remain in CANCLG or STOPG state.
  

Problem conclusion

• To correctly handle the canceling or stopping of a dynamic
  location alias, DB2 has been changed to utilize the Cancel
  socket call for any inactive connection's pending TCP/IP
  asynchronous communications.  This causes DB2 to be notified by
  TCP/IP to terminate the client connection.  Once all inactive
  connections have been terminated, DB2 will then be able to
  eventually cancel or stop the dynamic location alias.
  

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:

  UI39885 UI39886

Modules/Macros

• DSNLILNR
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI39885

     UP16/08/20 P F608

• RB10 PSY UI39886

     UP16/08/20 P F608

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.