Maintenance operations

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

Failover clusters

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

ENABLETPIDXBLD

DISABLETPIDXBLD

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 OpenEdge Data Management: Database Administration.