Existing database utilities that are enhanced to operate on a partition include the following:

  • Data utilities
    • BULKLOAD
    • DUMP
    • DUMPSPECIFIED
    • LOAD
    • TABLEMOVE
  • Index utilities
    • IDXACTIVATE
    • IDXBUILD (offline)
      Note: TPIDXBUILD rebuilds partition indexes when the database is online.
    • IDXCHECK
    • IDXCOMPACT
    • IDXDEACTIVATE
    • IDXFIX
  • Create and toss limits
    • SETLOBCREATELIMIT
    • SETLOBTOSSLIMIT
    • SETTABLECREATELIMIT
    • SETTABLETOSSLIMIT

See the complete description of each utility in PROUTIL Utility for details on how to specify a partition with each utility.