RE: QSQSRVR jobs on AS400

[lloen@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx]

Ashish Kulkarni writes:

> Hi When ever we run a java job which creates a JDBC connection using native
> driver it creates a spool file, how can we stop this does anyone have any
> idea about it.
> I think when we create a JDBC connection using non native driver it does not
> create this spool file.

> Ash

Check your connection options.  I don't recall ever getting a spool file
just for opening a native connection.  Perhaps there is some debug
option or other that is set.  Or, perhaps you "wrapper" the connection
function with a few lines of code (e.g. add some debug print that was
supposed to check a DEBUG variable that was compiled as "final" and
"true" or some such) and the debug code executes on the native path
only.


Larry Loen
www.applicationperformancegroup.com