[DB2EUG] Websphere 5.0.2 and DB2 OS/390 via DB2 Connect

[GROUPIT - Jenny Kuan Kong Lang]

Hi,   Websphere 5.0.2 and DB2 Connect Gateway on AIX 5L Database: OS/390 V5.2 (no local database access)   Encountered following error when attempting to access Host DB2 via WebSphere using WSAdmin Console (TestConnection).  DB2 Connect V8.1 resides on the same machine as WebSphere.  There is no local database, only remote databases residing on the host.  "Test Connection failed for datasource dbt on server server1 at node  masaix08 with the following exception: COM.ibm.db2.jdbc.DB2Exception:  [IBM][CLI Driver] SQL0332N There is no available conversion for the source  code page "1208" to the target code page "UNKNOWN". Reason Code "1".  SQLSTATE=57017 . " The codepage CCSID on Host DB2 is 37; I tried using DB2SET DB2CODEPAGE=850 for WAS.  It also failed.      Help appreciated as I keep hitting blank walls.   rgds Jenny Kuan