Indexes and Table Spaces -- Working With

  • Version 5 and Version 6 tasks in common
  • Checking index consistency
  • Granting and revoking table space privileges
  • Merge copying a table space
  • Modifying a table space
  • Recovering a table space to a page
  • Reporting index information
  • Starting indexes and table spaces
  • Stopping indexes and table spaces
  • Updating table space statistics
  • Version 5 tasks
  • Altering an index
  • Altering a table space
  • Checking data in table spaces
  • Concurrently copying a table space
  • Copying a table space
  • Creating an index
  • Creating a table space
  • Displaying reports about indexes
  • Displaying table space status
  • Loading data into a table space
  • Recovering indexes
  • Recovering indexes within table spaces
  • Recovering a table space to a current state
  • Recovering table spaces to a point on the log
  • Reorganizing an index
  • Quiescing a table space
  • Recovering a table space to image copy
  • Reorganizing a table space
  • Reporting table space information
  • Running index statistics
  • Version 6 tasks
  • Altering an index, partitioned
  • Altering an index, non-partitioned
  • Altering a table space
  • Checking a LOB table space
  • Checking data in table spaces
  • Concurrently copying an index or table space
  • Copying a table space
  • Creating an index
  • Creating a table space
  • Displaying reports about indexes
  • Displaying table space status
  • Loading data into a table space
  • Quiescing a table space set
  • Rebuilding an index
  • Recovering a table space
  • Recovering a table space or index to a current state
  • Recovering table spaces or indexes to a point on the log
  • Recovering a table space to image copy
  • Reorganizing a table space
  • Reorganizing an index
  • Reporting table space information
  • Running index statistics

    •