Enable a database for table partitioning
- Last Updated: August 11, 2021
- 2 minute read
- OpenEdge
- Version 13.0
- Documentation
You can enable a database for table partitioning from the Database Administration Console, by using command line utilities, and programmatically with ABL.
Database Administration Console
To enable a database for table partitioning with Database Administration Console:
- Select . The list of database connections appears.
- Highlight the database connection of your choice from the list of database connections, and click View. The database home page appears.
- Verify the Table
Partitioning status in the Database
Features panel.Note: You can click the Sort arrow to display the features in ascending or descending order. If the status displays a check mark in a green circle and the word Enable does not appear in the Action column then, the database is already enabled for table partitioning.
- Click Enable. The Enable Table Partitioning page appears.
- Click Enable table partitioning. A message confirms that the database is enabled for table partitioning.
- Click OK.Note: You can also use the Database Features panel to know the status of the Read-only Partitions.
Command line utilities
To enable an OpenEdge database for table partitioning use the PROUTIL command with
the ENABLETABLEPARTITIONING qualifier, which can be run online or offline against
the OpenEdge database.
- Enter
$ proutil dbname -C enabletablepartitioning. - Verify the OpenEdge database is enabled for table partitioning.
$ proutil dbname -C describe
Programmatically with ABL
To enable an
OpenEdge database for table partitioning, use the OS-COMMAND statement.
To
verify whether an OpenEdge database is enabled for table partitioning or not use the
_Database-Feature
VST:DEFINE VARIABLE cExecutableCommand AS CHARACTER NO-UNDO.
ASSIGN
cExecutableCommand = "proutil dbname -C enabletablepartitioning"
OS-COMMAND SILENT VALUE(cExecutableCommand).FIND _DataBase-Feature NO-LOCK WHERE _DBFeature-ID = 21 NO-ERROR.
DISPLAY
_DBFeature-ID FORMAT ">9" LABEL "ID"
_DBFeature_Name FORMAT "X(20)" LABEL "NAME"
_DBFeature_Active FORMAT "9" LABEL "ACTIVE"
_DBFeature_Enabled FORMAT "9" LABEL "ENABLED"
WITH FRAME ft DOWN.