Coding With Fun
Home Docker Django Node.js Articles Python pip guide FAQ Policy

What is the difference between db2 and db2 udb?


Asked by Khalani Hubbard on Dec 02, 2021 FAQ



One of them being "the DB2 storage is a part of the mainframe and that of the UDB used to be on an UNIX box connected to the mainframe". DB2 is much faster and will be readily available where as the UDB needs to be brought online before you can execute any jobs against it and much slower as well.
Just so,
Oracle is the cadillac with many add-on features for a price. Even it's standard or free edition has many features depending on your needs. IBM DB2 can be exclusively IBM proprietary or IBM (UDB) on Linux, Unix, Windows may be your answer.
Moreover, Throughout this article, DB2 z/OS refers to DB2 10 for z/OS; and DB2 LUW refers to DB2 9.7 for Linux, UNIX and Windows. It should also be noted that Linux on System Z servers would run DB2 LUW and not DB2 z/OS.
Besides,
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.
In respect to this,
The DB2 z/OS subsystem contains information for establishing connections with remote subsystems in a set of catalog tables called Communication Database (CDB). Also, an additional IBM DB2 Connect license is required to remotely connect to DB2 databases located on host systems including z/OS.