Local managed tablespace better for performance ?

From: Andreas Wizemann <AWizemann_at_fvvag.de>
Date: Tue, 25 Sep 2001 20:06:12 +0200
Message-ID: <vhh1rtks6qfoicssbhj8lfklm699pbih2t@4ax.com>

Hi,
i'm considering using local managed tablespaces to speed up a large batch application. Is there an 'easy' way to check, if this will give me the expected performance boost ? Means, can i select some values or ratios from my running system where i can expect to get some benefit ? Like checking cache hit ratio before increasing buffer...

Or, which are the 3 most efficient parameters to tune for a job inserting about 200.000 rows ?
eg. initrans, freelist, cache, rbs,...

DB is 8.1.7.1 on aix 4.3.3-ML08 using IBM ESS SHARK as DASD device.

regards
Andreas
Andreas Wizemann Received on Tue Sep 25 2001 - 13:06:12 CDT