Re: Good News for MS Windows users: Your favorite database is here..

Let me add something here:

The DB2 UDB code base on UNIX, Windows and OS/2 is roughly 90% the same. We reserve, on average, 10% of the code to optimize down into the operating system and sometimes the hardware. This is vital to achieve the performance, reliability, security and
scalability we demand of DB2 on UNIX (including Linux), Windows and OS/2. A pure porting strategy can't achieve this level of capability. Examples of our downward integration
include Intel's VI Architecture support for standards-based clustering in Intel server environments, integration with AIX HACMP, Sun Solstice and Microsoft Cluster Server for scalability, and use of Windows and Kerberos security and multi-threading schemes. The code base for DB2 UDB for AS/400 and for DB2 UDB for OS/390 and z/OS are two distinct code bases, and distinct from DB2 UDB on UNIX, Windows and OS/2 platforms. Because of the distinct hardware and OS architectures on these platforms, and because they
are IBM platforms with which we can more deeply and tightly integrate, we have different

internal architectures for DB2. This provides much better performance and scalability than a
porting strategy such as that of other vendors, particularly on S/390 and eServer zSeries.

As Blair points out (the DML as an example), internal differences should not be mistaken for external differences.

To further simplify the lives of DB2 DBAs, our administration toolset, notably the DB2 Control Center, extends its reach across multiple code bases to allow a single DBA from a
single workstation to manage multiple instances of DB2 on not only UNIX, Windows and OS/2 but also on OS/390 and z/OS. Our new standards-based SQL Procedures Language for writing stored procedures and our cross-platform Stored Procedure Builder are further evidence of cross-platform compatibility.

Another dimension to this argument is the notion of functional capabilities of our editions of
DB2 on UNIX, Windows and OS/2. Precisely the same functional capability is offered in the
four packages on these platforms: Personal Edition, Workgroup Edition, Enterprise Edition,
Enterprise-Extended Edition. This is not the case for the "competition". It is our view that a 100% porting plan cannot optimize performance for any particular platform. To not take advantage of underlying system strengths would be doing a huge disservice to customers.

Larry

Blair Kenneth Adamache wrote:

> DB2 is the same code base on all versions of Windows (95 through 2000), AIX,
> Solaris, HP-UX, NUMA-Q and OS/2. There are three other DB2 code bases (390, AS/400
> and VM/VSE). 4 code bases is not "zillions". Each RDBMS vendor has an additional
> code base kicking around (Oracle has RDB, Sybase has SQL Anywhere, and Microsoft has
> Access and Foxpro) - at least IBM has aligned DML across the platforms.
>
> Nuno Souto wrote:
>
> > On Sat, 19 May 2001 09:36:46 -0400, Blair Kenneth Adamache
> > <adamache_at_ca.ibm.com> wrote:
> >
> > >merging object-relational features into a parallel relational database) mesh
> > >nicely with DB2's approach. It is our expectation that Informix releases under
> >
> > Yeah, they might eventually allow IBM to deliver one version of DB2,
> > instead of the zillion versions out there, one for each platform...
> >
> > <d&r>
> >
> > Cheers
> > Nuno Souto
> > nsouto_at_bigpond.net.au.nospam
> > http://www.users.bigpond.net.au/the_Den/index.html
Received on Sun May 20 2001 - 12:02:23 CDT