A Few Differences When Moving From 9.7 to 10.1

You may also like...

15 Responses

  1. Chaitanya says:

    Super Ember.. I came to know many new features in 10.1 with your experience by this post

  2. Andrej Furlanic says:

    When you talk about “just-upgrade-no-new-features-used” upgrade path, like yours, i would add, that I had to modify scripts that are parsing “db2audit extract” output, there is a new column inserted in the output. Truth is that db2audit is not widely used.

    • Ember Crooks says:

      Thanks for the comment. I don’t frequently use db2audit, so I wouldn’t have noticed.

      • fuzail says:

        thanks for all your efforts you share for us.

        i would like to know if there is any comparison table for different db2 versions and there added feature and functionality.

        • Ember Crooks says:

          That would be a very large table. With each new release of DB2, there are lists of features that are added, deprecated, changed, and discontinued. The latter three can be found on the What’s Changed page in the Knowledge Center, while the other can be found on the What’s New page.

          These pages are different for each version, and there is no one source for all versions. Also IBM sometimes sneaks features in an earlier version than when they officially became available.

  3. Just going through the documentation 10.1 and seen deprecation of user-defined permanent tablespace of SMS and DMS type in future releases . Both these support Catalog and Temporary tablespace types , but I wonder why the DMS is still been given support when the SMS can handle this catalog and temporary tablespaces types flawlessly ? . Thanks for letting me know DMS being deprecated , I just came to know after I read this post which led me to documentation

    • Ember Crooks says:

      They’re giving us time to move off of them and get used to AST and storage groups – which I have a guest blogger writing about later this week.

  4. Chaitanya says:

    Hi.. Ember, I installed fixpack 10.1.3 and tried to run db2updv10 to upgrade db’s after running db2iupdate on the instance “db2inst1”, this is the error I received. , unable to upgrade..

    [db2inst1@localhost ~]$ db2level
    DB21085I This instance or install (instance name, where applicable:
    “db2inst1”) uses “32” bits and DB2 code release “SQL10013” with level
    identifier “0204010E”.
    Informational tokens are “DB2 v10.1.0.3”, “s130918”, “IP23515”, and Fix Pack
    Product is installed at “/opt/ibm/db2/V10.1”.
    [db2inst1@localhost bin]$ ./db2updv10 -d TEST -O


    _____ DB2 Service Tools _____

    I B M


    This tool is a service utility designed to update a DB2 Version 10.1
    database to the current fix pack level.


    DB2 Universal Database Version 10.1, 5622-044 (c) Copyright IBM Corp. 2011
    Licensed Material – Program Property of IBM
    IBM DATABASE 2 Database update to current fix pack tool

    MESSAGE: SYSCAT.ROUTINEAUTH had 0 rows successfully updated.
    MESSAGE: SYSCAT.MODULEAUTH had 0 rows successfully updated.
    MESSAGE: Rolling back work due to sqlcode: -204 on line 833.
    db2updv10 processing failed for database ‘TEST’.

    I tried googling it, but could not find , please adivse…….

    thanks chaitanya

  5. Kay says:

    Chaitanya, I have the same issue while running db2updv10,
    Did you get any response from the PMR

    • Rich says:


      Run the upgrade database command to get the database to version 10.1 – db2updv10 command would be used to upgrade an already version 10.1 database to the latest fix pack.

  6. Mark says:

    I have heard that the page headers have changed in 10.1. Does that mean that the upgrade process must modify each existing page? I have a big concern about that based on the size of my database and the amount of time it might take, since I have only a short window to do the upgrade. Do you have any info on that?

    • Ember Crooks says:

      Which page headers are you asking about? Data page headers? I want to be clear so I can ask some others and get a clear answer for you.

      I know that the pages in tablespaces are different between regular and large tablespaces to allow larger tables, but that’s not a change that occurs automatically – you have to move the data yourself.

  1. February 27, 2014

    […] have gone through Ember’s recent post A Few Differences When Moving From 9.7 to 10.1 where I came across storage groups – a new way of handling physical data .I just thought of […]

Leave a Reply

Your email address will not be published. Required fields are marked *