Hi,

I am getting below while calling the proc using the IBM provided sample code (attached).
Error code - 600 ; Error message - Could not open connection

The same connectivity is working from DB Visualizer and there are no errors in jdbcm4 trace file. How to fix this error?

Your PUT call is writing the JDBC adapter trace to m4jdbc.mtr.  That will be in the 'map directory', which will vary depending upon how you're calling the map.  If you're running in the Design Studio or an ITX engine, such as the Launcher, it will be in the same directory with the .mmc.

Take a look at that.  You should get some more specific information.

Your PUT call is writing the ITX JDBC adapter trace to m4jdbc.mtr.  Look there for more specific information.  That file will be in you 'map directory', which will vary depending upon how you're calling the map.  If your using the Design Studio, it will be in the same directory as the .mmc.

I was working on DB2 SP a while back using the JDBC adapter.  It uses both input/output cards and GET function.  I am attaching the project here, see if it's helpful?

Attachment(s)

DB2_SP.zip   40 KB 1 version