SDSNEXIT

Michael Bancale

SDSNEXIT
We currently have one SDSNEXIT loadlib for each DB2 Subsystem. I cannot
recall the reason we choose this method but we did. Now one of our systems
guys has asked if we could only have one SDSNEXIT loadlib to put in our link
list and not have to steplib this guy.

What is the standard practice?

TIA


Michael Bancale
[login to unmask email]
Texas Farm Bureau Insurance Company
www.txfb-ins.com
Waco, Texas

Kenneth Kornblum

Re: SDSNEXIT
(in response to Michael Bancale)
Hi Michael,

You probably did that so you could have individual DSNZPARMs for each ssid
without having to establish a naming convention for them (i.e. they're all
named DSNZPARM). Or maybe you're using different [login to unmask email], DSNHDECP or
[login to unmask email] versions (or some such thing) in various subsystems, and having
these in your SDSNEXIT is an easy way to manage that.

Those are generally the reasons I've seen.

HTH,
Ken Kornblum
Product Developer
BMC Software

-----Original Message-----
From: Michael Bancale [mailto:[login to unmask email]
Sent: Thursday, October 07, 1999 9:52 AM
To: [login to unmask email]
Subject: [DB2-L] SDSNEXIT


We currently have one SDSNEXIT loadlib for each DB2 Subsystem. I cannot
recall the reason we choose this method but we did. Now one of our systems
guys has asked if we could only have one SDSNEXIT loadlib to put in our link
list and not have to steplib this guy.

What is the standard practice?

TIA


Michael Bancale
[login to unmask email]
Texas Farm Bureau Insurance Company
www.txfb-ins.com
Waco, Texas

Bill Welch

Re: SDSNEXIT
(in response to Kenneth Kornblum)
We have one SDSNEXIT per DB2 subsystem, and that's the method I've seen at
other shops.

If you use the method suggested, you'll have to have a different name for
DSNZPARM for each DB2 subsystem, since this is located in SDSNEXIT, and
specify that unique name in each -START DB2 command.

You'll also have to devise a procedure for the occasions when you apply
PTFs to DB2 (you want to test them first before applying them to a running
system) and when you upgrade to a new version of DB2 (you normally want to
upgrade one subsystem at a time).

MVS systems programmers seem to like to push for putting DB2 libraries in
the LINKLIST, but I've found this usually causes more problems than it's
worth. It seems to be most troublesome on those occasions when you apply
PTFs to DB2 or upgrade to a new version. There are always some users who
put in a STEPLIB or JOBLIB card when they shouldn't or leave them out when
they shouldn't. This generates a lot of problem calls, and you have to do
a lot of research to see which library they're using.

Bill Welch

>At 09:52 AM 10/7/99 -0500, Michael Bancale wrote:
>We currently have one SDSNEXIT loadlib for each DB2 Subsystem. I cannot
>recall the reason we choose this method but we did. Now one of our systems
>guys has asked if we could only have one SDSNEXIT loadlib to put in our link
>list and not have to steplib this guy.
>
>What is the standard practice?
>
>TIA
>
>
>Michael Bancale
>[login to unmask email]
>Texas Farm Bureau Insurance Company
>www.txfb-ins.com
>Waco, Texas


--


William D. Welch
University of California, Berkeley
Central Computing Services, 502 Banway
510/643-2608
[login to unmask email]

Tim Lowe

Re: SDSNEXIT
(in response to Bill Welch)
Michael,
If you go to 1 SDSNEXIT for multiple DB2 subsystems, then you really cannot use
DB2 IMPLICIT Call Attach.
(you can still use DB2 EXPLICIT call attach, but not IMPLICIT call attach.)
DB2 implicit call attach requires a steplib concatenation with the right
DSNHDECP module for the DB2 subsystem that you want to attach to. (The SDSNEXIT
library is where this module is normally stored.)
Not very many people use this, but I have found it to be handy in some
situations.

Thanks,
Tim







Michael Bancale <[login to unmask email]> on 10/07/99 09:52:07 AM

Please respond to [login to unmask email]








To: [login to unmask email]

cc: (bcc: Tim Lowe/sfm/spc)



Subject: SDSNEXIT








We currently have one SDSNEXIT loadlib for each DB2 Subsystem. I cannot
recall the reason we choose this method but we did. Now one of our systems
guys has asked if we could only have one SDSNEXIT loadlib to put in our link
list and not have to steplib this guy.

What is the standard practice?

TIA


Michael Bancale
[login to unmask email]
Texas Farm Bureau Insurance Company
www.txfb-ins.com
Waco, Texas