param_gethistory 
Use
You open the database parameter history and transfer the first block of the contents. The entries are displayed in reverse chronological order, that is, starting with the most recent and ending with the oldest.
You can restrict the parameters displayed by specifying options. If you enter several selection criteria, then only the data for those parameters that correspond to all the criteria is displayed. You can also define which data should be displayed for the parameters selected.
Each parameter is displayed on a separate line with the details for all fields defined.
If the entries for the parameter history cannot be transferred in full due to the limited size of the response packet, you can display the remaining contents using param_gethistorynext an.
See also:
Concepts of the Database System, 
Log
Files
Prerequisites
You have the server authorization ParamRead.
Syntax
param_gethistory [NAME=<parameter_name>] [DATE=<yyyymmdd>] [GROUP=<group_list>] [STATE=<status_list>] [FIELDS=<field_list>]
<group_list>:: = <parameter_group>,<parameter_group>,...
<status_list>:: = <status>,<status>...
<field_list>:: = <field>,<field>,...
<field>:: = DATE | TIME | NAME | OLDVALUE | NEWVALUE | STATE | GROUP | COMMENT
Options
Option |
Description |
<parameter_name> |
Name of the database parameter If you do not specify a parameter name, the entries for all parameters in the history are displayed. |
<yyyymmdd> |
Date format (year, month, day) Only parameter changes since this date are displayed. If you do not specify a date, all entries in the history are displayed. |
<parameter_group> |
Parameter Group Changes to database parameters that belong to this group are displayed. Possible values are: General: General Database Parameters EXTENDED: Special Database Parameters SUPPORT: Support Database Parameters If you do not specify a parameter group, then the parameter changes for all groups will be output. See also: Concepts of the Database System, |
<status> |
Database parameter status Possible values are: a | c | c a: active database parameters c: changed database parameters d: deleted database parameters if you do not specify a state, then all parameter changes will be output. |
<field> |
Name of the field in the parameter history to be displayed You can display the following fields: DATE
Date when the
parameter was changed If you do not specify a field, then all fields will be displayed. |
<hhmmss> |
Time format: (hours minutes seconds) Only parameter changes since this time are displayed. If you do not specify a time, all entries in the history are displayed. |
Reply
OK
<header_line>
<param_line>
<param_line>
...
Values for the Reply Fields
Value |
Description |
<header_line> |
contains the names of the fields displayed S stands for STATUS of the database parameter |
<param_line> |
contains the values for the fields displayed in the <header_line>, the values are in the same column position as the field name in the <header_line> Possible statuses are: a: active database parameter c: changed database parameter d: deleted database parameter |
Example
Call the Database Manager CLI in session mode, log on as operator OLEG with the password MONDAY, connect to the database instance DEMODB:
>dbmcli –u OLEG,MONDAY –d DEMODB
dbmcli on DEMODB>
● Display the parameter history for the parameter MAXDATAVOLUMES:
>param_gethistory NAME=MAXDATAVOLUMES
OK
DATE TIME NAME NEWVALUE
OLDVALUE S GROUP
20050503 00134126 MAXDATAVOLUMES 32
64 A GENERAL
20050317 00141019 MAXDATAVOLUMES 64
1 C GENERAL
20050317 00141013 MAXDATAVOLUMES 1
C GENERAL
● Display all changes to the database parameter MAXUSERTASKS with date, time and status:
param_gethistory NAME=MAXUSERTASK FIELDS=DATE,TIME,STATE
OK
DATE TIME S
20050503 00105843 A
20050317 00141019 C
20050317 00141013 C