MVSFORUMS.com

[Rama_Prayaga]

Hello,

I need to improve the peroformance of a DYNAMIC sql application prgram.I have checked the Bind options the program which are below.


DSNT255I -DAF2 DSNTBCM2 BIND OPTIONS FOR
PACKAGE = CHSKA000DBAF.TN.YTNW140.(OTXO00001455A27BF5)
SQLERROR NOPACKAGE
CURRENTDATA NO
DEGREE 1
DYNAMICRULES BIND
DEFER
NOREOPT VARS
KEEPDYNAMIC NO
IMMEDWRITE NO
DBPROTOCOL DRDA
OPTHINT
ENCODING EBCDIC(00500)
PATH


I went thru the follwing link.

http://publib.boulder.ibm.com/infocenter/dzichelp/index.jsp?topic=/com.ibm.db2.doc.apsg/bjnqmstr407.htm

I have couple questions after going thru the link.

After reading the above link I had a feeling the REOPT(ONCE) would improve the performance of the SQL.Since, I have normally same set of columns which I update.Am I right in thinking so?

2) Though I have normally same set of columns , But i have different data to these fields for update.Then will the REOPT(ONCE) works fine as static sql.

3)Do I have to make any special changes in the program after giving this above option.

4)If I have to change my bind otpion then do I have change the option "NOREPT VARS" with once option,In the above statement.

Kindly,Please let me know

Reagdrs,
Rama Krishna Prayaga

[kolusu]

Rama_Prayaga,

Did you get a chance to look into this topic

http://mvsforums.com/helpboards/viewtopic.php?t=3078&highlight=reopt

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[Rama_Prayaga]

Hi Koulusu,

Thank you,

Regards,
Rama Krishna