subject: Re: SQL diags to return actual statement executed?

Hello

Subject 5: Re: SQL diags to return actual statement executed?

If you wan't to monitor all SQL statements - simply

Start Iseries Navigator
Select DataBases
Select SQL Performance Monitors
Select "Create a new SQL Performance Monitor"

Find the job you require to trace by selecting ADD, and when the SQL has
been executed, rigth click on the performance monitor and select "End"

A lot of reports are now avaliable regarding Which SQL statements were
executed, time of executing etc.

After analysis remember to delete the performance data.

If you are having a hard time finding the QZDASOINIT or QZRCSRVS jobs
for the user simply enter:

WRKOBJLCK OBJ(USERPROFILE) OBJTYPE(*USRPRF)




Kind regards/Venlig hilsen,
Jesper Juul Fjeldgaard
System administrator
ERP Operations - Group IT
JEJFJ@xxxxxxxxxx
Vestas Wind Systems A/S