What is the maximum length of SQL queries that I can see using the RRM reports?
NetIQ Security Solutions for iSeries 8.0
VigilEnt Security Agent for iSeries 7.5
Remote Request Management (RRM)
I am running the RRM network transactions reports and my SQL queries featured are being cut off.
SQL statements coming through RRM are limited to 132 characters showing up in the RRM reports.
This is due to a restriction on our reports.
The report gets its data from the PSJRN01 journal and the actual data in the journal will cover the beyond 132 characters in the report.
This is dependent on whether you have our exit program on both QIBM_QZDA_SQL1 and QIBM_QZDA_SQL2 exit points.
OS/400 will decide, depending on the length of the query which exit point will cover the incoming transaction.
QIBM_QZDA_SQL1 will facilitate SQL requests < 512 bytes and QIBM_QZDA_SQL2 facilitates request > 512 bytes with a maximum of 32k bytes.