467,154 Members | 949 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,154 developers. It's quick & easy.

Priming the Package Cache ?

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
  • viewed: 1081
Share:
2 Replies
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
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

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by xixi | last post: by
2 posts views Thread by xixi | last post: by
4 posts views Thread by xixi | last post: by
10 posts views Thread by datapro01@yahoo.com | last post: by
reply views Thread by shterke | last post: by
1 post views Thread by Ramchandra | last post: by
2 posts views Thread by Damir | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.