In order to enable Historical Server to send it’s monitoring data to an Adaptive Server database, you must specify the following:
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 to connect to the output server if they are not the same as those used by the Historical Server to connect to the monitored server. If the user name and the password are not specified, they default to the ones specified in the -U and -P parameters on the command line.
The target Adaptive Server and database for the historical data must be available when Historical Server is started.
The command line syntax is:
histserver -U<user name> - P<password> -D<output dir> -l<log file> -I<interfaces file> [-d<delimiter>] [-O<ASE name>] [-o<DATABASE name>] [-f ] -u<outputASE user name> - p<outputASEpassword>
-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 outputASE user name – login name for the connection to the Adaptive Server with the output.
-p outputASEpassword – 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.
In the following example, the -O and -o parameters are specified and the output database is called hs_monitoring:
$SYBASE/ASE-12_5/bin/histserver -D$SYBASE -Sajax_hs -l$SYBASE/ajax_hs.log -Usa -Pnorthstar -Oajax -ohs_monitoring