Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2002

    Unanswered: db2 catalog database

    I upgraded DB2 on my NT machine. How do I recatalog databases that previously existed ? I issued the following command:
    db2 catalog db testdb on c:\db2...but it seems on NT, you can only specify a drive letter for the Path.


  2. #2
    Join Date
    Feb 2002
    J, I don't know what the 'on <path>' clause does. Have you tried leaving it out as in 'db2 catalog db testdb'.


  3. #3
    Join Date
    Feb 2002
    Hi. You should check the local and system database directories for the database(s) in question:

    db2 list db directory
    --system database directory
    db2 list db directory <drive>
    --local database directory

    The system database directory acts as a mapping of the databases on the system. The local database directory actually gives the path to the database files.

    If you find that the system database directory doesn't contain the database, but the local on does, you'll need to catalog using the drive.
    hope this helps,

Posting Permissions

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