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, Database Parameters

<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
TIME        Time when the parameter was changed
NAME        Name of the parameter
NEWVALUE    New value of the parameter
OLDVALUE    Old value of the parameter
STATE       The change status of the parameter
GROUP       Group that the parameter is assigned to
COMMENT          Comment that you can enter when changing a parameter or that is created by the system

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