Advice on DB2 V7 Migration/DB2 V6 Toleration Maintenance

Deanna McMurray

Advice on DB2 V7 Migration/DB2 V6 Toleration Maintenance
Hello,

I am fairly new to DB2 on z/OS and am hoping to gather some advice and
expertise from our list members.

I have been given the task of upgrading our DB2 V6.1 system to DB2 V7.1.
Although I have a *little* SMP/E experience, I certainly not an expert at
it.

My understanding is one of the first things to do for the DB2 V7 migration
is to install the tolerance maintenance for DB2 V6. I ordered this
maintenance from IBM but by the time all the pre/coreqs/sups are included
it is well over 150 PTFs with LOTS of them needing action/rebind/etc work.
I have received them into our DB2 SMPE zone but am working on resolving the
hundreds of ++HOLD issues to allow them to be applied. Very messy.

Can I get a serverpac instead for maintenance for V6 that would have all of
these resolved? I just don't have enough experience in this area to know
what to do to speed up this process. I have a goal of completing our V7
migration by end of May.

Any help on what to do to get this V6 toleration maintenance on in a timely
manner (within 2-3 weeks) would be GREAT.

Also, I had originally ordered DB2 V7 as a CBPDO. It is received but I'm
waiting to begin on it until the V6 toleration maintenance is complete.
Would it be faster to reorder it and install it as a Serverpac? My
understanding is that Serverpac's are easier to install because the
maintnenace is already resolved (unlike a CBPDO). Is that correct?

Thanks and any advice given is appreciated.

Deanna McMurray
University of CA, Irvine

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Avram Friedman

Re: Advice on DB2 V7 Migration/DB2 V6 Toleration Maintenance
(in response to Deanna McMurray)
Deanna
You have made a great start.

Some suggestions
Review info APAR II12653
This lists the service requirements for DB2 V6 to go to DB2 V7.
In general there is service through PUT0201 that is required plus 1 fix on PUT0401. I would suggest reviewing the 0401 fix to see if you can rule it out. it is UQ83973.

You will need to go to either PUT0204 or PUT0404 depending on your need for the PUT0401 fix.

Some suggestions
1. Ignore hold actions for application rebinds. You either have the problem these fixes address or you don't. If you had them you would know.

2. Ignore the changes to reinstall V6 sample applications, you will not be needing them anymore anyway.

3. Ignore actions for features you do not have, if you don't use DB2 JDBC or DB2 DBCS do not worry about doing the actions for them.

4. Do not do an APPLY CHECK or APPLY with GROUPEXTEND if you have received service beyond your target ... just do a GROUP.

5. Restrict the service you put on by SOURCEID so you do not go beyond your target.

6. Make sure the service you need for migration and fallback mentioned in the II APAR goes on beyound that do not worry about what service does not go on ... this is a preventive not a corrective effort. If something does not go on because it is PE dependent there is no reason to seek out the fix in your case DO NOT PUT ON THE PE OR ANYTHING DEPENDENT ON THE PE UNLESS THE CHAIN IN RESOLVED WITHING YOUR TARGET RANGE... DO NOT EXPAND YOUR TARGET RANGE TO FIX THINGS. If things will not apply they are not suppose too!

The II APAR can be found on IBMLINK or by doing a search at WWW.IBM.COM/DB2


please understand me, these instructions are for some one inexperienced in serive who is far behing and needs to apply preventive service to migrate. These are all good general service suggestions.

Besides service actions required for the upgrade the DB2 V7 install guide and program directory will instruct you to run several test queries and utilities to verify your system is ready to be migrated ... checking for invalid plans, type 1 indexes etc. If you encounter any exceptions they need to be resolved prior to your upgrade.

Go near bleeding edge with your V7 system. tour shop does not do service often, in an new migration most changes will cause the right actions to be generated by the V7 install CLIST. Get current while it is easy.

Deanna McMurray <[login to unmask email]> wrote:
Hello,

I am fairly new to DB2 on z/OS and am hoping to gather some advice and
expertise from our list members.

I have been given the task of upgrading our DB2 V6.1 system to DB2 V7.1.
Although I have a *little* SMP/E experience, I certainly not an expert at
it.

My understanding is one of the first things to do for the DB2 V7 migration
is to install the tolerance maintenance for DB2 V6. I ordered this
maintenance from IBM but by the time all the pre/coreqs/sups are included
it is well over 150 PTFs with LOTS of them needing action/rebind/etc work.
I have received them into our DB2 SMPE zone but am working on resolving the
hundreds of ++HOLD issues to allow them to be applied. Very messy.

Can I get a serverpac instead for maintenance for V6 that would have all of
these resolved? I just don't have enough experience in this area to know
what to do to speed up this process. I have a goal of completing our V7
migration by end of May.

Any help on what to do to get this V6 toleration maintenance on in a timely
manner (within 2-3 weeks) would be GREAT.

Also, I had originally ordered DB2 V7 as a CBPDO. It is received but I'm
waiting to begin on it until the V6 toleration maintenance is complete.
Would it be faster to reorder it and install it as a Serverpac? My
understanding is that Serverpac's are easier to install because the
maintnenace is already resolved (unlike a CBPDO). Is that correct?

Thanks and any advice given is appreciated.

Deanna McMurray
University of CA, Irvine

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm




Avram Friedman
(877)311-0480 Voice Mail
[login to unmask email]
Http://www.IBMsysProg.com




---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Mark Ediger

Re: Advice on DB2 V7 Migration/DB2 V6 Toleration Maintenance
(in response to Avram Friedman)
Hi Deanna,

You are correct about Serverpac and CBPDO. In your
case, normally this would be the best way to go. However, I do not
know if
you can still order a Serverpac for V6 since it went out of service
last year in June. I have never tried to do this.
I certainly hope you can, otherwise you won't have much choice
other than applying your already received maintenance. However,
150 ptfs is not really that large a number to apply in a given
maintenance cycle. It may be possible, but a lot of detailed work.
You might be able to cut this down but excluding all the superceding
ptfs and just trying to get the toleration ptfs on.
Good luck.

Mark Ediger
Acixom CDC




>>> [login to unmask email] 01/11/06 2:37 PM >>>
Hello,

I am fairly new to DB2 on z/OS and am hoping to gather some advice and
expertise from our list members.

I have been given the task of upgrading our DB2 V6.1 system to DB2
V7.1.
Although I have a *little* SMP/E experience, I certainly not an expert
at
it.

My understanding is one of the first things to do for the DB2 V7
migration
is to install the tolerance maintenance for DB2 V6. I ordered this
maintenance from IBM but by the time all the pre/coreqs/sups are
included
it is well over 150 PTFs with LOTS of them needing action/rebind/etc
work.
I have received them into our DB2 SMPE zone but am working on resolving
the
hundreds of ++HOLD issues to allow them to be applied. Very messy.

Can I get a serverpac instead for maintenance for V6 that would have
all of
these resolved? I just don't have enough experience in this area to
know
what to do to speed up this process. I have a goal of completing our
V7
migration by end of May.

Any help on what to do to get this V6 toleration maintenance on in a
timely
manner (within 2-3 weeks) would be GREAT.

Also, I had originally ordered DB2 V7 as a CBPDO. It is received but
I'm
waiting to begin on it until the V6 toleration maintenance is
complete.
Would it be faster to reorder it and install it as a Serverpac? My
understanding is that Serverpac's are easier to install because the
maintnenace is already resolved (unlike a CBPDO). Is that correct?

Thanks and any advice given is appreciated.

Deanna McMurray
University of CA, Irvine

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG
conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Abe Kornelis

Re: Advice on DB2 V7 Migration/DB2 V6 Toleration Maintenance
(in response to Mark Ediger)
Deanna,

This is in addition to valuable advice already given to you by others.

150 PTFs ie a piece of cake. I'm looking at 1500 for 1 customer and
2500 for another one. That's messy, alright. NEvertheless, if it is
your first go, 150 is daunting enough.

Since your goal is not to upgrade the V6 software, but rather to
prepare for a transition to V7, you should cut down as much as
possible on both the PTFs to be applied, and on the hold actions
to be performed. Be aware that hold actions need to be performed
for *every* subsystem that runs the software.

On SMP: Do ACCEPT any previous maintenance applied before applying
any new maintenance. If you have usermods applied, exclude them from
ACCEPT processing - you should RESTORE these before applying maintenance.

Do *not* use GROUP of GROUPEXTEND options of SMP. Try to
keep control of what happens during apply by specifying the exact
set of PTFs (plus any pre- or co-requisites) that *you* want
applied. I even take the trouble of listing the exact hold conditions
to be byapssed down to the PTF-level to maintain full control over
what happens during apply - no surprises. The amount of data/information
is simply too large to spot anything that is not marked by SMP as a
downright showstopper...

A few more comments inserted below.

Success!
Abe Kornelis

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of Deanna McMurray

Hello,

My understanding is one of the first things to do for the DB2 V7 migration
is to install the tolerance maintenance for DB2 V6.
**--> Corect.

I ordered this
maintenance from IBM but by the time all the pre/coreqs/sups are included
it is well over 150 PTFs with LOTS of them needing action/rebind/etc work.
**--> You can omit the sups unless any of them be needed to resolve a
PE condition for a PTF the you really need.

I have received them into our DB2 SMPE zone but am working on resolving the
hundreds of ++HOLD issues to allow them to be applied. Very messy.
**--> I assume you have a lot of hold action for application rebinds.
We now have hold DB2BIND to separate these out. A great improvement,
but of no use to you at this moment.
Here's how I'm wont to tackle this, feel free to borrow, or to use
your own preferred procedure:
LIST MCS to obtain coverletters, download to PC and convert to a
document. Use text processing software to obtain:
- list of functional changes to be communicated to customers
- list of actions te be performed.
In the process I simply discard anything I have 'processed'.
I end tend to end up with less than 1% of the original data.

Can I get a serverpac instead for maintenance for V6 that would have all of
these resolved? I just don't have enough experience in this area to know
what to do to speed up this process. I have a goal of completing our V7
migration by end of May.

Any help on what to do to get this V6 toleration maintenance on in a timely
manner (within 2-3 weeks) would be GREAT.
**--> You'll be hard pressed.

Also, I had originally ordered DB2 V7 as a CBPDO. It is received but I'm
waiting to begin on it until the V6 toleration maintenance is complete.
Would it be faster to reorder it and install it as a Serverpac? My
understanding is that Serverpac's are easier to install because the
maintnenace is already resolved (unlike a CBPDO). Is that correct?

Thanks and any advice given is appreciated.

Deanna McMurray
University of CA, Irvine

**--> Wish you success,
Abe.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm