transaction enqueue lock

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 14 Aug 2002 10:27:27 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA70280C480@lnewton.leeds.lfs.co.uk>

Hi Jon,

did you export/drop/import the tables (and obviously the indexes) after setting the new value? If you didn't then only new blocks allocated to the table will have the extra slots !

Cheers,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: jon.m.landenburger_at_verizon.com (Jon Landenburer) [mailto:jon.m.landenburger_at_verizon.com]
Posted At: Tuesday, August 13, 2002 7:32 PM Posted To: server
Conversation: transaction enqueue lock
Subject: Re: transaction enqueue lock

Thanks for responding Norm. In fact our MINTRANS was 2 and we kicked it up to 4. (did not think of the indexes!)<SNIP> Received on Wed Aug 14 2002 - 04:27:27 CDT