Folks,

 I am not sure what I am doing wrong, but We have an transaction that
 does some serious calculation on small chink of data over and over
 again.

 It selects few rows from the table several times and does different
calculations. It was taking about 45 seconds to run. I thought that
moving the file to its own tablespace and giving it large bufferpool
would improve the performance. I experienced exactly opposite, the
transaction now took 4 minutes instead of 45 seconds.

 Initially table was created as follows:

CREATE TABLE APDEV15.AADMPF00
    (KEY0 CHAR (31) NOT NULL,
     REC VARCHAR(3000));

CREATE UNIQUE INDEX AADMPF00_ASC ON APDEV15.AADMPF00 (KEY0 ASC)
    ALLOW REVERSE SCAN;

Then I changed it as follows:

CREATE BUFFERPOOL PLANFILEPOOL SIZE 40 PAGESIZE 4K;

CREATE REGULAR TABLESPACE PLANFILESPACE PAGESIZE 4K MANAGED BY SYSTEM
  USING ('/f2/dbap15/dbap15/PLANFILESPACE') BUFFERPOOL PLANFILEPOOL;

CREATE TABLE APDEV15.AADMPF00
    (KEY0 CHAR (31) NOT NULL,
     REC VARCHAR(3000)) IN PLANFILESPACE INDEX IN PLANFILESPACE;

CREATE UNIQUE INDEX AADMPF00_ASC ON APDEV15.AADMPF00 (KEY0 ASC) ALLOW REVERSE SCAN;

What am I doing wrong?

I am running DB2 UDB 8.1 FP5 under AIX 5.1

Thanks.