DB2 for z/OS Version 8

Jim McAlpine

DB2 for z/OS Version 8
I'm not a DBA but I'll ask the question anyway. When upgrading from DB2
Version 7 to Version 8 is there anything in a "standard" CICS/COBOL/DB2
application that could cause problems with an upgrade or would you expect
the upgrade be "transparent" to the application.

Jim McAlpine


This email and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to
whom they are addressed. Any unauthorised distribution or
copying is strictly prohibited. Whilst Cedar Software Ltd
takes steps to prevent the transmission of viruses via e-mail,
we cannot guarantee that any email or attachment is free from
computer viruses and you are strongly advised to undertake your
own anti-virus precautions. Cedar Software Ltd grants no
warranties regarding performance, use or quality of any e-mail
or attachment and undertakes no liability for loss or damage,
howsoever caused.


For more information on Cedar Software and our products,
please visit our web site at http://www.cedar.com/Home.asp


---------------------------------------------------------------------------------
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: DB2 for z/OS Version 8
(in response to Jim McAlpine)
There is a long history in DB2 service of closing loop holes. Things
that are documented not to work but by some over site do get repaired.
This sort of improvement is not typically tracked as a conversion
concern because the net result is this work the way they are suppose
too. The best way to find this class of problems is extensive testing
followed by word of mouth. I can not recall any DB2 migration that was
free of this class of problem. The good news is the number of impacted
programs is usually quite small.

_____

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Jim McAlpine
Sent: Friday, January 14, 2005 11:45 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 for z/OS Version 8


I'm not a DBA but I'll ask the question anyway. When upgrading from DB2
Version 7 to Version 8 is there anything in a "standard" CICS/COBOL/DB2
application that could cause problems with an upgrade or would you
expect the upgrade be "transparent" to the application.

Jim McAlpine
_____


This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they are
addressed. Any unauthorised distribution or copying is strictly
prohibited. Whilst Cedar Software Ltd takes steps to prevent the
transmission of viruses via e-mail, we cannot guarantee that any email
or attachment is free from computer viruses and you are strongly advised
to undertake your own anti-virus precautions. Cedar Software Ltd grants
no warranties regarding performance, use or quality of any e-mail or
attachment and undertakes no liability for loss or damage, howsoever
caused.

For more information on Cedar Software and our products, please visit
our web site at http://www.cedar.com/Home.asp
< http://www.cedar.com/Home.asp >

_____



------------------------------------------------------------------------
--------- 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
--------------------------------------------------------

NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited.


---------------------------------------------------------------------------------
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

[login to unmask email]

Re: DB2 for z/OS Version 8
(in response to Avram Friedman)
Jim,

Based on my research to-date, there's very little in the 'standard'
CICS/Cobol/DB2 application that could 'cause' problems.

*However*, if you do upgrade there are several remotely possible things
that *may* affect such an application, maybe even cause it to fail. A few
that come to mind are: Was it last bound in a DB2 version prior to V2.3?
Does it access any tables or views that may end up being invalidated? Is
it Cobol II ? Does it use any special registers whose definitions have
changed from CHAR to VARCHAR?

I'd recommend some reading and research, starting with the DB2 V8
Installation Guide, GC18-7418, chapter on Migration, section on
incompatibilities, followed by the Redbook, DB2 V8: Everything You Ever
Wanted to Know and More, SG24-6079.

Lock Lyon
Compuware Corp




I'm not a DBA but I'll ask the question anyway. When upgrading from DB2
Version 7 to Version 8 is there anything in a "standard" CICS/COBOL/DB2
application that could cause problems with an upgrade or would you expect
the upgrade be "transparent" to the application.

Jim McAlpine


---------------------------------------------------------------------------------
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

Jim McAlpine

Re: DB2 for z/OS Version 8
(in response to LL581@DAIMLERCHRYSLER.COM)
Lock,

Thanks for that. I don't think any of the specific things you mentioned
will affect us but I wiil read the chapter you mentioned.

Thanks again.

Jim McAlpine

-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: 14 January 2005 17:20
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 for z/OS Version 8



Jim,

Based on my research to-date, there's very little in the 'standard'
CICS/Cobol/DB2 application that could 'cause' problems.

*However*, if you do upgrade there are several remotely possible things that
*may* affect such an application, maybe even cause it to fail. A few that
come to mind are: Was it last bound in a DB2 version prior to V2.3? Does
it access any tables or views that may end up being invalidated? Is it
Cobol II ? Does it use any special registers whose definitions have changed
from CHAR to VARCHAR?

I'd recommend some reading and research, starting with the DB2 V8
Installation Guide, GC18-7418, chapter on Migration, section on
incompatibilities, followed by the Redbook, DB2 V8: Everything You Ever
Wanted to Know and More, SG24-6079.

Lock Lyon
Compuware Corp




I'm not a DBA but I'll ask the question anyway. When upgrading from DB2
Version 7 to Version 8 is there anything in a "standard" CICS/COBOL/DB2
application that could cause problems with an upgrade or would you expect
the upgrade be "transparent" to the application.

Jim McAlpine


----------------------------------------------------------------------------
----- 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



This email and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to
whom they are addressed. Any unauthorised distribution or
copying is strictly prohibited. Whilst Cedar Software Ltd
takes steps to prevent the transmission of viruses via e-mail,
we cannot guarantee that any email or attachment is free from
computer viruses and you are strongly advised to undertake your
own anti-virus precautions. Cedar Software Ltd grants no
warranties regarding performance, use or quality of any e-mail
or attachment and undertakes no liability for loss or damage,
howsoever caused.


For more information on Cedar Software and our products,
please visit our web site at http://www.cedar.com/Home.asp


---------------------------------------------------------------------------------
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