My Cart (0)

Customer Service 1-800-221-5528

DB2 for the COBOL Programmer, Part 2

by Curtis Garvin and Anne Prince
13 chapters, 402 pages, 160 illustrations
Published 1999
ISBN 978-1-890774-03-5
eBook: $36.00
List Price: $45.00 Save 20%

This book picks up from where Part 1 of DB2 for the COBOL Programmer leaves off. It gives you the advanced skills you need to become a top DB2 programmer. Like the Part 1 book, this one was a classic and a best-seller.

Today, however, it no longer makes sense to update a book like this because the market has become so small. If you’re working on an IBM mainframe, though, most of the information in this book is still useful, especially when you’re maintaining legacy programs. One reason for this is that IBM has always prided itself on the upward-compatibility of its software.

Your two DB2 books allowed me to secure a job using DB2 even though I had no experience in DB2. The manager who hired me said that I knew more about DB2 than some of his staff that had worked with it for 2 or more years."

T. C., Senior Systems Technical Specialist, Tampa, Florida

  • About this Book
  • Table of Contents
  • FREE Downloads
  • Reviews

What you’ll learn in this book

The goal of this book is to raise your DB2 skills from the entry-level skillset that you developed with DB2 for the Programmer, Part 1. Here, then, is some of what you'll learn from this book:

  • how to use stored procedures that move SQL code off of the client and onto the database server to reduce network overhead
  • how to use dynamic SQL so your programs can generate and execute SQL statements as they run
  • how data sharing works on the parallel sysplex and other System/390 configurations
  • how to work with distributed DB2 data, where the data is managed by a DB2 subsystem on a system that's connected over a network
  • how to process DB2 data in CICS programs (this section does not teach CICS itself, so if you need CICS training, see Murach's CICS for the COBOL Programmer).
  • advanced locking concepts that let you understand how locking and data sharing affect each other and what impact that has on program efficiency
  • the concepts and practices of DB2 database administration that let you design databases, manage database objects, and set up a quality assurance environment

What versions of DB2 this book teaches

Although the programs in this book were tested with DB2 version 4.1, this book teaches the DB2 essentials that don’t change much from one version of DB2 to the next. As a result, you should be able to use all the skills that you learn in this book with any version of DB2. Although newer releases have some enhancements to DB2...especially performance enhancements...everything in the earlier releases should still work.

Of course, this assumes that you have access to an IBM mainframe that uses DB2 as its database management system. That means that this book is best used in a training program or environment that gives you access to an IBM mainframe. If you don’t have access to an IBM mainframe, you can still use this book to learn how to develop COBOL/DB2 programs. You just won’t be able to practice what you’ve learned until you’re on the job.

Companion books

This is the second book in our two-part DB2 series, and it assumes that you already have the skills presented in DB2 for the COBOL Programmer, Part 1. Beyond that, though, there’s a lot more to learn to be an effective DB2 programmer. Depending on your assignments, then, here are other mainframe books that may be useful, and all of them work in combination with our COBOL and DB2 books:

Murach’s Mainframe COBOL

This is the perfect companion book for COBOL/DB2 programmers. After you use it to master COBOL, it becomes your best COBOL reference.

Murach’s CICS for the COBOL Programmer

This book shows you how to write interactive COBOL programs using the Customer Information Control System (CICS), which is IBM’s world-class transaction processor. Often, in fact, mainframe applications use a combination of COBOL, CICS, and DB2.

Murach’s OS/390 and z/OS JCL

This book presents the background skills that every programmer needs for working with an IBM mainframe. That includes using the operating system’s JCL (Job Control Language), working with VSAM files by using AMS (Access Method Services), and much more.

MVS TSO, Part 1 and Part 2

Part 1 of this book shows how to use the ISPF text editor to develop your programs. Part 2 tells you more about ISPF and the TSO commands that underlie it.

To view the table of contents for this book in a PDF, just click on the link below:

Table of Contents

The programs in the book

This download consists of text files for the 7 programs that are presented in the book, along with the JCL, SQL, CLIST, and PROC you need to compile and run the programs. It also contains a Readme.txt file that summarizes what files are included and how to use them.

Self-extracting Zip file (36Kb) Download Now

There are no reviews for this product yet.

To leave a review, please log in to your account.     Log In Here

Our Ironclad Guarantee

You must be satisfied. Try our books for 60 days. They must be the best you've ever used or send them back for a prompt refund. No questions asked!

Contact Murach Books

For orders and customer service:


Weekdays, 8 to 4 Pacific Time

College Instructors

If you're a college instructor who would like to consider a book for a course, please visit our website for instructors to learn how to get a complimentary review copy and the full set of instructional materials.