Chat now with support
Chat mit Support

Space Manager with LiveReorg 9.0 - User Guide

Smart Start for Space Manager Collect Statistics Profile DML Activity Manage Storage Reorganize Objects with Reorg Manager Partition Tables with the Partitioning Wizard Run and Monitor Scripts Run Reports Options Troubleshooting Administration Functions Appendix About Us

Status Codes for Script Execution

This section provides a list of status codes for scheduled server-side script execution. These are displayed in the Status Message column of the Script/Job Monitor.

Codes for Script Groups

Code Message

0

New

10

Unscheduled

Displayed for script groups that are stored, but not scheduled.

50

Completed

Displayed for script groups that have executed successfully.

100

Scheduled

Displayed for script groups that are scheduled and waiting to run.

200 Active
300 Interrupted

Codes for Unscheduled Scripts

Code Message

110

Unscheduled

Displayed for scripts that are stored, but not scheduled.

Codes for Completed Scripts

Code Message

210

Completed

Displayed for scripts that have executed successfully.

220

Completed with Warnings

Displayed for scripts that have executed with one or more warnings (but no errors).

230

Completed with Errors

Displayed for scripts that have executed, but with one or more errors (and possibly warnings).

Codes for Scripts that Are No Longer Running

Code Message

310

Canceled by request

Displayed for executing scripts that have been canceled by the user.

320

Aborted

Displayed for scripts that have been aborted due to an error. An error message is also displayed.

324

Aborted no restart

Displayed for live reorganization and partitioning scripts that cannot be restarted. This status is displayed after an attempt to restart a script is made. Usually, it indicates that a QUEST_EXEC command is not scripted correctly. It can also indicate that a LiveReorg object or control structure needed by QSA is missing. For help in cleaning up LiveReorg objects, contact Quest Software Support. Once cleanup is performed, a new script can be generated for objects in the failed script.

325

Aborted restart

Displayed for live reorganization and partitioning scripts that cannot be restarted. This status is displayed after an attempt to restart a script is made. Usually, it indicates that a LiveReorg object or control structure needed by the QSA is missing. For help in cleaning up LiveReorg objects, contact Quest Software Support. Once cleanup is performed, a new script can be generated for objects in the failed script.

350

Aborted internal

Displayed for scripts that failed due to a fatal internal error. Information on the error is displayed in the script execution log.

360

Aborted timeslot

Displayed for scripts that did not start within 10 minutes of their scheduled time. There is a 10-minute time window for the start of script execution. If QSA is running or started during this time window, a script is executed by QSA. If QSA is started after the time window ends, a script is aborted. Reschedule the script or run it using the Execute function available in the Scripts/Job Monitor. Check the monitor to see QSA’s status.

Codes for Halted and Scheduled Scripts

Code Message

370

Halted for datafile maintenance

Displayed by default for scripts that have been paused for datafile maintenance or another purpose. Your own reason for a pause is displayed after “Halted for…” if you entered one when you selected the script-pause option. This option was available for standard reorganizations with Reorg Manager in previous releases (8.0.2 or earlier) of Space Manager.

410

Scheduled

Displayed for scripts that are scheduled and waiting to run.

Codes for Executing Scripts

Code Message

510

Executing

Displayed for scripts that are currently executing.

515

Processing with posting paused

Codes for LiveReorg Scripts

Code Message

520

Posting live modifications

Displayed for live reorganization scripts for which live updates made to the original tables are being posted to reorganized copy tables.

610

Blocked

Displayed for live reorganization scripts that are waiting to obtain a lock on one or more tables that are locked by another session. Tables are locked briefly at the beginning of the data copy stage of a live reorganization. They are also locked briefly during the switch from reorganized table to copy table when the T-Lock switch style is used.

620

Waiting until Day/Date/Time

Displayed for live reorganization scripts that are waiting for a user-specified time window to make the switch from original tables to reorganized copy tables.

630

Waiting for approval

Displayed for displayed for live reorganization scripts that are waiting for the user to approve the switch from an original table to a reorganized copy table.

 

Error Messages

This section provides a list of the error messages generated by QSA. The description for each error includes cause and recommended action. Most QSA error messages are displayed in the Status Message column of the Scripts/Job Monitor.

Oracle errors are also displayed in the Scripts/Job Monitor. For more information on Oracle errors, see the Oracle documentation and Common Oracle Errors Found in Script Execution.

Note Most QSA error messages have a prefix of “QSA”. The error messages QSA generates for FastCopy have a prefix of “FC”.

Show all

 

Administration Functions

License Key

After you first install the Space Manager client and try to connect to a database, you are prompted to enter a license key. Once you enter a permanent key, you do not need to enter it again. It is preserved during upgrades. You only need to change or re-enter a license key when:

  • Your trial key expires.
  • You switch from a trial key to a permanent key.
  • You change your licensing agreement with Quest Software.
  • You uninstall and then reinstall the Space Manager client.

To update a license key

  1. Select Tools | Admin | License Key.
  2. Enter your permanent or trial license key.

 

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen