Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2010

    Unanswered: DB2 v8 to v9.5 migration_Identity collation

    Hi Friends,
    I am new to DB2. I am currently working on a migration project where we are migrating our databases to V9.5 from V8.2. While doing an impact analysis, I read that in V9.5, catalogs collate using IDENTITY sequence in Unicode database.

    For this what am I supposed to check. How can I find out if there will be an impact due to this after migration. Please help.

  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    the message is not clear at all - be as complete as possible, we don't see your screen..
    how about looking at the doc
    Identity column load considerations
    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
    Dec 2008
    Toronto, Canada
    If you create a new database in new DB2 version it will be unicode by default and probably with different collating sequence than in your original database. If you restore your database in new DB2 version, db cfg should be picked up from backup.

    If you don't want an impact just use same db cfg as in your original database. Restoring your database from backup file in new version should do the trick.

    If you want to learn more abt collating sequence, it's here:


    IBM DB2 9.5 Information Center for Linux, UNIX, and Windows
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

Posting Permissions

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