PH14503: DB2ZAI IS NOT SUPPORTING SECURITYMECHANISM FOR DB2 CONNECTION

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Db2ZAI cannot connect to Db2 when Db2 zPARM
  TCPALVER=SERVER_ENCRYPT
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 AI for z/OS users (Db2ZAI) may                       *
  * be affected                                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Db2ZAI user interface and Db2ZAI                             *
  * services do not support certain                              *
  * JDBC properties, such as security                            *
  * mechanism, encryption algorithm                              *
  * options, and etc.                                            *
  *                                                              *
  * Db2ZAI has been reported to have                             *
  * high CPU consumption and                                     *
  * increased lock escalation                                    *
  * when ML is enabled.                                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  See problem description
  

Problem conclusion

• Db2ZAI user interface and data services have been updated
  to support the certain JDBC properties such as security
  mechanism and encryption algorithm options.
  
  Below are the Db2ZAI SQL Optimization stored procedures
  that have been updated to resolve the lock escalation,
  high CPU consumption, and as well as support of simple
  model for host variable.
  
  DSNML.CREATE_OFNR_SIMPLE_MODELS
  DSNML.CREATE_PARA_MODELS
  DSNML.GET_CPU_TIME_REG_MODEL
  DSNML.GET_NEXT_ELIGIBLE_HV_MODEL
  DSNML.GET_NEXT_ELIGIBLE_OFNR_MODEL
  DSNML.INSERT_UI_METRICS
  
  Db2ZAI configuration script has been updated to prompt for
  user inputs on the ports.
  
  Additional keyword:
  DB2AIV1R2/K
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

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

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

  UI65807

Modules/Macros

• COYNOD02 COYCATLG COYAKIRA COYBACK  COYNOD01
  

Fix information

• Fixed component name

  DB2 AI FOR Z/OS

• Fixed component ID

  5698CGN00

Applicable component levels

• R120 PSY UI65807

     UP19/10/30 P F910 ¢

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.