Overview of onutil Commands

The onutil command-line utility modifies storage objects, checks the integrity of certain objects, and often generates a diagnostic display. The onutil utility performs many checks in parallel, utilizing the parallel-processing capabilities of Extended Parallel Server.

The onutil utility accepts commands that allow you to create, alter, and delete cogroups and dbslices. You also can use onutil commands to configure dbspaces, logical logs, and logical logslices:

• Cogroups
• Dbslices
• Dbspaces
• Logical logs
• Logical logslices

The onutil utility lets you check and display the following database characteristics if a connection to the database server is available:

• The root reserved pages of each coserver
• Chunks and extents of each coserver
• Data rows of a table
• Index keys
• Index keys with rowids
• Tblspace reports
• Tblspace-allocation reports
• Content of specified pages
• System catalog tables of a database

The onutil utility can perform the following functions when the database server is offline:

• Check and display the root reserved pages on one coserver
• Dump a specified page