DB2 - Problem description
Problem IC83395 | Status: Closed |
[IBM][DB2.NET] SQL0902 AN UNEXPECTED EXCEPTION HAS OCCURRED IN PROCESS. CLI DRIVER CRASHES IN CLI_CSIPOSTCONNECT | |
product: | |
DB2 CONNECT / DB2CONNCT / 970 - DB2 | |
Problem description: | |
.NET application gives below error message: Message : [IBM][DB2.NET] SQL0902 An unexpected exception has occurred in Process: 7240 Thread 42 AppDomain: Name:Orcas.exe There are no context policies. Function: SQLConnect CLI Driver throws memory could not read error. This error has found on Windows, but may occur on any other platform. On windows, CLI Driver may crash with below stack: db2app.dll!CLI_csiPostConnect(CLI_CONNECTINFO * pDbcInfo=0x03850060) Line 567 + 0x15 bytes C++ db2app.dll!CLI_sqlConnect(CLI_CONNECTINFO * pDbcInfo=0x03850060, sqlca * pSqlca=0x03850ab4, CLI_ERRORHEADERINFO * pErrHeader=0x0385010c) Line 2415 + 0xc bytes C++ db2app.dll!SQLConnect2(CLI_CONNECTINFO * pDbcInfo=0x03850060, unsigned char * szDSN=0x0385dd70, short cbDSNIn=8, unsigned char * szUID=0x0385da2e, short cbUIDIn=8, unsigned char * szAuthStr=0x0385da3b, short cbAuthStrIn=8, unsigned char * szNewPwd=0x00000000, short cbNewPwdIn=0, unsigned char fReadSysOwner='R') Line 6110 + 0x26 bytes C++ This error happens because of some fixed number of Keywords in the connection string passed to SQLDriverConnect2 from all sources. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All CLI Driver user. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to db2_v97fp7 or heigher releases. * **************************************************************** | |
Local Fix: | |
Add or remove a valid keyword to/from any of connection string, db2dsdriver.cfg or db2cli.ini file. The number of keywords passed in connection string to SQLDriverConnect2 from all sources should get changed from its current count to avoid this issue. | |
available fix packs: | |
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows | |
Solution | |
v97fp7 and heigher releases contains this fix. After the fix, user fill not face this issue. | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC83940 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 12.05.2012 24.10.2012 24.10.2012 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP7 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.7 |