Performing Database Maintenance - PAS ICS Integrity - 7.3 - Help - Intergraph

ICS Integrity Help

Language
English
Product
PAS ICS Integrity
Subproduct
ICS
Search by Category
Help
PAS Version
7.3

The Database Maintenance options on the Maintenance window allow you to rebuild the full-text search catalog and table indexes, identify spare assets, update friendly names, and more. In addition to these options, review the other maintenance considerations for data backup, archiving, and other data maintenance and management tasks. For more information, see Maintaining Integrity.

To perform Integrity database adjustments using the Admin Utility:

  1. In the Admin Utility, click the Maintenance link in the Ongoing Maintenance section. The Maintenance window is displayed.

    The Database Maintenance section of the Maintenance window provides rebuild and index options that apply to all assets, as well as other options that apply only to the selected asset.

  2. If you want to update full-text search capabilities, click Rebuild Full-text catalogs. This option begins a background process to update the full-text catalog used to perform full-text searches. Rebuilding the full-text index can be time intensive, based on the volume of data that needs to be processed, so rebuild the catalog only if you observe issues with the full-text search results. If a user performs a search before this background process finishes, only the results that have been indexed up to that point are returned without indicating the data is incomplete. To use the full-text search in Integrity, the SQL Full-text Filter Daemon Launcher service must be enabled and running on the Microsoft SQL Server.

  3. If you want to view the status of the database table indexes, click Index Monitor. This option displays the Database Index Monitor window, which displays the index status for each database table. You can view the status of all indexes or only the fragmented ones. The Reindex Needed column identifies the indexes that should be rebuilt. To rebuild indexes, choose whether to rebuild the selected indexes, all fragmented indexes, or only the system-wide indexes (common tables' indexes), and then click Rebuild Now. You can sort the displayed information by clicking on a column heading.

  4. If you want to update the spare reservations for an asset, select the asset, check the Spare Reservations check box, and then click Run. This option begins an update of spare reservations that have been filled with objects previously deleted from a prior import.

  5. If you want to update the friendly name for an asset, select the asset, check the Update friendly names check box, and then click Run. This option begins an update of the name displayed for objects of the selected asset.