Skip to main content

Making Connections With IBM Db2

Joseph Gulla explains important information about IBM Db2 and industry standards.

"IT Trendz" in white against a purple banner, white chat bubble in righthand corner, with dots connected by white lines against a blue background.

Last week, I focused on IBM Db2® with a concentration on four IBM products including Db2 Big SQL, Db2 Event Store, Db2 Hosted and Db2 Tools. This means we’ve explored eight products on the IBM Db2 ecosystem, not including the different database editions themselves, including Advanced, Standard, Base and Community. This week, I am supplementing that information with additional products discussed below. However, before I dive into those products, I want to share important information about IBM Db2 and industry standards.

Standards Compliance

We often happen upon information about how a product adopts certain standards, but many of us skip over compliance information as we take it for granted or don’t fully appreciate its importance. When it comes to storing and processing the organization asset we know as data, standards adoption is very important.
As a software supplier, you don’t want to be in the marketplace with a product that doesn’t have the most beneficial scaffolding to help support and enable it. Of course, the product has to perform well and have excellent usability characteristics, but leveraging the support and power of key industry standards is a smart move.
IBM Db2 11.5 is purposefully compliant with standards and technical reports from many organizations, including:
  • Db2 has adopted several ISO/IEC standards, including eight standards from the #9075 SQL Standards series ranging from foundation practices to technologies like Java® routines and XML. Standards #13249 (SQL multimedia and application packages) and #19075 (SQL support JSON) are also incorporated by Db2.
  • Character Data Representation Architecture is an IBM architecture that defines a set of identifiers, resources and APIs for identifying character data and maintaining data integrity during data conversion processes
  • Unicode is adopted by IBM Db2 because everyone in the world should be able to use their own language on phones and computers
  • Cryptographic standards, including Federal Information Processing Standard certificates 376, 409 and 3064 (Crypto for C) and National Institute of Standards and Technology SP 800-131A, are adopted to ensure data security
  • Open Group distributed relational database architecture DRDA V5 Volumes 1 through 3 and X/Open XA have been adopted by IBM Db2 to support well distributed architecture practices
  • Java Database connectivity is an API that defines how a client may access a database supported by IBM Db2
  • Object Management Group Common Warehouse Metadatamodel specifies interfaces adopted by IBM Db2 that can be used to enable easy interchange of warehouse and business intelligence metadata. This interchange is between warehouse tools, warehouse platforms and warehouse metadata repositories in distributed heterogeneous environments.
  • Open Geospatial Consortium (OGC) has the motto “Making location count.” IBM Db2 adopts OGC standards. 
This adoption of key standards by Db2 allows IBM to bring value to both the company and to its clients. IBM’s continued support of key IT industry standards ensures that the products that adopt these standards maintain interoperability and quality.

Db2 Has Software to Make the Necessary Connections  

Because IBM Db2 seeks to thrive in an environment filled by diverse information technology solutions, IBM has developed many interfaces to make Db2 inclusion possible.  
Db2 Connect
Db2 Connect software is used to connect applications that run on Linux®, UNIX®, and Windows® OSes to IBM mainframe databases. Db2 Connect server products provide indirect connectivity that allows clients to access IBM Z® and IBM Power Systems™ servers through the Db2 Connect gateway. The various Db2 Connect server products, supporting AIX®, Linux, Windows and UNIX provide unique packaging and licensing solutions that are appropriate for different client environments.

IBM Data Server Clients

Several types of IBM clients and drivers are available for the data server. You can add Db2 Connect capability to any client or driver. Each client and driver provides a particular type of support. The IBM clients and drivers, available for download, include:
  • IBM Data Server Driver Package contains drivers and libraries with support for Java (JDBC and SQLJ), C/C++ (ODBC and CLI), .NET drivers and database drivers for open-source languages like PHP and Ruby
  • IBM Data Server Driver for JDBC and SQLJ provides support for JDBC and SQLJ for client applications developed in Java
  • IBM Data Server Driver for ODBC and CLI provides support for ODBC and Call Level Interface (CLI) libraries for the C/C++ client applications
  • IBM Data Server Runtime Client includes many utilities and libraries specific to Db2. Also, it includes Db2 Command Line Processor tool.
  • IBM Data Server Client is an all-in-one client package and includes all of the client tools and libraries available, including add-ins for Visual Studio
  • IBM Database Add-Ins for Visual Studio contains the add-ins for Visual Studio for .NET tooling support
  • IBM .NET Driver NuGet contains the .NET Driver NuGet packages for various platforms 
As this is the last post in this series on IBM Db2, I hope this series has been useful. I enjoyed surveying Db2 editions, supporting products and explaining the special compliance of Db2 with important industry standards.

Next Week

In 2020, I have explored IMS®, CICS® and Db2 to better understand the current posture and content of the products. Next week, I will continue my focus on IBM middleware with a post on IBM WebSphere® software.
IBM Systems Webinar Icon

View upcoming and on-demand (IBM Z, IBM i, AIX, Power Systems) webinars.
Register now →