Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.9 - Installation Guide

Rollback Changes to Configuration Parameters

The Configuration analysis first executes the configuration parameter changes that you have selected on your database. Then it retrieves the query plan for each SQL statement that you have selected for your analyzer. When you set up the individual scenarios, you determine if you would like the configuration parameter changes rolled back or to leave them set on Adaptive Server.

If you do not have the analysis process rollback the configuration changes, you can roll them back in any one of the following ways:

  • In the tree pane (left pane), right-click the scenario name and select Go To Undo Changes.

  • When you close the Configuration Analyzer window, you are prompted to rollback the changes. Click Yes.

  • In the tree pane (left pane), click the scenario name and select the Apply/Undo Changes button at the top of the right pane. Click image\B_Execute.gif next to the Undo Change pane.

You can make the changes permanent, in one of the following ways:

  • In the tree pane (left pane), right-click the scenario name and select Confirm Changes.

  • When you close the Configuration Analyzer window, you are prompted to rollback the changes. Click No.

 

Related Topic

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating