Results 1 to 3 of 3
  1. #1
    Join Date
    May 2005
    Location
    Bangalore, India
    Posts
    35

    Unanswered: Question regarding 2 versions of DB2 on the same box

    Hi All,

    We have 2 versions of Db2 running on the same box. Db2 v7.1 and db2v8.2

    Now I need to drop databases and instances from the DB2 v7.1.

    Unfortunately the name of databases and instances are same in both the versions.

    The user that I use to connect to DB2, by default connect to the DB2 V8.2 as the db2profile it uses that has DB2 v8.2 location as DB2DIR.

    1) How I can I be sure that I drop the right database and instance.

    2) One more thing. When we use db2imigr to migrate the instance does the instance in old db2 version ceases to exist or it MOVES from old to new version.

    We are on AIX 4.3

    Regards,
    Divakar

  2. #2
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    When issuing the "db2 connect to ..." command, this returns a line of the form
    Code:
     Database server        = DB2/6000 7.1.9
    or something like that.
    So first parse this output before proceeding with a subsequent "db2 drop database ..."

    (I'm assuming that your "db2 ..." commands are put in a script.)
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

  3. #3
    Join Date
    Jun 2006
    Posts
    471

    level

    db2level in the instance where the db should be dropped would indicate also the version
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

Posting Permissions

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