Kent, if you're going to use AUTODEFER, then make sure you have your DB
backed up!

-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On
Behalf Of Craig Lalley
Sent: Thursday, February 02, 2006 11:10 AM
To: [log in to unmask]
Subject: Re: [HP3000-L] Transaction manager

--- Kent Wallace <[log in to unmask]> wrote:

> How do I turn the transaction manager off for a specific IMAGE
database?
> 

Kent, 

You certainly wouldn't want to do this for a production database, but I
think you are
trying to load a large dataset.

So

You will need exclusive access, for about 1 minute.

RUN DBUTIL.PUB.SYS
>> ENABLE DB FOR AUTODEFER
>> EXIT

Also if you have OMNIDEX indexes

RUN DBINSTAL.PUB.DISC
>choose db
>SET TPI NOXM

Or you could remove the indexes and then add them after you load the
dataset.

HTH,

-Craig


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *