Hi,

What are the activity wise difference between the following commands and when to use them i.e. which commnad can be used for warm back and which backup can be used for cold backup

1. onbar -b -w -L 0
2. ontape
3. onunload
4. dbexport -o

Regards

Saikat Ghosh

Check out the "Migration Guide" for whatever IDS version you've got here: http://www-306.ibm.com/software/data.../pubs/library/.

Hi,
Informix does not have the concept of cold backups nor does it need it. That is only for those databases that can't keep there data consistant or figure out how to do real backups.

But anyway, use onbar when you have a storage manager, something like TSM. Otherwise you will find yourself setting up disk pools and managing your backups yourself. Onbar is the fastest way to backup and you canhave as many threads as your hardware can support. We saw back-up times reduced by 75%.

Use ontape to go to local disk or local tapes. It is single threaded. Also good for use with HDR.

I only use dbexport when I need to move a small database and it will lock your database.

As for onunload, well it was more useful before onbar and before row level recovery. I'm sure it still has it's uses, I just don't use it.


DBAGIRL