Results 1 to 5 of 5

Thread: db2updv97

  1. #1
    Join Date
    Feb 2007
    Posts
    55

    Unanswered: db2updv97

    I'm on DB2 9.7 Fix pack 2 and looking at updating to FP 11 before upgrading to 10.5 Is there a way to tell if db2updv97 has been run on the databases?

    It kind of seems like it is a bad idea to run after FP install, unless you have thoroughly tested the applications, especially since we are going from FP 2 to 11.

  2. #2
    Join Date
    Jul 2016
    Location
    Moscow
    Posts
    294
    Provided Answers: 45
    Run this and post the result:
    select * from sysibm.sysversions

  3. #3
    Join Date
    Feb 2007
    Posts
    55
    Most of them show:

    VERSIONNUMBER VERSION_TIMESTAMP AUTHID VERSIONBUILDLEVEL

    ------------- -------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------

    9070200 2013-01-31-10.31.23.568000 DB2ADMIN s100514

    9071000 2015-04-15-11.37.04.534000 DB2ADMIN s141015



    2 record(s) selected.

  4. #4
    Join Date
    Jul 2016
    Location
    Moscow
    Posts
    294
    Provided Answers: 45
    If you were at fp11 with such an output, this would mean, that you haven't ever run db2updv97, since the highest db2 version & fixpack of the system catalog of this database is 9.7.2.
    Regards,
    Mark.

  5. #5
    Join Date
    Feb 2007
    Posts
    55
    ok, thank you.

Posting Permissions

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