The following objects are core objects in TRIRIGA Application Platform functionality and any modifications to these objects are not supported by TRIRIGA.
Any TRIRIGA-shipped Business Objects belonging to the following Modules should not be modified. Care should also be taken in modifying any Forms, Queries and Workflows belonging to the following Modules as platform functionality can be affected. (There may be other objects not included in this list.)
[Admin: To see other related posts, use the Best Practices tag.]
Does anyone have any experience in extracting TRIRIGA data from the database directly through Oracle SQL Developer? I am trying to extract through SQL code, and combine in one table, the data from triSpace, triSpaceClassCurrent, and triSpaceStandardsSpec. The idea is to create a single table with all spaces, space classifications, and space standards.
[Admin: To see other related posts, use the Oracle tag or SQL tag.]
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 signing into IBM TRIRIGA and navigating to Tools > System Setup > System > Database Table Manager.
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.
Migrating database table indexes
You can view, alter, drop, and create database table indexes in the Database Table Manager tool. In addition, the Database Table Manager supports the migration of database table indexes from one IBM TRIRIGA environment to another.
The process of migrating database table indexes is done through the migration of record data on the triPlatformDBTableManager module.
[Admin: This post is related to the 02.10.17 post about finding the performance best practices, and the 01.15.15 post about custom tuning indexes for performance.]