Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
The moose likes Performance and the fly likes Tuning SQL & JDBC for DB2 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Performance
Bookmark "Tuning SQL & JDBC for DB2" Watch "Tuning SQL & JDBC for DB2" New topic

Tuning SQL & JDBC for DB2

Monty Ireland
Ranch Hand

Joined: Oct 03, 2000
Posts: 161
I am presently tuning the following env.
java 1.2.1
jdbc 2.0
db2 7.2
I am trying to make my complex SQL run faster.
Possible in parallel within the DB2 engine.
Any idea's as to how I might?
1. configure JDBC
2. configure DB2 CLI
3. configure DB2 engine
I would greatly appreciate any and all wisdom.

Multi Platform Database Developer & DBA on E.S.T.
I agree. Here's the link:
subject: Tuning SQL & JDBC for DB2
It's not a secret anymore!