|
Problem IC72080
|
Status: Closed |
SNAPSHOT TABLE FUNCTIONS AND ADMIN VIEWS MAY RETURN CHARACTER DATA IN THE WRONG CODE PAGE. |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
Snapshot table functions and admin views perform a database
snapshot to retrieve the data requested.
The snapshot processing establishes an instance attachment to
the database and the code page associated
with the instance attachment is determined from the system code
page (i.e. the environment in which
db2 is started). Snapshot processing converts character data
from the database code page to the
code page of the snapshot requester if the code pages are
different. This means the character data
returned from a snapshot table function or admin view will be in
the system code page rather than
the database code page. The character data may become corrupted
on the client side when it is
converted from database code page to client code page. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users on V9.1 and doing data code page conversion. *
****************************************************************
* PROBLEM DESCRIPTION: *
* Corrupted or wrong data seen on db2 client side due to wrong *
* code page conversion by snapshot tables and admin views. *
****************************************************************
* RECOMMENDATION: *
* Customer should upgrade to product DB2 V9.5FP8 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Problem first fixed in DB2 V9.5fp8 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 21.10.2010
03.07.2011
03.07.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.8
|
 |
