Sitescope Monitor DB2 10.x (388 Views)
Reply
Frequent Visitor
meltem84
Posts: 3
Registered: ‎02-13-2014
Message 1 of 7 (388 Views)
Accepted Solution

Sitescope Monitor DB2 10.x

Hi,

 

is Sitescope 11.01 compatible with DB2 10.x?

 

I tried to create a new monitor with the available monitor template "DB2 8.x and 9.x" . The connection to the DB2 10.x was successful:

 

Step 1:Attempting to Locate Driver Class...
Driver Class: com.ibm.db2.jcc.DB2Driver LOCATED SUCCESSFULLY!

Step 2:Attempting to Load Driver Class...
Driver Class: LOADED SUCCESSFULLY!

Step 3: Attempting to Connect to Database...
Database: jdbc:db2://xxx.xxx.xxx.xxx.com:port/database_name Connection ESTABLISHED SUCCESSFULLY!

Step 4: Attempting to Execute Query...
Statement created.
***ERROR***: The supplied Query will not execute because it is either invalid, the table does not exist or some of the columns do not exist.

Status Summary: Error from database driver: DB2 SQL Error: SQLCODE=-440, SQLSTATE=42884, SQLERRMC=FUNCTION;SNAPSHOT_LOCK, DRIVER=3.67.26

 

It can't handle with the standard query select * from table(SNAPSHOT_LOCK('database_name',-1)) as PG, table(SNAPSHOT_APPL_INFO('database_name',-1)) as AI where AI.agent_id = PG.agent_id

 

Is there a possibility to create a monitor for DB2 10.x?

 

Thanks & regards,

Meltem

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

Re: Sitescope Monitor DB2 10.x

Hi,

 

You can try using the database query monitor, but youhave to place a compatible jdbc driver in SiteScope\WEB-INF\lib folder

 

Also please verify if the account you are using has enough permissons to execute queries over that table.

 

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.
HP Expert
kenneth.gonzalez
Posts: 1,761
Registered: ‎04-28-2011
Message 3 of 7 (364 Views)

Re: Sitescope Monitor DB2 10.x

Hi,

Check DB2 docs for your error code. -440 means unauthorized:

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2z9.doc.codes/src/...
Kenneth Gonzalez
HP Support

If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.

If you haven’t tried it yet, come and join us in our entitled forums at Support Customer Forums
Frequent Visitor
meltem84
Posts: 3
Registered: ‎02-13-2014
Message 4 of 7 (349 Views)

Re: Sitescope Monitor DB2 10.x

Hallo,

 

thank you for the quick reply.

 

I have enough permissions to read the DB2 tables.

 

I want to use the standard counters for DB2 like "Buffer Pool/no counters avilable check snahpshot switches" and the other standard counters.

 

 

Is there a possibility to create this counters for DB2 10.x via query monitor? Where can I see the statements behind the standard counters?

 

Thx and regards,

Meltem

HP Expert
A_Krizhanovsky
Posts: 16
Registered: ‎01-24-2013
Message 5 of 7 (340 Views)

Re: Sitescope Monitor DB2 10.x

Hi ,

Sure, you can create DB Query monitor against your DB2 environment
Connection URL - jdbc:db2://<host>:<port>/<database>
Driver - com.ibm.db2.jcc.DB2Driver
Also specify username, password and query
Best Regards, Alexander
SiteScope Core QA Team Engineer
Frequent Visitor
meltem84
Posts: 3
Registered: ‎02-13-2014
Message 6 of 7 (313 Views)

Re: Sitescope Monitor DB2 10.x

Hi,

 

i need a list of the quires for the db2 counters. The connection is not the problem.

 

Regards,

 

Meltem

HP Expert
kenneth.gonzalez
Posts: 1,761
Registered: ‎04-28-2011
Message 7 of 7 (307 Views)

Re: Sitescope Monitor DB2 10.x

Hi,

Check SiteScope/template.applications/DB2_Queries.xml file.
Kenneth Gonzalez
HP Support

If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.

If you haven’t tried it yet, come and join us in our entitled forums at Support Customer Forums
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.