SQLLogParse

This example shows a list of output files generated for an Enterprise Server using SQLLogParse for the F986101 table.

The following are some examples of SQLParse log files:

Example: SQLParse – SELECT.txt

Performance Workbench [/u01/jde920/jde_home/SCFHA/perf/results/jdedebug_3344_F986101_SELECT.txt]________________________________________
**SELECT statements for F986101 in /u01/jde920/e920/log/jdedebug_3344.log:
==========================================================================
(UNIQUE SELECTS & counts)
UNIQUE statements
=================
7
TOTAL Statements
================
7      
COUNT     SQL
========  ===
1         SELECT OMENHV, OMAPPLID, OMOBNM, OMDATP, OMDATS, OMUGRP, OMOAPP, OMDATM, OMOVRE, OMSY, OMSTSO, OMFUNO, OMOCM2, OMOCMDSC FROM JDE920.SVM920.F986101  WHERE  ( OMENHV = 'PD920' AND OMSTSO = 'AV' AND  ( OMUGRP = 'JDE' OR OMUGRP = '*ALL' OR OMUGRP = '*PUBLIC' OR OMUGRP = ' ' )  )  ORDER BY OMSTSO ASC,OMAPPLID ASC

Example: SQLParse – SQLSTATS.txt

Performance Workbench [/u01/jde920/jde_home/SCFHA/perf/results/jdedebug_3344_SQLSTATS.txt]________________________________________
SQL Statistics File for: /u01/jde920/e920/log/jdedebug_3344.log
-----------------------
.F986101 :
==========
      7  SELECTs
      7  Unique SELECTs
      0  UPDATEs
      0  Unique UPDATEs
      0  INSERTs
      0  Unique INSERTs
      0  DELETEs
      0  Unique DELETEs

Example: SQLParse – SQLParse_STDERROR.txt

Performance Workbench [/u01/jde920/jde_home/SCFHA/perf/results/jdedebug_4088_SQLParse_STDERROR.txt]________________________________________
Parsing SQL statements in /u01/jde920/e920/log/jdedebug_4088.log...
 F986101 
Writing SQL Stats file...
Writing UNIQUE SQL files...
(Hit ENTER..)
Parsing SQL statements in /u01/jde920/e920/log/jdedebug_4088.log...
 F986101 
Writing SQL Stats file...
Writing UNIQUE SQL files...
(Hit ENTER..)

Example: SQLParse – UPDATE.txt

Performance Workbench [/u01/jde920/jde_home/SCFHA/perf/results/jdedebug_3344_F986101_UPDATE.txt]________________________________________
**UPDATE statements for F986101 in /u01/jde920/e920/log/jdedebug_3344.log:
==========================================================================
(UNIQUE UPDATES & counts)

Example: SQLParse – DELETE.txt

Performance Workbench [/u01/jde920/jde_home/SCFHA/perf/results/jdedebug_4088_F986101_DELETE.txt]________________________________________
**DELETE statements for F986101 in /u01/jde920/e920/log/jdedebug_4088.log:
==========================================================================
(UNIQUE DELETES & counts)

Example: SQLParse – INSERT.txt

Performance Workbench [/u01/jde920/jde_home/SCFHA/perf/results/jdedebug_3344_F986101_INSERT.txt]________________________________________
**INSERT statements for F986101 in /u01/jde920/e920/log/jdedebug_3344.log:
==========================================================================
(UNIQUE INSERTS & counts)