Hi,


DB2 Server is DB2 7.1 in OS/390
Java development is on Win 2000
Connecting with DB2 Connect.


We recently moved our database from one mainframe to another. Source system CCSID was 500. The CCSID in new mainframe DB2 is 1146. After the movement, the java development people are unable to connect to new DB2 system using JDBC. Following is the error they get.

Error:
------
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL0332N There is no available conversion for the source code page "1146" to the target code page "1208". Reason Code "1". SQLSTATE=57017

But they can connect to the old system.

We tried following :
-------------------
1. We tried changing the db2cli.ini file and added
DisableUnicode =1

Still got the error.

2. So added

DisableUnicode =1
ConnectCodepage=1146

Error is same.

Does anyone know what could be the problem?

Thanks,
xamar

read this:
http://www.developer.ibm.com/tech/fa...al?oid=2:77935

Can't open the link. I am interested in this topic, too. thx

The contents of the link
I am getting an SQL0332N error when I connect to a zSeries Unicode database. Can I connect to such a database?

A: Yes, the connection is possible. Specify the following in the db2cli.ini file under the sqllib directory:
[Common]
DisableUnicode=1

Thanks achiola and others!

We didn't have the [Common] in there. It works after we added that.

Most of the places I looked around did talk about DisableUnicode(which we tried) but not this "Common" thing.

So thanks again.
xamar.