Running SQL Scripts for Oracle Schema Users

Atlas Hub comes with some SQL scripts written specifically for use with your database. These scripts help you maintain and tune Atlas Hub databases. You run some SQL scripts after installation, some on a weekly basis for database performance maintenance, and some scripts are run for you automatically by Atlas Hub.

The SQL scripts for Oracle schema users that you may run are located in the Micro Focus\Hub\DBScripts\Oracle_Scripts folder.

Note: The Oracle_Scripts folder contains several subfolders: Create_Stored_Procedures, Drop_Stored_Procedures, Install, Preinstall, Generic, and DW (for Data Warehouse). The scripts in these subfolders are run by Atlas Hub as needed. Never execute any of them directly from an external database user interface, such as SQL*Plus or SQL *Worksheet.

The following table lists the SQL scripts that you are most likely to need. Some should be run manually on a regular basis. The table recommends the frequency for running these scripts. You may adjust the frequency depending on the Atlas Hub usage at your facility. Run scripts at times when the server is least used, such as overnight or on weekends.

In addition to running these scripts, you should also run a Purge option from the Server Administration tool to remove deleted views from the database. We recommend purging the database after you have deleted one or more views from a project. See the Server Administration Tool Help for information on the Purge option.

StarTeam Script Name Run Frequency
starteam_oracle_compute_stats.sql Weekly
starteam_oracle_dropall.sql Only if necessary
starteam_oracle_rebuild_indexes.sql Weekly
Be sure to backup your Atlas Hub schema user, as necessary, and verify these backups periodically. You should restore and test backups of your Atlas Hub project data on a test system. Restoring and testing your backups helps to ensure that your data is being backed up correctly.

To run a SQL script for Oracle schema users:

  1. Go to the command prompt.
  2. Change directories to the directory containing the Atlas Hub SQL scripts for Oracle schema users.
  3. At the command prompt, type: sqlplus username/password@servicename
    The Atlas Hub Oracle Schema User Name.
    The Atlas Hub Oracle Schema Password.
    The Net Service Name created using Oracle Net 8 Easy Config.
  4. Execute the script.

    For example, to execute the starteam_oracle_compute_stats.sql script, type @starteam_oracle_compute_stats.sql and press Enter.