PH64351: DATASOURCE DESCRIPTION UPDATE TO FOLLOW THE DEFAULT DB2 JDBC SECURITYMECHANISM CHANGED IN DB2 11.5.9

APAR status

• Closed as program error.

Error description

• The datasource template of db2 includes following sentence for
  the securityMechanism property.
  
  "If no value is specified for this property, 3 is used."
  
  But the default value is changed in Db2 11.5.9. So, the
  description have to be updated to follow the change.
  
  Changed functionality in Db2 11.5.9 - IBM Documentation
  https://www.ibm.com/docs/en/db2/11.5?topic=1159-changed-functio
  nality
  ------
  New default setting for the IBM Data Server Driver for JDBC and
  SQLJ securityMechanism configuration keyword and property.
  ------
  

Local fix

• Set the value 3 to use  the clear text password security
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:  All users of IBM WebSphere Application      *
  *                  Server                                      *
  *                  using datasources.                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: Db2 JCC Driver property                 *
  *                      securityMechanism                       *
  *                      description is incorrect for version    *
  *                      4.33.31 and later.                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The description of the securityMechanism property is incorrect.
  Update the description to instruct users to check the Db2 manual
  for the default value.
  

Problem conclusion

• The securityMechanism description has been updated.
  
  The fix for this APAR is targeted for inclusion in fix pack
  8.5.5.28 and 9.0.5.23. For more information, see 'Recommended
  Updates for WebSphere Application Server':
  https://www.ibm.com/support/pages/node/715553
  

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:

Fix information

• Fixed component name

  WEBS APP SERV N

• Fixed component ID

  5724H8800

Applicable component levels