JdeAnalyzer - Help

Main form is the starting point and also the most important part of the application. From the main form you can access form of settings, set debugging on/off, clear jdedebug.log or start optimization and analysis. You can also set the most important parameters here.

The main form contains the following fields and buttons:

• Input File - specify the input jdedebug.log file (generated locally or by a finished UBE)
• Output File - the optimized jdedebug.log file name
• Max Size - maximal size of Output File (when this size is reached, the process stops)
• Exclude irrelevant lines - if checked, the process removes lines that are not important (click button next to this checkbox to define list of strings - if any of these is found on a line then line is not exported)
• Exclude BSFN dumping - BSFN dumping may not be important for you, you can remove it checking this checkbox to reduce file size
• Exclude time information - each line in the log has its time information, this may be removed to reduce file size
• Exclude module information - each line in the log has its module information, this should be removed to reduce file size
• Time from - the log processing may start after a certain time in the log is reached, you can specify the time here as HH:MM:SS (if blank or 00:00:00 no restriction applies)
• Text from - you can start processing the log from the line where a certain text is found (could be name of the report or function), in such a case put the text in this field
• Functions extra info - when checked the JdeAnalyzer will analyze all business functions called and provide important information for each of them (see Additional Settings for more info)
• SQLs extra info - when checked the JdeAnalyzer will analyze all SQL Select statements called and provide important information for each of them (see Additional Settings for more info)
• Button Settings - this button activates form Additional Settings
• Button Start - this button starts the processing of jdedebug.log
• JdeDebug.log section - here you can erase content of jdedebug.log or open it
• Debugging section - here you can find out if the debugging is on or off and change it (it will not take effect until you restart)

In this form you can define additional settings for BSFN and SQLs analysis. These settings will take effect only of corresponding checkbox on the main form is checked (otherwise no information is generated). You can also define settings for other features of the application.

• Functions extra info
  • Filename additional text - define a string to be used for building the filename for output
  • Export all calls - if checked all calls and returns from functions will be logged individually
  • Export (summary) - if checked a summary information for each function will be exported
  • Export list of calling funcs - for each function in the summary the program will export a list of function that call the function
  • Export list of called functions - export list of subfunctions called
  • Only funcs with bad performance - to reduce the output JdeAnalyzer can export only those functions that could potentially impact performance (fast functions will be listed separately at the end)
• SQL Statements extra info
  • Filename additional text - define a string to be used for building the filename for output
  • Ignore system tables - some logs may contain many SQLs for system tables - these cannot be changed and may not be necessary to print to the output file
  • Only SQLs with bad performance - JdeAnalyzer exports only those SQLs that could impact performance
  • Generate detail statements - if off JdeAnalyzer will probably export one statement information per table/view, if on all columns in WHERE clause and ORDER BY clause will be also exported
  • Export calling function list - the same SQL statements may be exported from different BSFNs, to get complete list of the functions check this checkbox on
  • Export found/not found records - after each statement the jdedebug.log informs if a record was found or not - this information may be also useful and can be exported (note that number of fetched records based on an SQL statement may be much larger that the exported numbers, they only say how many SQL statements were successful and how many did not return any result)
• Other Settings
  • Display current environment in tray bar - check to display name of current environment on tray bar

If you decide to buy licences of JdeAnalyzer, you provide a company name and get a licence code. These two values together with proxy settings need to be provided to validate your full version of the application over the Internet. The licence is validated everytime you run the program or keep using the program for a longer period of time.

4. FAQs

Q: My statistics is not complete, some functions / SQL statements are missing
A: Run the analysis for all log without restrictions (fields Max Size, Time from, Text form should be empty)

Q: My statistics displays negative values for times or other nonsence
A: When more then one process runs at the same time (asynchronously) the logging is hard to read not only for a human