To define the table in DB2 cache or memory

yacov · New User Joined: 27 Jul 2007 Posts: 6 Location: Israel

Hi,

My question is DBA oriented

I have a small table ~ 500 rows, each row 100 bytes.

All the accesses to this table in on-line operations are for read and not for update or insert.

But we have really many accesses to this table, about million every day.

Is it possible for DBA to define the table in DB2 cache or memory, in order to cause selects not going to the disk, but to go to the memory?

Thanks

murmohk1 · Posted: Fri Nov 09, 2007 12:54 pm

Yacov,

murmohk1 · Posted: Fri Nov 09, 2007 3:30 pm

Yacov,

Addition to my prev post -

If I remember correctly, upon successfull record retervial ..... PAGE (where record is present) will be loaded into memory along with record. Depending on the memory/buffer size, this page remain there for sometime.

Since you have less number of rows and more hits..... there is a possibility that your table remains in buffer.

yacov · New User Joined: 27 Jul 2007 Posts: 6 Location: Israel

murmohk1,

So, do I have some way (on DB2 level) that can speed up record retrivals?

murmohk1 · Posted: Fri Nov 09, 2007 4:04 pm

Yacov,