Manage Learn to apply best practices and optimize your operations.

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

Database expert Craig Mullins explains the differences between DB2 UDB and DB2 OS/390. He begins by clarifying that the two are comprised of completely different code bases.

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.

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

This was last published in May 2005

Dig Deeper on IBM DB2 management

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.