Restoring DB2 Image - File System Challenge

chaisikar · #1 (**permalink**) 01-20-05, 02:04

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

jacampbell · #2 (**permalink**) 01-20-05, 02:26

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

sathyaram_s · #3 (**permalink**) 01-20-05, 05:21

You may use a redirected restore

chaisikar · #4 (**permalink**) 01-25-05, 07:05

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