Database utility changes in support of table partitioning fall into three categories: unchanged, enhanced to support partition-aware output, enhanced to operate on a partition, newly added specifically for table partitioning.

Unchanged database utilities continue to operate across the database, and are not impacted by table partitioning. These utilities include:

  • Backup and restore
  • After-imaging and Replication
  • PROSTRCT
  • Transparent Data Encryption
  • Auditing

Utilities that are enhanced to support partition-aware output include:

  • PROUTIL Analysis tools (CHANALYS/DBANALYS/IDXANALYS/TABANALYS)
  • PROUTIL VIEWB2
  • PROMON

Utilities that are enhanced with the ability to operate on a partition scope include:

  • BULKLOAD
  • DUMP/DUMPSPECIFIED
  • IDXACTIVATE
  • IDXBUILD
  • IDXCHECK
  • IDXCOMPACT
  • IDXDEACTIVATE
  • IDXFIX
  • IDXMOVE
  • LOAD
  • TABLEMOVE
  • Create and toss limits (DISPTOSSCREATELIMITS, SETAREACREATELIMIT, SETAREATOSSLIMIT, SETLOBCREATELIMIT, SETLOBTOSSLIMIT, SETTABLECREATELIMIT, SETTABLETOSSLIMIT)
  • DBTOOL
  • PROMON

Utilities that are specific to table partitioning include:

  • Enable and disablement
    • ENABLETABLEPARTITIONING
    • DISABLETABLEPARTITIONING
    • DISABLEREADONLYPARTITIONS
    • ENABLEREADONLYPARTITIONS
  • Partition management
    • PARTITIONMANAGE ALTER
    • PARTITION MANAGE MERGE
    • PARTITIONMANAGE RENAME
    • PARTITION MANAGE SPLIT
    • PARTITION MANAGE TRUNCATE
    • PARTITIONMANAGE VIEW
  • Single partition index rebuild
    • TPIDXBUILD
Startup parameters that are enhanced with the ability to operate on a partition scope include:
  • -IndexCheck
  • -TableCheck

For details on these utilities and startup parameters, see Manage the OpenEdge Database.