Slow JDBC DB2 Connection
Hello, Having an issue with a new server we are setting up. The server is Linux RHE 4, running DB2 8.1 and Domino 7.03. Our DB2 databases reside an a separate dedicated DB2 server and are cataloged on our new server. Connections to these databases are working fine using SQL tools and from the server [...]

Answer Question   |  January 8, 2009  9:12 PM
DB2, DB2 8.1, DB2 8.x, DB2 Performance, Domino 7.0.3, Domino 7.x, JDBC, Linux RHE 4

db2 os/390 v8 utility unload template parms
Hi, We are switching to use the unload utility from the unload program (dsntiaul). I would like to know how to use the template feature to allow multiple volumes to be used in the output. Since we use SMS to manage our storage devices and we want the output on dasd not tape, we normally [...]

Answer Question   |  September 23, 2009  3:56 PM
DB2, DB2 8.x, DSNTIAUL, OS/390

DB2: Optimizer not using any indexes
I have DB2 version 8.2 installed in AIX one thing I am seeing is strange that optimizer not using any indexes. In any simple join index are not being used. Is there any parameter which needs to be set up?

Answer Question   |  August 14, 2008  5:15 PM
AIX, DB2, DB2 8.x