LogParse
This example shows a list of output files generated for an Enterprise Server using LogParse with default options.
The following are some examples of LogParse log files. For the purpose of documentation, these examples are truncated.
Example: LogParse – SUMMARY.html
Example: LogParse – STDERROR.txt
Performance Workbench [/u01/jde920/jde_home/SCFHA/perf/results/jdedebug_3344_STDERROR.txt]
stderr file for: /u01/jde920/e920/log/jdedebug_3344.log
===============
PW logparse: May 2018 - #1
Processing: /u01/jde920/e920/log/jdedebug_3344.log...
Writing Results:
DONE!!! Summary file: /u01/jde920/jde_home/SCFHA/perf/results/jdedebug_3344_SUMMARY5.html
Timing Gap file: /u01/jde920/jde_home/SCFHA/perf/results/jdedebug_3344_TIMING5.txt
BSFN csv file: /u01/jde920/jde_home/SCFHA/perf/results/jdedebug_3344_BSFN5.csv
TBLE csv file: /u01/jde920/jde_home/SCFHA/perf/results/jdedebug_3344_TBLE5.csv
UBE csv file: /u01/jde920/jde_home/SCFHA/perf/results/jdedebug_3344_UBE5.txt
logparse processed in 0 seconds
(Hit ENTER..)
Example: LogParse –
BSFNS.csv
Performance Workbench [/u01/jde920/jde_home/SCFHA/perf/results/jdedebug_3344_BSFN5.csv]________________________________________
Level 1?,BSFN name,count ,error(2) ,TOTAL(s) ,AVG(s) ,< 1 us ,max(s) ,min(s)
#,SecureAddressBookTables ,76405784,1, 0.158019, 0.158019, 0.000000, 0.158019, 0.158019
#,DetermineToolsReleaseforABDP ,73906608,1, 0.108011, 0.108011, 0.000000, 0.108011, 0.108011
,GetABConstants ,71407432,1, 0.031990, 0.031990, 0.000000, 0.031990, 0.031990
,GetServicePackRelease ,68908256,1, 0.029003, 0.029003, 0.000000, 0.029003, 0.029003
#,jdeInitEnvBSFN ,66409080,1, 0.004001, 0.004001, 0.000000, 0.004001, 0.004001
,TOP LEVEL,63909904,0, 0.000000, -nan, 0.000000, 0.000000, 0.000000
Example: LogParse –
TIMING.txt
Performance Workbench [/u01/jde920/jde_home/SCFHA/perf/results/jdedebug_3344_TIMING5.txt]
The following statements took at least 0.020000 seconds in logfile: /u01/jde920/e920/log/jdedebug_3344.log:
===============================================================
GAP TIME(s) BSFN LINE
=========================================================
0.928999 : TOP LEVEL : Nov 27 06:36:58.595001 - 3344/1020 Using ICU data file "icudt52l.dat"
0.050000 : TOP LEVEL : Nov 27 06:36:59.524000 - 3344/1020 About to call dispatch function, flags=0x2, Type=13513
0.157000 : TOP LEVEL : Nov 27 06:36:59.579000 - 3344/1020 SYS:XMLDispatch Site key request send to 10.0.1.143_anykrnl_m2 (SQLENT326)
0.062999 : TOP LEVEL : Nov 27 06:36:59.810001 - 3344/1020 SYS:XMLDispatch Try to send the message to security server SQLENT326
0.032000 : TOP LEVEL : Nov 27 06:36:59.880000 - 3344/1020 SYS:XMLDispatch ODBC DBInitDriver envr=0807E750,pool=Y.
0.032998 : TOP LEVEL : Nov 27 06:37:00.018002 - 3344/1020 SYS:XMLDispatch ODBC:S DBPerformRequest req=087DFD58,con=087DBF80,env=016F04C0,dbc=016FCF40,spid=106 SqlDb326 A (PD920@JDE920)
0.029990 : TOP LEVEL : Nov 27 06:37:00.057010 - 3344/1020 SYS:XMLDispatch ODBC:S DBPerformRequest req=087E2140,con=087DBF80,env=016F04C0,dbc=016FCF40,spid=106 SqlDb326 A (PD920@JDE920)
0.029999 : TOP LEVEL : Nov 27 06:37:00.093001 - 3344/1020 SYS:XMLDispatch ODBC:S DBPerformRequest req=087E2140,con=087DBF80,env=016F04C0,dbc=016FCF40,spid=106 SqlDb326 A (PD920@JDE920)
0.029996 : TOP LEVEL : Nov 27 06:37:00.135004 - 3344/1020 SYS:XMLDispatch ODBC:S DBPerformRequest req=087E2140,con=087DBF80,env=016F04C0,dbc=016FCF40,spid=106 SqlDb326 A (PD920@JDE920)
0.031992 : TOP LEVEL : Nov 27 06:37:00.173008 - 3344/1020 SYS:XMLDispatch ODBC:S DBPerformRequest req=087FA758,con=087DBF80,env=016F04C0,dbc=016FCF40,spid=106 SqlDb326 A (PD920@JDE920)
Example: LogParse –
UBE.txt
Performance Workbench [/u01/jde920/jde_home/SCFHA/perf/results/jdedebug_3344_UBE5.txt]
UBE debug tags in logfile: /u01/jde920/e920/log/jdedebug_3344.log
=========================
Example: LogParse –
TBLES.csv
Performance Workbench [/u01/jde920/jde_home/SCFHA/perf/results/jdedebug_3344_TBLE5.csv]
________________________________________
O/C mismatch,Table,Open,Close,SELECT,INSERT,DELETE,UPDATE
,F0004,1,1,0,0,0,0
,F0005,1,1,0,0,0,0
,F0006,1,1,0,0,0,0
,F0007,1,1,0,0,0,0
,F0008,1,1,0,0,0,0
,JDE_PRODUCTION.PRODDTA.F0009,2,2,1,0,0,0
,JDE_PRODUCTION.PRODDTA.F0010,2,2,1,0,0,0
,F0012,1,1,0,0,0,0
,F0013,1,1,0,0,0,0
,F0014,1,1,0,0,0,0
,F00144,1,1,0,0,0,0
,F0015,1,1,0,0,0,0
,F0022,1,1,0,0,0,0
,F0025,1,1,0,0,0,0
,F0026,1,1,0,0,0,0
,JDE920.SY920.F0092,2,2,2,0,0,0
,JDE920.SY920.F00921,1,1,1,0,0,0
,JDE920.SY920.F00926,2,2,2,0,0,0
,JDE920.SY920.F0092L,1,1,1,0,0,0
,JDE920.SY920.F0093,1,1,1,0,0,0
,JDE920.SY920.F00941,3,3,3,0,0,0
,JDE920.SY920.F00942,3,3,3,0,0,0
,JDE920.SY920.F00942T,1,1,2,0,0,0
,JDE920.SY920.F00945,1,1,1,0,0,0
,JDE920.SY920.F00948,1,1,1,0,0,0
,JDE920.SY920.F00950,2,2,3,0,0,0
JASLogParse