SHOW HISTORY CONFIGURATION
Use the SHOW HISTORY CONFIGURATION command to display the settings of a history configuration or all history configurations. This command is run on the source system.
Syntax
Syntax for showing
a history configuration:
SHOW HISTORY CONFIGURATION [ <config_name> | ALL ]Inputs
The SHOW HISTORY CONFIGURATION command has the following inputs:
| Input | Description |
|---|---|
| <config_name> | The name of the history configuration whose settings are to be displayed. The default is the currently active history configuration. |
| ALL | Displays the settings of all history configurations. |
Outputs
The SHOW HISTORY
CONFIGURATION command has the following outputs:
| Output | Description |
|---|---|
| SHOW HISTORY CONFIGURATION | The command was successful. |
| ERROR: permission denied | You do not have the necessary permission to issue this command |
| ERROR: <config-name> not found. | The specified configuration name cannot be found. |
Privileges
You must be an administrator or must have the Manage Security permission.
Usage
The following command
shows information about the configuration with the name plan_hist:
MYDB.SCH1(USER)=> SHOW HISTORY CONFIGURATION plan_hist;
CONFIG_NAME | CONFIG_NAME_DELIMITED | CONFIG_DBNAME |
CONFIG_DBNAME_DELIMITED | CONFIG_DBTYPE | CONFIG_TARGETTYPE |
CONFIG_LEVEL | CONFIG_HOSTNAME | CONFIG_USER | CONFIG_USER_DELIMITED |
CONFIG_PASSWORD | CONFIG_LOADINTERVAL | CONFIG_LOADMINTHRESHOLD |
CONFIG_LOADMAXTHRESHOLD | CONFIG_DISKFULLTHRESHOLD |
CONFIG_STORAGELIMIT | CONFIG_LOADRETRY | CONFIG_ENABLEHIST |
CONFIG_ENABLESYSTEM | CONFIG_NEXT | CONFIG_CURRENT | CONFIG_VERSION
----------+-----------------------+---------------+-------------------
PLAN_HIST | f | | f
| 3 | 1 | 1 | localhost |
| f | | -1 |
-1 | -1 | -1 |
-1 | -1 | f | f | f
| f | 1