DB2 v8 on z/os

Martin Flavell

DB2 v8 on z/os
Hi,

Is there any way to get rid of an ssi definition dynamically, so it can be added in again, without having to do an ipl?

An ipl was done yesterday on one of our systems, to add DB2 for the first time, and the subsystem entries were defined, but the early code was missed out of lpa/link. These have now been added dynamically, but the subsystems cannot be activated. New subsystems invoke the early code, using setssi add, but I'm trying to get the ones already defined into use.
    
Regards,  

Martin Flavell

-------------------------------------------------------------------------
IBM Certified Solutions Expert -- DB2 V7.1 Database Administration for OS/390
IBM Certified Database Administrator -- DB2 UDB V8.1 for Linux, Unix, Windows
-------------------------------------------------------------------------
Technical Consultant
Thesaurus Computer Services Ltd.
Technical Infrastructure and Professional Services

[login to unmask email]
Telephone:01908 246500.    Fax:01908 246555.    
WWW: www.i-tcs.com  

________________________________________________________________________

This email is confidential and intended solely for the use of the individual to whom it is
addressed. Any views or opinions presented are solely those of the author and do not
necessarily represent those of Thesaurus Computer Services. If you are not the
intended recipient, be advised that you have received this email in error and that any
use, dissemination, forwarding, printing, or copying of this email is prohibited. If you
have received this email in error please notify the sender, or [login to unmask email],
by e-mail or telephone +44 (0)1908-246500

Thesaurus Computer Services.
Bank House, 171 Midsummer Boulevard, Central Milton Keynes, MK9 1EB, United Kingdom

Company registration number: 2069568
________________________________________________________________________

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at www.idug.org under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more.
If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services

Christopher Tee

Re: DB2 v8 on z/os
(in response to Martin Flavell)
Martin

Unfortunately, the erly code can only be loaded by an IPL. If the erly
code is available, you should see a DSN3100I message at IPL time.


Chris Tee
DB2 Systems Programmer
Database Team
SSO IGA Technical Services
Internal Tel: 250072 External Tel: 023 9256 0072



[login to unmask email]
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
18/01/2008 11:53
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc

Subject
[DB2-L] DB2 v8 on z/os






Hi,

Is there any way to get rid of an ssi definition dynamically, so it can be
added in again, without having to do an ipl?

An ipl was done yesterday on one of our systems, to add DB2 for the first
time, and the subsystem entries were defined, but the early code was
missed out of lpa/link. These have now been added dynamically, but the
subsystems cannot be activated. New subsystems invoke the early code,
using setssi add, but I'm trying to get the ones already defined into use.

Regards,

Martin Flavell

-------------------------------------------------------------------------
IBM Certified Solutions Expert -- DB2 V7.1 Database Administration for
OS/390
IBM Certified Database Administrator -- DB2 UDB V8.1 for Linux, Unix,
Windows
-------------------------------------------------------------------------
Technical Consultant
Thesaurus Computer Services Ltd.
Technical Infrastructure and Professional Services

[login to unmask email]
Telephone:01908 246500. Fax:01908 246555.
WWW: www.i-tcs.com

________________________________________________________________________

This email is confidential and intended solely for the use of the
individual to whom it is
addressed. Any views or opinions presented are solely those of the author
and do not
necessarily represent those of Thesaurus Computer Services. If you are not
the
intended recipient, be advised that you have received this email in error
and that any
use, dissemination, forwarding, printing, or copying of this email is
prohibited. If you
have received this email in error please notify the sender, or
[login to unmask email],
by e-mail or telephone +44 (0)1908-246500

Thesaurus Computer Services.
Bank House, 171 Midsummer Boulevard, Central Milton Keynes, MK9 1EB,
United Kingdom

Company registration number: 2069568
________________________________________________________________________

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list archives, the FAQ, and delivery preferences are at www.idug.org under
the Listserv tab. While at the site, you can also access the IDUG Online
Learning Center, Tech Library and Code Place, see the latest IDUG
conference information, and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services






Unless stated otherwise above:
IBM United Kingdom Limited - Registered in England and Wales with number
741598.
Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU






The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

James Campbell

Re: DB2 v8 on z/os
(in response to Christopher Tee)
Some time in the past week I read something about some code in SYS1.SAMPLIB that
removes a subsystem from the SSVT chain. I just noted it and moved on. From memory the
query was from someone who had forgotten to include the early code parameters, so just
had the basic definition.

You are looking for something with IEFSSN and DEACTIVATE.

James Campbell
>
> [login to unmask email]
> Sent by: DB2 Data Base Discussion List
> Subject [DB2-L] DB2 v8 on z/os
>
> Hi,
>
> Is there any way to get rid of an ssi definition dynamically, so it can be added in again, without
> having to do an ipl?
>
> An ipl was done yesterday on one of our systems, to add DB2 for the first time, and the
> subsystem entries were defined, but the early code was missed out of lpa/link. These have now
> been added dynamically, but the subsystems cannot be activated. New subsystems invoke the
> early code, using setssi add, but I'm trying to get the ones already defined into use.
>
> Regards,
>
> Martin Flavell
>

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Cathy Taddei

Re: DB2 v8 on z/os
(in response to James Campbell)
I searched SYS1.SAMPLIB, and found nothing like what you read about,
James. Could it have been a reference to the share tapes or something?
We're on z/OS 1.7.

Martin, you can try the SETSSI DEACT,S=ssn command, but I am not
optimistic. I did some testing a few months ago, and while I was able
to successfully add subsystems, I was never able to deactivate one, even
one with only basic parameters that I had dynamically added. Please let
me know if you have any success with it.

Thanks,
Cathy

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of [login to unmask email]
Sent: Friday, January 18, 2008 10:54 PM
To: [login to unmask email]
Subject: Re: DB2 v8 on z/os

Some time in the past week I read something about some code in
SYS1.SAMPLIB that
removes a subsystem from the SSVT chain. I just noted it and moved on.
From memory the
query was from someone who had forgotten to include the early code
parameters, so just
had the basic definition.

You are looking for something with IEFSSN and DEACTIVATE.

James Campbell
>
> [login to unmask email]
> Sent by: DB2 Data Base Discussion List
> Subject [DB2-L] DB2 v8 on z/os
>
> Hi,
>
> Is there any way to get rid of an ssi definition dynamically, so it
can be added in again, without
> having to do an ipl?
>
> An ipl was done yesterday on one of our systems, to add DB2 for the
first time, and the
> subsystem entries were defined, but the early code was missed out of
lpa/link. These have now
> been added dynamically, but the subsystems cannot be activated. New
subsystems invoke the
> early code, using setssi add, but I'm trying to get the ones already
defined into use.
>
> Regards,
>
> Martin Flavell

------------------------------------------------------------------------------

This email is confidential and may be legally privileged.

It is intended solely for the addressee. Access to this email by anyone else, unless expressly approved by the sender or an authorized addressee, is unauthorized.

If you are not the intended recipient, any disclosure, copying, distribution or any action omitted or taken in reliance on it, is prohibited and may be unlawful. If you believe that you have received this email in error, please contact the sender, delete this e-mail and destroy all copies.

=====

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Avram Friedman

Re: DB2 v8 on z/os
(in response to Cathy Taddei)
Based on the need to avoid an IPL I also assume you wish to avoid a good
chance of a system crash. To the extent that this assumption is true there is
no good method for removing or modifying a DB2 entry in an active SSI table
with out an IPL.

Should you be interested in DB2 unsupported methodoligies that are risky I
would suggest reviewing the IEFSSVT macro in the MVS Programming
Authorized Programming Reference.

In addition if you hope to remove a member forever review 1997 Q&As Usage
items RS4000008376 and RTA000099573.

Please recall, under ideal conditions an IPL may not be required to start this
process, but several system crashes and all night / all week recoveries are to
be expected. Also in the case of removing a member from a data sharing
group, a group restart will be needed (The BSDS needs to change).

Regards
Avram Friedman

On Tue, 22 Jan 2008 11:49:16 -0800, Taddei, Cathy
<[login to unmask email]> wrote:

>I searched SYS1.SAMPLIB, and found nothing like what you read about,
>James. Could it have been a reference to the share tapes or something?
>We're on z/OS 1.7.
>
>Martin, you can try the SETSSI DEACT,S=ssn command, but I am not
>optimistic. I did some testing a few months ago, and while I was able
>to successfully add subsystems, I was never able to deactivate one, even
>one with only basic parameters that I had dynamically added. Please let
>me know if you have any success with it.
>
>Thanks,
>Cathy
>
>-----Original Message-----
>From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
>Behalf Of [login to unmask email]
>Sent: Friday, January 18, 2008 10:54 PM
>To: [login to unmask email]
>Subject: Re: DB2 v8 on z/os
>
>Some time in the past week I read something about some code in
>SYS1.SAMPLIB that
>removes a subsystem from the SSVT chain. I just noted it and moved on.
>From memory the
>query was from someone who had forgotten to include the early code
>parameters, so just
>had the basic definition.
>
>You are looking for something with IEFSSN and DEACTIVATE.
>
>James Campbell
>>
>> [login to unmask email]
>> Sent by: DB2 Data Base Discussion List
>> Subject [DB2-L] DB2 v8 on z/os
>>
>> Hi,
>>
>> Is there any way to get rid of an ssi definition dynamically, so it
>can be added in again, without
>> having to do an ipl?
>>
>> An ipl was done yesterday on one of our systems, to add DB2 for the
>first time, and the
>> subsystem entries were defined, but the early code was missed out of
>lpa/link. These have now
>> been added dynamically, but the subsystems cannot be activated. New
>subsystems invoke the
>> early code, using setssi add, but I'm trying to get the ones already
>defined into use.
>>
>> Regards,
>>
>> Martin Flavell
>
>--------------------------------------------------------------------------
----

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms