Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2008

    Question Unanswered: territory & code set

    m using db2 v8.1 ESE on windows.
    I wanted to know what role 'territory and code set ' plays while creating database in db2.
    m learning a rational tool named 'clearquest' which says u need to select a different code set and territory and not the default one which get selected when you create a database. where the difference actually occur while selecting this.

  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    this is related to the charsets for character data saved in database, so if clients come in, they have to know how to translate data from one codepage to another. this is flaaged in sysibm.syscolums with ccsid
    you can specify any code when creating a db and I believe current versions use utf, before it was the territory us..
    see some admin guides for detail
    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