Creating a Code Analyst Session

Go Up to Using the Code Analyst

The Code Analyst Wizard creates a new Code Analysis session that creates data for the Code Analyst tabs:

1. On the Tools menu, select Code Analyst.
2. On the Code Analyst Tools toolbar, click Create New Collection.

   Rapid SQL opens the first panel of the Code Analyst Wizard.

3. Select the individual object or group of objects to analyze.
4. Click Next.

   If the object(s) selected to be analyzed requires parameters, the second panel of the wizard prompts you to enter the parameters.

5. Double-click the object to set the parameters.
6. For IBM DB2 LUW for Open Systems and Oracle, the Compile button opens the Confirm Compile dialog box that lets you compile the objects to ensure that the Code Analyst can capture the time metrics.
7. Click Finish.

   Code Analyst displays a message that the Code Analyst will run longer than the actual code. Then Code Analyst analyzes the objects, using the IDERA SQL Debugger to profile and then opens the Run Detail tab.

   Tip: You can also select the "Please do not show me this dialog again" option in the dialog box or set the option on the Code Analyst Options.

Code Analyst Wizard

The table below describes the options and functionality of the Code Analyst Wizard:

Option	Description
Session Name	Lets you type a name.
Select by Owner	Code Analyst Wizard queries the database to get the list of procedures and functions and lets you select objects to retrieve Codes for. Select to display available objects by owner, and then select the database(s).
Select by Object	Code Analyst Wizard queries the database to get the list of procedures and functions and lets you select objects to retrieve Codes for. Select to display available objects by object, and then select the object(s).
Object Name	Double-click each object to specify the input parameters. Specify which object executes first by clicking the Up and Down buttons.
Compile	IBM DB2 LUW FOR OPEN SYSTEMS AND ORACLE ONLY: Opens the Confirm Compile dialog box that lets you compile the objects to ensure that the Code Analyst can capture the time metrics.
Schedule	Opens the Select Scheduler dialog box or opens scheduling application.
Finish	Code Analyst analyzes the code.