Use this function to drop dynamic temporary tables that have been orphaned by failed and aborted processes. (Refer to Special Topic SA-4, "Application Locking/Dynamic Tables," for more information on dynamic temporary tables.) It results in a cleaner, more efficient database.
You can drop dynamic tables only if all the orphan tables were built by non-restartable processes. If any of the tables were built by restartable processes, you must run those restartable processes to completion before you can execute this function. To determine if there are interrupted, restartable functions, you can either run this function, which will then notify you if any exist, or you can check the POST_SEMAPHORE table to see if it contains any entries.
Only one user at a time can run this application. SQLBASE clients must use an Effective User ID of "DELTEK," and ORACLE and SQLSERVER clients must provide a System Admin User ID/Password. You can also use the Delete All Permanent Z Tables checkbox to truncate (delete in SQLBASE) all permanent Z Tables.
You can execute this process only when:
The Number of orphaned tables and views is greater than zero.
The Number of failed restartable processes is zero.
You cannot execute this process when:
The Number of orphaned tables and views is zero.
The Number of failed restartable processes is greater than zero.
This function has already been tried but an error occurred while dropping the tables.
Another user logs into Costpoint while this function is dropping the tables. This can happen if you forget to disable logins before entering this screen.
At system initialization, use the Maintain User Override Rights screen to give the Database Administrator limited rights to this function.
The Database Administrator should run this process as part of the database's regularly scheduled preventive maintenance procedures. Because it can be run only when everyone except the Database Administrator is out of the system, this function should be scheduled for a time when users are not normally in Costpoint. The Process Server cannot run at the same time as this function.
Before executing this function:
Prevent everyone from entering Costpoint by disabling Costpoint logins through the Enable/Disable Costpoint Usage screen.
Clear "phantom" users from the table in the Clear User(s) screen.
Instruct everyone listed in the table in the Clear User(s) screen to log out of Costpoint.
Continue steps 2 and 3 until the table in Clear User(s) screen is empty.
This group box displays the number of orphaned tables and the types of failed processes that created the tables.
The number of dynamic temporary tables in the database displays. A dynamic table is left in the database when the process that created it was interrupted before the table was dropped.
The number of interrupted processes that can be restarted displays. If this number is other than zero, you will not be able to drop the tables.
The number of interrupted processes that cannot be restarted displays. It is these processes whose tables are going to be dropped.
Select this checkbox to truncate (delete for SQLBASE) all permanent Z Tables.
Select this menu or toolbar option to drop the orphaned tables. This process will also truncate/delete permanent Z Tables if the Delete All Permanent Z Tables checkbox is selected. This option is enabled only when:
The Number of orphaned tables and views is greater than zero.
The Number of failed restartable processes is zero.
The Drop Orphan Tables option is disabled when:
The Number of orphaned tables and views is zero.
The Number of failed restartable processes is greater than zero.
This function has already been tried but an error occurred while dropping the tables.
Another user logs into Costpoint while this function is dropping the tables. This can happen if you forget to disable logins before entering this screen.