November 20, 2012

Supporting USS on DB2 for z/OS

A reader recently told me about installing DB2 for z/OS and setting up UNIX Systems Services (USS) components. He wanted to understand more about the archictectural differences between DB2 on USS and DB2 for z/OS.

I found some DB2 manuals and IBM Redbooks that address the topic. For starters, there's "The ABCs of z/OS System Programming: Volume 9" (update May 2011).

Of course when working with DB2 installs, you should review the DB2 Installation guide, but when working with distributed applications like USS components, you need to understand DB2 distributed functions (DDF). While "DB2 9 for z/OS: Distributed Functions" obviously doesn't cover the latest in DB2, it does provide a good introduction to DDF.

The reader who contacted me was hoping to find a diagram showing the DB2 for z/OS components that run on USS. Unfortunately, I couldn't turn up anything. As a visual person myself, I think a diagram showing how Java applications running on USS communicate with DB2 for z/OS would be great. However, I did find the "DB2 9 for z/OS Application Programming Guide and Reference for Java." This manual explains how IBM Data Server Driver for JDBC and SQLJ are used to make the connection from your application to DB2 for z/OS.

Have you found other resources that have helped you understand the DB2 for z/OS architecture in supporting applications that run on USS? Please share your tips in Comments.