Hello all!

I have problem making a backup of db (DB" v7.2). It should have 110 GB (counting all tablespaces). I'm tring to place backup on the same computer in a directory that has 170GB free place. On AIX (v.4) I have enabled large file system, user has enough authorities, "ulimit -a" shows "file - unlimited".
But, after 1h and 30 minutes it just stops with an message
"SQL2059W A device full warning was encountered on device /backup'. Do you want to continue(c), terminate this device only(d), abort the utility(t) ? (c/d/t)".
But backup directory is only 40 % full.
It stops when completes 68 589 453 312 B.
/backup directory is 174 214 610 944 B.

I can't see anything to avoid the problem.

Any advice I appreciate.
Thank you,
NNicole

The following thread has details
http://www.dbforums.com/t1000341.html

But, since you are on V4, you can apply the following technique :

db2 backup database sample to /dbbackup,/dbbackup,/dbbackup

will write the backup into three different files ... For 110, I'll use atleast 3 and preferably 4 ... Hence, you are unlikely to hit the 64 Gig limit

HTH

Sathyaram

After changing ulimite , you MUST restart instance, please use db2stop; db2start; and try again.
let us know what happened.

I didn't have problem with changing ulimite because I didn't update it, so I didn't need stop/start...
But backup in three directories - work...

db2 backup database sample to /backup/a, /backup/b, /backup/c

Thank you!!

NNicole