Dear All,

I have a problem when running dbexport in order to do a backup for my database on the server
Size of database to back up is 80GB.
When running dbexport, 2GB are only backed up , since the size of the dbexport.out generated is 2GB and not 80 GB.
Please note that there is no problem of space .
Please advise if there is a parameter to adjust on the config File in order to bypass the 2GB limitation of Dbexport

Your prompt reply are highly appreciated

2 GB is an Informix limitation in all databaseservers
until verson 9.40. In 9.40 the 2GB limit is removed.

dbexport is not a backup tool. Think about ontape or
onbar for this purpose.

Thanks for your reply.
Can you please advise what are the arguments to issue with the command OnTape if we want to do a copy for the database on the HDD and not on the tape.
Why I cannot use the dbexport if i want to create a copy of my existing
database on the disk?

Thanks in advance

If your database is 80 GB big, dbexport is definetly the
wrong tool.

Beside the 2 GB-Limitation (which you will also have when using
ontape to backup in a filesystem), the export and import of the
data would take a lot of hours and your database is exclusively
locked during that time.

I would think about other methods like splitting the mirror
(from the O/S side) or using the Informix HPL.

/dev/rdsk/***

You can use onbar or ontape to backup because there are backup tools,
but dbexport,import is database reorganize tool

Here is how to backup your database to disk.
1. create an emty file using touch(UNIX), give the file rw access also the folder. ex. touch /backup/infbackup;chmod 777 /backup/infbackup
2. modify onconfig file and change TAPEDEV /backup/infbackup
TAPEBLK 1024 # tape block size
TAPESIZE 4000000 # maximum amount data that the tape can handle
3. restart informix
4. ontape -s -L 0

Hi,

i feel the problem of not genarating more than 2gb dbexport.out due to file system is mounted without large file option. if you mount the corresponding file system where dbexport.out created with large file options it will allow to create dbexport. however it is not advisable to take dbexport for such large database as others suggested.

Thanks

Hi,

i feel the problem of not genarating more than 2gb dbexport.out due to file system is mounted without large file option. if you mount the corresponding file system where dbexport.out created with large file options it will allow to create dbexport. however it is not advisable to take dbexport for such large database as others suggested.

Thanks