Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2003
    Location
    Kuching/Malaysia
    Posts
    17

    Unanswered: Restoring DB2 Image - File System Challenge

    Hi All,

    Do have one question.

    I do have one ABC Database db2 image file which is backup by command below:

    ABC_User> db2 backup db ABCDB online to /ABCDB_Archive

    the ABCDB database detail as below

    Database alias = ABCDB
    Database name = ABCDB
    Local database directory = /database/abcdb
    Database release level = 9.00

    The challenge now I have is when come to restore this image to another development environment

    My virtual "/database/abcdb" file system is too small to restore back the image which had been backup before. No way to increase, because no disk.

    The question is

    Can I restore my images from the previous backup from "/database/abcdb" to two difference local database directory? How to do it?

    What I mean here is my one mount point is not enough space, but I do have some mount point balance from others, so can I do that?

    Any good suggestion for me?

    Thank

    Regards
    SiKar

  2. #2
    Join Date
    Jan 2005
    Posts
    191
    Create a symbolic link from /database/abcdb to a file system with enough space.
    mkdir /big-fs/abcdb
    ln -s /big-fs/abcdb /ABCDB_Archive/.../lastname
    now anything written into /ABCDB_Archive/.../lastname will actually go into big-fs.

    James Campbell

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    You may use a redirected restore
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Dec 2003
    Location
    Kuching/Malaysia
    Posts
    17
    Dear James Campbell

    Symbolic link cannot apply in my environment, I understand what is your method. Reason is because I totally did not have enough space that big like what I have in ABCDB database. Unless symbolic link can joining multi location.

    so Symbolic link not work for me.

    Regards
    SiKar

  5. #5
    Join Date
    Dec 2003
    Location
    Kuching/Malaysia
    Posts
    17
    Dear sathyaram_s

    What do you mean re-directed restore?

    Regards
    SiKar

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    please search in the documentatiion .. Developer domain has a step-by-step procedure to perform a redirected restore ..
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  7. #7
    Join Date
    Dec 2003
    Location
    Kuching/Malaysia
    Posts
    17
    Hi sathyaram

    Thank

    Regards

Posting Permissions

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