HP3000-L Archives

February 2006, Week 1

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: Transaction manager
From:
Craig Lalley <[log in to unmask]>
Reply To:
Craig Lalley <[log in to unmask]>
Date:
Thu, 2 Feb 2006 09:10:22 -0800
Content-Type:
text/plain
Parts/Attachments:
text/plain (39 lines) 
--- 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 *

ATOM RSS1 RSS2