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".
Edited by: Jonghoon Kim on May 20, 2009 5:11 AM