Converting IBS_SPEC_ASSIGNMENTS
to Module Level Assignments
Historically, the IBM®
TRIRIGA® Application Platform
stores all associations between records in the IBS_SPEC_ASSIGNMENTS
table. As an
alternative, the 3.7.0 platform has been enhanced to support Module Level Assignment tables. The
Module Level Assignments (MLA) converter tool takes the IBS_SPEC_ASSIGNMENTS
table and distributes the IBM TRIRIGA
records that are found into smaller tables that are created by module type.
The converter executable is located in the directory where you installed IBM TRIRIGA Application Platform 3.7.0 at <installation-directory>/tools/MLA-Converter. Review the prerequisites and conversion instructions below. For more information, see the 3.7.0 Module Level Assignments video.
Contents
I. Prerequisites
To use the Module Level Assignment (MLA) enhancements, you must first install or upgrade to IBM TRIRIGA Application Platform 3.7.0. After installing or upgrading, you must also perform your normal platform-upgrade regression testing. Make sure that your applications behave as expected. Validate the install or upgrade prior to starting the MLA conversion.
IBS_SPEC_ASSIGNMENTS
table is to restore it from your backup.II. Important Information
- Supported databases: Currently, this converter supports Oracle and DB2 databases only. It does not support Microsoft SQL Server.
- Reverse associations: The Reverse Association flag in the IBM TRIRIGA Report Manager is disabled since this functionality is no longer supported. After converting your database to use Module Level Assignments, the Reverse Association flag in queries and reports is ignored and only forward associations are allowed in reports and queries. Reverse associations as defined in the Association Manager and created through workflow tasks are still supported, and are used to fix any of the reports that are missing data because of the use of the flag.
- Customized databases: The converter does not support customized databases where
partitioning, additional indexing, triggers, or other non-as-delivered database features have been
added to the
IBS_SPEC_ASSIGNMENTS
table. The default tablespace will be used as defined in TRIRIGADB.properties.