Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2007
    Posts
    30

    Unanswered: Difference between onbar/ontape/onunload/dbexport Command

    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

  2. #2
    Join Date
    Aug 2006
    Location
    The Netherlands
    Posts
    248
    Check out the "Migration Guide" for whatever IDS version you've got here: http://www-306.ibm.com/software/data.../pubs/library/.

  3. #3
    Join Date
    Jan 2004
    Location
    San Antonio, Texas
    Posts
    47

    Cool

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •