The following tasks are used frequently when you need to perform general database maintenance tasks.
Define databases for logging on to Smart Instrumentation — Use this procedure to enable Smart Instrumentation users to select a database when logging on to Smart Instrumentation. After performing this procedure, users can select a database from the Database list on the Logon Information dialog box and connect to this database. All the databases that you want to make available for connection must belong to the same database platform: Oracle or SQL Server.
Switch between databases — Use this procedure to switch from one database to another using the Database Profile Manager.
Rebuild default views in domains — Use this procedure to rebuild the default views of all the database objects for a specific domain. You must rebuild the default views after upgrading SmartPlant Instrumentation to Version 2016 SP1. This is because during the upgrade, the software makes changes to certain tables, and as a result, the default views associated with these tables might become invalid.
Rebuild stored procedures and triggers — This procedure is used by the System Administrator for the following purposes:
-
To identify abnormal database behavior and solve it by rebuilding the stored procedures and triggers in the database if the software displays inappropriate SQL messages when using Smart Instrumentation.
You can rebuild stored procedures either for the Admin schema or for a specific Domain schema.
Rebuild catalog tables — Use this procedure to rebuild the catalog tables, which enable users to work with multi-tag specifications in the Specifications module. The software creates the catalog tables during the Smart Instrumentation database setup. If the software encounters a database problem when creating the catalog tables, you can try to rebuild them to resolve the problem. If such a problem occurs, the software displays a message notifying you that you cannot work with multi-tag specifications due to a problem with the catalog tables.