PM41836: DB2 OUTBOUND CONNECTION UNSUCCESSFUL. SQLCODE -904 WITH REASON 00D31030 IS RETURNED.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2DDF defect pm41836 dpm41836
  After applying PTFs UK68317 or UK68318 or UK68319 (APAR PM34683)
  a DB2 outbound connection may fail if the CDB SYSIBM.LUNAMES or
  SYSIBM.IPNAMES SECURITY_OUT column value 'A'/'R' and USERNAMES
  column value is 'O' (outbound ID translation option).
  SQLCODE -904 with reason 00D31030 resource type of 00000A00
  , AND RESOURCE NAME *.SYSIBM.USERNAMES(PASSWORD) is returned
  (incorrectly).
  **************************************
  Additional symptoms and keywords:
   SQLCODE904N SQL904N sql904n srcn904 RC00D31030 00D31030
   RESOURCE TYPE 00000A00 RESOURCE TYPE
   *.SYSIBM.USERNAMES(PASSWORD)
  

Local fix

• Verify SYSIBM.USERNAMES PASSWORD column to ensure it has a
  minimum of 1 blank ('40'X) character.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Distributed Data Facility (DDF) users.   *
  *                 Specifically where a DB2 for z/OS system is  *
  *                 configured to access remote servers.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: After applying APAR PM34683, PTFs       *
  *                      UK68317/UK68318/UK68319, attempts to    *
  *                      access a remote server may fail due     *
  *                      to SQLCODE -904 unavailable resource    *
  *                      message condition with reason           *
  *                      '00D31030'X and resource type           *
  *                      '00000A00'X indicating                  *
  *                      SYSIBM.USERNAMES(PASSWORD) column is in *
  *                      error.                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  After applying APAR PM34683, PTFs UK68317/UK68318/UK68319,
  attempts to a remote server may fail due to SQLCODE -904
  unavailable resource message with reason code '00D31030'X and
  resource type '00000A00'X indicating SYSIBM.USERNAMES(PASSWORD)
  column is in error.
  This problem may occur when DB2 creates an outbound connection
  to a remote server that contains an authorization ID and no
  password. The Communications Database (CDB) is populated with
  a row in either the SYSIBM.LUNAMES or SYSIBM.IPNAMES where the
  SECURITY_OUT column value specifies 'A' (default value), 'R',
  or 'D'. Further, if outbound translation is also desired, the
  USERNAMES column value would specify 'O' and a row in
  SYSIBM.USERNAMES table would specify the outbound ID for
  translation. Since a password is not required for the outbound
  connection, the SYSIBM.USERNAMES PASSWORD column value is not
  required to contain a value. However, DB2, with APAR PM36483
  applied, detected the zero length PASSWORD column value and
  incorrectly interpreted this as an error.
  

Problem conclusion

• DB2 has been changed to tolerate an undefined (zero length)
  SYSIBM.USERNAMES PASSWORD column value for outbound connections
  that do not require a password.
  

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:

  UK69496 UK69497 UK69498

Modules/Macros

• DSNLVXID
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK69496

     UP11/08/03 P F108

• R810 PSY UK69497

     UP11/08/03 P F108

• R910 PSY UK69498

     UP11/08/03 P F108

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.