Upgrade to V6 or V7?

Janice G Fields

Upgrade to V6 or V7?
Hi,

Does anyone have any experience in upgrading from version 5 to version 6 or
7? Can you tell me about your experiences good or bad? Do you have any
recommendations that can make the upgrade smoother? Do you recommend one
version over the other (v6 over v7)? We are an OS 390 shop and have been on
V5 for several years.


Thanks in advance for any and all help.

Jan Fields
Database Analyst
Indiana University



Steve Whittaker

Re: Upgrade to V6 or V7?
(in response to Janice G Fields)
Janice:
Just my comments. We went from V5 to V6 this past summer and we had
absolutely
no problems. Our system programmers made sure they had the latest and
greatest
PTF's and that we were current with whatever we needed on V5 before we moved
forward.
We migrated it up through 6 DB2 subsystems and did not run into any
problems. We've
been on V6 since about late June and so far so good. We did alot of testing
with each subsystem
and I think this helped alot.
I heard alot of horror stories early on with DB2 V6 but I think by the time
we got to our upgrade
all of those bugs had been worked out. Sometimes its nice being a little
late in the game..
Good luck with whatever you decide on.

--Steve....

Steve Whittaker
DB2/DBA Progress Energy, Inc.
Mail stop:PEB 14 - Raleigh
Email: [login to unmask email]
Phone: (919) 546-7267


-----Original Message-----
From: Fields, Janice G [mailto:[login to unmask email]
Sent: Wednesday, December 19, 2001 2:28 PM
To: [login to unmask email]
Subject: Upgrade to V6 or V7?


Hi,

Does anyone have any experience in upgrading from version 5 to version 6 or
7? Can you tell me about your experiences good or bad? Do you have any
recommendations that can make the upgrade smoother? Do you recommend one
version over the other (v6 over v7)? We are an OS 390 shop and have been on
V5 for several years.


Thanks in advance for any and all help.

Jan Fields
Database Analyst
Indiana University








Eric Pearson

Re: Upgrade to V6 or V7?
(in response to Steve Whittaker)
We went from V5 to V7.
This was a very clean and trouble-free upgrade.
IBM released a very high-quality product with V7.
Do make sure that your V5 has current maintenance first.
Do run the 'colon checker' against your SQL.

Regards,
eric pearson
NS ITO Database Support


-----Original Message-----
From: Fields, Janice G [mailto:[login to unmask email]
Sent: Wednesday, December 19, 2001 2:28 PM
To: [login to unmask email]
Subject: Upgrade to V6 or V7?


Hi,

Does anyone have any experience in upgrading from version 5 to version 6 or
7? Can you tell me about your experiences good or bad? Do you have any
recommendations that can make the upgrade smoother? Do you recommend one
version over the other (v6 over v7)? We are an OS 390 shop and have been on
V5 for several years.


Thanks in advance for any and all help.

Jan Fields
Database Analyst
Indiana University








Russell Collins

Re: Upgrade to V6 or V7?
(in response to Eric Pearson)
Hi Jan. Fellow IU alumni here. I have never upgraded an OS 390 machine.
However I have upgraded an NT machine from version 5 to 6 and 5 to 7. The
main issue that I had was when trying to upgrade a version 5 machine to X.
You have to make sure that you have enough disk space for the operation.
You can do this by increasing the size of the log files to about 2 or 3
times the amount. Otherwise you will get some error messages. Besides
that, the DB2 upgrade software did everything and it went smooth. My
thoughts are that you will have to run a migration script or something on
the mainframe. I don't know if this is any help but if you have any
concerns about it, let me know.


Russell Collins
eCommerce Technology Austin
http://www.ectaustin.com/



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of
Fields, Janice G
Sent: Wednesday, December 19, 2001 1:28 PM
To: [login to unmask email]
Subject: Upgrade to V6 or V7?


Hi,

Does anyone have any experience in upgrading from version 5 to version 6 or
7? Can you tell me about your experiences good or bad? Do you have any
recommendations that can make the upgrade smoother? Do you recommend one
version over the other (v6 over v7)? We are an OS 390 shop and have been on
V5 for several years.


Thanks in advance for any and all help.

Jan Fields
Database Analyst
Indiana University








Jim Tonchick

Re: Upgrade to V6 or V7?
(in response to Russell Collins)
Our decision was a dictated by the budget. I would have preferred to install
V7, but the separation of the Utilities and the unexpected one time change
for something that used to be included, killed V7 in our shop. My boss has
ordered V6 and it should be in house by the time I get back from holiday
vacation. I sure hpoe that IBM comes to their sences and undoes the utility
packaging fiasco in V7. Maybe by V8?

Jim Tonchick
Fiserc, Inc.



Jeff Frazier

Re: Upgrade to V6 or V7?
(in response to Jim Tonchick)
Hello Janice, We migrated our 8 DB2's from V5 to V6 with our last
production system going in Aug. We only had a couple minor problems such
as SQL Reserved words, and a GLPEDIT problem under Peoplesoft. Just run
DSNTIJPM, watch new ZPARMS such as EDMSPACES and all should be fine. Ours
went real well. Jeff




"Fields, Janice G" <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
12/19/01 02:27 PM
Please respond to DB2 Data Base Discussion List


To: [login to unmask email]
cc:
Subject: Upgrade to V6 or V7?


Hi,

Does anyone have any experience in upgrading from version 5 to version 6
or
7? Can you tell me about your experiences good or bad? Do you have any
recommendations that can make the upgrade smoother? Do you recommend one
version over the other (v6 over v7)? We are an OS 390 shop and have been
on
V5 for several years.


Thanks in advance for any and all help.

Jan Fields
Database Analyst
Indiana University



the

[login to unmask email]

Re: Upgrade to V6 or V7?
(in response to Jeff Frazier)
When we went from 5 to 6 the only 'gotcha' was parallelism, BIND paramter
"DEGREE(ANY)". We had a couple of programs that became real CPU hogs.





Jeff Frazier <[login to unmask email]>@RYCI.COM> on 2001/12/19 03:29:42
PM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

Sent by: DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc:
Subject: Re: Upgrade to V6 or V7?



Hello Janice, We migrated our 8 DB2's  from V5 to V6 with our last
production system going in Aug. We only had a couple minor problems such as
SQL Reserved words, and a GLPEDIT problem under Peoplesoft. Just run
DSNTIJPM, watch new ZPARMS such as EDMSPACES and all should be fine.  Ours
went real well.  Jeff



"Fields, Janice G"
<[login to unmask email]>         To:
Sent by: DB2 Data Base [login to unmask email]
Discussion List         cc:
<[login to unmask email]>         Subject:
Upgrade to V6 or V7?
12/19/01 02:27 PM
Please respond to DB2
Data Base Discussion
List






Hi,

Does anyone have any experience in upgrading from version 5  to version 6
or
7?  Can you tell me about your experiences good or bad?  Do you have any
recommendations that can make the upgrade smoother?  Do you recommend one
version over the other (v6 over v7)?  We are an OS 390 shop and have been
on
V5 for several years.


Thanks in advance for any and all help.

Jan Fields
Database Analyst
Indiana University


visit








Roger Miller

Re: Upgrade to V6 or V7?
(in response to Rohn.Solecki@MTS.MB.CA)
I've become very convinced that V7 is generally the better answer. If it is
helpful, I'll send out the updated road show foils if you send me a message

[login to unmask email]
Please be sure to have two r's, so Lisa does not



Roger Miller

Re: Upgrade to V6 or V7?
(in response to Roger Miller)
I've become very convinced that V7 is generally the better answer. For the
next six months there is a choice, then it will always be V7. There is
transitional pricing offer to help with that part of the problem. It's on
my home page below.

If it is helpful, I'll send out the updated road show foils in a pdf file if
you send me a message. It includes feedback from quite a few customers
about what problems they found. Direct email is better than appending to
the list. I'll send them out in early 2002. This is my last day for this
year.

Happy holidays to all.

Roger Miller, DB2 for z/OS web: ibm.com/software/db2os390

email: [login to unmask email]
Please be sure to have two r's, so Lisa does not get too many messages.



Michael Ebert

Re: Upgrade to V6 or V7?
(in response to Roger Miller)
I'd like to have them, please.

Merry Xmas and a Happy New Year to you & your family!

MfG, ME.




From: Roger Miller <[login to unmask email]>@RYCI.COM on 21/12/2001 12:47 CST

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

Sent by: DB2 Data Base Discussion List <[login to unmask email]>



To: [login to unmask email]


cc:






Subje Re: Upgrade to V6 or V7?
ct:





I've become very convinced that V7 is generally the better answer. For
the
next six months there is a choice, then it will always be V7. There is
transitional pricing offer to help with that part of the problem. It's on
my home page below.

If it is helpful, I'll send out the updated road show foils in a pdf file
if
you send me a message. It includes feedback from quite a few customers
about what problems they found. Direct email is better than appending to
the list. I'll send them out in early 2002. This is my last day for this
year.

Happy holidays to all.

Roger Miller, DB2 for z/OS web: ibm.com/software/db2os390

email: [login to unmask email]
Please be sure to have two r's, so Lisa does not get too many messages.