which registry variable to set ? (updated from 8.1 to 8.2)

[Knokmans]

Hi,

We are using DB2 ESE on AIX, having most tablespaces DMS on filesystem
This has the disadvantage that all data which is read into bufferpools also
is read by JFS filesystem paging.

On db2 8.1 we used these registry settings
DB2_DIRECT_IO=on
DB2_STRIPED_CONTAINERS=on

After updating to version 8.2 we had a huge decrease of performance (e.g.
db2 backup takes twice as long) on all 3 machines we have running this way.
We also see that both registry variables are not supported anymore.
(DB2_STRIPED_CONTAINERS is not supported for a longer time...)

After removing these (not supported !!) variables we won a lot again, but
the systems still aren't as fast as they were before. I'm sure we're NOT the
only ones to have this problem.

Which variable do we have to set to prevent JFS filesystem paging now
DB2_DIRECT_IO is not supported anymore. Or is there another solution for
this. (please don't answer to run DMS on RAW LogicalVolumes)

Knokmans

[Gert van der Kooij]

In article <41***********************@dreader18.news.xs4all.n l>,
Knokmans (kn******@nospam.com) says...

Which variable do we have to set to prevent JFS filesystem paging now
DB2_DIRECT_IO is not supported anymore. Or is there another solution for
this. (please don't answer to run DMS on RAW LogicalVolumes)

Knokmans

Hi,

DB2 8.2 introduced the FILE SYSTEM CACHING option. Check the CREATE
and ALTER TABLESPACE commands.

Hope this helps.

Kind regards, Gert