Stalled transaction could be caused by tpi.  If you disable tpi from xm, the 
stalled transactions may go away.

Removing tpi from the database before the repack will also do the the job.

repack, then re-index.  In some cases this is not possible which is why disable 
tpi from xm is the way to go.

 
TPI by Omnidex does the DBPUT as follows: 

The DBPUT uses empty records from delete chain, than a reshuffle of the index 
records is done in order to keep the RRNs in sorted order.  This can apparently 
take up lots of XM buffer space. 


Omnidex suggests that customers do a REPACK of detail set and 
REINDEX.  If the delete rate is high a REPACK of the detail set 
and REINDEX should be done often.  Workaround: Disable TPI XM: 

Turn off XM for TPI (Omnidex) 

RUN DBINSTAL.PUB.DISC   
Data base name: mydb 
Cmd: SET TPI NOXM 


 Cathlene Mc Rae
 HP SR. Response Center Engineer
 [log in to unmask]

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