Re: Database consistency with HPL

Desmodromic wrote: > 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