Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2004
    Posts
    64

    Unanswered: DB2 Java Codepage problem

    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

  2. #2
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276

  3. #3
    Join Date
    May 2003
    Posts
    113
    Can't open the link. I am interested in this topic, too. thx

    Quote Originally Posted by achiola

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    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
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Apr 2004
    Posts
    64

    Reply

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •