DB2 V8 and Z/os - Forcing bind

Scott Hodgin

DB2 V8 and Z/os - Forcing bind
Periodically, we need to get an emergency CICS/DB2 program compiled and
bound to our production environment. Many times there are cached threads
that prevent the bind from occurring. Is there a way (short of
terminating all active threads) to force this bind though? Surely 24/7
shops have a need to force a bind through.




Scott Hodgin

Database Administrator, MCITP
South Carolina Farm Bureau Insurance Company

[login to unmask email]



_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.IDUG.org membership is now free.
Do you have people in your office who are not an IDUG member?
Show them how to access the information and help train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Jorg Lueke

Re: DB2 V8 and Z/os - Forcing bind
(in response to Scott Hodgin)
Are you using package versioning?


On Mon, 11 Jan 2010 10:27:44 -0600, Hodgin, Scott
<[login to unmask email]> wrote:

>Periodically, we need to get an emergency CICS/DB2 program compiled
and
>bound to our production environment. Many times there are cached threads
>that prevent the bind from occurring. Is there a way (short of
>terminating all active threads) to force this bind though? Surely 24/7
>shops have a need to force a bind through.
>
>
>
>
>Scott Hodgin
>
>Database Administrator, MCITP
>South Carolina Farm Bureau Insurance Company
>
>[login to unmask email]
>
>
>
>__________________________________________________________
___________
>
>* IDUG North America * Tampa, Florida, * May 10-14 2010 *
http://IDUG.ORG/NA *
>__________________________________________________________
___________
>
>http://www.IDUG.org membership is now free.
>Do you have people in your office who are not an IDUG member?
>Show them how to access the information and help train the next generation
of DB2 Users!
>__________________________________________________________
___________
>
>If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's DB2-L
>

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/events/index.html is your DB2 Events calendar! RUG meetings,
Webcasts, Conferences- what is going on next?
RUG leaders- get your events on the calendar today!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L