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
Manuals and Reference Material
Keep up to date with lots of good DB2 Information. Read the magazine at this page or subscribe.
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.
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
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.
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.
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.
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.
Search for practical guides for implementing solutions such as DB2 on Linux or implementing a Data Warehouse.
Has lots of great tips and information about running your DB2 for z/OS system. Willie updates it frequently, so check back often.
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.