Control Center Operations Guide for VSE

Chapter 12. Table Utility

The Table Utility provides an easy way for you to create a table or view a list of tables stored in a DB2 Server for VSE database, and select one (or to directly specify a single table) and then do these DBA-oriented operations on it:

• Drop (delete) a table.
• Reorganize a table (recreating all associated DDL).
  • Generate DDL.
  • Unload a table to tape or disk in a DBSU internal format.
  • Perform a full reorganization on a table.
  • Reload a table from tape or disk generated by an Unload.
• Update statistics.

The Table Utility consists of a set of programs, a batch DDL generator program, and batch jobstreams that execute Database Services Utility (DBSU) commands.

Based on your selections, the Table Utility will:

• generate the DDL required to recreate a table and the objects related to it, including:
  • Table Definition
  • Data
  • Referential Integrity constraints
  • Unique column definitions
  • Indexes
  • Views
  • Grants
  • Table and Column Comments
  • Table and Column Labels
  • Packages
• load data in clustering index sequence
• update statistics
• reprep invalidated packages
• support:
  • Commitcount use
  • table backup (image copy)
  • copying a table to a different database
  • copying a table to a different owner and/or name
  • moving a table to a different DBSPACE or Server
  • reloading data into a different table
• drop a table
• provide a screen interface to define (create) a table.