Connecting DB2 to z/OS to Other DB2 Systems

For years DBAs have used IBM DB2 Connect to develop applications that run on Linux, Unix or Windows and connect to DB2 for z/OS. But what about connecting an application that runs on z/OS to DB2 running on a LUW system or even a separate z/OS system?

The drivers for connecting to other DB2 systems are available with DB2 for z/OS. To learn about these drivers and how to install them, see the DB2 10 for z/OS Application Programming Guide and Reference for Java.

(Note: As of DB2 Version 9.1, the JDBC/SQLJ Driver for OS/390 and z/OS is no longer supported. All Java application programs and Java routines that are currently written to work with the JDBC/SQLJ Driver for OS/390 and z/OS must be modified to work with the IBM Data Server Driver for JDBC and SQLJ -- formerly known as the DB2 Universal JDBC Driver. See the DB2 10 for z/OS Installation and Migration Guide to learn more about installing the IBM Data Server Driver for JDBC and SQLJ.)

Despite the growing need for mainframe pros to work with LUW environments, lack of awareness remains an issue. For instance, many people still don't realize that a Java application running on z/OS can be connected to a system with DB2 for LUW, or that a web-based application running on z/OS under UNIX System Services can be connected to another system with DB2 for z/OS.

A couple other relevant resources, starting with this list of IBM Data Server Driver for JDBC and SQLJ versions and DB2 for z/OS APARs. And to receive notifications about potential migration issues due to incompatible changes in DB2 10, you can track information APAR II14619 (DB2 V10.1 DDF MIGRATION INFOAPAR).

The point I was trying to make is that people still are not aware that you can connect a JAVA application running on z/OS to a DB2 running on LUW or a web based application running on z/OS under unix system services to DB2 for z/OS. I put the DB2-L comment in to show that even as of last month questions still come in asking is this possible.

 

The Emergence of IMDB Technology

Businesses as well as consumers demand that more information be placed at their fingertips. When using mobile devices such as iPhone and Android, people expect answers to their questions in seconds rather than minutes. This reality is driving the emergence of in-memory database (IMDB) technology.

With the low cost of memory, data is increasingly being moved to IMDBs, which can provide up to 10 times faster data access than traditional disk storage devices.

Until I glanced at the above Wikipedia link, I hadn't realized that IBM acquired solidDB in 2008. The solidDB database supports both IMDB technology and disk storage access. It's used in consumer hand-held devices as well as on UNIX, AIX, Linux and Windows servers.

Once the application connects to solidDB, a subset of data from the back-end database is stored in memory. That's the role of solidDB Universal Cache, which supports DB2 for z/OS as well as DB2 for LUW, Informix, SQL Server, Oracle and Sybase. Updated data is kept in sync using IBM Infosphere CDC (Change Data Capture).

For details on solidDB 7.0, check out these links:

* The list of products included with solidDB 7.0

* An overview of the architecture

* A list of supported back-end data servers 

Another good solidDB resource is the IBM Redbook, "IBM solidDB: Delivering Data with Extreme Speed" (published May 2011).

Is your company taking advantage of IMDB technology? Please share your experiences in comments.

The Ambidextrous IT Workforce

Over the years IT pros working on distributed platforms (Linux, UNIX, Windows) have often asked me how they can learn more about the mainframe and z/OS. When it comes to broadening one's horizons, I think mainframe DBAs have an easier time picking up UNIX or Linux (and in some cases Oracle and SQL Server) to support DB2 UDB. Being able to download tools, particularly Linux, is the best way to get started with something new.

Still, I'm seeing more and more people from the Linux world who find themselves needing to learn about the mainframe. This trend really got rolling with last year's introduction of the z/196, and with the increasing use of zBX blades running zLinux as well as z/OS on z/196 and z/114, I think the next generation of IT pros will only continue to find themselves more involved with the mainframe.

If you're an "ambidextrous" worker moving from LUW environments to z/OS, make it a point to bookmark the IBM z/OS basic skills information center. You'll find tons of material on mainframe and z/OS concepts. It'd also be nice to hear about your experiences and how you compare the challenges of managing z/OS and non-Z/OS system, so please share in Comments.