RE: QSQSRVR jobs on AS400

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