DB2 Server for VSE & VM: Database Services Utility

How to Use This Manual

This manual describes and explains what the Database Services Utility is, how it functions, and when to use it.

Utilization

This manual contains two parts. Each chapter in Part 1 has a task area, for example, loading data or interpreting output. Within each task area, member subtasks are grouped according to their importance or in order of performance.

To use the user-guide part of this manual, select the chapter that corresponds to the general type of Database Services Utility activity that you want to perform. Within that chapter, find the procedure that provides specific instructions for the subtask that you want. Supplementary information, alternative procedures, and examples are in boxes within the text. Perform the procedure's numbered steps and refer to the supplementary text within frames, figures, and examples as necessary.

To use the reference part of this manual, find the general or specific topic of interest in the table of contents or index and refer directly to its listed page or pages.

Organization

The Summary of Changes summarizes the technical and library changes made to DB2 Server for VSE & VM Version 7 Release 1.

Part 1 contains the following chapters:

Chapter 1, Getting Started,

introduces the Database Services Utility and explains its use. It also provides an example of a Database Services Utility job.

Chapter 2, Loading Data with the Database Services Utility,

shows how to load tables with data specified by the user.

Chapter 3, Unloading Data with the Database Services Utility,

shows how to unload tables in a format specified by the user or in a format provided by the Database Services Utility.

Chapter 4, Reloading Data with the Database Services Utility,

shows how to reload tables with data in a format provided by the Database Services Utility.

Chapter 5, Unloading and Reloading Packages with the Database Services Utility,

shows how to unload and reload packages.

Chapter 6, Interpreting the Output of the Database Services Utility,

describes VSE report output or VM message-file output, how to read it, and how to understand it.

Part 2 contains the following chapters:

Chapter 7, Using the Database Services Utility from Application Programs,

contains rules for naming objects, lists reserved words, describes the procedures required to initiate Database Services Utility processing from application programs, and describes how to use the Database Services Utility application program interface.

Chapter 8, Command Reference,

describes command processing and contains complete descriptions of all Database Services Utility commands.

Chapter 9, Error Handling and Debugging,

describes the processing undertaken by the Database Services Utility whenever errors are encountered and supplies information on the processing of debug-type errors.

Chapter 10, Improving Performance,

describes measures that could help improve the Database Services Utility's processing speed or efficiency.

Appendix A, Sample Tables,

shows the contents of the sample tables supplied with the DB2 Server for VSE & VM product.

Appendix B, FILEDEF Command Syntax and Notes,

presents a syntax diagram and usage notes on the Conversational Monitor System (CMS) FILEDEF command as it relates to the Database Services Utility.

The Bibliography lists the publications that are related to this book.