[sqr-users] DB2 timing report of SQL statements in a SQR program

["Victor Loghin" <VictorLoghin@vgl.ca>]

Fellow Listers,
 
I have developed a program to produce a timing report of the SQL
statements in a SQR programs run on DB2 for z/OS. I have been using it
for a while and have found it very useful in identifying SQL performance
problems.  
I have made it available for download on my web site. I call this tool
the SQL Timor. It is used in conjunction with another tool called the
Formator. The Formator reads in a SQR program and insert calls to the
SQL Timor for all SQL statements. The modified code is run and the
timing report is displayed at the end of the program.
Even though it is written specifically for DB2 on z/OS, it should work
with DB2 UDB on Linux, UNIX and Windows. The only call to the database
is to get the current timestamp from SYSIBM.SYSDUMMY1 and my
understanding it is supported on UDB. If anyone tries it on DB2 UDB,
please let me know if it works.
 
Documentation for can be found at
<http://www.vgl.ca/Tools/SQLTimor/_main.htm> SQLTimor and
<http://www.vgl.ca/Tools/Formator/_main.htm> Formator.
Both can be downloaded from  <http://www.vgl.ca/Download/_main.htm>
http://www.vgl.ca/Download/_main.htm. 
 
Victor Loghin
VGL Consulting Inc.
VictorLoghin@vgl.ca
 <http://www.vgl.ca> www.vgl.ca
 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users