Skip to Content
Former Member
May 19, 2009 at 05:47 AM

how to pin/cache a table in the bufferpool.(when db starts)


Hi ,

Is there any way to pin/cache a table in any bufferpool on db2 udb when db starts?

I have found a reference to assign a bufferpool to a tablespace.

but I don't think it caches a tablespace when db starts but pins a tablespace to the bufferpool when any data acess is occured.

Do we have any option to pin a table in the bufferpool when db starts?

What I know it on Oracle is there is the option "ALTER TABLE ... CACHE".

Many Thanks,


Edited by: Jonghoon Kim on May 20, 2009 5:11 AM