Communication between JAVA and DB2 HowTo?

Andreas I. · #1 (**permalink**) 02-16-09, 10:20

Hello, i am new to Java and DB2. If my posting is just too stupid, please dont laugh that loud.

Situation:
There is my PC with a JAVA-application
There is another PC running a DB2.
Both PCs stand in different buildings, connected via VPN.

An IBM DB2 client runs on my PC.
The JAVA-application ist connected to the DB2, i can send SQL-queries and receive results.

Everything fine until now...

The Problem is:
I want to send other commands to the DB2 like "get snapshot for all on ds2"
But that doesnt work!
Here is my code:

Code:

   Connection con = null; 
          try 
          { 
         con = DriverManager.getConnection( "jdbc:db2:DS2", "**username**", "**password**" );
         Statement stmt = con.createStatement(); 
         ResultSet rs = stmt.executeQuery( "get snapshot for all on ds2" );

I get this error: "com.ibm.db2.jcc.b.SqlException: [jcc][10103][10941][3.50.152] Die Methode executeQuery kann nicht zur Aktualisierung verwendet werden. ERRORCODE=-4476, SQLSTATE=null
"

This is german. It means "you cant update with executeQuery"...
BUT: I dont update my Database. I just want to read some Monitor-datas...

Help! How to read monitor-data from DS2?

ARWinner · #2 (**permalink**) 02-16-09, 11:23

You cannot run db2 commands using jdbc. What db2 version and OS are you using?

Andy

Andreas I. · #3 (**permalink**) 02-16-09, 11:28

My PC is Windows XP.
The other PC running DB2 is Linux. DB2 Version 9.5.0.808

ARWinner · #4 (**permalink**) 02-16-09, 11:35

You can use jdbc to query the admin views and functions and that will get you the snapshot info.

Andy

sathyaram_s · #5 (**permalink**) 02-16-09, 11:48

Refer
IBM DB2 9.5 Information Center for Linux, UNIX, and Windows

Cheers
Sathyaram

Andreas I. · #6 (**permalink**) 02-16-09, 11:52

Thank you!
I will search, which admin view contains the required information.

But does this work for ALTER TABLESPACE too?
I want to change some DB2-Parameters like prefetchsize.

ARWinner · #7 (**permalink**) 02-16-09, 12:02

I believe that ALTERTABLESPACE is regulare SQL and can be executed through jdbc. To change parameters, look at the ADMIN_CMD stored Procedure.

Andy

Andreas I. · #8 (**permalink**) 02-16-09, 12:13

thank you! I wil try that.

Andreas I. · #9 (**permalink**) 02-17-09, 12:07

Hello,
meanwhile i could get the required Information by query an admin view. That worked fine. example:
ResultSet rs = stmt.executeQuery( "SELECT sum(PREFETCH_WAIT_TIME) AS TIME FROM SYSIBMADM.SNAPAPPL" );
...to query the current PREFETCH_WAIT_TIME...

To change Prefetchsize, do this:
int rs = stmt.executeUpdate( "ALTER TABLESPACE USERSPACE1 PREFETCHSIZE 128" );

executeUpdate instead executeQuery

Just, if someone else has the same problems!

Internet Services

Web Development

Digital Marketing

Consumer Tech