Re: Sybase DB credentials for iSPI (568 Views)
Reply
Super Advisor
MohanSekar
Posts: 289
Registered: ‎03-01-2012
Message 1 of 3 (594 Views)

Sybase DB credentials for iSPI

Dear Experts,

 

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.

 

Thanks.

 

Regards

 

Mohan

Esteemed Contributor
Michael Cameron
Posts: 211
Registered: ‎05-27-2004
Message 2 of 3 (568 Views)

Re: Sybase DB credentials for iSPI

To connect to the database on the NPS server use the ODBC DSNs, for example:

dbisql -c "DSN=PerfSPIDSN" -nogui "select @@version"
@@version                                                                                                                       
--------------------------------------------------------------------------------------------------------------------------------
Sybase IQ/16.0.0.481/130503/P/sp01/Enterprise Linux64 - x86_64 - 2.6.18-194.el5/64bit/2013-05-03 16:14:49                       

(1 rows)

Execution time: 0.082 seconds

 

The credentials are available in the DSN:

 

iqdsn -g PerfSPIDSN
Sybase IQ Data Source Utility Version 16.0.0.481
PerfSPIDSN: UID=DBA;PWD=HP_IQ;LINKS='tcpip{port=9303;HOST=localhost;DOBROADCAST=NONE;VERIFY=NO}'

 

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...

Occasional Contributor
MKenawi
Posts: 5
Registered: ‎05-06-2012
Message 3 of 3 (252 Views)

Re: Sybase DB credentials for iSPI

 

Hello Michael,

 

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?

 

Thank you,

Kenawi

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.