Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Backup question

Status
Not open for further replies.

bjverzal

MIS
Apr 26, 2001
964
US
On a DB2 backup to disk, I am told there is a limitation of 2GB on each individual filesystem. For example:

db2 backup database database_name to /fs01,/fs02 . . .

Is there a limitation of 2GB each on /fs01 and /fs02 ?

Currently I have over 100 /fs?? filesystems, each one 2GB in size. I'd like to create less BIGGER ones versus more SMALLER ones. Will DB2 use the space if it is bigger than 2GB ?

Can anyone point me to documentation ?

Thanks, Bill.
 
Hi there!
I work on DB2 UDB for AIX and I had the same senario. My database was almost 100GB of size.
I created two filesystems on AIX (large file enabled - up to 64GB) and I changed the file size limit that is specified for my user (/etc/security/limits).
Then i backed up my database i.e
backup db dbname to /dir1, /dir2

Hope this helps!

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top