Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

DB2 vs. DB2 UDB

If I understand correctly, DB2 Universal Database support would be coming soon on the iSeries. What's the difference between the DB2 we use and DB2 UDB?

While SQL is supposed to be SQL, each database provider has their own "flavor" of commands, procedures and syntax rules. This is also true for IBM's DB2 Universal. DB2 Universal is divided into areas based on operating systems. The first "flavor" in the IBM world is DB2 Universal for AIX, Linux, HP-Unix (or HP-UX), Sun and Windows. The second is for the iSeries. The third is for z/OS and OS/390 and the last is for VSE & VM. Most of these differences surround file and table naming, field name lengths, data type differences and storage methods. While I haven't been through all of the changes surrounding the latest release yet, I think the majority of changes surround the database catalog. These changes allow developers to access database information such as schema, authority (privileges) and table information in a consistent manner across the product line.


Search400.com's targeted search engine: Get relevant information on DB2/400.

The Best Web Links: tips, tutorials and more.

Check out this online event, Getting the Most out of SQL & DB2 UDB for the iSeries.

Dig Deeper on DB2 UDB (universal databases)

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.