Let’s talk about analyzing logs.
Everybody knows OW Debug Log Commander, from Everest software. Is really a great JDE geek tool to help us to start/stop a log session and also come with other cool features like Julian calendar converter (in my opinion the best julian date converter on the market now!) and deletion of Global Tables, the famous “DD” files.
And I believe most of you know or heard about Performance Workbench. Performance Workbench is a set of tools that parse a log file accordingly to some input parameters to get statistical data, like business functions timing, SQL statements, number of table access like select, delete, update, etc… You must uncompress the parse .EXE files in a separate directory (I usually use C:\PARSE) and run the main program. It does not have any other tool like in OW Debug Log Commander, but is really useful – specially for HUGE logs.
But, what if you get together the best of OW Debug Log Commander and Performance Workbench and put more amazing features all in one software??? Well, it looks like a dream, right? No, it’s real and it’s called JDE Trace, by PatWel.
It has a couple years I’m using this and once you get the philosophy, you’ll never want to use anything else!
Below, I’ll list the features for JDE Trace
- The data is broken out by process/thread and displayed in a tree control.
- Follow the flow of a session and find BSFN errors/warnings.
- Paste business function parameters to the clipboard for use with JDE Object Browser
- Dynamically control trace status (jdedebug.log) for any process
- Truncate jdedebug.log files with one click
- Delete global tables, dddict and ddtext spec files
- Date conversion tool
- SQL Analysis Pane shows the activity on all referenced tables
- Cache Analysis Pane shows all cache activity
- BSFN Analysis Pane shows each function reference with time statistics
- Includes support for JAS debug files.
- Details show the execution time of a BSFN or SQL statement
- Long Tasks pane lists BSFN calls or SQL statements with a long execution time
- Errors/Warnings pane lists instances of BFSN warning/errors and GBR Errors
You can find the JDE Trace in http://www.patwel.com
I’ll post a tutorial showing the details and features of JDE Trace this week!! See you soon!