SEO

#1 (**permalink**) 02-27-2008, 06:54 AM

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.

#2 (**permalink**) 02-27-2008, 06:55 AM

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

#3 (**permalink**) 02-27-2008, 06:56 AM

Thanks.

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Priming the Package Cache ?