DB2 - Problem description
Problem IC69225 | Status: Closed |
SNAPSHOT TABLE FUNCTIONS AND ADMIN VIEWS MAY RETURN CHARACTER DATA IN THE WRONG CODE PAGE. | |
product: | |
DB2 FOR LUW / DB2FORLUW / 910 - 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 using snapshot functions. * **************************************************************** * PROBLEM DESCRIPTION: * * Some of the characters in the output of snapshot command are * * unreadable. * **************************************************************** * RECOMMENDATION: * * Upgrade to V9.1fp10 * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows | |
Solution | |
Problem fixed in V9.1fp10 | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC72080 IC72081 IC72082 IC75764 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 15.06.2010 22.09.2011 22.09.2011 |
Problem solved at the following versions (IBM BugInfos) | |
9.1.FP10 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.1.0.10 | |
9.1.0.11 |