|
Problem IC61864
|
Status: Closed |
CLI0002W WARNING WHEN EXECUTING A CLI APPLICATION TO QUERY AN OD BC NICKNAME WHO'S DATASOURCE IS USING A NON UNICODE CODEPAGE. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
A CLI/ODBC application may receive a CLI0002W warning "Data
Truncated", when executing a query that uses a federated
nickname using an ODBC Wrapper.
.
The warning is unexpected and would occur if the federated
server's codepage is 1208 (ie, Unicode), and the Information
Integrator Classic Federation (IIFC) server's codepage is not
1208. For example, this would happen if the IIFC server is
using DataCom on z/OS who has a codepage of 850, not 1208. |
| Problem Summary: |
Users Affected: DB2 CLI applications using ODBC Relational
Wrapper.
Problem Description:
A CLI/ODBC application may receive a CLI0002W warning "Data
Truncated", when executing a query that uses a federated
nickname using an ODBC Wrapper. |
| Local Fix: |
Modify the db2cli.ini file by using one of the following
keywords:
.
1) IGNOREWARNLIST="'01004'"
.
2) IGNOREWARNINGS=1 |
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 UDB Version 9.7, Fixpak 1 |
| Workaround |
see LOCAL FIX |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 06.07.2009
22.12.2009
22.12.2009 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
