Auto Bind

Jobi M B225 Augustine

Auto Bind
Hi list,

I would appreciate if somebody could tell me the bind parameter that we need
to set to make the program as an auto bind program. I like to bind the
program automatically each time the program runs. We use OS390 / DB2 V6.

Is it any of the parameters that are specified below ?

Thanks in advance !!

//BINDAPKG EXEC PGM=IKJEFT01,DYNAMNBR=99
//STEPLIB DD DSN=TTAA.TS2.DB2.APFLIB,DISP=SHR
//DBRMLIB DD DSN=TEST.DB2T.DBRMLIB,DISP=SHR
//*
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DB2T)
BIND MEMBER(GVQ01600) -
PACKAGE(VQ0_BATCH) -
ACTION(REPLACE) -
QUALIFIER(GVQ0) -
EXPLAIN(NO) -
FLAG(I) -
ISOLATION(CS) -
RELEASE(COMMIT) -
VALIDATE(BIND)


Thanks and best regards,

a Jobi Augustine
CIGNA Systems - ES IM &T
* Tel (860) 226-5466 (6-5466)
* Fax (860) 226-5344 (6-5344)
* Mail [login to unmask email] <mailto:[login to unmask email]>

Confidential, unpublished property of CIGNA. Do not duplicate or distribute.
Use and distribution limited solely to authorized personnel. © Copyright
2002 by CIGNA.




------------------------------------------------------------------------------
CONFIDENTIALITY NOTICE: If you have received this e-mail in error, please immediately notify the sender by e-mail at the address shown. This e-mail transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance.© Copyright 2002 CIGNA

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++



Larry Jardine

Re: Auto Bind
(in response to Jobi M B225 Augustine)
I think you want REOPT(VARS)

-----Original Message-----
From: Augustine, Jobi M B225 [mailto:[login to unmask email]
Sent: Wednesday, January 09, 2002 11:23 AM
To: [login to unmask email]
Subject: Auto Bind


Hi list,

I would appreciate if somebody could tell me the bind parameter that we need
to set to make the program as an auto bind program. I like to bind the
program automatically each time the program runs. We use OS390 / DB2 V6.

Is it any of the parameters that are specified below ?

Thanks in advance !!

//BINDAPKG EXEC PGM=IKJEFT01,DYNAMNBR=99
//STEPLIB DD DSN=TTAA.TS2.DB2.APFLIB,DISP=SHR
//DBRMLIB DD DSN=TEST.DB2T.DBRMLIB,DISP=SHR
//*
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DB2T)
BIND MEMBER(GVQ01600) -
PACKAGE(VQ0_BATCH) -
ACTION(REPLACE) -
QUALIFIER(GVQ0) -
EXPLAIN(NO) -
FLAG(I) -
ISOLATION(CS) -
RELEASE(COMMIT) -
VALIDATE(BIND)


Thanks and best regards,

a Jobi Augustine
CIGNA Systems - ES IM &T
* Tel (860) 226-5466 (6-5466)
* Fax (860) 226-5344 (6-5344)
* Mail [login to unmask email] <mailto:[login to unmask email]>

Confidential, unpublished property of CIGNA. Do not duplicate or distribute.
Use and distribution limited solely to authorized personnel. © Copyright
2002 by CIGNA.




----------------------------------------------------------------------------
--
CONFIDENTIALITY NOTICE: If you have received this e-mail in error, please
immediately notify the sender by e-mail at the address shown. This e-mail
transmission may contain confidential information. This information is
intended only for the use of the individual(s) or entity to whom it is
intended even if addressed incorrectly. Please delete it from your files if
you are not the intended recipient. Thank you for your compliance.©
Copyright 2002 CIGNA

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++



http://www.ryci.com/db2-l. The owners of the list can be reached at
[login to unmask email]



Dave Nance

Re: Auto Bind
(in response to Larry Jardine)
Try VALIDATE(RUN). The big question is WHY would you want to? That is why DB2 allows you to validate at bind time so there isn't time being spent doing that work when you need to give a customer response.

>>> [login to unmask email] 01/09/02 11:22AM >>>
Hi list,

I would appreciate if somebody could tell me the bind parameter that we need
to set to make the program as an auto bind program. I like to bind the
program automatically each time the program runs. We use OS390 / DB2 V6.

Is it any of the parameters that are specified below ?

Thanks in advance !!

//BINDAPKG EXEC PGM=IKJEFT01,DYNAMNBR=99
//STEPLIB DD DSN=TTAA.TS2.DB2.APFLIB,DISP=SHR
//DBRMLIB DD DSN=TEST.DB2T.DBRMLIB,DISP=SHR
//*
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DB2T)
BIND MEMBER(GVQ01600) -
PACKAGE(VQ0_BATCH) -
ACTION(REPLACE) -
QUALIFIER(GVQ0) -
EXPLAIN(NO) -
FLAG(I) -
ISOLATION(CS) -
RELEASE(COMMIT) -
VALIDATE(BIND)


Thanks and best regards,

a Jobi Augustine
CIGNA Systems - ES IM &T
* Tel (860) 226-5466 (6-5466)
* Fax (860) 226-5344 (6-5344)
* Mail [login to unmask email] <mailto:[login to unmask email]>

Confidential, unpublished property of CIGNA. Do not duplicate or distribute.
Use and distribution limited solely to authorized personnel. © Copyright
2002 by CIGNA.




------------------------------------------------------------------------------
CONFIDENTIALITY NOTICE: If you have received this e-mail in error, please immediately notify the sender by e-mail at the address shown. This e-mail transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance.© Copyright 2002 CIGNA

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

=======================

This message, including any attachments, is intended solely for the use of the named
recipient(s) and may contain confidential and/or privileged information. Any
unauthorized review, use, disclosure or distribution of this communications is expressly
prohibited. If you are not the intended recipient, please contact the sender by reply e-mail
and destroy any and all copies of the original message. Thank you.



Jeff L'Italien

Re: Auto Bind
(in response to Dave Nance)
Jobi,

To my knowledge their is no such option/parm. An automatic bind normally only
occurs when a package/plan becomes invalidated due to a dropped dependent
object. Just out of curiousity, why would there be a need to have this done?

Regards,
Jeff L'Italien
American Express



From: "Augustine, Jobi M B225" <[login to unmask email]>@RYCI.COM> on
01/09/2002 11:22 AM EST

Please respond to "DB2 Data Base Discussion List" <[login to unmask email]>

Sent by: "DB2 Data Base Discussion List" <[login to unmask email]>


To: [login to unmask email]
cc:
Subject: Auto Bind


Hi list,

I would appreciate if somebody could tell me the bind parameter that we need
to set to make the program as an auto bind program. I like to bind the
program automatically each time the program runs. We use OS390 / DB2 V6.

Is it any of the parameters that are specified below ?

Thanks in advance !!

//BINDAPKG EXEC PGM=IKJEFT01,DYNAMNBR=99
//STEPLIB DD DSN=TTAA.TS2.DB2.APFLIB,DISP=SHR
//DBRMLIB DD DSN=TEST.DB2T.DBRMLIB,DISP=SHR
//*
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DB2T)
BIND MEMBER(GVQ01600) -
PACKAGE(VQ0_BATCH) -
ACTION(REPLACE) -
QUALIFIER(GVQ0) -
EXPLAIN(NO) -
FLAG(I) -
ISOLATION(CS) -
RELEASE(COMMIT) -
VALIDATE(BIND)


Thanks and best regards,

a Jobi Augustine
CIGNA Systems - ES IM &T
* Tel (860) 226-5466 (6-5466)
* Fax (860) 226-5344 (6-5344)
* Mail [login to unmask email] <mailto:[login to unmask email]>

Confidential, unpublished property of CIGNA. Do not duplicate or distribute.
Use and distribution limited solely to authorized personnel. © Copyright
2002 by CIGNA.




------------------------------------------------------------------------------
CONFIDENTIALITY NOTICE: If you have received this e-mail in error, please
immediately notify the sender by e-mail at the address shown. This e-mail
transmission may contain confidential information. This information is
intended only for the use of the individual(s) or entity to whom it is intended
even if addressed incorrectly. Please delete it from your files if you are not
the intended recipient. Thank you for your compliance.© Copyright 2002 CIGNA

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++


visit the







Francis C - CNF Leblanc

Re: Auto Bind
(in response to Jeff L'Italien)
Change it to VALIDATE(RUN)

> -----Original Message-----
> From: Augustine, Jobi M B225 [SMTP:[login to unmask email]
> Sent: Wednesday, January 09, 2002 8:23 AM
> To: [login to unmask email]
> Subject: Auto Bind
>
> Hi list,
>
> I would appreciate if somebody could tell me the bind parameter that we
> need
> to set to make the program as an auto bind program. I like to bind the
> program automatically each time the program runs. We use OS390 / DB2 V6.
>
> Is it any of the parameters that are specified below ?
>
> Thanks in advance !!
>
> //BINDAPKG EXEC PGM=IKJEFT01,DYNAMNBR=99
> //STEPLIB DD DSN=TTAA.TS2.DB2.APFLIB,DISP=SHR
> //DBRMLIB DD DSN=TEST.DB2T.DBRMLIB,DISP=SHR
> //*
> //SYSTSPRT DD SYSOUT=*
> //SYSPRINT DD SYSOUT=*
> //SYSTSIN DD *
> DSN SYSTEM(DB2T)
> BIND MEMBER(GVQ01600) -
> PACKAGE(VQ0_BATCH) -
> ACTION(REPLACE) -
> QUALIFIER(GVQ0) -
> EXPLAIN(NO) -
> FLAG(I) -
> ISOLATION(CS) -
> RELEASE(COMMIT) -
> VALIDATE(BIND)
>
>
> Thanks and best regards,
>
> a Jobi Augustine
> CIGNA Systems - ES IM &T
> * Tel (860) 226-5466 (6-5466)
> * Fax (860) 226-5344 (6-5344)
> * Mail [login to unmask email] <mailto:[login to unmask email]>
>
> Confidential, unpublished property of CIGNA. Do not duplicate or
> distribute.
> Use and distribution limited solely to authorized personnel. © Copyright
> 2002 by CIGNA.
>
>
>
>
> --------------------------------------------------------------------------
> ----
> CONFIDENTIALITY NOTICE: If you have received this e-mail in error, please
> immediately notify the sender by e-mail at the address shown. This e-mail
> transmission may contain confidential information. This information is
> intended only for the use of the individual(s) or entity to whom it is
> intended even if addressed incorrectly. Please delete it from your files
> if you are not the intended recipient. Thank you for your compliance.©
> Copyright 2002 CIGNA
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
> http://www.ryci.com/db2-l. The owners of the list can be reached at
> [login to unmask email]



Colin Clayton

Re: Auto Bind
(in response to Francis C - CNF Leblanc)
Jobi,

assuming that your program contains only static SQL, there is no Bind option
that will do this. You could get some reoptimization by binding with
REOPT(VARS) perhaps, or change the program to execute dynamic SQL. Remember
there will be an overhead to prepare the dynamic statements.



Jobi M B225 Augustine

Re: Auto Bind
(in response to Colin Clayton)
Hi,

Thanks for all the responses.

One of our DB2 applications is choosing different access path depending on
the volume of data for the clients. So somebody came up with an idea of
forcing DB2 to take the best access path each time it runs !!

Hope it is not a good practice !!

Thanks and best regards,

a Jobi Augustine
CIGNA Systems - ES IM &T
* Tel (860) 226-5466 (6-5466)
* Fax (860) 226-5344 (6-5344)
* Mail [login to unmask email] <mailto:[login to unmask email]>

Confidential, unpublished property of CIGNA. Do not duplicate or distribute.
Use and distribution limited solely to authorized personnel. © Copyright
2002 by CIGNA.




-----Original Message-----
From: Jeff A L'Italien [SMTP:[login to unmask email]
Sent: Wednesday, January 09, 2002 12:04 PM
To: [login to unmask email]
Subject: Re: Auto Bind

Jobi,

To my knowledge their is no such option/parm. An automatic bind
normally only
occurs when a package/plan becomes invalidated due to a dropped
dependent
object. Just out of curiousity, why would there be a need to have
this done?

Regards,
Jeff L'Italien
American Express



From: "Augustine, Jobi M B225" <[login to unmask email]>@RYCI.COM>
on
01/09/2002 11:22 AM EST

Please respond to "DB2 Data Base Discussion List" <[login to unmask email]>

Sent by: "DB2 Data Base Discussion List" <[login to unmask email]>


To: [login to unmask email]
cc:
Subject: Auto Bind


Hi list,

I would appreciate if somebody could tell me the bind parameter that
we need
to set to make the program as an auto bind program. I like to bind
the
program automatically each time the program runs. We use OS390 / DB2
V6.

Is it any of the parameters that are specified below ?

Thanks in advance !!

//BINDAPKG EXEC PGM=IKJEFT01,DYNAMNBR=99
//STEPLIB DD DSN=TTAA.TS2.DB2.APFLIB,DISP=SHR
//DBRMLIB DD DSN=TEST.DB2T.DBRMLIB,DISP=SHR
//*
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DB2T)
BIND MEMBER(GVQ01600) -
PACKAGE(VQ0_BATCH) -
ACTION(REPLACE) -
QUALIFIER(GVQ0) -
EXPLAIN(NO) -
FLAG(I) -
ISOLATION(CS) -
RELEASE(COMMIT) -
VALIDATE(BIND)


Thanks and best regards,

a Jobi Augustine
CIGNA Systems - ES IM &T
* Tel (860) 226-5466 (6-5466)
* Fax (860) 226-5344 (6-5344)
* Mail [login to unmask email] <mailto:[login to unmask email]>

Confidential, unpublished property of CIGNA. Do not duplicate or
distribute.
Use and distribution limited solely to authorized personnel. ©
Copyright
2002 by CIGNA.





----------------------------------------------------------------------------
--
CONFIDENTIALITY NOTICE: If you have received this e-mail in error,
please
immediately notify the sender by e-mail at the address shown. This
e-mail
transmission may contain confidential information. This information
is
intended only for the use of the individual(s) or entity to whom it
is intended
even if addressed incorrectly. Please delete it from your files if
you are not
the intended recipient. Thank you for your compliance.© Copyright
2002 CIGNA

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++



visit the
DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list
can be




=======================To change your
subscription options or to cancel your subscription visit the DB2-L webpage
at http://www.ryci.com/db2-l. The owners of the list can be reached at
[login to unmask email]

------------------------------------------------------------------------------
CONFIDENTIALITY NOTICE: If you have received this e-mail in error, please immediately notify the sender by e-mail at the address shown. This e-mail transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. © Copyright 2002 CIGNA

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++



Francis C - CNF Leblanc

Re: Auto Bind
(in response to Jobi M B225 Augustine)
In order for the VALIDATE(RUN) to use a different access path given that the
volume of data is changing between runs, you will need to execute a RUNSTATS
to insure that the catalog has current statistics.

> -----Original Message-----
> From: Augustine, Jobi M B225 [SMTP:[login to unmask email]
> Sent: Wednesday, January 09, 2002 9:54 AM
> To: [login to unmask email]
> Subject: Re: Auto Bind
>
> Hi,
>
> Thanks for all the responses.
>
> One of our DB2 applications is choosing different access path depending on
> the volume of data for the clients. So somebody came up with an idea of
> forcing DB2 to take the best access path each time it runs !!
>
> Hope it is not a good practice !!
>
> Thanks and best regards,
>
> a Jobi Augustine
> CIGNA Systems - ES IM &T
> * Tel (860) 226-5466 (6-5466)
> * Fax (860) 226-5344 (6-5344)
> * Mail [login to unmask email] <mailto:[login to unmask email]>
>
> Confidential, unpublished property of CIGNA. Do not duplicate or
> distribute.
> Use and distribution limited solely to authorized personnel. © Copyright
> 2002 by CIGNA.
>
>
>
>
> -----Original Message-----
> From: Jeff A L'Italien [SMTP:[login to unmask email]
> Sent: Wednesday, January 09, 2002 12:04 PM
> To: [login to unmask email]
> Subject: Re: Auto Bind
>
> Jobi,
>
> To my knowledge their is no such option/parm. An automatic bind
> normally only
> occurs when a package/plan becomes invalidated due to a dropped
> dependent
> object. Just out of curiousity, why would there be a need to have
> this done?
>
> Regards,
> Jeff L'Italien
> American Express
>
>
>
> From: "Augustine, Jobi M B225"
> <[login to unmask email]>@RYCI.COM>
> on
> 01/09/2002 11:22 AM EST
>
> Please respond to "DB2 Data Base Discussion List" <[login to unmask email]>
>
> Sent by: "DB2 Data Base Discussion List" <[login to unmask email]>
>
>
> To: [login to unmask email]
> cc:
> Subject: Auto Bind
>
>
> Hi list,
>
> I would appreciate if somebody could tell me the bind parameter
> that
> we need
> to set to make the program as an auto bind program. I like to bind
> the
> program automatically each time the program runs. We use OS390 /
> DB2
> V6.
>
> Is it any of the parameters that are specified below ?
>
> Thanks in advance !!
>
> //BINDAPKG EXEC PGM=IKJEFT01,DYNAMNBR=99
> //STEPLIB DD DSN=TTAA.TS2.DB2.APFLIB,DISP=SHR
> //DBRMLIB DD DSN=TEST.DB2T.DBRMLIB,DISP=SHR
> //*
> //SYSTSPRT DD SYSOUT=*
> //SYSPRINT DD SYSOUT=*
> //SYSTSIN DD *
> DSN SYSTEM(DB2T)
> BIND MEMBER(GVQ01600) -
> PACKAGE(VQ0_BATCH) -
> ACTION(REPLACE) -
> QUALIFIER(GVQ0) -
> EXPLAIN(NO) -
> FLAG(I) -
> ISOLATION(CS) -
> RELEASE(COMMIT) -
> VALIDATE(BIND)
>
>
> Thanks and best regards,
>
> a Jobi Augustine
> CIGNA Systems - ES IM &T
> * Tel (860) 226-5466 (6-5466)
> * Fax (860) 226-5344 (6-5344)
> * Mail [login to unmask email] <mailto:[login to unmask email]>
>
> Confidential, unpublished property of CIGNA. Do not duplicate or
> distribute.
> Use and distribution limited solely to authorized personnel. ©
> Copyright
> 2002 by CIGNA.
>
>
>
>
>
> --------------------------------------------------------------------------
> --
> --
> CONFIDENTIALITY NOTICE: If you have received this e-mail in error,
> please
> immediately notify the sender by e-mail at the address shown.
> This
> e-mail
> transmission may contain confidential information. This
> information
> is
> intended only for the use of the individual(s) or entity to whom
> it
> is intended
> even if addressed incorrectly. Please delete it from your files
> if
> you are not
> the intended recipient. Thank you for your compliance.© Copyright
> 2002 CIGNA
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
> visit the
> DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list
> can be
>
>
>
>
> =======================To change your
> subscription options or to cancel your subscription visit the DB2-L
> webpage
> at http://www.ryci.com/db2-l. The owners of the list can be reached at
> [login to unmask email]
>
> --------------------------------------------------------------------------
> ----
> CONFIDENTIALITY NOTICE: If you have received this e-mail in error, please
> immediately notify the sender by e-mail at the address shown. This e-mail
> transmission may contain confidential information. This information is
> intended only for the use of the individual(s) or entity to whom it is
> intended even if addressed incorrectly. Please delete it from your files
> if you are not the intended recipient. Thank you for your compliance. ©
> Copyright 2002 CIGNA
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
> http://www.ryci.com/db2-l. The owners of the list can be reached at
> [login to unmask email]



Larry Jardine

Re: Auto Bind
(in response to Francis C - CNF Leblanc)
I believe that VALIDATE(RUN) only validates the existence and validity of
the tables and DB2 access authority. This parm does not change the access
path. REOPT(VARS) will re-evaluate access paths at runtime.

-----Original Message-----
From: Leblanc, Francis C - CNF [mailto:[login to unmask email]
Sent: Wednesday, January 09, 2002 1:40 PM
To: [login to unmask email]
Subject: Re: Auto Bind


In order for the VALIDATE(RUN) to use a different access path given that the
volume of data is changing between runs, you will need to execute a RUNSTATS
to insure that the catalog has current statistics.



John Hardy

Re: Auto Bind
(in response to Larry Jardine)
As you will need to Run the RUNSTATS utility anyway (whenever the 'volume
of data' changes), why not rebind your plan/package as an additional step?

I suspect that whoever came up with the idea you mention had forgotten
about the need for RUNSTATS....


On Wed, 9 Jan 2002 12:53:46 -0500, Augustine, Jobi M B225
<[login to unmask email]> wrote:

>Hi,
>
>Thanks for all the responses.
>
>One of our DB2 applications is choosing different access path depending on
>the volume of data for the clients. So somebody came up with an idea of
>forcing DB2 to take the best access path each time it runs !!
>
>Hope it is not a good practice !!
>
>Thanks and best regards,
>
>a Jobi Augustine
>CIGNA Systems - ES IM &T
>* Tel (860) 226-5466 (6-5466)
>* Fax (860) 226-5344 (6-5344)
>* Mail [login to unmask email] <mailto:[login to unmask email]>
>
>Confidential, unpublished property of CIGNA. Do not duplicate or
distribute.
>Use and distribution limited solely to authorized personnel. © Copyright
>2002 by CIGNA.
>
>
>
>
> -----Original Message-----
> From: Jeff A L'Italien [SMTP:[login to unmask email]
> Sent: Wednesday, January 09, 2002 12:04 PM
> To: [login to unmask email]
> Subject: Re: Auto Bind
>
> Jobi,
>
> To my knowledge their is no such option/parm. An automatic bind
>normally only
> occurs when a package/plan becomes invalidated due to a dropped
>dependent
> object. Just out of curiousity, why would there be a need to have
>this done?
>
> Regards,
> Jeff L'Italien
> American Express
>
>
>
> From: "Augustine, Jobi M B225" <[login to unmask email]>@RYCI.COM>
>on
> 01/09/2002 11:22 AM EST
>
> Please respond to "DB2 Data Base Discussion List" <[login to unmask email]>
>
> Sent by: "DB2 Data Base Discussion List" <[login to unmask email]>
>
>
> To: [login to unmask email]
> cc:
> Subject: Auto Bind
>
>
> Hi list,
>
> I would appreciate if somebody could tell me the bind parameter
that
>we need
> to set to make the program as an auto bind program. I like to bind
>the
> program automatically each time the program runs. We use OS390 /
DB2
>V6.
>
> Is it any of the parameters that are specified below ?
>
> Thanks in advance !!
>
> //BINDAPKG EXEC PGM=IKJEFT01,DYNAMNBR=99
> //STEPLIB DD DSN=TTAA.TS2.DB2.APFLIB,DISP=SHR
> //DBRMLIB DD DSN=TEST.DB2T.DBRMLIB,DISP=SHR
> //*
> //SYSTSPRT DD SYSOUT=*
> //SYSPRINT DD SYSOUT=*
> //SYSTSIN DD *
> DSN SYSTEM(DB2T)
> BIND MEMBER(GVQ01600) -
> PACKAGE(VQ0_BATCH) -
> ACTION(REPLACE) -
> QUALIFIER(GVQ0) -
> EXPLAIN(NO) -
> FLAG(I) -
> ISOLATION(CS) -
> RELEASE(COMMIT) -
> VALIDATE(BIND)
>
>
> Thanks and best regards,
>
> a Jobi Augustine
> CIGNA Systems - ES IM &T
> * Tel (860) 226-5466 (6-5466)
> * Fax (860) 226-5344 (6-5344)
> * Mail [login to unmask email] <mailto:[login to unmask email]>
>
> Confidential, unpublished property of CIGNA. Do not duplicate or
>distribute.
> Use and distribution limited solely to authorized personnel. ©
>Copyright
> 2002 by CIGNA.
>
>
>
>
>
>---------------------------------------------------------------------------
-
>--
> CONFIDENTIALITY NOTICE: If you have received this e-mail in error,
>please
> immediately notify the sender by e-mail at the address shown. This
>e-mail
> transmission may contain confidential information. This
information
>is
> intended only for the use of the individual(s) or entity to whom it
>is intended
> even if addressed incorrectly. Please delete it from your files if
>you are not
> the intended recipient. Thank you for your compliance.© Copyright
>2002 CIGNA
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
>visit the
> DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list
>can be
>
>
>
>
> =======================To change your
>subscription options or to cancel your subscription visit the DB2-L webpage
>at http://www.ryci.com/db2-l. The owners of the list can be reached at
>[login to unmask email]
>
>---------------------------------------------------------------------------
---
>CONFIDENTIALITY NOTICE: If you have received this e-mail in error, please
immediately notify the sender by e-mail at the address shown. This e-mail
transmission may contain confidential information. This information is
intended only for the use of the individual(s) or entity to whom it is
intended even if addressed incorrectly. Please delete it from your files
if you are not the intended recipient. Thank you for your compliance. ©
Copyright 2002 CIGNA
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>

http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-
[login to unmask email]



Sanjeev (CTS) S

Re: Auto Bind
(in response to John Hardy)
I think Jeff explained it very clearly. There is no such Bind parameter
exists which does the Auto Bind of program each time it runs. VALIDATE(RUN)
checks for the object existence and authorizations. REOPT(VARS) reoptimize
each and every SQLs in the plan as and when it is executed (even if it is
executed repeatedly, depends on the values of the host vars) not the whole
plans at a time during the begining of execution.

Also with reference to your 2nd mail, there is no such gurantee that if you
bind the plan each and every time it will choose the best access path.
Instead of doing all these, it is better to identify the SQL(s) with
problems and tune it for the better performance.

Hope this helps...

With Best Regards,
Sanjeev
IBM Certified Solutions Expert
DB2 UDB V7.1 Database Administration OS/390


> -----Original Message-----
> From: Augustine, Jobi M B225 [SMTP:[login to unmask email]
> Sent: Wednesday, January 09, 2002 9:53 PM
> To: [login to unmask email]
> Subject: Auto Bind
>
> Hi list,
>
> I would appreciate if somebody could tell me the bind parameter that we
> need
> to set to make the program as an auto bind program. I like to bind the
> program automatically each time the program runs. We use OS390 / DB2 V6.
>
> Is it any of the parameters that are specified below ?
>
> Thanks in advance !!
>
> //BINDAPKG EXEC PGM=IKJEFT01,DYNAMNBR=99
> //STEPLIB DD DSN=TTAA.TS2.DB2.APFLIB,DISP=SHR
> //DBRMLIB DD DSN=TEST.DB2T.DBRMLIB,DISP=SHR
> //*
> //SYSTSPRT DD SYSOUT=*
> //SYSPRINT DD SYSOUT=*
> //SYSTSIN DD *
> DSN SYSTEM(DB2T)
> BIND MEMBER(GVQ01600) -
> PACKAGE(VQ0_BATCH) -
> ACTION(REPLACE) -
> QUALIFIER(GVQ0) -
> EXPLAIN(NO) -
> FLAG(I) -
> ISOLATION(CS) -
> RELEASE(COMMIT) -
> VALIDATE(BIND)
>
>
> Thanks and best regards,
>
> a Jobi Augustine
> CIGNA Systems - ES IM &T
> * Tel (860) 226-5466 (6-5466)
> * Fax (860) 226-5344 (6-5344)
> * Mail [login to unmask email] <mailto:[login to unmask email]>
>
> Confidential, unpublished property of CIGNA. Do not duplicate or
> distribute.
> Use and distribution limited solely to authorized personnel. © Copyright
> 2002 by CIGNA.
>
>
>
>
> --------------------------------------------------------------------------
> ----
> CONFIDENTIALITY NOTICE: If you have received this e-mail in error, please
> immediately notify the sender by e-mail at the address shown. This e-mail
> transmission may contain confidential information. This information is
> intended only for the use of the individual(s) or entity to whom it is
> intended even if addressed incorrectly. Please delete it from your files
> if you are not the intended recipient. Thank you for your compliance.©
> Copyright 2002 CIGNA
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
> http://www.ryci.com/db2-l. The owners of the list can be reached at
> [login to unmask email]



Eric Pearson

Re: Auto Bind
(in response to Sanjeev (CTS) S)
in that case the answer is REOPT(VARS)

Regards,
eric pearson
NS ITO Database Support


-----Original Message-----
From: Augustine, Jobi M B225 [mailto:[login to unmask email]
Sent: Wednesday, January 09, 2002 12:54 PM
To: [login to unmask email]
Subject: Re: Auto Bind


Hi,

Thanks for all the responses.

One of our DB2 applications is choosing different access path depending =
on
the volume of data for the clients. So somebody came up with an idea of
forcing DB2 to take the best access path each time it runs !!=20

Hope it is not a good practice !!

Thanks and best regards,

a Jobi Augustine
CIGNA Systems - ES IM &T
* Tel (860) 226-5466 (6-5466)
* Fax (860) 226-5344 (6-5344)
* Mail [login to unmask email] <mailto:[login to unmask email]>=20

Confidential, unpublished property of CIGNA. Do not duplicate or =
distribute.
Use and distribution limited solely to authorized personnel. =A9 =
Copyright
2002 by CIGNA.




-----Original Message-----
From: Jeff A L'Italien [SMTP:[login to unmask email]
Sent: Wednesday, January 09, 2002 12:04 PM
To: [login to unmask email]
Subject: Re: Auto Bind

Jobi,

To my knowledge their is no such option/parm. An automatic bind
normally only
occurs when a package/plan becomes invalidated due to a dropped
dependent
object. Just out of curiousity, why would there be a need to have
this done?

Regards,
Jeff L'Italien
American Express



From: "Augustine, Jobi M B225" <[login to unmask email]>@RYCI.COM>
on
01/09/2002 11:22 AM EST

Please respond to "DB2 Data Base Discussion List" <[login to unmask email]>

Sent by: "DB2 Data Base Discussion List" <[login to unmask email]>


To: [login to unmask email]
cc:
Subject: Auto Bind


Hi list,

I would appreciate if somebody could tell me the bind parameter that
we need
to set to make the program as an auto bind program. I like to bind
the
program automatically each time the program runs. We use OS390 / DB2
V6.

Is it any of the parameters that are specified below ?

Thanks in advance !!

//BINDAPKG EXEC PGM=3DIKJEFT01,DYNAMNBR=3D99
//STEPLIB DD DSN=3DTTAA.TS2.DB2.APFLIB,DISP=3DSHR
//DBRMLIB DD DSN=3DTEST.DB2T.DBRMLIB,DISP=3DSHR
//*
//SYSTSPRT DD SYSOUT=3D*
//SYSPRINT DD SYSOUT=3D*
//SYSTSIN DD *
DSN SYSTEM(DB2T)
BIND MEMBER(GVQ01600) -
PACKAGE(VQ0_BATCH) -
ACTION(REPLACE) -
QUALIFIER(GVQ0) -
EXPLAIN(NO) -
FLAG(I) -
ISOLATION(CS) -
RELEASE(COMMIT) -
VALIDATE(BIND)


Thanks and best regards,

a Jobi Augustine
CIGNA Systems - ES IM &T
* Tel (860) 226-5466 (6-5466)
* Fax (860) 226-5344 (6-5344)
* Mail [login to unmask email] <mailto:[login to unmask email]>

Confidential, unpublished property of CIGNA. Do not duplicate or
distribute.
Use and distribution limited solely to authorized personnel. =A9
Copyright
2002 by CIGNA.




=09
------------------------------------------------------------------------=
----
--
CONFIDENTIALITY NOTICE: If you have received this e-mail in error,
please
immediately notify the sender by e-mail at the address shown. This
e-mail
transmission may contain confidential information. This information
is
intended only for the use of the individual(s) or entity to whom it
is intended
even if addressed incorrectly. Please delete it from your files if
you are not
the intended recipient. Thank you for your compliance.=A9 Copyright
2002 CIGNA

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=


visit the
DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list
can be




=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3DTo =
change your
subscription options or to cancel your subscription visit the DB2-L =
webpage
at http://www.ryci.com/db2-l. The owners of the list can be reached at
[login to unmask email]

----------------------------------------------------------------------------
--
CONFIDENTIALITY NOTICE: If you have received this e-mail in error, please
immediately notify the sender by e-mail at the address shown. This e-mail
transmission may contain confidential information. This information is
intended only for the use of the individual(s) or entity to whom it is
intended even if addressed incorrectly. Please delete it from your files if
you are not the intended recipient. Thank you for your compliance. ©
Copyright 2002 CIGNA

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++