To turn off XM for a database using SUPRTOOL you must open the
database in mode-3 and do SET DEFER ON. Make sure you have a good
backup before doing this.

-----Original Message-----
From: Leonard S. Berkowitz
To: [log in to unmask]
Sent: 12/31/01 7:42 AM
Subject: STALLED TRANSACTION again

We are attempting to add nearly 1.8 millions records to a TI dataset.
Suprtool is the means. After 95% of the file is processed:

  95% In=1698720    Out=1698720   Delta-Min=9:01. Wall-Min=177:58.
Cpu-Sec=7099.



 **** STALLED TRANSACTION: EXCEEDED ACCUMULATED LOG DATA THRESHOLD

Originally, the VOLUTIL checkptstat was disabled. We changed it to
enabled
with the same result.

This dataset does have an Omnidex MDK index (Multi-Dimensional Keyword,
for
the uniformed; I know this only because I have a little sticky note on
my
wall <grin>)

We are going to try this with NOXM for Omnidex. This is a solution we
regularly used before our 6.5 upgrade that we expected to eliminate the
problem.

Any suggestions?
===================
Leonard S. Berkowitz
Perot Health Care Systems
(Harvard Pilgrim Health Care account)
voice: 617-509-1212
fax:   617-509-3737
pager: 781-226-2431

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