IZ13815: SAP: ENABLE SQLSETCONNECTATTR TO SUPPORT RETRYONERROR AND ALLOW SOME CLI KEYWORDS WHEN SQLPUTDATA IS IN PROGRESS .

DB2 Version 9.5 Fix Pack 3b for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 1  for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 2a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 2  for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4  for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

APAR status

• Closed as new function.

Error description

• a. RetryOnError is a CLI keyword which currently could be set
  using a connection string or by setting it in the db2cli.ini
  file. SAP wants it to be set using the CLI API
  SQLSetConnectAttr also. The code changes are minimal in
  nature, as already most of the CLI keywords are supported
  using SQLSetConnectAttr.
  b. Currently when SQLPutData is in progress, it disallows
  setting any CLI keywords using SQLSetConnectAttr. SAP wants to
  set SQL_ATTR_INFO_PROGRAMID, SQL_ATTR_INFO_APPLNAME,
  SQL_ATTR_INFO_WRKSTNNAME  and SQL_ATTR_INFO_USERID when
  SQLPutData is in progress.
  

Local fix

Problem summary

• see problem description
  

Problem conclusion

• First fixed in DB2 UDB Version 9.5, FixPak 1
  

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 CEE AIX

• Fixed component ID

  5765F3000

Applicable component levels

• R910 PSY

     UP

• R950 PSY

     UP