IT29206: SQLSETCONNECTATTRW() WITH SQL_ATTR_SESSION_GLOBAL_VAR ATTRIBUTEIS NOT WORKING AS EXPECTED

APAR status

• Closed as program error.

Error description

• When application has SQLSetConnectAttrW() API call with
  SQL_ATTR_SESSION_GLOBAL_VAR  attribute, it is working as
  designed.  Client is not sending the attribute list to server
  and resulting in unexpected error.
  
    memcpy(membuf, "SQL_COMPAT='NPS'", 17);
    membuf[17] = '\0';
  
    toWideChar(membuf, szAttribBuf);
    sql_rc = SQLSetConnectAttrW(hdbc, SQL_ATTR_SESSION_GLOBAL_VAR,
  szAttribBuf, SQL_NTS);
  
  When application calls like this, client is not sending the
  SQL_COMPAT='NPS' to server.
  
  In DRDA trace we see empty set statement flowing to server:
  DDM Format: d0 SEND(AR) OBJDSS - Object Data Stream Structure
  LL: 23 CORR: 0003 CHAINED: y CONT ON ERR: n SAME CORR FOR NEXT
  DSS: n
  
  NM: SQLSTT - SQL Statement
  LL: 17 CP: 2414
  DATA: (ASCII) (EBCDIC)
  0000000007534554 20203D20FF .....SET = . .............
  
  DDM Format: d0 SEND(AR) RQSDSS - Request Data Stream Structure
  LL: 78 CORR: 0004 CHAINED: y CONT ON ERR: n SAME CORR FOR NEXT
  DSS: y
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * DB2 CLI/ODBC Unicode API users                               *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to DB2 version 11.1.4.5                              *
  ****************************************************************
  

Problem conclusion

• With DB2 v11.1.4.5 we will see SQLSetConnectAttrW() with
  SQL_ATTR_SESSION_GLOBAL_VAR  working correctly.
  

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

  DB2 CONNECT

• Fixed component ID

  DB2CONNCT

Applicable component levels

• RB10 PSY

     UP