13.2.5 Other commands

These commands are in the utils PVSR directory and can be ran from any current directory, similar to the start_stop_pvsr command.

load.pl

The number of records collected by the collector server and consequently stored in the database can be monitored on the PVSR machine running the SQLLDR server, or on the WEB user interface under the “Settings=>Servers=>Collector load” menu item.. The command is named load.pl, located in the bin directory, and has the following parameters:

• server id: the identifier of the collector server
• measurement period in seconds

For example:

./load.pl 15 300

Result (last records):

2005.05.18. 19:45:00;2191;28747

2005.05.18. 19:50:00;2500;28399

2005.05.18. 19:55:00;2290;28571

2005.05.18. 20:00:00;164;28528

2005.05.18. 20:05:00;311;28388

2005.05.18. 20:10:00;314;28425

2005.05.18. 20:15:00;345;28387

2005.05.18. 20:20:00;1272;28372

2005.05.18. 20:25:00;2260;28381

The second column shows the number of milliseconds it took to load the data, while the third column shows the number of loaded measurements results. If there is a gap in the collection then the output will indicate the number of skipped files as well

run_sqlldr.pl

This command can be used to manually load CTL files produced by the collectors into the database. This might be required if the SQLLDR module skipped a CTL file or if the loading wasn’t successful or if there was a database corruption and the recovered database does not contain every measurement result. The command has several parameters, and only the -ctl=name_of_the_CTL_file parameter is mandatory:

·       -log=log_file_name: default: file name +.log

·       -table=table_name: which PVSR_MON_RES* table is the target, by default it uses the table present in the data file

·       -d or -direct: use direct path load

·       -v or –verbose: verbose output

·       -h or -? or -help: help

For example:

./run_sqlldr.pl -ctl=../tmp/done/C10.SQLload1311057900.300.ctl -table=PVSR_MON_RES_ARCHIV

load_intensity.pl

Similar to the load.pl, this command displays also load statistics, except that this command shows every loaded file by default and it has only one optional parameter: display a file only if it contains more than the given number of rows. For example: “./load_intensity.pl 500”. The parameters displayed are:

·       Date: when did the load occur

·       File: name of the file

·       Table: name of the table PVSR used

·       Rows: number of rows

·       Time: time it took to load the data, in seconds

·       Rows/sec: number of rows loaded in one second

·       Direct: whether direct path loading was used or not

backup_status.pl

Displays the backup status: primary PVSR, secondary PVSR or backup is not configured

test_oracle.pl

Checks whether PVSR can connect to its database or not.

test_threshold_server.pl

Checks the availability of one or more threshold modules, with different parameters and a timeout parameter can also be specified in each case (the default is 10):

·       the ID of a threshold module

·       the ID of a data collector module, in which case all the possible threshold modules it can communicate with will be tested

·       the HOST parameter of a data collector module, in which case all the possible threshold modules any of the collector module with that HOST parameter can communicate with will be tested

·       IP address (or FQDN) and any of the udp/<port>, tcp/<port> or ssl/<port> values, in which case the specified IP address and port will be tested with the given protocol