Results 1 to 8 of 8
  1. #1
    Join Date
    Nov 2005
    Posts
    5

    Unanswered: Peoplesoft Unicode sql0332N

    I have a problem with a three tier environment with PS. we made the change
    to the db2cli.ini disableunicode=1 file on the client end and on the mid tier server and we are still failing with
    PSAPPSRV.100630 [10/21/05 15:26:43](1) GenMessageBox(200, 0, M): SQL Access Manager: SQL error. Stmt #: 2 Error Position: 0 Return: 8600 - [IBM][CLI Driver] SQL0332N There is no available conversion for the source code page "819" to the target code page "UNKNOWN". Reason Code "1". SQLSTATE=57017 (SQLSTATE 57017) -332 PSAPPSRV.100630 [10/21/05 15:26:43](1) GenMessageBox(0, 0, M)
    This issue was resolved at the two tier level by adding disableunicode=1
    but does not seems to work for the three tier.

    Has any one experienced this situation?

  2. #2
    Join Date
    Nov 2005
    Location
    Toronto
    Posts
    65
    db2set DB2CODEPAGE=819
    remove the DISABLEUNICODE
    Last edited by wangzhonnew; 11-15-05 at 11:14.

  3. #3
    Join Date
    Nov 2005
    Posts
    5

    no-go

    Hi Wangzhonnew, I tried your sugestion and it still does not work for us.
    I'm not sure how to display the code page setting under connect to verify
    what we actually have the setting. Thanks for suggestion and will listen to any other advice.

  4. #4
    Join Date
    Nov 2005
    Location
    Toronto
    Posts
    65
    do you have any error message in db2diag.log like:
    2005-07-01-11.57.12.688620+120 I493947C446 LEVEL: Warning
    PID : 311382 TID : 1 PROC : db2agent
    (TESTISO) 0
    INSTANCE: tbrinst NODE : 000 DB : TESTISO
    APPHDL : 0-214 APPID: *LOCAL.tbrinst.050701095716
    FUNCTION: DB2 UDB, base sys utilities, sqleSetupCodePageInfo, probe:200
    MESSAGE : Conversion table not available. Source code page = 819, Target
    code page = 912

    if it's zOS is there anything like:
    DSNT552I -DB8G DSNLTACC CHARACTER CONVERSION 049
    FROM CCSID 819 TO CCSID 1208
    FAILED WITH ERROR CODE 24
    Last edited by wangzhonnew; 11-15-05 at 14:13.

  5. #5
    Join Date
    Nov 2005
    Posts
    5

    additional info

    We have performed a trace and it seems the conversion table causing problems is 1200, the trace at the unix mid tier level shows.
    ( DBMS NAME="DB2", Version="07.01.0002", Fixpack="0x32030105" )
    ( Application Codepage=819, Database Codepage=1047, Char Send/Recv Codepage=819, Graphic Send/Recv Codepage=1200 )

    the error is

    GenMessageBox(200, 0, M): /local_home/build81/pt82106a-retail/src/pssys/stmget.cpp: SQL error. Stmt #: 2546 Error Position: 0 Return: 8601 - [IBM][CLI Driver][DB2] SQL0332N There is no available conversion for the source code page "1047" to the target code page "1200". Reason Code "".
    (SQLSTATE ) -332
    PSAPPSRV.856126 [11/14/05 11:21:43](1) GenMessageBox(200, 0, M): SQL Access Manager: SELECT OWNERID FROM PS.PSDBOWNER WHERE DBNAME = :1
    PSAPPSRV.856126 [11/14/05 11:21:43](1) GenMessageBox(0, 0, M): Database Signon: Could not sign on to database PS80DEV with user APPSRVID.

    Not sure why the 1200 is coming into play because its for graphics and for our select there is no graphics involved.

  6. #6
    Join Date
    Nov 2005
    Location
    Toronto
    Posts
    65
    I'm not familiar with this problem, here is a link about DB2 Universal Database character conversion. Hope it helps
    http://www-128.ibm.com/developerwork.../dm-0506chong/

  7. #7
    Join Date
    Nov 2005
    Posts
    5

    thx

    This is a very good link, thank you. We have ibm and PS looking at this issue togetther. I'll let you know the real issue and solution when found.

  8. #8
    Join Date
    Nov 2005
    Posts
    5

    Resolution

    We have a resolution to this issue. The codepage table sent for UDB connect Version 8.1 on the AIX server did not support codepage 1047 to 1200 translation.
    IBM sent a new table with the support for this combination to install and this resolved our problem.

    Thnx for Your effort
    Randy

Posting Permissions

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