Priming the Package Cache ?

PaulR

Hi,

Is there an easy way re-prime the Package Cache after a
db2stop/db2start ?

i.e We have a Script of captured SQL (containing parm. markers) of our
workload, that we would like to simply run Prepares of , and not
execute.

is there a tool to do this ?

Thanks.

Apr 28 '06 #1

Kiran Nair

We can use PREP and BIND to do that same . But your program needs to be
an SQC (embedded C SQL).If you do PREP without BINDFILE or BIND the
BIND file the package gets loaded into database. I am not sure if it
gets loaded to package cache ..it may need an execute of application .

Regards,
Kiran Nair

Apr 28 '06 #2

PaulR

Thanks.

We have actually written a very simple little Java/JDBC app. to prep
all the SQL statements in a given file.

May 2 '06 #3