Application Perf Mgmt (BAC / BSM) Practitioners Forum
Showing results for 
Search instead for 
Do you mean 

SiteScope - DB2 Monitor

SOLVED
Go to Solution
Highlighted
Valued Contributor

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,

1 ACCEPTED SOLUTION
HPE Expert

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.
9 REPLIES
HPE Expert

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

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

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,
HPE Expert

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

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,

HPE Expert

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

Re: SiteScope - DB2 Monitor

No that didn't work because the status ==200
HPE Expert

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

Re: SiteScope - DB2 Monitor

Well I can, hopefully they will understand...