What is the maximum length of SQL queries that I can see using the RRM reports? (NETIQKB54901)

  • 7754901
  • 02-Feb-2007
  • 08-Oct-2007

Resolution

goal
What is the maximum length of SQL queries that I can see using the RRM reports?

fact
NetIQ Security Solutions for iSeries 8.0

fact
VigilEnt Security Agent for iSeries 7.5

fact
Remote Request Management (RRM)

symptom
I am running the RRM network transactions reports and my SQL queries featured are being cut off.

cause
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.

fix

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.



Additional Information

Formerly known as NETIQKB54901