Space Manager with LiveReorg 9.0 - User Guide

Change Approval Method

You can change the approval method (switch option) for online scripts. Approval method determines how the switch proceeds for a live reorganization script or a partitioning script.

Approval method can be changed for online scripts that are waiting to run or waiting to be restarted. A change in approval method applies to all tables in a script for which the switch has not yet been made.

For more information about approval methods (also known as Switch Options), see Select Scripting Options and More About Scripting Options (LiveReorg).

To change approval method

1. In the Script/Job Monitor, do one of the following to change approval method:
   • Right-click a script group and select Change Approval Type.
   • Right-click a script group and select Properties. Then select the Script Attributes tab.
2. Select one of the approval types.
3. Click OK to save your changes and close the dialog.

Related Topics

Approve the Switch

Approve the Switch

When the switch option for a live reorganization script is Upon user approval, you must approve the switch for each table in the script. You can do this from the Scripts/Job Monitor or from its Live Reorg Detail pane using one of the following procedures.

To see if a table is waiting for the switch to be approved, check the Status Message column in Scripts/Job monitor. “Waiting for approval” is the status for a script when one of its tables is waiting for approval.

After you approve the switch for one table in a script, check to see when the next table is ready for the switch. How much time passes before approval is required depends on the size of the table being reorganized, the number and size of its indexes, and the level of activity against the table.

To approve the switch from the Scripts/Job Monitor

1. Open the Scripts/Job monitor by selecting Manage | Script/Job Monitor.
2. Check the Status Message column. “Waiting for approval” is displayed for each live reorganization script with a table that is ready for the switch.
3. Right-click a live reorganization script and select Approve Switch.

To approve the switch from Live Reorganization Detail

1. Open the Scripts/Job monitor by selecting Manage | Script/Job Monitor.
2. Select a live reorganization script. Information on the script is displayed in the Live Reorganization Detail pane.
3. When “Stage 3 (Waiting for approval)” is displayed for a table in the Live Reorg Detail pane, right-click anywhere in the pane and select Approve Switch.

Enable SMTP Email Notification

When you are away from the Space Manager client computer, you can monitor scheduled execution with email notifications from QSA. These alert you when scheduled execution fails. QSA sends an email immediately after a failure occurs.

Each email notification identifies script name, execution error, execution start and stop times, database server hostname, and Oracle SID for the database. The subject field displays “Script Failure Notice!”.

QSA emails notifications when its SENDMAIL parameters are configured. These parameters allow you to specify who should receive notifications. You can specify both a primary and a secondary recipient. A recipient can be an individual or an email group.

Important: Before you can use QSA’s email notification capability, Oracle’s UTL_SMTP package must be installed on the database server. The package must have access to an SMTP mail server or relay server.

Use the following procedure to enable email notification. To configure notifications for other events, see Configure Additional Notification Events.

To enable email notifications

1. Run Space Manager and connect to the target database for QSA. Connect as the Oracle DBA that installed the agent.

2. Select Tools | Admin | Quest Server Agent | Manage Quest Server Agent Installation.

3. Select Configure Quest Server Agent and click Next .
4. If your database resides on a UNIX or Linux server, a login window displays. Enter the login name and password of the UNIX or Linux account that installed the agent.

5. On the QSA Parameters page, set the following SENDMAIL parameters in order to enable email notifications (values are required for all parameters except SENDMAIL_TO1):

   QSA Parameter	Description
   SENDMAIL_DOMAIN	Specifies the domain name of the mail server or relay server. For example: yourcompany.com.
   SENDMAIL_HOST	Specifies the address or fully-qualified name of the mail server or relay server host, for example: www.quest.com.
   SENDMAIL_PORT	Specifies the port number on which the mail server or relay server is listening.
   SENDMAIL_FROM	Specifies who sent the email notification. The text string you enter should be the email address of an individual or group, such as Administrator@yourcompany.com.
   SENDMAIL_TO	Specifies the email recipient. Must be the email address of an individual or group, such as DBA@yourcompany.com. The address must be valid. Only one address may be entered.
   SENDMAIL_TO1	Specifies a second recipient for email notifications. To specify three or more recipients, insert a row for each recipient in the QUEST_EXEC_PARAMETER table, where NAME is SENDMAIL_TO# and VALUE is a valid email address. Each SENDMAIL_TO# entry should increment by 1; for example, SENDMAIL_TO3, SENDMAIL_TO4. If there is a break in the number sequence, emails are not sent to recipients after the break. If you delete a recipient row, update the NAME rows that follow so the number sequence is preserved. You can specify a maximum of 99 recipients.

6. Click Next and then Finish to save your entries and close the QSA Installer.
7. After enabling email notification, see Configure Additional Notification Events to learn how to configure notifications for other events.

Note: To disable SMTP email notification, set the SENDMAIL_PORT value to "0".

Related Topics 

Configure Additional Notification Events

Enable SNMP Traps Notification

You can monitor scheduled execution for reorgs using Simple Network Management Protocol (SNMP) Trap notifications from QSA. If you enable these notifications, QSA alerts you when a scheduled execution fails. QSA sends a notification immediately after a failure occurs.

Use the following procedure to enable SNMP trap notification. To configure notifications for other events, see Configure Additional Notification Events.

Note: In addition to using an SNMP trap watcher program, you can also use Quest Foglight® to receive SNMP notifications.

To enable SNMP Trap notifications

1. Run Space Manager and connect to the target database for QSA. Connect as the Oracle DBA that installed the agent.

2. Select Tools | Admin | Quest Server Agent | Manage Quest Server Agent Installation.

3. Select Configure Quest Server Agent and click Next .
4. If your database resides on a UNIX or Linux server, a login window displays. Enter the login name and password of the UNIX or Linux account that installed the agent.

5. On the QSA Parameters page, set the following SNMP parameters in order to enable SNMP trap notifications.

   QSA Parameter	Description
   SNMP_TO_HOST	Enter the host name for the SNMP monitor.
   SNMP_PORT	Enter the port number that the SNMP monitor is listening on.
   SNMP_COMMUNITY	Enter the name of your SNMP community (or any unique string value).

6. Click Next and then Finish.
7. Stop and then restart QSA from the Tools | Admin | Quest Server Agent menu.
8. After enabling SNMP trap notification, see Configure Additional Notification Events to learn how to configure notifications for other events.

Note: To disable SNMP trap notification, set the SNMP_PORT value to "0".

Related Topics 

Configure Additional Notification Events

Enable Email (SMTP) Notification