Examples for dump_hist command

The following examples illustrate how to use the dump history utility to extract certain types of information:

For current host

The following command prints all parameters for the current host:

For application instance

The following command prints all parameters of the application instance, db_manager, on a host entitled host1:

To print time as an integer rather than a local time string

The following command disallows the conversion of time stamps to a local time string:

Following is a sample line of output generated by this command:

To write to a file

This command redirects the output of dump_hist to a file called dump_hist.out. Each line of this file uses a pipe symbol to separate the values and displays the host name, parameter name, parameter value, date, and time.

 For a specific time period

This command prints history data from October 1, CCYY 8:00AM through October 1, 9:00AM of the same year.