Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009

    Unanswered: DB2 UNICODE support

    I am running a DB2 v9 UTF-8 server supporting Unicode on Windows XP SP2 and I am trying to "reorganize" and "update statistics" for a table having Unicode name.
    The DB2 client that I have crashes in "javaw.exe", when I run a statement such as "REORG TABLE SCHEMA."вфы" " or " RUNSTATS ON TABLE SCHEMA."вфы" ON ALL COLUMNS WITH DISTRIBUTION ON ALL COLUMNS AND INDEXES ALL ALLOW WRITE ACCESS;" (update statistics)
    Shouldn't this be supported? Everything else works fine for tables...
    Can anyone run the same statements on their servers?
    Also I run the same statement in another DB management tool (DBArtisan), and it says "DBMS UTF8 -- SQL2211N The specified table does not exist."
    Anyone has any idea what happens, or a relevant link to Unicode support?

  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    is the windows enabled for this language
    to accept correct data, the windows client has to be defined for this supprting language; there is some article in developerswork that show a sample of japanese data handling
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

Posting Permissions

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