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.