Database consistency with HPL

I am trying to find the fastest way to take a copy of an entire database. Dbexport/dbimport are too slow as is ontape. I am not able to use onbar as we don't have access to a storage manager (third party who handles backups doesn't want to use ISM). I was thinking of using HPL but am not sure how the preserve referential integrity of the database. It's an OLTP system which needs to be available 24/7, therefore it is not going to be possible to kill user sessions and lock the database prior to running the HPL unload jobs. Any ideas?

Desmodromic said: > I am trying to find the fastest way to take a copy of an entire > database. Dbexport/dbimport are too slow as is ontape. I am not able to > use onbar as we don't have access to a storage manager (third party who > handles backups doesn't want to use ISM). > > I was thinking of using HPL but am not sure how the preserve > referential integrity of the database. It's an OLTP system which needs > to be available 24/7, therefore it is not going to be possible to kill > user sessions and lock the database prior to running the HPL unload > jobs. > > Any ideas? Enterprise Replication or HDR? -- Bye now, Obnoxio "... no bill is required as no value was provided." -- Christine Normile -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.

Hi, do you mean you want to copy "a database" or "a server instance". One IDS server instance has more than one database inside (usually there are the sysmaster, the sysutils, and in newer versions the sysuser databases - apart from one or more databases with actual user's data). Backup utilities (ontape, onbar) do not handle single databases. They operate on a dbspace level. Data unload/load utilities (dbexport/dbimport, onunload/onload, HPL) operate on a database level. If you want to copy the complete data of a server instance, then external backup and restore might be your easy choice. It can be much faster than ontape, doesn't need a storage manager like onbar as you use an external (system) utilities like tar, cpio, dd, ... See the Backup and Restore Guide manual for more info. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management Informix URLs list: http://home.arcor.de/mfu1/informix/urls.html Informix in the news: http://www.crn.com/sections/software/software.jhtml?articleId=193004835 IBM Information On Demand Global Conference October 15-20, 2006, Anaheim, California see http://www.ibm.com/events/informationondemand informix-list-bounces@iiug.org wrote on 09.10.2006 04:10:17: > I am trying to find the fastest way to take a copy of an entire > database. Dbexport/dbimport are too slow as is ontape. I am not able to > use onbar as we don't have access to a storage manager (third party who > handles backups doesn't want to use ISM). > > I was thinking of using HPL but am not sure how the preserve > referential integrity of the database. It's an OLTP system which needs > to be available 24/7, therefore it is not going to be possible to kill > user sessions and lock the database prior to running the HPL unload > jobs. > > Any ideas? > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list