Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

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 FixList
9.1.0.4 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.