I also went into DBUTIL and enable autodefer and disabled indexing.  My test of 10000 records went in 1 min 30 sec. with XM off(I think) and 2 min. 3 sec. with it on.

However the system is in use and usage is volatile.

Thanks
Kent Wallace

>>> John Clogg <[log in to unmask]> 12/10/01 01:45PM >>>
This only detaches the Omnidex indexes from XM, not the database.

-----Original Message-----
From: KENT WALLACE [mailto:[log in to unmask]] 
Sent: Monday, December 10, 2001 12:16 PM
To: [log in to unmask] 
Subject: Turning off Transaction manager


I went into the DBINSTAL omnidex utility and 

set tpi off
and
set tpi NOXM

Used dbutil to 
EN health for AUTODEFER

and I get:

:SUPRTOOL
i benwf.phndata
>fo
    File: BENWF.PHNDATA.AMITEST     (SD Version B.00.00)
       Entry:                     Offset
          BP-EXPLODE#          X10     1
          BP-BENEFIT           X10    11
          COMPONENT            X4     21
          RIDER-TITLE          X8     25
          YMDEFF               X8     33
          YMDEND               X8     41
          PRIORITY             X2     49
    Limit: 10000000  EOF: 4806446  Entry Length: 50  Blocking: 81
>put bp-explode,HEALTH,1,<<snip>>
>num 20
>x

Error:  Unable to call dbinfo

TURBOIMAGE ERROR AT $000df868; RETURN STATUS = -176
DBINFO, MODE 202, ON BP-EXPLODE OF HEALTH
CANNOT DETACH DATA SET #109 FROM MPE XL XM: XM ERROR -264


I am on 5.5 PP 6 and the set is a jumbo.  Any help would be appreciated.

Thanks
Kent Wallace

* 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 *