09-18-2013 10:47 PM
I have installed NPS and iSPI Performance for Metrics on my HA cluster where NNMi is installed.
What will be the credentials to login to Sybase iSQL as I am not aware of that information.
Kindly advise on the default credentials and database to be selected to login.
09-19-2013 05:54 AM
To connect to the database on the NPS server use the ODBC DSNs, for example:
dbisql -c "DSN=PerfSPIDSN" -nogui "select @@version"
Sybase IQ/188.8.131.521/130503/P/sp01/Enterprise Linux64 - x86_64 - 2.6.18-194.el5/64bit/2013-05-03 16:14:49
Execution time: 0.082 seconds
The credentials are available in the DSN:
iqdsn -g PerfSPIDSN
Sybase IQ Data Source Utility Version 184.108.40.2061
But these are subject to change (user can run changeDBpwd.ovpl)
I'd urge caustion using direct database access. Access to the database is unsupported, while you can possibly get what you need by using direct access there is no published API and the schema is subject to change not only across versions but even in patches. You also circumvent the BI layer used for reporting which imposes things like multi-tenancy rules.
It may be better to explain what you need before using what you asked for...
07-23-2014 12:01 AM
I have the same requirement. I need to access NPS Sybase database to monitor it using HP Operations Agent. However, HP Opeartions Agent cannot discover the database, and I really do not know what will be the effect of applying the monitoring policies to the databse. Will it affect database performance?
Is there a way to detect early database issues through database access, or some log file to monitor for early database issues?