Solving code-page problems when accessing Performance Warehouse

For some installations, you might receive SQL0332 errors when accessing Performance Warehouse.

To solve this problem, set DB2CODEPAGE to a value that is compatible with the host SCCSID. In addition, the SYSIBM.SYSSTRINGS table must contain a row that maps the two values in the INCCSID OUTCCSID columns. For more information about DB2CODEPAGE values, see the section National Language Support Considerations in one of the Db2 Connect™ Quick Beginnings books.

If you still cannot connect to Performance Warehouse, you might see the following message: SQL0332N - There is no available conversion for the source code page 1208 UNKNOWN 3 to the target code page. Reason Code. SQLSTATE=57017.

To solve this problem, add DISABLEUNICODE=1 in the file sqllib\db2cli.ini for the Db2® subsystem, where sqllib is the default Db2 Connect installation directory. See also the technical notes (Technotes) #1008683 and #1008573.

If DISABLEUNICODE does not work, you might get the following message: SQL0332N There is no available conversion for the source code page 01208 to the target code page 00437. Reason code DSNXRIVB. SQLSTATE=57017.

To solve this problem, UNICODE support on z/OS® must be enabled correctly including Enforced Subset and Round Trip method in the conversion image. For more information, see APAR PQ40270 and PMR #68853.