DB2 FOR LUW / DB2FORLUW / 970 - DB2

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.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Customers on DB2 V9.7                                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Snapshot and admin views output is not seen in correct code  * 
* page.                                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to latest fixpack of DB2 V9.7                        * 
****************************************************************

Fixed in V9.7fp3

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

21.10.2010
11.04.2011
11.04.2011

9.7.,
9.7.FP3