db2Dean’s DB2 for z/OS Page


Last Updated: 2 March 2006


These days I primarily work with DB2 on Linux, Unix and Windows, but I’m not above posing for a picture with an ultra-cool System z9!  While you may rightly wonder about the social skills of the man in the picture to the right, please contact me with any DB2 on z/OS questions that you may have but don’t know where to turn.  I probably can’t answer them, but I have friends who can.  Let’s thank Jeff Sullivan, an IBM Lab Services member, who contributed most of the content to this page!  By the way, if you need top shelf consulting services then Jeff is your man and I can put you in contact with him.


Anyway, a number of my customers also use DB2 on z/OS so I wanted to create a page on that subject for them.  DB2 on z/OS is not a complete mystery to me, but I am pretty rusty these days.  For many years I was a COBOL programmer writing serious applications against IMS and DB2/MVS databases.


I also answer many questions about DB2 Connect that allows applications on distributed platforms easily connect to DB2/zOS. 


ATTENTION!  DB2 9 for z/OS will go GA on March 16, 2007!  To read about all of the goodies like pureXML, check out this site:  DB2 9


Web Pages

Manuals and Reference Material

DB2 Magazine

Keep up to date with lots of good DB2 Information.  Read the magazine at this page or subscribe.


Download Central

We finally have a central location for down loading all available trial and other free software.  So if you want to tryout DB2 for z/OS, for example, this is the site for you.


FREE DB2 Express-C

Get a free, permanent copy of DB2 for your laptop or development server.  Want to try out the pureXML feature that will be available in DB2 9 for z/OS?  Then this is the site for you.  It has lots of great information and links to down load the software.


End of Support for DB2 for z/OS 7.1

End of Support for DB2 for z/OS 8.1

Search for Product EoS Dates

Every version of software eventually goes out of support.  Review these pages periodically to make sure that you don’t get a nasty little surprise in the middle of the night when you call for support for DB2.



APARS are, shall we say, the less desirable features of DB2.  This page shows the most recent APARS and lets you search them.


DB2/zOS Classes

Browse the DB2/zOS classes by category such as “administration” or “programming”.  I also find the training paths link that diagram the courses useful.  Check out the Certification tab is you are interested in becoming certified in DB2.





V8 DB2 Manuals

V7 DB2 Manuals

Book mark these links for the DB2 versions that you are using.  It is well worth reviewing the list of manuals to see what is available. 


V8 DB2 Information Center Search

Search for information about DB2.  I frequently access the information centers to answer customer questions.



This site contains a lot of great information organized in a way that is easy to find.


DB2 DeveloperWorks

This is a great site for learning about how to do things in DB2 and joining discussion forums.  Click the “DBAs” or “Developers” tab depending on the content that you want to see.


Redbooks (Data Related)

Search for practical guides for implementing solutions such as DB2 on Linux or implementing a Data Warehouse.


Willie Favero’s BLOG

Has lots of great tips and information about running your DB2 for z/OS system.  Willie updates it frequently, so check back often.


Craig S. Mullins Web Site

Lots of good DB2 information



The International DB2 User Group is a community of DB2 users.  The site contains excellent information and they have a tremendous conference every year.



HOME | Search