Re: SiteScope - DB2 Monitor (404 Views)
Reply
Valued Contributor
RYU123
Posts: 350
Registered: ‎10-09-2012
Message 1 of 10 (470 Views)
Accepted Solution

SiteScope - DB2 Monitor

Dear Experts,

We are currently using SiteScope 11.22 installed on RHEL.

I was wondering if I wanted to test the Database Connection using the "Database Connection Tool" in SiteScope,

what would I input as the "Database Connection URL" and "Database driver?

 

Any advice on this is very much appreciated.

Thanks,

HP Expert
Gunnar_L
Posts: 304
Registered: ‎05-22-2012
Message 2 of 10 (457 Views)

Re: SiteScope - DB2 Monitor

Hi,

 

To monitor a DB2 database it is necessary to copy the jdbc (in a previous ticket I useddb2jcc.jar) file (has to be provided by your DBA) into <SiteScope>WEB-INF\lib folder, then you have to restart your SiteScope service.

 

In the data base query monitor you have to use the following information:

 

Database Connection URL: jdbc:db2://<hostname>:<port>/<database_name>

Database driver: com.ibm.db2.jcc.DB2Driver (Could be different if you use other driver)
  
If you receive an error you can use the database connection tool to find more information about what is wrong with the monitor configuration.

 

Hope this helps.

Best Regards,

Gunnar López
HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Valued Contributor
RYU123
Posts: 350
Registered: ‎10-09-2012
Message 3 of 10 (452 Views)

Re: SiteScope - DB2 Monitor

Thanks, I think it worked except for the authentication part which probably I would have to talk with the DBAs or something.

 

But just to make a correction.

Actually I put the driver in <SiteScope>java\lib\ext folder.

 

Thanks,

Valued Contributor
RYU123
Posts: 350
Registered: ‎10-09-2012
Message 4 of 10 (442 Views)

Re: SiteScope - DB2 Monitor

Ok this may sound like a stupid or obvious question.
So is a "status == 200" good enough to see if the database query executed.
So basically we are using a database query monitor as our database availability.
So if a certain database query does not execute, then we assume that the database is down.
So my question is, is a "status = 200" good enough to say that the database executed the query?
Thanks,
HP Expert
Gunnar_L
Posts: 304
Registered: ‎05-22-2012
Message 5 of 10 (432 Views)

Re: SiteScope - DB2 Monitor

Hi,

 

Yes, status == 200, means everything is ok and SiS was able to successfully execute the query,  for example if the table or view doesn't exixts then you will receive a -1 status.

 

Best Regards,

Gunnar López
HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Valued Contributor
RYU123
Posts: 350
Registered: ‎10-09-2012
Message 6 of 10 (427 Views)

Re: SiteScope - DB2 Monitor

Thanks Gunnar,

I explained this to the DBA because he wanted SiteScope to check for a return code 0(no error).

He does not want to use "status == 200" as a good status because 200 is not a db2 code.

Is there a way to check for a return code of 0?

Thanks,

HP Expert
Gunnar_L
Posts: 304
Registered: ‎05-22-2012
Message 7 of 10 (421 Views)

Re: SiteScope - DB2 Monitor

You can try setting the threshold with value "status == 0"

 

Best Regards,

Gunnar López
HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Valued Contributor
RYU123
Posts: 350
Registered: ‎10-09-2012
Message 8 of 10 (417 Views)

Re: SiteScope - DB2 Monitor

No that didn't work because the status ==200
HP Expert
Gunnar_L
Posts: 304
Registered: ‎05-22-2012
Message 9 of 10 (416 Views)

Re: SiteScope - DB2 Monitor

mmm and is not possible for y ou to use the status == 200, and write a description in the monitor saying that status == 200 is the equivalent to DB2 code 0?

 

Best Regards,

Gunnar López
HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Valued Contributor
RYU123
Posts: 350
Registered: ‎10-09-2012
Message 10 of 10 (404 Views)

Re: SiteScope - DB2 Monitor

Well I can, hopefully they will understand...
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.