By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,611 Members | 1,693 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,611 IT Pros & Developers. It's quick & easy.

Priming the Package Cache ?

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.