Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2012

    Unanswered: create database collate system V10.5


    I created a database V10.5 under LINUX 11.3 setting collate to "SYSTEM" with the following script:

    create database <DBNAME>
    automatic storage yes
    on /db2/<DB2INSTANCE>/data/<DBNAME>/data dbpath on /db2/<DB2INSTANCE>/data/<DBNAME>/metalog
    using codeset ISO885915
    territory de_DE
    collate using system
    pagesize 16384
    dft_extent_sz 4;

    It worked fine but as I check the configuration of the database (db2 get db cfg) it shows

    Database collating sequence = UNIQUE
    Alternate collating sequence (ALT_COLLATE) =

    I would like to understand why, and which is the difference between both SYSTEM abd UNIQUE

    Thanks a lot in advance
    Best regards

  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    according the doc : SYSTEM
    This is the default parameter when creating a database. For non-Unicode databases, the collating sequence is based on the database territory.
    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-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

  3. #3
    Join Date
    Aug 2012
    Thanks Guy
    it's very helpful

Posting Permissions

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