Hi,

How to Archive Data using Informix? Please provide help.

Regards

Saikat Ghosh

Hi,
try ontape -s -L 0

ontape
usage:
{ -a |
-c |
-l |
-p |
-r [-D DBspace_list] |
-s [-L archive_level] [-A database_list] [-B database_list]
[-N database_list] [-U database_list] }

-a Automatic backup of logical logs
-c Continuous backup of logical logs
-l Logical restore
-p Physical restore for HDR
-r Full restore DBspaces/BLOBspaces as listed
-s Archive full system
-A set the following database(s) to ansi logging
-B set the following database(s) to buffered logging
-N set the following database(s) to no logging
-U set the following database(s) to unbuffered logging

Hi,

Thanks for your reply. Can you please tell me the difference & usage of onbar/ontape/dbexport

Regards

Saikat Ghosh

Hi,
just a simple short answer. Ontape and Onbar backup Databases. You are able to do incremental backups. Ontape is very easy to handle. Onbar is the more powerfull backup. I'm not shure if Ontape still works with engine Version >9.xx.
Dbexport writes Data within Datafiles. You can edit these File after export. You can Dbimport any Dbexport File on different engines. To backup Databases you should use Ontape/Onbar.

Check out IBM/informix:
http://publib.boulder.ibm.com/infoce....doc/gsg85.htm

Thanks a Lot.

Using ontape can we take backup in local harddisk in Win'2K Server?

Or should we use onbar for that?

Regards

Saikat Ghosh

Hi,
with ontape you can backup Informix databases+Chunks, no matter what System(win or unix). Ontape/Onbar backup only Databases/Chunks which are defined within the Informix setup. If ontape works do it, and try to restore the databases.

Thanks a lot