Hi

How do i backup a database greater then 2 GB as the db2 backup command creates a single backup file of the database.My unix file system does not allow files greater then 2Gb.

Can db2 backup command split files with sizes less then 2 GB also what steps do i need to take while restoring these spilt files.

regards
Hrishy

what OS R U using , if solaris , can setup , file size as large , that you can tabke , backup




Lekharaju Ennam

Assuming you are using UNIX, you can ask the unix engineers to change the user limits for the person taking the backup. On AIX you can see the limits by "ulimit -a" command on the prompt. Even if you are unable to change the limits you can still take a backup image BUT you will get more than one backup files...with same naming format but at the end you will find..000, 001....and so on each with 2GB or little less in size.

While restoring you do a restore as you would normally do, DB2 will automatically pick the right file one after another.

dollar

Hi Dollar

The db2 backup command will automagically spli the files with sizes less then 2Gb am i right do i need to pass it some option.I am on redhat Advanced server 3.0 with Veritas Volume Manager

regards
Hrishy

In the backup database command, you can provide multiple paths for db2 to write the backup to ... You may specify the same path too ...

Refer Command Reference for details

Cheers
Sathyaram

Hrishy,

Backup command will automatically split the files for you...nothing else is required from you side besides the command itself

dollar

in backup command use compress option , that will compress you backup file


Lekharaju Ennam

The COMPRESS option is available on DB2 version 8.1 FP4 or later.

Hi
you can create a " Large file enabled journal file system" " If working on AIX " through smit utility and the you can take your DB backup on that files system as " Large file enabled journal file system" permits individual files more than 2GB also

Regards


Falcon