Before You Begin

Purpose

This OBE shows you how to use the Performance Workbench in the Server Manager Console.

Time to Complete

45 minutes

Background

Starting with Tools Release 9.2.9, Performance Workbench functionality is available directly from the Server Manager. Performance Workbench assists you in parsing and narrowing down the log file content to present information in a format that is easy to interpret. Instead of downloading log files to a Microsoft Windows workstation for analysis, the Performance Workbench enables you to create summary log files directly through the Server Manager Console. You can also download them to a local workstation for further evaluation.

Note: This is applicable only for Enterprise Servers and HTML Web (JAS) Servers.

Scenario

For this OBE, you will access the Performance Workbench functionality for an Enterprise server and update the options for the LogParse. You will then generate the output file the Enterprise server and download the output file to your local machine.

Prerequisite

Before performing the tasks in this OBE, you must ensure that:

• You are on Tools Release 9.2.9.
• Latest Roll-Up ESUs are installed.
• You have the permissions to access the Performance Workbench utility. For details, see Server Manager Permission Requirements in the JD Edwards EnterpriseOne Server Manager Guide.

Accessing the Performance Workbench

In this task you will learn how to access the Performance Workbench in the Sever Manager Console for the Enterprise and HTML servers.

1. Log in to the Server Manager Console with a user that has the enterpriseServerDeveloper permission for that server.
2. In Managed Homes section, navigate to the Enterprise server that has a debug log created.
3. Under Available Log Files, select the .log file for the Enterprise server and click the Analyze button.

The following screen displays the various Performance Workbench utility options with default values for logparse Options and SQLLogParse Options.

Generating LogParse Output File

In this task you will update the Performance Workbench options and generate the LogParse output file. The following screenshot displays the default values of logparse options:

1. In the Parse Level field, select 3 from the drop-down menu.
2. In the Timing Gap (in microseconds) filed, update the value to 10000.
3. Uncheck the Show Table Owners option.
4. Click Analyze.

   

   Output files are created in the Performance Results section with their respective file types.

   

   The syntax of the output file names is:
   <input log name>SUMMARY<ParseLevel>.html
   Where <ParseLevel> is a number from 1 to 5, specifying the level of detail in the summary file and which matches the specified Parse Level when generated.
   

   Observe the name of the Analysis Summary File is jde_360076_SUMMARY3.html since we selected 3 as the Parse Level. The syntax is similar for BSFN CSV, TBLE CSV, Timing Gaps, and UBE CSV file types.

5. Open the Analysis Summary File to verify that the output file is generated based on the options you updated. The Parse Level is 3, Timing Gap is 10000 and Show Table Owners is N as we had updated in the logparse options.

   

Generating SQLLogParse Output Files

In this task you will update the Performance Workbench utility options for SQLLogParse. The following screenshot displays the default values of SQLLogParse options:

1. In the Parse Level field, select 2 from the drop-down menu. Parse Level 2 generates only the SQLSTATS file.
2. Enter the table values in the Tables to Parse field. For this OBE, we will enter F9860.
3. Click Analyze.

   

   Output files are created in the Performance Results section with their respective file types.

Downloading Log Files

In this task you will download the output files in your local machine. For this task, we will download the BSFN CSV file.

1. Click the BSFN CSV output file.
2. After the file opens in the window, click the Download Entire Log File link at the top.



3. To download all the output files simultaneously, click the Download all in Zip button in the Performance Results section.

Want to Learn More?

• "Performance Workbench (Release 9.2.9" in the Server Manager Guide.