RE: SQL statements through JDBC causing QPSRVDMP's

Query Id (QQRID) field with value 3010 contains parameter marker values for
associated SQL statement (associated via QQJFLD join field) in the column
QQ1000. There should be a list of comma separated values for each parameter
marker (?) in the statement.
I can't recall if IBM's SQL Performance Monitors have a report that ties
parameter marker values and associated SQL statements.... they might.
One of our tool does the association, that's how I know about it.

Another thing that caught my eye is that there were some messages about SQL
packages. These objects can get damaged. Good news is that they're
dynamically rebuilt as new statements flow across the Ethernet wire, so
usually you're fine by just deleting them and having them auto-rebuild.

Good luck.

Elvis

Celebrating 11-Years of SQL Performance Excellence on IBM i5/OS and OS/400
www.centerfieldtechnology.com


-----Original Message-----
Subject: Re: SQL statements through JDBC causing QPSRVDMP's

Elvis,

FWIW, I am getting a dump, not a job log, which I suppose is a good
thing if it wasn't in hex. I did run STRDBMON from Navigator and I can
see the statements. Nothing looks strange to me and the few statements
that I knew what to substitute in for the ? parameter markers, ran fine
using interactive SQL. (Man, I wish there was a way to see the actual
statements that were processed, including what as substituted in for the
parameter markers so you could just cut and paste into interactive SQL...)

I think the connections coming and going are a by-product of the abends
that are happening with the dumps, although I can't say that for sure.

I'll do some additional searching. I am also going to try this on a
V5R3M0 box and see if anything different happens.

Thanks