Chapter 31. An Introduction to DB2 Utilities

In This Chapter

• Generating Utility JCL

• Monitoring DB2 Utilities

• The IBM DB2 Utilities

• Using LISTDEF and TEMPLATE

• Issuing SQL Statements in DB2 Utilities

DB2 utility programs are divided into four broad categories:

• Online utilities

• Offline utilities

• Service aids

• Sample programs

Each of these categories is defined in Part VI, “DB2 Utilities and Commands.” A complete description of every utility that makes up each category is also provided. Sample JCL listings are provided for each utility. The job names, data set names, space allocations, and volumes used in the JCL are only examples. The database and table space names are from the DB2 sample tables used throughout this book. These ...

Get DB2 Developer’s Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS, Sixth Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial