| Latest versions | fixlist |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IT04126 | Status: Closed |
FOR SQLFETCH() RGBVALUE IN CLI TRACE IS TRUNCATED WHEN USING DB2TRC -CLI OPTION | |
| product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
| Problem description: | |
rgbValue difference in classical trace vs db2trc -cli trace for
SQLFetch(). when using db2trc -cli rgbvalue is truncating in cli
traces
classical trace snippet:
SQLFetch( hStmt=1:7 )
> Time elapsed - +8.000000E-006 seconds
( iRow=1, iCol=1, fCType=SQL_C_WCHAR, rgbValue="DSYLI" -
x'4400530059004C004900', pcbValue=10, piIndicator=10 )
db2trc -cli trace snippet:
SQLFetch( hStmt=1:7 )
> Time elapsed - +6.000000E-006 seconds
( iRow=1, iCol=1, fCType=SQL_C_WCHAR, rgbValue="D" -
x'44000000000000000000', pcbValue=10, piIndicator=10 ) | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All Platforms * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 LUW v10.5 Fixpack 5 or Later. * **************************************************************** | |
| Local Fix: | |
Use classical cli trace instead of db2trc -cli | |
| Solution | |
First Fixed in DB2 LUW v10.5 Fixpack 5 | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 02.09.2014 18.05.2017 18.05.2017 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 10.5.0.5 |
|