Making Connections With IBM Db2
Joseph Gulla explains important information about IBM Db2 and industry standards.
By Joseph Gulla08/24/2020
Standards ComplianceWe 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.
Db2 Has Software to Make the Necessary ConnectionsBecause 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 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 ClientsSeveral 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
Next WeekIn 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.
Joseph Gulla is the general manager and IT leader of Alazar Press. He's a frequent Destination z contributor and writes a weekly IT Trendz blog.
Sponsored ContentAchieve Compliance Without Impacting Productivity
Post a Comment
Note: Comments are moderated and will not appear until approvedcomments powered by Disqus