Go Back  IT Forums > Software > Informix
Reload this Page Database consistency with HPL
User Name
Password
Reply
 
Thread Tools Search this Thread Display Modes

Database consistency with HPL
  #1
Old 10-08-2006, 06:10 PM
Desmodromic
Junior Member


Desmodromic is offline
Desmodromic's Info
Join Date: Sep 2006
Posts: 3
Default 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?

Reply With Quote
Database consistency with HPL
  #2
Old 10-08-2006, 11:20 PM
Obnoxio The Chav
Junior Member


Obnoxio The Chav is offline
Obnoxio The Chav's Info
Join Date: Nov 2004
Posts: 583
Default Database consistency with HPL

Desmodromic said:
Quote:
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.

Reply With Quote
Database consistency with HPL
  #3
Old 10-10-2006, 11:14 AM
Art S. Kagel
Junior Member


Art S. Kagel is offline
Art S. Kagel's Info
Join Date: Nov 2004
Posts: 340
Default Database consistency with HPL
Desmodromic wrote:
Quote:
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?

Use HPL to copy the data with all constraints disabled, set constraints to
filtering, then add exceptions to the dependent tables and enable the
constraints. Records that violate the constraints will be moved to the
exceptions tables.

Art S. Kagel
Reply With Quote
Reply

« Previous Thread | Next Thread »

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump



Powered by: vBulletin Version 3.0.7
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Style Design by vBStyles.com


Top Contact Us - IT Forums - Archive - MyLounge Top
MyLounge.com Site Map
Forum: Cars, Cell Phone, Database, Games, Home Improvement, IT, Music, School, Sports, Web Design, Web Server, Weight Loss

The MyLounge.com forum is intended for informational use only and should not be relied upon and is not a substitute for any advice. The information contained on MyLounge.com are opinions and suggestions of members and is not a representation of the opinions of MyLounge.com. MyLounge.com does not warrant or vouch for the accuracy, completeness or usefulness of any postings or the qualifications of any person responding. Please consult a expert or seek the services of an attorney in your area for more accuracy on your specific situation. Please note that our forums also serve as mirrors to Usenet newsgroups. Many posts you see on our forums are made by newsgroup users who may not be members of MyLounge.com Term of Service