Hi, When i try to do redirect restore i end up with "filesystem full error"

[ctginst1@linux-server2 StgBackup]$ db2 -tvf ABC.sql
UPDATE COMMAND OPTIONS USING S ON Z ON MAXDB71_NODE0000.out V ON
DB20000I The UPDATE COMMAND OPTIONS command completed successfully.

SET CLIENT ATTACH_DBPARTITIONNUM 0
DB20000I The SET CLIENT command completed successfully.

SET CLIENT CONNECT_DBPARTITIONNUM 0
DB20000I The SET CLIENT command completed successfully.

RESTORE DATABASE MAXDB71 FROM '/StgBackup/' TAKEN AT 20120109113635 ON '/db_bkp' INTO MAXDB71 REDIRECT
SQL2523W Warning! Restoring to an existing database that is different from
the database on the backup image, but have matching names. The target database
will be overwritten by the backup version. The Roll-forward recovery logs
associated with the target database will be deleted.
Do you want to continue ? (y/n) y
SQL1277W A redirected restore operation is being performed. Table space
configuration can now be viewed and table spaces that do not use automatic
storage can have their containers reconfigured.
DB20000I The RESTORE DATABASE command completed successfully.

SET TABLESPACE CONTAINERS FOR 3 USING ( FILE 'CTGDAT/MAXDATA/container1' 600000 )
SQL0968C The file system is full. SQLSTATE=57011

I use db29.1 fp6,

I have 40Gb available in the path where i am restoring, where db is just 16 gb.

Please help me... thanks

check the diag.log
it is possible that the home directory is full - that is where the db is created
on xxx is for datapath for automatic storage

hey thanks for your reply..

i have given the DBPATH in script or do i need to specify the same in Target directory?

RESTORE DATABASE MAXDB71
-- USER <username>
-- USING '<password>'
FROM '/StgBackup/'
TAKEN AT 20120109113635
ON '/db_bkp'
-- , '/opt/ctginst1'
-- , '/opt/ctginst1/ctginst1/MAX_Container'
-- DBPATH ON '<target-directory>'
INTO MAXDB71
-- NEWLOGPATH '/opt/ctginst1/ctginst1/NODE0000/SQL00001/SQLOGDIR/'
-- WITH <num-buff> BUFFERS
-- BUFFER <buffer-size>
-- REPLACE HISTORY FILE
-- REPLACE EXISTING
REDIRECT
-- PARALLELISM <n>
-- COMPRLIB '<lib-name>'
-- COMPROPTS '<options-string>'
-- WITHOUT ROLLING FORWARD
-- WITHOUT PROMPTING

i get this error when restoring a particular Tablepace...

on is for datapath for automatic storage
dbpath is for the config files and others
this is displayed when doing db2 list db directory
check infocenter/doc for details of each option

Looks like you're specifying a relative path, not absolute, so it is being created in the database directory (/db_bkp).

Check also ulimit and/or disk quotas.

Issue got resolved...

problem i had was "disk full issue", which is because one of the tablespace not able to restore. when i check it in source db it was having 51gb. But i don have enough space in target db.

Then i altered the number pages to a value close to High water Mark.

Then the tablespace got restored.

I don know it is a correct way.. but it worked for me.

thanks for all your sugestions...

That's not what you said initially:

So, you've just wasted everybody's time (including your own) by not providing full information.

No, please don say that...

I still stand to my point, I found the db size was 16GB
And one of the TBS is around 12GB size, But the capacity of the TBS was
51GB. I had 40GB space in my Target DB path.

So i told what i faced, Changing the capacity value came just as a luck.