Database tables
As an administrator, you can view, alter, drop, and create database table indexes in the Database Table Manager tool. This tool is not found in the IBM® TRIRIGA® Administrator Console. With the proper permissions, you can find the Database Table Manager by logging into IBM TRIRIGA and navigating to .
The Database Table Manager supports the following actions on IBM TRIRIGA database tables: viewing table indexes, altering table indexes, dropping table indexes, and creating new table indexes. These actions can be performed on any IBM TRIRIGA table. For environments that use a Microsoft SQL Server database, the actions of viewing, creating, and removing Sparse columns are also supported.
Full access to this tool is limited to admin users who have full access to the IBM TRIRIGA Administrator Console. Admin users who have read-only access to the Administrator Console can view the indexes and Sparse columns only. All other users don't have access.
Database table synchronization
When you open the Database Table Manager tool for the first time, such as after a new or upgrade installation, you must synchronize the database table indexes or Sparse columns.
The Synchronize Table Manager button performs a sync of all database table indexes and Sparse columns into record data that allows tables to be manageable.
When you select this button, a process is started that might take several minutes to run. This sync process is useful if new business objects are created and you want to manage the new T_TABLE that defines the new business objects. The sync process is also useful if at any time you suspect the Database Table Manager record data is not in sync with the database table indexes or Sparse columns.