Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    34

    Lightbulb Unanswered: Hard Disk Space Vs DB2

    Windows = NT
    DB2 = UDB 6.1

    I'm running out of space, and I don't have any other alternate to increase the space on existing hard drive.

    There is C: & D: in the system.

    Db2 software and database - everything is on D:

    Now, I'm planning to add E: drive which will come from SAN.

    Once I get E: drive, planning to copy everything from D: to E: and then drop the D: drive and rename E: drive to D:

    What are the risks involved in this process ?

    Do you think after this process, DB2 will not work ?

    Because I don't have DB2 6.1 software handy, have only 7.1.

    Please advice.

  2. #2
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    Solution

    Hi ,

    This is the best thing to do .

    1. Take the offline backups of all your databases with the logs.
    2. Drop the databases.
    3. Restore the databases on E: with the same names. Use redirected restore.

    This will allow for using D: and E: as well and does not hamper your setup.


    The other alternative is risky.

    1.Take a full backup of all your databaes offline + logs.
    2. Take a print of all the db2 registry settings using db2set.
    3. Take a fullbackup image of D:
    4. Drop D:
    5. Rename E: to D:
    6. Restore image back.

    This should work. but needs a lot of caution and effort.
    HTH

    Nitin

    Ask the experienced rather than the learned

  3. #3
    Join Date
    Feb 2004
    Posts
    34

    Thumbs up Thanks a bunch Nitin...

    ....i guess your second idea will work out for me as i need to remove D: drive as its dying.

Posting Permissions

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