We moved from ver 7.2 to ver 8.1 on AIX 5.3.
This is a 4 node logical partitioned environment on p690.
The older one was 4 node on SP2 environment.

But the select queries are running considerably slow on new version than older one.

Are there any db/dbm parameters to be tuned in 8.1 for optimizing the SELECTs.

Thanks for help in advance
toby

Yes, lots.

Do you have your old configuration? Try using those values as a starting point... there are parrallelism parameters, bufferpools, etc that you will want to tune.

Also - do a REORG/RUNSTATS on everything, if you haven't already.