Control Center Operations Guide for VSE

Features

The DBSPACE Reorganization tool allows you to:

• Extract and create all DDL required to re-create the DBSPACE and the objects it contains, including:
  • Tables
  • Data
  • Referential Integrity constraints
  • Unique column definitions
  • Indexes
  • Views
  • Grants
  • Table and Column Comments
  • Table and Column Labels
  • Packages (Access Modules)
• Unload DBSPACE data to tape or disk
• Free unused pages by dropping and re-acquiring the DBSPACE
• Load data in clustering index sequence
• Load data with freespace for future inserts
• Rebuild clustered indexes (where possible)
• Update Statistics
• Reprep invalidated access modules
• Reload a DBSPACE to a different database
• Reload a DBSPACE with a different owner
• Reload a DBSPACE with a different DBSPACE name
• Acquire a DBSPACE in a new storage pool
• Acquire a different size DBSPACE
• Change the number of DBSPACE header pages
• Change the free space percent
• Change the index percent
• Change the lock mode
• Run in Multiple or Single User Mode