DB2 for z/OS v8 Install

teldb2kals

DB2 for z/OS v8 Install
Hi,

I am in the process of installing DB2 v8. The very first installation screen asks if we want to do an INSTALL or UPDATE or MIGRATE or ENFM. I am not sure what to select here, as it mentions that INSTALL would directly generate jobs for New Function Mode, while I would like to first move to compatibility mode.

So, I think I would have to select MIGRATE. But I don't have the old DSNTID member from my v7 install. Should I run the v7 install clist again to generate a DSNTID member ?

Thanks,
Kals.

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

George Palko

Re: DB2 for z/OS v8 Install
(in response to teldb2kals)
Kals,
In your case that is correct. You would want to choose Migrate on the first panel.
As far as DSNTIDX is concerned. If you don't have that member I would recommend rebuilding one. There's various ways to do it.
You could take the DSNTIDXA member copy it to DSNTIDXB and then update DSNTIDXB with the correct values. Or, indeed doing a dummy install would generate the same results. In any case, you have a situation where you're going to have to reconcile you're new DSNTIDX member with the current one that you've lost.

Good Luck,
George

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of teldb2kals
Sent: Tuesday, January 15, 2008 9:48 PM
To: [login to unmask email]
Subject: [DB2-L] DB2 for z/OS v8 Install


Hi,

I am in the process of installing DB2 v8. The very first installation screen asks if we want to do an INSTALL or UPDATE or MIGRATE or ENFM. I am not sure what to select here, as it mentions that INSTALL would directly generate jobs for New Function Mode, while I would like to first move to compatibility mode.

So, I think I would have to select MIGRATE. But I don't have the old DSNTID member from my v7 install. Should I run the v7 install clist again to generate a DSNTID member ?

Thanks,
Kals.

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


-----------------------------------------
CONFIDENTIALITY NOTICE: The Ohio Public Employees Retirement System
intends this e-mail message, and any attachments, to be used only
by the person(s) or entity to which it is addressed. This message
may contain confidential and/or legally privileged information. If
the reader is not the intended recipient of this message or an
employee or agent responsible for delivering the message to the
intended recipient, you are hereby notified that you are prohibited
from printing, copying, storing, disseminating or distributing this
communication. If you received this communication in error, please
delete it from your computer and notify the sender by reply e-mail.

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 for z/OS v8 Install
(in response to George Palko)
If you wish to bring a V7 system to the V8 level then Migrate is the correct
option on the first pannel of the install CLIST.

The V8 IVPs can not be run in V8 CM mode which is why they are not
generated by the install CLIST when Migrate is specified. They will be
generated when you run the CLIST again for ENFM.

Based on my own experience the best way to rebuild the V7 DSNTID member is
1. Make sure you do not have it this is often where the error is ... The
member is stored in the SMPE Target SDSNSAMP (HLQs specified on the first
pannel of the install CLIST) not NEW.SDSNSAMP. Are you looking in the right
place.
2. If you make the mistake of not doing ZPARM updates via the INSTALL
CLIST then:
A) Install (if not allready done) the DSNWZP stored procedure and sample
driver program.
B) Run the driver program it produces a report that includes Pannel ID and
Pannel line number for each ZPARM
C) Sort the report (can be done with the ISPF sort command in edit) by
Pannel ID and Pannel line number
D) Turn on PannelID in ISPF
E) Rerun the install CLIST for V7 with your easy to use sorted report ...
Note some fields require special codeing rules, for example default trace
options, it takes some research to get these right.


One of my personal rules for doing a migration in a rush is a migration is sort of
like a specialized application of service / maintance. For the most part, if
there are steps that provide value (like comparing old to new access paths)
but are not typically done at your shop, rush migration may not be the right
time to start. In the famous words of an old comic strip and movie cartoon "I
is who I is, I am Popyee the Sailor Man" this quote also has a biblical counter
when Moses asked God at the burning bush what he should call God the
response was "I am who I am"

Regards
Avram Friedman

On Wed, 16 Jan 2008 13:48:02 +1100, teldb2kals <[login to unmask email]>
wrote:

>Hi,
>
>I am in the process of installing DB2 v8. The very first installation screen
asks if we want to do an INSTALL or UPDATE or MIGRATE or ENFM. I am not
sure what to select here, as it mentions that INSTALL would directly generate
jobs for New Function Mode, while I would like to first move to compatibility
mode.
>
>So, I think I would have to select MIGRATE. But I don't have the old DSNTID
member from my v7 install. Should I run the v7 install clist again to generate a
DSNTID member ?
>
>Thanks,
>Kals.
>
>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

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

teldb2kals

Re: DB2 for z/OS v8 Install
(in response to Avram Friedman)
Thanks, Avram. That was the big question initially...do we have it somewhere
? Still looking, but not much hopeful now. V7 was installed a few years ago,
by another DBA no longer here, and lots of datasets have changed since then.
The DSNTIDxx member was probably either somewhere else (is this possible?)
or deleted.

By a coincidence, what you suggested was exactly how I started trying to fix
it. I took a printout of the DSNWZP o/p. But I find there are some panel
inputs not in the report (the report is only ZPARMs), like Number of
Databases, etc, and I am still working my way thru those.

Can I just use the defaults supplied on the screens ?
How do I ensure that the new DSNTID member I generate is fairly similar to
my current v7 environment ?
Should I run the v7 install setup for each subsystem, or can I generate 1
DSNTID member and reuse it for all subsystems ?

Thanks,
Kals.

On Wed, 16 Jan 2008 13:27:47 +0000, Avram Friedman
<[login to unmask email]> wrote:

>If you wish to bring a V7 system to the V8 level then Migrate is the correct
>option on the first pannel of the install CLIST.
>
>The V8 IVPs can not be run in V8 CM mode which is why they are not
>generated by the install CLIST when Migrate is specified. They will be
>generated when you run the CLIST again for ENFM.
>
>Based on my own experience the best way to rebuild the V7 DSNTID member is
>1. Make sure you do not have it this is often where the error is ... The
>member is stored in the SMPE Target SDSNSAMP (HLQs specified on the first
>pannel of the install CLIST) not NEW.SDSNSAMP. Are you looking in the right
>place.
>2. If you make the mistake of not doing ZPARM updates via the INSTALL
>CLIST then:
>A) Install (if not allready done) the DSNWZP stored procedure and sample
>driver program.
>B) Run the driver program it produces a report that includes Pannel ID and
>Pannel line number for each ZPARM
>C) Sort the report (can be done with the ISPF sort command in edit) by
>Pannel ID and Pannel line number
>D) Turn on PannelID in ISPF
>E) Rerun the install CLIST for V7 with your easy to use sorted report ...
>Note some fields require special codeing rules, for example default trace
>options, it takes some research to get these right.
>
>
>One of my personal rules for doing a migration in a rush is a migration is
sort of
>like a specialized application of service / maintance. For the most part, if
>there are steps that provide value (like comparing old to new access paths)
>but are not typically done at your shop, rush migration may not be the right
>time to start. In the famous words of an old comic strip and movie cartoon "I
>is who I is, I am Popyee the Sailor Man" this quote also has a biblical
counter
>when Moses asked God at the burning bush what he should call God the
>response was "I am who I am"
>
>Regards
>Avram Friedman
>
>On Wed, 16 Jan 2008 13:48:02 +1100, teldb2kals <[login to unmask email]>
>wrote:
>
>>Hi,
>>
>>I am in the process of installing DB2 v8. The very first installation screen
>asks if we want to do an INSTALL or UPDATE or MIGRATE or ENFM. I am not
>sure what to select here, as it mentions that INSTALL would directly generate
>jobs for New Function Mode, while I would like to first move to compatibility
>mode.
>>
>>So, I think I would have to select MIGRATE. But I don't have the old DSNTID
>member from my v7 install. Should I run the v7 install clist again to
generate a
>DSNTID member ?
>>
>>Thanks,
>>Kals.
>>
>>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
>
>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

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 for z/OS v8 Install
(in response to teldb2kals)
There are a large number of values on the pannels that should be ignored in
setting up a migration.
As you point out they have nothing to do with ZPARMS
And more importantly they do effectivly influance the update migration jobs.

The values you pointed out, Number of databases and other values on the
two sizes pannels DSNTIPD and DSNTIP7 tend to be for space calculations for
the various catalog and directory datasets. I have never had much luck
updating these to get proper sizes generated for the new objects created by
a migration. The Install CLIST is going to generate a kob called DSNTIJIN.
This usually requires a lot of manual editing / sanity checks. There is a sample
on the IDUG code page that helps with the adjustments for ENFM in which
shadows are created for every catalog pageset.

The same is true of the Buffer pools pannels DSNTIP1 and 2, The buffer pool
specifications are retained in the BSDS and are not rebuilt by migration (there
are new required buffer pools and these are generated with min values in
install job.

The pannels that merit extra attention in my opinion are
The calculation pannels at the end DSNTIPC and DSNTIPC1 for EDM and Sort
pools.
Thread management Pannel DSNTIPE to make sure you allow the right number
of threads DBATS CTHREADS etc There are recomendations for changing
these in V8.
The DDF pannels to insure your listener and response ports are correct
When you actually do your migrate the stored procedure pannel DSNTIPX as
there are additional controls.

I don't mean to imply that any pannels are unimportant. The ones I mention
are ones where I have either had problems or I know people who did.

If I could make a quick IDUG confrence plug ... there is a presentation
scheduled by a person from FEDEX Freight on doing fast migrations to V8. I
am sure it would be worth while. I propsed a presention on the same subject
and have wrote fast migrations on the LISTSERV several times but the other
propsal was the accepted one.

Id be happy to help with any questions.

Avram Friedman


On Wed, 16 Jan 2008 18:25:15 +0000, Teldb2kals
<[login to unmask email]> wrote:

>Thanks, Avram. That was the big question initially...do we have it somewhere
>? Still looking, but not much hopeful now. V7 was installed a few years ago,
>by another DBA no longer here, and lots of datasets have changed since
then.
>The DSNTIDxx member was probably either somewhere else (is this possible?)
>or deleted.
>
>By a coincidence, what you suggested was exactly how I started trying to fix
>it. I took a printout of the DSNWZP o/p. But I find there are some panel
>inputs not in the report (the report is only ZPARMs), like Number of
>Databases, etc, and I am still working my way thru those.
>
>Can I just use the defaults supplied on the screens ?
>How do I ensure that the new DSNTID member I generate is fairly similar to
>my current v7 environment ?
>Should I run the v7 install setup for each subsystem, or can I generate 1
>DSNTID member and reuse it for all subsystems ?
>
>Thanks,
>Kals.
>
>On Wed, 16 Jan 2008 13:27:47 +0000, Avram Friedman
><[login to unmask email]> wrote:
>
>>If you wish to bring a V7 system to the V8 level then Migrate is the correct
>>option on the first pannel of the install CLIST.
>>
>>The V8 IVPs can not be run in V8 CM mode which is why they are not
>>generated by the install CLIST when Migrate is specified. They will be
>>generated when you run the CLIST again for ENFM.
>>
>>Based on my own experience the best way to rebuild the V7 DSNTID
member is
>>1. Make sure you do not have it this is often where the error is ... The
>>member is stored in the SMPE Target SDSNSAMP (HLQs specified on the first
>>pannel of the install CLIST) not NEW.SDSNSAMP. Are you looking in the
right
>>place.
>>2. If you make the mistake of not doing ZPARM updates via the INSTALL
>>CLIST then:
>>A) Install (if not allready done) the DSNWZP stored procedure and sample
>>driver program.
>>B) Run the driver program it produces a report that includes Pannel ID and
>>Pannel line number for each ZPARM
>>C) Sort the report (can be done with the ISPF sort command in edit) by
>>Pannel ID and Pannel line number
>>D) Turn on PannelID in ISPF
>>E) Rerun the install CLIST for V7 with your easy to use sorted report ...
>>Note some fields require special codeing rules, for example default trace
>>options, it takes some research to get these right.
>>
>>
>>One of my personal rules for doing a migration in a rush is a migration is
>sort of
>>like a specialized application of service / maintance. For the most part, if
>>there are steps that provide value (like comparing old to new access paths)
>>but are not typically done at your shop, rush migration may not be the right
>>time to start. In the famous words of an old comic strip and movie
cartoon "I
>>is who I is, I am Popyee the Sailor Man" this quote also has a biblical
>counter
>>when Moses asked God at the burning bush what he should call God the
>>response was "I am who I am"
>>
>>Regards
>>Avram Friedman
>>
>>On Wed, 16 Jan 2008 13:48:02 +1100, teldb2kals
<[login to unmask email]>
>>wrote:
>>
>>>Hi,
>>>
>>>I am in the process of installing DB2 v8. The very first installation screen
>>asks if we want to do an INSTALL or UPDATE or MIGRATE or ENFM. I am not
>>sure what to select here, as it mentions that INSTALL would directly
generate
>>jobs for New Function Mode, while I would like to first move to compatibility
>>mode.
>>>
>>>So, I think I would have to select MIGRATE. But I don't have the old
DSNTID
>>member from my v7 install. Should I run the v7 install clist again to
>generate a
>>DSNTID member ?
>>>
>>>Thanks,
>>>Kals.
>>>
>>>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
>>
>>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
>
>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

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 for z/OS v8 Install
(in response to Avram Friedman)
Hi Kals. I have been in this situation before, and I did what George
and Avram suggested and executed the install CLIST in INSTALL mode,
using DSNTIDXA as input. I did not skip any panels or take defaults if
I had good values. I had to list the BSDS to get DDF information. I
didn't count tablespaces; I just took a SWAG and then used the override
fields on panel DSNTIPC to fill in actual values for EDM pool, RID pool,
etc. You don't have to fill in everything just to migrate, but having
accurate values for bufferpools, etc. in DSNTIDxx was a big help to me
later on when I converted to data sharing.

You know you've done it right when the generated DSNTIJUZ matches your
current DSNTIJUZ. Keep in mind that the generated DSNTIJUZ will not
include hidden zparms that your shop may have coded. If they don't
match, run the install clist again in UPDATE mode to make corrections.

Be very careful if you choose to edit DSNTIDxx. In many cases, the
zparm macro parameter name is different from the name used in DSNTIDxx,
and in several cases the scale is different, i.e. one is in Kbytes and
the other is in bytes or 4k pages. That said, you can edit DSNTIDxx to
be used for other similar subsystems by changing the really obvious
things like subsystem name and DDF parameters, then using it as input to
the install clist in UPDATE mode. Compare the output as above and make
corrections. Each subsystem should have its own DSNTIDxx.

HTH,
Cathy

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Teldb2kals
Sent: Wednesday, January 16, 2008 10:25 AM
To: [login to unmask email]
Subject: Re: DB2 for z/OS v8 Install

Thanks, Avram. That was the big question initially...do we have it
somewhere
? Still looking, but not much hopeful now. V7 was installed a few years
ago,
by another DBA no longer here, and lots of datasets have changed since
then.
The DSNTIDxx member was probably either somewhere else (is this
possible?)
or deleted.

By a coincidence, what you suggested was exactly how I started trying to
fix
it. I took a printout of the DSNWZP o/p. But I find there are some panel
inputs not in the report (the report is only ZPARMs), like Number of
Databases, etc, and I am still working my way thru those.

Can I just use the defaults supplied on the screens ?
How do I ensure that the new DSNTID member I generate is fairly similar
to
my current v7 environment ?
Should I run the v7 install setup for each subsystem, or can I generate
1
DSNTID member and reuse it for all subsystems ?

Thanks,
Kals.

On Wed, 16 Jan 2008 13:27:47 +0000, Avram Friedman
<[login to unmask email]> wrote:

>If you wish to bring a V7 system to the V8 level then Migrate is the
correct
>option on the first pannel of the install CLIST.
>
>The V8 IVPs can not be run in V8 CM mode which is why they are not
>generated by the install CLIST when Migrate is specified. They will be
>generated when you run the CLIST again for ENFM.
>
>Based on my own experience the best way to rebuild the V7 DSNTID member
is
>1. Make sure you do not have it this is often where the error is ...
The
>member is stored in the SMPE Target SDSNSAMP (HLQs specified on the
first
>pannel of the install CLIST) not NEW.SDSNSAMP. Are you looking in the
right
>place.
>2. If you make the mistake of not doing ZPARM updates via the INSTALL
>CLIST then:
>A) Install (if not allready done) the DSNWZP stored procedure and
sample
>driver program.
>B) Run the driver program it produces a report that includes Pannel ID
and
>Pannel line number for each ZPARM
>C) Sort the report (can be done with the ISPF sort command in edit) by
>Pannel ID and Pannel line number
>D) Turn on PannelID in ISPF
>E) Rerun the install CLIST for V7 with your easy to use sorted report
...
>Note some fields require special codeing rules, for example default
trace
>options, it takes some research to get these right.
>
>
>One of my personal rules for doing a migration in a rush is a migration
is
sort of
>like a specialized application of service / maintance. For the most
part, if
>there are steps that provide value (like comparing old to new access
paths)
>but are not typically done at your shop, rush migration may not be the
right
>time to start. In the famous words of an old comic strip and movie
cartoon "I
>is who I is, I am Popyee the Sailor Man" this quote also has a
biblical
counter
>when Moses asked God at the burning bush what he should call God the
>response was "I am who I am"
>
>Regards
>Avram Friedman
>
>On Wed, 16 Jan 2008 13:48:02 +1100, teldb2kals <[login to unmask email]>
>wrote:
>
>>Hi,
>>
>>I am in the process of installing DB2 v8. The very first installation
screen
>asks if we want to do an INSTALL or UPDATE or MIGRATE or ENFM. I am not
>sure what to select here, as it mentions that INSTALL would directly
generate
>jobs for New Function Mode, while I would like to first move to
compatibility
>mode.
>>
>>So, I think I would have to select MIGRATE. But I don't have the old
DSNTID
>member from my v7 install. Should I run the v7 install clist again to
generate a
>DSNTID member ?
>>
>>Thanks,
>>Kals.
>>

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

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

teldb2kals

Re: DB2 for z/OS v8 Install
(in response to Cathy Taddei)
Thanks, Cathy. I suppose that when you say "executed the install CLIST in INSTALL mode,using DSNTIDXA as input", you mean the v7 install clist.

After a bit of digging around, I did manage to find a DSNTID member from our v7 install. It did not have any subsystem "ssid" references in it, hence I did not think it was the right one. But one of my colleagues tells me that, at the time, they just created the one member for all subsystems together, and then individually customised the DSNTIJUZ job for each subsystem. Hence I did not find individual DSNTIDxx members for each ssid.

So, now, I am thinking of using this DSNTID member for my v8 "MIGRATE" directly. The problem is, because it doesn't have ssid specific names (like ARCHLOG, etc), none of those appear on the panels as they are in the ZPARMs.

I could follow the same methodology as what's been done before, create just one initial o/p DSNTIDxx member, manually update it with the dataset names as per the existing ZPARM for the subsystem, and customise it for each ssid. Does this sound logical ?
(I know you recommended having one DSNTID member for each ssid, and I guess the advantage is when you go to reuse the installation clist, you get all the parameters correctly, but, I understand we have just used manually updated the DSNTIJUZ job till now for updating zparms).

I am glad I am making some progress atleast.

Regards,
Kals




"Taddei, Cathy" <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
17/01/2008 01:10 P.M.
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>

To
[login to unmask email]
cc

Subject
Re: [DB2-L] DB2 for z/OS v8 Install





Hi Kals. I have been in this situation before, and I did what George
and Avram suggested and executed the install CLIST in INSTALL mode,
using DSNTIDXA as input. I did not skip any panels or take defaults if
I had good values. I had to list the BSDS to get DDF information. I
didn't count tablespaces; I just took a SWAG and then used the override
fields on panel DSNTIPC to fill in actual values for EDM pool, RID pool,
etc. You don't have to fill in everything just to migrate, but having
accurate values for bufferpools, etc. in DSNTIDxx was a big help to me
later on when I converted to data sharing.

You know you've done it right when the generated DSNTIJUZ matches your
current DSNTIJUZ. Keep in mind that the generated DSNTIJUZ will not
include hidden zparms that your shop may have coded. If they don't
match, run the install clist again in UPDATE mode to make corrections.

Be very careful if you choose to edit DSNTIDxx. In many cases, the
zparm macro parameter name is different from the name used in DSNTIDxx,
and in several cases the scale is different, i.e. one is in Kbytes and
the other is in bytes or 4k pages. That said, you can edit DSNTIDxx to
be used for other similar subsystems by changing the really obvious
things like subsystem name and DDF parameters, then using it as input to
the install clist in UPDATE mode. Compare the output as above and make
corrections. Each subsystem should have its own DSNTIDxx.

HTH,
Cathy

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 for z/OS v8 Install
(in response to teldb2kals)
Hi Kals. Yes, I meant that in your case you would run the version 7
clist in Install mode. You could still run it in install mode using the
DSNTIDxx member you found, which would give you the opportunity to get
the ssid, dataset names, and other parms correct.

I always like to start a new version upgrade with a correct DSNTIDxx,
because IBM sometimes changes things that will make it difficult for you
to compare a v7 DSNTIJUZ to the V8 DSNTIJUZ. Some zparms will be gone,
some will have new defaults, and there will be brand new ones. It is so
easy to zip through the install clist (after you laboriously create your
first good DSNTIDxx) and maintain separate DSNTIDxx members for each
subsystem, that I don't see the point in not doing it. Sure, I'll
update DSNTIJUZ manually for a quick zparm change, but when it comes
time to upgrade, I'll run the clist in the old version to make sure
DSNTIDxx is up to date before running the clist in the new version.
Good luck with your upgrade!

Cathy


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of teldb2kals
Sent: Wednesday, January 16, 2008 5:45 PM
To: [login to unmask email]
Subject: Re: DB2 for z/OS v8 Install

Thanks, Cathy. I suppose that when you say "executed the install CLIST
in INSTALL mode,using DSNTIDXA as input", you mean the v7 install clist.


After a bit of digging around, I did manage to find a DSNTID member from
our v7 install. It did not have any subsystem "ssid" references in it,
hence I did not think it was the right one. But one of my colleagues
tells me that, at the time, they just created the one member for all
subsystems together, and then individually customised the DSNTIJUZ job
for each subsystem. Hence I did not find individual DSNTIDxx members for
each ssid.

So, now, I am thinking of using this DSNTID member for my v8 "MIGRATE"
directly. The problem is, because it doesn't have ssid specific names
(like ARCHLOG, etc), none of those appear on the panels as they are in
the ZPARMs.

I could follow the same methodology as what's been done before, create
just one initial o/p DSNTIDxx member, manually update it with the
dataset names as per the existing ZPARM for the subsystem, and customise
it for each ssid. Does this sound logical ?
(I know you recommended having one DSNTID member for each ssid, and I
guess the advantage is when you go to reuse the installation clist, you
get all the parameters correctly, but, I understand we have just used
manually updated the DSNTIJUZ job till now for updating zparms).

I am glad I am making some progress atleast.

Regards,
Kals




"Taddei, Cathy" <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
17/01/2008 01:10 P.M.
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>

To
[login to unmask email]
cc

Subject
Re: [DB2-L] DB2 for z/OS v8 Install





Hi Kals. I have been in this situation before, and I did what George
and Avram suggested and executed the install CLIST in INSTALL mode,
using DSNTIDXA as input. I did not skip any panels or take defaults if
I had good values. I had to list the BSDS to get DDF information. I
didn't count tablespaces; I just took a SWAG and then used the override
fields on panel DSNTIPC to fill in actual values for EDM pool, RID pool,
etc. You don't have to fill in everything just to migrate, but having
accurate values for bufferpools, etc. in DSNTIDxx was a big help to me
later on when I converted to data sharing.

You know you've done it right when the generated DSNTIJUZ matches your
current DSNTIJUZ. Keep in mind that the generated DSNTIJUZ will not
include hidden zparms that your shop may have coded. If they don't
match, run the install clist again in UPDATE mode to make corrections.

Be very careful if you choose to edit DSNTIDxx. In many cases, the
zparm macro parameter name is different from the name used in DSNTIDxx,
and in several cases the scale is different, i.e. one is in Kbytes and
the other is in bytes or 4k pages. That said, you can edit DSNTIDxx to
be used for other similar subsystems by changing the really obvious
things like subsystem name and DDF parameters, then using it as input to
the install clist in UPDATE mode. Compare the output as above and make
corrections. Each subsystem should have its own DSNTIDxx.

HTH,
Cathy



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

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