RE: SQL statements through JDBC causing QPSRVDMP's

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
bounces@xxxxxxxxxxxx] On Behalf Of Elvis Budimlic
Sent: Friday, January 25, 2008 2:58 PM
To: 'Midrange Systems Technical Discussion'
Subject: 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.

Some of the Ops-Nav reports do tie parameters to statements.

But that won't help with being able tot do the cut & paste Pete wants as the show up in a different
column.



Charles Wilt
Software Engineer
CINTAS Corporation - IT 92B
513.701.1307

wiltc@xxxxxxxxxx




This e-mail transmission contains information that is intended to be confidential and privileged. If you receive this e-mail and you are not a named addressee you are hereby notified that you are not authorized to read, print, retain, copy or disseminate this communication without the consent of the sender and that doing so is prohibited and may be unlawful. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please delete and otherwise erase it and any attachments from your computer system. Your assistance in correcting this error is appreciated.