Re: db2 to oracle migration

>>> On 1/28/2008 at 12:42 PM, in message
<479DCDA4.6F0F.0085.0@efirstbank.com>,
Frank Swarbrick wrote:
>>>> On 1/26/2008 at 4:00 PM, in message
> , Mark
A
> wrote:
> I haven't seen any mention of this yet in this thread, but Oracle
> version 10
> is the last version that will run on z/OS. (I think it is version 10.
> I
> can't seem to find any links to this announcement, but I've gotten at
> least
> two emails about it (which I must have deleted).).

Here's the only web link I can find on this, just in case anyone cares...

http://www.zseriesoraclesig.org/foru...7bbd301cf7899f
5d6c32e2a2c5e9efe4

Frank

Frank Swarbrick wrote:
>>>> On 1/28/2008 at 12:42 PM, in message
> <479DCDA4.6F0F.0085.0@efirstbank.com>,
> Frank Swarbrick wrote:
>>>>> On 1/26/2008 at 4:00 PM, in message
>> , Mark
> A
>> wrote:
>> I haven't seen any mention of this yet in this thread, but Oracle
>> version 10
>> is the last version that will run on z/OS. (I think it is version 10.
>> I
>> can't seem to find any links to this announcement, but I've gotten at
>> least
>> two emails about it (which I must have deleted).).
>
> Here's the only web link I can find on this, just in case anyone cares...
>
> http://www.zseriesoraclesig.org/foru...7bbd301cf7899f
> 5d6c32e2a2c5e9efe4
Nice!

Now lets make sure it doesn't get lost via the SIG either:
http://www.zseriesoraclesig.org/foru...7bbd301cf7899f

"https://metalink.oracle.com/metalink/plsql/f?p=130:14:11342242931433391299:::14_database_id,p14_docid,p14_show_header,p14_show_help,p14_black_frame,p14_font:NOT,461234.1,1,1,1,helvetica

Text before its gone again.....

Oracle Database on z/OS Support Status
The final patch set for Oracle Database 10g Release 2 will be the last
release Oracle delivers for the z/OS platform. Customers can continue to
run the terminal patchset release of Oracle Database 10g Release 2 on
z/OS for as long as they want with support options to meet both their
current and future needs. Oracle will not be delivering an Oracle
Database 11g release for z/OS.

1. What is the Support plan for Oracle Database products on z/OS?

The final release for Oracle Database including the Client, and Oracle
Programmer (which includes the Access Manager for IMS, Access Manager
for CICS, OCI, and pre-compilers for COBOL, Fortran and PL/1) on z/OS
will be the final patchset for 10.2.

Premier Support will be extended two years for z/OS and will end in July
2012

Extended Support, which starts after Premier Support ends, will be
offered indefinitely – this represents an exception to the standard
Oracle Lifetime Support Policy. Customers choosing not to enroll in
Extended Support will be eligible for Sustaining Support.

The following table summarizes these three standard support levels and
what is provided. For further details about Oracle’s Lifetime Support
Policy, please see:
http://www.oracle.com/support/lifeti...rt-policy.html

Upon customer request, as new versions of IBM z/OS, CICS, and IMS are
released, Oracle will test with the 10.2 terminal release for
compatibility. Extended support customers are entitled to any updates or
fixes to ensure this compatibility. This compatibility assurance will
continue indefinitely. Sustaining Support customers will not be entitled
to these updates or fixes.

1. Will customers be forced to move off of the mainframe?

No! These z/OS products are supported under Oracle’s Lifetime Support
policy. This means you will receive and be entitled to Oracle’s support
as long as you have paid support.

Over time, per Oracle’s standard Lifetime Support policy, products move
from Premier to Extended to Sustaining support. Under Extended Support,
Oracle does not perform any further certifications for newer versions of
z/OS, CICS or IMS. Under Oracle’s Sustaining Support, no further
updates, bug fixes, security alerts or critical patch updates occur for
that release.

However, for z/OS, Oracle is modifying its Extended Support policy. Upon
customer request, as new versions of IBM z/OS, IMS, CICS and other
related software are released, Oracle will test with the Oracle 10.2
terminal release for compatibility. Extended support, which starts in
August 2012, will continue indefinitely.

Customers desiring to remain on the mainframe and upgrade to future
releases of the Oracle Database can move to the open systems mainframe
environment and run Oracle for Linux on System z. Oracle will continue
to support the mainframe platform by offering the Technology Products on
Linux for System z on a timely basis from their initial release. For
further information on this option, customers should consult their
Oracle Account representative.

2. Will fixes, security alerts and critical patch updates (CPUs)
continue to be provided for all supported releases?

Yes. Fixes, security alerts, and critical patch updates will continue to
be provided through Premier Support and Extended Support for the 10.2
releases ported to z/OS.

3. Will there be a 64-bit version of Oracle Database 10g Release 2?

Oracle plans to deliver a 31-bit version of the product as is currently
done, but has no plans for a 64-bit version.

4. Will the Oracle products (e.g. database, Oracle Programmer) be
upgraded and certified with new versions of z/OS and other relevant IBM
software?

Yes. They will be done as requested by customers through Premier and
also Extended Support per the exception discussed above.

“Oracle Programmer” consists of Oracle Clients (ODBC, OCI),
Pre-compilers (Pro*COBOL, Pro*PL/1, Pro*Fortran), Access Manager for
CICS and Access Manager for IMS. Each of these elements will be
maintained, upon customer request, to remain current with the latest
releases of their counterparts. For example, when a new release of CICS
is issued, Oracle will test and certify that the Access Manager for CICS
is compatible. A similar process will occur for the other elements of
“Programmer” as changes occur.

5. Will an Oracle Client (e.g Access Manager for CICS or OCI) running on
z/OS be able to access later version (beyond 10.2) of the database
running on a different platform?

Yes, per Oracle’s policy regarding dissimilar client/server versions of
the database as explained in Metalink Note 207303.1, Client / Server /
Interoperability Support Between Different Oracle Versions

6. Will there be an “additional fee” for Extended Support?

The standard fee for extended support will apply for each year customers
wish to have Extended Support.

7. Who may customers speak with to discuss this?

Please contact your Oracle account representative.

8. What level of support will customers get through this period for z/OS
and how quickly will patches, bug fixes, Service Requests (SRs) be handled?

Customers will receive the same level of support that they had
previously. There is no change in the delivery time of SR handling or
bug fixes. Service Requests are prioritized by severity level, not by
platform.

9. What is the status of the Oracle Transparent Gateway for DB2?

Oracle Transparent Gateway for DB2 is being stabilized as well. Oracle
Database 10g Release 2 is the final release for this product. Oracle
will not continue active development of this product and no new
enhancements will be made. Oracle will however continue to provide the
same level of support to existing customers.

10. What are the plans to support the Transparent Gateway for DB2?

Oracle will continue to support the Transparent Gateway for DB2. Premier
support will be available to existing customers until July 2010 per
Oracle’s standard Lifetime Support policy.

Oracle is streamlining the offerings for accessing the different
platform versions of DB2. Oracle recommends that customers use the
Database Gateway for DRDA to access DB2 on z/OS. The Database Gateway
for DRDA enables a customer to access DB2 on any platform, including
z/OS and AS/400. If you are already using Transparent Gateway for DB2
and need additional licenses, you should feel free to continue to
purchase this product. Oracle recommends customers migrate to the
Database Gateway for DRDA to maintain the highest level of support.

11. Can Linux for IBM System z run on my GP (General Purpose)
processors, or can it only run on IFL (Integrated Facility for Linux)
processors?

Linux for IBM System z can run on GP and IFL processors.

12. Does Linux for System z run in LPAR's (Logical Partitions) natively
or just under z/VM?

Linux for System z can run in LPAR's natively and as a guest under z/VM."

So: DB2 is DB2 is DB2 everywhere where Oracle is Oracle is Oracle.
And that is Linux, Unix, and Windows.
That IBM has other DB2 versions on additional platforms where Oracle has
folded (or is not applicable in case of i5/OS) can hardly be held
against us.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Serge Rielau wrote:

> So: DB2 is DB2 is DB2 everywhere where Oracle is Oracle is Oracle.
> And that is Linux, Unix, and Windows.
> That IBM has other DB2 versions on additional platforms where Oracle has
> folded (or is not applicable in case of i5/OS) can hardly be held
> against us.
>
> Cheers
> Serge

That's not correct Serge.
http://www.oracle.com/technology/sof...ase/index.html

On Oracle everything is identical for all operating systems. That
includes Windows (all versions), Linux (all flavours), Solaris, AIX,
HP-UX, OpenVMS, z/Linux, and most importantly for this conversation:
z/OS (OS/390).
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)

"Frank Swarbrick" wrote in message
news:479DCDA4.6F0F.0085.0@efirstbank.com...
>>>> On 1/26/2008 at 4:00 PM, in message
> , Mark A
> wrote:
>> "Bob Jones" wrote in message
>> news:zTMmj.5549$Rg1.1377@nlpi068.nbdc.sbc.com...
>>> I thought DB2 for z/OS is 99% the same as LUW as IBM used to claim. Is
>> it
>>> not true?
>>
>> It is 99% the same at the DML level (select, insert, update, delete).
>> That
>> allows portability of applications from one platform to another.
>>
>> They not the same code base and is substantially different in most every
>>
>> other respects. IBM never claimed otherwise. If you thought so, then you
>>
>> were not listening carefully.
>>
>> But compatibility of databases at the DML level is nothing to sneeze at,
>> as
>> anyone who has tried to migrate an application from one database to
>> another
>> knows.
>>
>> Oracle folks like to make a big deal about the facts that DB2 for Linux,
>>
>> UNIX, and Windows is a different product than DB2 for z/OS, but very few
>>
>> shops run Oracle on z/OS for any kind of important application. If
>> Oracle is
>> installed on z/OS, it usually because they got a free license. I once
>> got a
>> list from an Oracle sales rep of 5 Fortune 100 companies that had Oracle
>>
>> installed on OS/390, and I checked every one of the 5 references
>> provided to
>> me. None of them panned out. They had it installed, but not using it for
>>
>> anything meaningful.
>
> I haven't seen any mention of this yet in this thread, but Oracle version
> 10
> is the last version that will run on z/OS. (I think it is version 10. I
> can't seem to find any links to this announcement, but I've gotten at
> least
> two emails about it (which I must have deleted).).
>

That comes as no surprise. There is just no mass market for z/OS.

Bob Jones wrote:

> There is just no mass market for z/OS.

"I think there is a world market for about five computers."

> On Oracle everything is identical for all operating systems. That
> includes Windows (all versions), Linux (all flavours), Solaris, AIX,
> HP-UX, OpenVMS, z/Linux, and most importantly for this conversation:
> z/OS (OS/390).
Version 10. No 11. How is that for a death sentence? Got an exit plan
for Boeing?

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

"Darin McBride" wrote in message
news:VWaoj.26665$4w.2366@pd7urf2no...
> Bob Jones wrote:
>
>> There is just no mass market for z/OS.
>
> "I think there is a world market for about five computers."

What a small world for z.

Serge Rielau wrote:
>> On Oracle everything is identical for all operating systems. That
>> includes Windows (all versions), Linux (all flavours), Solaris, AIX,
>> HP-UX, OpenVMS, z/Linux, and most importantly for this conversation:
>> z/OS (OS/390).
> Version 10. No 11. How is that for a death sentence? Got an exit plan
> for Boeing?

Patience.

That said you still need to address the fact that your original
statement was incorrect. Still it seems it would be worthwhile
if you addressed the underlying issue which is why DB2 is not
brought inline with a single code base.

You control the hardware, the operating system, and the entire
code base for DB2. What is it that is stopping you?
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

"DA Morgan" wrote in message
news:1202167223.328589@bubbleator.drizzle.com...
> Patience.
>
> That said you still need to address the fact that your original
> statement was incorrect. Still it seems it would be worthwhile
> if you addressed the underlying issue which is why DB2 is not
> brought inline with a single code base.
>
> You control the hardware, the operating system, and the entire
> code base for DB2. What is it that is stopping you?
> --
> Daniel A. Morgan

The fact that Oracle has been trying for many years to sell a database
developed for UNIX on the z/OS operating system, and that customers have
abandoned the product such that Oracle can no longer make a profit from it,
pretty much demonstrates that the market place wants a database engine on
z/OS that is optimized for that particular operating system.

I suppose that you would prefer that IBM make the same mistake that Oracle
made. What is worthwhile to you, may not be worthwhile to everyone else.