gpcc-util

Performs a number of Command Center tasks from the command line, including starting a recommendations scan, performing a table metadata scan, and importing and exporting workload management rules.

gpcc-util <command> [ <options> ]

gpcc [ --version | -v ]

gpcc [ --help | -h ]

Commands

• Recommendation Command
• Table Scan Command
• Workload Management Rules Command

Recommendation Command

The recommendation command controls the recommendation scan process.

Options

-d or --duration

Optional. Specifies the duration limit of the recommendation scan.

--help

Optional. Provides more information about the recommendation command.

start

Optional. Starts the recomendation scan immediately.

Table Scan Command

The table-scan command performs a scan of the table metadata in the cluster.

Options

--help

Optional. Provides more information about the table-scan command.

start

Optional. Starts the table metadata scan immediately.

--skip_size_check or -s

Optional. Skips table size calculations.

Workload Management Rule (WLM) Command

The wlm-rule command imports or exports workload management rules.

Options

export

Export workload management rules.

--file or -f

Specifies the path of the text file from which to import rules or to which to export rules.

--help

Optional. Provides more information about the table-scan command.

import

Import workload management rules.

Global Options

--version or -v

Displays the gpcc-util version.

--help or -h

Displays syntax and help text for the gpcc-util command.

Examples

Start a recommendation scan immediately, limiting its duration to 12 hours:

gpcc-util recommendation start -d 12h

Get help on the table metadata scan’s start command:

gpcc-util table-scan start --help

Export workload management rules to a file in the /tmp directory called rules.txt:

gpcc-util wlm-rule export --file /tmp/rules.txt