Results 1 to 8 of 8
  1. #1
    Join Date
    May 2012
    Posts
    9

    Unanswered: How to catalog local database

    Hi All
    My DB2 instance have 3 db in it on WINDOWS. I updated my Db2 without taking backup of dbs, my huge mistake. Now node and db directory is not there.
    So I created a local node and catalog the all 3 db on it. But still not able to connect with dbs.

    Please help

    Thanks
    Victim

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by victim View Post
    So I created a local node and catalog the all 3 db on it.
    That was not necessary. Try instead "CATALOG DB whatever ON C:", assuming your databases are on the drive C:.

  3. #3
    Join Date
    Jul 2004
    Posts
    306
    Quote Originally Posted by victim View Post
    Hi All
    My DB2 instance have 3 db in it on WINDOWS. I updated my Db2 without taking backup of dbs, my huge mistake. Now node and db directory is not there.
    So I created a local node and catalog the all 3 db on it. But still not able to connect with dbs.

    Please help

    Thanks
    Victim
    What db2 versions did you upgrade from and to?
    Did you perform all the upgrade steps including migrating the instance and dbs?

  4. #4
    Join Date
    Mar 2012
    Location
    Canberra, Australia
    Posts
    38
    good idea to use db2cfexp before doing any fixpacks or upgrades. If you have to destroy an instance as part of a failed fixpack recovery then you need to have the detail

  5. #5
    Join Date
    May 2012
    Posts
    9
    Guys,
    For my knowledge anyone share the steps what is in what order when we are migrating /updating the db2

    thx

  6. #6
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    On Windows only, if you indicate that you are updating an existing version of DB2, it will update the instances and databases automatically during the install. If you indicate that you are installing a new version, then the databases are probably still attached to the old version/instance.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  7. #7
    Join Date
    May 2012
    Posts
    9
    Quote Originally Posted by n_i View Post
    That was not necessary. Try instead "CATALOG DB whatever ON C:", assuming your databases are on the drive C:.
    I tried but got this error

    C:\>db2 catalog db sample on C:\DB2\NODE0000\sample
    SQL6028N Catalog database failed because database "sample" was not found in
    the local database directory.

  8. #8
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    C:\DB2\NODE0000\sample
    most of the time only
    C:\DB2\ is needed.. subdirectories are created by db2 when db is created
    or c:\ because DB2 is the default instance name
    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 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Tags for this Thread

Posting Permissions

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