DB2 Server for VSE & VM: Database Services Utility

Table of Contents

  • About This Manual
  • Who Should Use This Manual
  • How to Use This Manual
  • Utilization
  • Organization
  • Components of the Relational Database Management System
  • Prerequisites
  • Knowledge
  • Highlighting Conventions
  • |How to Send Your Comments

  • Syntax Notation Conventions

  • SQL Reserved Words

  • Summary of Changes
  • |Summary of Changes for DB2 Version 7 Release 1
  • |Enhancements, New Functions, and New Capabilities
  • |Reliability, Availability, and Serviceability Improvements
  • |Library Enhancements

    • Part 1. User's Guide

  • Chapter 1. Getting Started
  • Introducing the Database Services Utility
  • Loading Data into a Database
  • Starting and Using the Database Services Utility
  • Multiple User Mode
  • Single User Mode
  • Overview of Database Services Utility Files
  • Working with an Input Control Card File in DB2 Server for VSE
  • Creating a Control Card File
  • Working with a Report
  • Working with a Control File in DB2 Server for VM
  • Using a Control File
  • Creating a Control File
  • Defining Input and Output Requirements
  • Using File Definitions
  • Using the SQLDBSU EXEC
  • Working with a Message File
  • Using the Database Services Utility on Remote Application Servers Which Support DRDA Flow
  • Using SQL Statements within the Database Services Utility
  • CONNECT
  • SELECT
  • COMMIT
  • Using SQL Comments
  • Querying the Current Status in DB2 Server for VM
  • Canceling a DB2 Server for VM Command
  • Exiting from the Database Services Utility

  • Chapter 2. Loading Data with the Database Services Utility
  • DATALOAD Command Components
  • DATALOAD Procedures
  • Using the DATALOAD Command with a Separate Data Input File
  • Using the DATALOAD Command with Embedded Data
  • Data Format Support
  • JCL for the DB2 Server for VSE DATALOAD Command
  • Using File Definitions with the DB2 Server for VM DATALOAD Command
  • General Loading Procedures
  • Comparison Operators
  • Loading Null Values
  • Loading CURRENT DATE, CURRENT TIME, and CURRENT TIMESTAMP Values
  • Loading Data into Multiple Tables
  • Combining Records to Load Multiple Table Rows
  • Committing Work While Loading Data
  • Restarting the Loading Process
  • Statistics Collection

  • Chapter 3. Unloading Data with the Database Services Utility
  • DATAUNLOAD Procedures
  • Unloading Data in System-Defined Format
  • Unloading Data in User-Specified Format
  • Unloading NULL Values
  • Unloading a View
  • Using File Definitions with the DB2 Server for VM DATAUNLOAD Command
  • UNLOAD Procedures
  • Unloading Data in System-Defined Format
  • Using the UNLOAD DBSPACE Command
  • Using the UNLOAD TABLE Command
  • Using File Definitions with the DB2 Server for VM UNLOAD DBSPACE and UNLOAD TABLE Commands

  • Chapter 4. Reloading Data with the Database Services Utility
  • RELOAD Procedures
  • Reloading Data in System-Defined Format
  • Using the PURGE Parameter
  • Using the NEW Parameter
  • Using the RELOAD DBSPACE Command
  • Using the RELOAD TABLE Command
  • Using File Definitions with DB2 Server for VM RELOAD DBSPACE and RELOAD TABLE Commands
  • FILEDEFs Supporting RELOAD Command Processing
  • |Release Coexistence Considerations for DB2 Server for VM
  • Statistics Collection

  • Chapter 5. Unloading and Reloading Packages with the Database Services Utility
  • Package Procedures
  • Preprocessing
  • Using the UNLOAD PACKAGE Command
  • Using the RELOAD PACKAGE Command
  • Authorizing the Use of Packages
  • Preprocessing and Distributing an Application
  • Using File Definitions with DB2 Server for VM UNLOAD and RELOAD PACKAGE Commands
  • FILEDEFs Supporting UNLOAD and RELOAD PACKAGE

  • Chapter 6. Interpreting the Output of the Database Services Utility
  • Understanding the Report and Message File Output
  • Command Input (DB2 Server for VSE & VM)
  • System Output (DB2 Server for VSE & VM)
  • Inclusion of Data in a Report (DB2 Server for VSE)
  • Inclusion of Data in a Message File (DB2 Server for VM)
  • Using the LIST Parameter on a DATALOAD Command
  • Reading Report and Message-File Output in Error Recovery

    • Part 2. Reference

  • Chapter 7. Using the Database Services Utility from Application Programs
  • In DB2 Server for VSE
  • Single User Mode Job Control
  • Multiple User Mode Job Control
  • In DB2 Server for VM
  • Names and Identifiers
  • General Rules for Naming Data Objects
  • Qualifying Object Names
  • Using Special Characters and Blanks within Identifiers
  • Reserved Words
  • SQL Reserved Words
  • Database Services Utility Reserved Words
  • Using Reserved Words as Identifiers
  • Using the Database Services Utility from Programming Languages
  • Addressing Mode
  • Register Contents for Database Services Utility Dynamic Startup
  • Using the Database Services Utility from an Assembler Program
  • Using the Database Services Utility from a C Program
  • Using the Database Services Utility from a COBOL Program
  • Using the Database Services Utility from a PL/I Program
  • Using the Database Services Utility Application Program Interface

  • Chapter 8. Command Reference
  • Command Processing
  • COMMENT
  • COMMENT Format
  • REORGANIZE INDEX
  • REORGANIZE INDEX Format
  • SCHEMA
  • SCHEMA Format
  • SQL Statement Processing
  • SELECT and Arithmetic Exceptions
  • Processing Summary
  • Load-Data Commands
  • DATALOAD TABLE
  • DATALOAD TABLE Format
  • Table_Column_Id_Subcommand
  • INFILE Subcommand
  • ENDDATA Subcommand
  • DATAUNLOAD
  • DATAUNLOAD Format
  • Data_Field_Id_Subcommand
  • OUTFILE Subcommand
  • RELOAD DBSPACE
  • RELOAD DBSPACE Format
  • |Release Coexistence Considerations for DB2 Server for VM
  • RELOAD TABLE
  • RELOAD TABLE Format
  • |Release Coexistence Considerations for DB2 Server for VM
  • UNLOAD DBSPACE
  • UNLOAD DBSPACE Format
  • |Release Coexistence Considerations for DB2 Server for VM
  • UNLOAD TABLE
  • UNLOAD TABLE Format
  • |Release Coexistence Considerations for DB2 Server for VM
  • Load-Package Commands
  • Processing for the Load-Package Commands
  • RELOAD PACKAGE
  • RELOAD PACKAGE Format
  • UNLOAD PACKAGE
  • UNLOAD PACKAGE Format
  • REBIND PACKAGE
  • REBIND PACKAGE Format
  • Set-Item Commands
  • SET AUTOCOMMIT
  • SET AUTOCOMMIT Format
  • SET ERRORMODE
  • SET ERRORMODE Format
  • SET FORMAT
  • SET FORMAT Format
  • SET ISOLATION
  • SET ISOLATION Format
  • SET LINECOUNT, SET LINEWIDTH
  • SET LINECOUNT (LINEWIDTH) Format
  • SET UPDATE STATISTICS
  • SET UPDATE STATISTICS Format

  • Chapter 9. Error Handling and Debugging
  • Types of Errors
  • Return Codes
  • Storage Dumps
  • Dumps Initiated by the Database Services Utility
  • Debugging

  • Chapter 10. Improving Performance
  • Nonrecoverable Storage Pool
  • Tape-File Support in DB2 Server for VM
  • Tape File Support Considerations
  • Locking Considerations
  • DATALOAD and RELOAD Locking Considerations
  • SELECT, DATAUNLOAD, and UNLOAD Locking Considerations
  • UNLOAD and RELOAD PACKAGE Considerations
  • Update Statistics Considerations
  • Reorganizing Indexes
  • Double-Byte Character Set
  • Basic Support
  • Extended Support

    • Part 3. Appendixes

  • Appendix A. Sample Tables
  • DEPARTMENT Table
  • Relationship to Other Tables
  • EMPLOYEE Table
  • Relationship to Other Tables
  • PROJECT Table
  • Relationship to Other Tables
  • ACTIVITY Table
  • Relationship to Other Tables
  • PROJ_ACT Table
  • Relationship to Other Tables
  • EMP_ACT Table
  • Relationship to Other Tables
  • IN_TRAY Table
  • CL_SCHED Table

  • Appendix B. FILEDEF Command Syntax and Notes
  • Specifying ddname
  • Specifying Device Type

  • Notices
  • Programming Interface Information
  • Trademarks

  • Bibliography

  • Index


    • [ Top of Page | Previous Page | Next Page | Table of Contents | Index ]