|
Problem IC52940
|
Status: Closed |
UNICODE CLI APPLICATION CAN FAIL WITH CLI0119E WHEN CALLING SQLCOLATTRIBUTESW |
| product: |
DB2 EVERYPLACE / 5724D0400 / 910 - DB2 |
| Problem description: |
An Unicode application calling SQLColAttributesW can fail with
"CLI0119E Unexpected system failure":
----------------------------------------------------------------
SQLColAttributesW( hStmt=1:1, iCol=1,
fDescType=SQL_DESC_TYPE_NAME, rgbDesc=&01e11920, cbDescMax=204,
pcbDesc=&0012c0c8, pfDesc=<NULL pointer> )
---> Time elapsed - +3.681800E-002 seconds
SQLColAttributesW( )
<--- SQL_ERROR Time elapsed - +1.295000E-003 seconds
SQLGetDiagRecW( fHandleType=SQL_HANDLE_STMT, hHandle=1:1,
iRecNumber=1, pszSqlState=&00129efc, pfNativeError=&00129f40,
pszErrorMsg=&01e12b98, cbErrorMsgMax=2000, pcbErrorMsg=&00129ee8
)
---> Time elapsed - +1.770000E-004 seconds
( iRowNumber=-2, iColumnNumber=-2 )
SQLGetDiagRecW( pszSqlState="58004", pfNativeError=-99999,
pszErrorMsg="[IBM][CLI Driver] CLI0119E Unexpected system
failure. SQLSTATE=58004 {SQLColAttribute}", pcbErrorMsg=87 )
<--- SQL_SUCCESS Time elapsed - +2.416000E-003 seconds
----------------------------------------------------------------
The problem was introduced in FP8. |
| Problem Summary: |
An Unicode application calling SQLColAttributesW can fail with
"CLI0119E Unexpected system failure":
----------------------------------------------------------------
SQLColAttributesW( hStmt=1:1, iCol=1,
fDescType=SQL_DESC_TYPE_NAME, rgbDesc=&01e11920, cbDescMax=204,
pcbDesc=&0012c0c8, pfDesc=<NULL pointer> )
---> Time elapsed - +3.681800E-002 seconds
SQLColAttributesW( )
<--- SQL_ERROR Time elapsed - +1.295000E-003 seconds
SQLGetDiagRecW( fHandleType=SQL_HANDLE_STMT, hHandle=1:1,
iRecNumber=1, pszSqlState=&00129efc, pfNativeError=&00129f40,
pszErrorMsg=&01e12b98, cbErrorMsgMax=2000, pcbErrorMsg=&00129ee8
)
---> Time elapsed - +1.770000E-004 seconds
( iRowNumber=-2, iColumnNumber=-2 )
SQLGetDiagRecW( pszSqlState="58004", pfNativeError=-99999,
pszErrorMsg="[IBM][CLI Driver] CLI0119E Unexpected system
failure. SQLSTATE=58004 {SQLColAttribute}", pcbErrorMsg=87 )
<--- SQL_SUCCESS Time elapsed - +2.416000E-003 seconds
----------------------------------------------------------------
The problem was introduced in FP8. |
| Local Fix: |
Change the CLI application to call SQLColAttributeW (ODBC 3 API)
instead of SQLColAttributesW (ODBC 2 API). |
| available fix packs: |
DB2 Version 9.1 Fix Pack 4a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 4 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 5 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
|
| Solution |
Change the CLI application to call SQLColAttributeW (ODBC 3 API)
instead of SQLColAttributesW (ODBC 2 API). |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC54504 JR28398
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 14.06.2007
14.11.2007
14.11.2007 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.4
|
 |
| 9.1.0.4
|
|
