any way to deal with pkg or SP specially ?
we have some query has good access plan but still process is running slow?

TIA.
any guidelines on Package/Stored Procedure handling would be gratly appreciated.

I am not sure that I understand what you are looking for. You need to state your DB2 version and OS.

For DB2 LUW V8.2, your have the option of setting of setting precompile and bind options when creating an SQL stored procedure. This will explain it:

http://publib.boulder.ibm.com/infoce...d/t0006584.htm

For packages, you can use the REBIND command with the REOPT clause to affect the access plan:

http://publib.boulder.ibm.com/infoce...e/r0001990.htm

HTH

Andy

We have 8.2 wth FP-13.
We see some strage behavious like it works well for certain thousands row and after that it doesnt move for slect/insert activities.

ARWinner:
I can not open the link you sent.
would you resend the link?
Thanks!

In order to make sure that you are not in a lock-wait situation, change the following parm.

db2 connect to <db-name>
db2 update db cfg using locktimeout 15
db2 force application all (or db2stop and db2start)

If you have a lock-wait problem longer than 15 seconds, your application error with a -911 reason code 68.

If you are having trouble opening the links, just goto the DB2 online documentation and search for "prepopts" for the first link and lookup the "REBIND" command for the second.

Maybe if you posted the code for the SP you are having trouble with, we could give you a better answer.

Andy