What is the difference between DB2 UDB and DB2 OS/390?

What are the differences between DB2 UDB and DB2 OS/390?

Well, the two are comprised of completely different code bases. That means that the code is separate for the mainframe (z/OS and OS/390) DB2 and the distributed LUW (Linux, Unix, Windows) DB2.

Of course, IBM has done a reasonably good job of making DB2 on these different platforms compatible, at least from an interface perspective. With only a few differences SQL written for one platform will work on the other, though. There are, of course, differences in the setup and maintenance based on the type of platform. And the LUW DB2 has different optimization technology than the mainframe DB2.

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT IBM DB2 management How to select an MPP database: DB2 vs. Teradata What are the top database management systems (DBMS)? Are there benefits to using both Teradata and a DB2 database? Tips for evaluating top database management systems and choosing a small DBMS Exec explains IBM's Information On Demand (IOD) initiative IBM DB2 9 Fundamentals certification (Exam 730): Sample questions about tables, Part 7 IBM DB2 9 Fundamentals certification (Exam 730): Sample questions about tables, Part 6 IBM DB2 9 Fundamentals certification (Exam 730): Sample questions about tables, Part 5 DB2 basics IBM DB2 basics

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

>And if you want to understand what is common to all of the SQL implementations across the different DB2 platforms, check out the SQL Reference for Cross Platform Development manual. It can be downloaded from the IBM Web site here.

More DB2 resources

• DB2 UDB on Unix/Linux vs. DB2 OS/390
• IBM iSeries (AS/400) DB2 UDB: Top 10 expert questions.