Sending data to a database server

Select an Adaptive Server, and:

1. Create a database for the Historical Server to use for storing monitoring data. The default name of the database is hs_monitoring. If you do not want to use the default name, create a new database with the name you want to use, then change the database name in the hs_directload.sql script.

2. Run hs_directload.sql on the database. This installation script creates two catalog tables, sessions and views, and the stored procedure sp_hs_dboutput.

The command line syntax is (the new syntax is in default font):

histserver -Uuser name
- Ppassword -Doutput dir
-llog file -Iinterfaces file
[-ddelimiter] [-OASE_name
] [-odatabase_name] [-f ] 
-uoutput_ASE_user name - poutput_ASE_password

where:

• -O ASE_name – the name of the target Adaptive Server.

• -o database_name – the database name to which the monitoring data is sent, if it is not hs_monitoring, identify the database name on this option.

• -u output_ASE_ user name – login name for the connection to the Adaptive Server with the output.

• -p output_ASE_password – password for the login name for the output Adaptive Server.

• -f – must be used when the -O option is specified if you want Historical Server to send data to files in the output directory as well as the database.

You must have access to Historical Server and update permissions to the target database.

You must specify:

• The destination for the monitoring data from Historical Server to a specific Adaptive Server and database, rather than a flat file.

• The user name and password for the output if they are not the same as those on Historical Server. If the user name and the password are not specified, the values specified in the -U and -P parameters are used.

The target Adaptive Server and database for the historical data must be available when Historical Server is started.