Chapter 30. An Introduction to DB2 Utilities

IN THIS CHAPTER

• Generating Utility JCL

• Monitoring DB2 Utilities

• Version 7 and the State of 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 Performance 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 tablespace names are from the DB2 sample tables used throughout this book. These names should be changed to reflect the needs of your application.

The online utilities are referred to as online because they execute under the control of DB2. They are run using the DSNUTILB program, which is supplied with DB2. DSNUTILB uses the Call Attach Facility (CAF) to run as an independent batch program.

Online utilities operate using control card input. DSNUTILB reads the control card input and then executes the proper utility based on the input. The first word in the control card is the name of the utility to be processed , followed by the other parameters required for the utility.