Displaying history configuration settings

Issue the SHOW HISTORY CONFIGURATION command to display information about the active configurations or about all configurations.

The SHOW HISTORY CONFIGURATION command is described in the IBM® Netezza® Database User’s Guide. For example, the following command shows information about the current configuration:

SYSTEM.ADMIN(ADMIN)=> SHOW HISTORY CONFIGURATION;

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
-------------+-----------------------+---------------+-------------------------+---------------
+-------------------+--------------+-----------------+-------------+-----------------------+---
--------------+---------------------+-------------------------+-------------------------+------
--------------------+---------------------+------------------+-------------------+-------------
--------+-------------+----------------+----------------                                       
DISABLEQHIST | f                     |               | f                       |             3 
|                 1 |            1 | localhost       |             | f                     |   
              |                  -1 |                      -1 |                      -1 |      
                 -1 |                  -1 |                -1 | f                 | f          
         | f           | f              |              1                                       
(1 row)