Partition-scoped utilities

Database Administration

Maintaining and Monitoring Your Database : Table-partitioned database : Partition-level database administration : Partition-scoped utilities

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)

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.