As you monitor and manage scheduled scripts from the Scripts/Job Monitor window, you can also monitor and manage the Quest Server Agent (QSA). This allows you to easily check the status of QSA, which is used to run stored scripts. Most management functions can only be used when QSA is running.
You can check the status of QSA from the QSA Status panel at the top of the Scripts/Job Monitor window. You can also check its status in the QSA field in the top-right corner of the Script Properties dialog.
QSA can be in one of four states:
QSA starts automatically during installation on UNIX servers and local Windows servers (those that reside on your Space Manager client computer). To start QSA on a remote Windows server, use the Windows Services window on the server.
In most cases, QSA starts automatically when it is installed. It then runs continuously, waiting to execute scripts at their scheduled times. Normally, QSA only needs to be restarted if it was stopped using the Stop Quest Server Agent function.
The Start Quest Server Agent function can be used to start QSA on local Windows servers (those that reside on your Space Manager client computer) and on UNIX and Linux servers to which you have both SSH and SFTP access. See Start QSA Under Special Circumstances for more information about starting QSA with other configurations.
Note: If QSA is not running when a script’s scheduled execution time occurs, you have 10 minutes in which to start it. The script is executed when QSA starts. If QSA starts after the 10-minute time window ends, the script aborts with this error: “QSA-20312: Scheduled launch time expired”. To run a script whose launch time has expired, execute it on demand or reschedule it from the Scripts/Job Monitor.
To start QSA from the Scripts/Job Monitor
Use the Restart Quest Server Agent function when you do not have the permission level necessary to start the Quest Server Agent. The Restart Quest Server Agent function automatically stops and restarts the agent. This only requires the same permission level as that for stopping the agent.
To restart QSA from the Scripts/Job Monitor
The Stop Quest Server Agent function can be used to stop QSA on local Windows servers (those that reside on your Space Manager client computer) and on UNIX and Linux servers to which you have both SSH and SFTP access. See Stop QSA Under Special Circumstances for more information about stopping QSA with other configurations.
To stop QSA from the Scripts/Job Monitor
Tip: You can also start, restart, and stop QSA using the Tools | Admin | Quest Server Agent menu. See Start or Stop QSA Server Agent for more information.
Space Manager with LiveReorg includes the Find Long LONGs package. This allows users and reorg tools to easily identify tables with “long LONG” columns. These are LONG or LONG RAW columns that are larger than 32,760 bytes in size.
The size of LONG and LONG RAW columns determines which data movement method can be used to reorganize their tables. Tables that contain LONG columns in which some rows contain data larger than 32,760 bytes must be reorganized with FastCopy (or DBMS_DataPump). Tables that contain LONG columns where all rows are 32,760 bytes or less can be reorganized with either FastCopy/DBMS_DataPump or SQL (PL/SQL is used).
If a table is not supported for FastCopy (or DBMS_DataPump) and its LONG columns are 32,760 bytes or less , run the long LONGs procedure to provide this information to Space Manager. This information may enable Space Manager to reorganize the table. If Space Manager does not know the size of a LONG column, its table is excluded from reorganization.
Reorg Manager automatically checks the Find Long LONGs table to identify tables with long LONGs. You can query the table yourself to identify these tables. See Query the Find Long LONGs table for more information.
The Find Long LONGs package (QUEST_SPC_FIND_LONG) is installed with Space Manager. (The package is installed via the SPC_PKG_FIND_LONG.SQL script, which is located in the INSTALL subdirectory of the Space Manager client directory.) The package includes the following:
Find Long LONGs procedure—Called QUEST_SPC_FIND_LONG.EXECUTE, this procedure populates the Find Long LONGs table with information on the size of any LONG or LONG RAW columns contained in your tables.
For more information about the Find Long LONGs procedure or to learn how to run the procedure, see Populate the Find Long LONGs table.
Important: Before you can use the Find Long LONGs package, Oracle’s UTL_RAW package must be installed and valid on your database server.