How did we improve lease and platform performance?


Improvements in IBM TRIRIGA Performance

By Rick Rhea & Jay Manaloto

What has the IBM TRIRIGA performance team been up to? Over the last few years and last few releases, our performance team has focused on areas that aren’t normally covered by our standard benchmark tests, and on tools that can help customers to resolve performance issues on their own. If you’re interested, here are a few of our recent improvements in lease and platform performance.

  • Lease Benchmark Testing: Not only are database server and process server resources especially important, but using multiple process servers improves performance.
  • New Recommended Indexes: Several additional indexes were identified and added to the best practices to obtain the best response times and resource utilization of the database server.
  • Lease Journal Entries: By redesigning journal entry processing with parallel and batch processing, and multiple process servers, our test results took only about 2.5 hours instead of over 90 hours.
  • Platform Enhancements: Dynamic workflows can now pass and return parameters, the Query task can now return the number of records instead of the actual records, and the Trigger Action task can now run the asynchronous event that occurs after the transition by a user other than the currently logged-in user.
  • BIRT Reporting & Lease Disclosure Reports: In Version 3.6.1, the reporting was modified to improve running on a separate BIRT server, and to avoid the problematic “params.displayText”.
  • Performance Analyzer Tool: In Version 3.5.3, this tool was introduced to allow a customer to run specific logging types without using the Admin Console, and to view easy-to-read reports.
  • Module Level Associations, Early Adopter Feature: In Version 3.7.0, the platform was enhanced to support Module Level Associations (MLA) tables where the records in the IBS_SPEC_ASSIGNMENTS table are distributed into smaller tables that are created by module type.

By applying the above finding and tools, our recent IBM TRIRIGA 10.7.0 / 3.7.0 release has demonstrated a significant improvement in performance over previous releases. But we’re not done yet! Our performance team will continue to dig deeper into weaker areas or potential opportunities to make our products stronger or faster. So stay tuned for any upcoming developments!

Note: For future releases, “Module Level Assignments” will be renamed “Module Level Associations”.

References:

[Admin: This post is related to the 07.27.17 post about the Performance Analyzer. To see other related posts, use the Performance tag.]

Continue reading

IBM InterConnect 2017 Bootcamp labs developers shouldn’t miss


When learning about new technologies and tools, it often helps to get one’s hands just a little bit dirty and see what really makes them work. That’s the idea behind the new Bootcamp labs at IBM InterConnect 2017, March 19-23 in Las Vegas.

These instructor-led labs run 3 to 4 hours, giving enrollees the opportunity to do hands-on work with new products and technologies. Attendees can find a deeper dive in these sessions led by subject matter experts…

IoT Platform to Maximo/TRIRIGA hands-on lab

Thursday, 8:30 AM – 12:15 PM, Mandalay Bay South Seas I1, Session ID: 7436A

This lab offers attendees a basic understanding of how connected operations work. Use a simulated temperature sensor (a gauge meter in Maximo) to send a temperature reading to the Internet of Things (IoT) Quickstart. The message is then sent to NODE-RED, which parses the message. When a reading changes, it goes into a REST-API call that inserts the meter reading into the referenced asset meter readings. The reading updates the measure point and triggers a work order using Maximo functionality, or if one chooses to do so, using a TRIRIGA work task…

[Admin: This post is related to the 02.06.15 post about exploring the TRIRIGA user group community, and the 06.07.16 post about using sensors with Watson IoT to create TRIRIGA work tasks.]

Continue reading

Why can’t the Cleanup Agent clean large number of records?


I have a problem with a TRIRIGA environment. Due to an inefficient integration, we have a large number of records with a negative Object ID ready to be cleaned by the Cleanup Agent. But it seems that the Cleanup Agent can’t clean that many records.

Can I configure something or execute something into the database to clean everything in parts? I guess that I cannot simply execute a delete into the database, where the object_id < 0, since there must be more things to clean.

No, you should not go into the back-end and execute a delete on the database. There is a lot more to clean up. What do you mean the Cleanup Agent cannot clean that many records? Are you getting an exception? The OBJECT_ID must be negative, the OBJECT STATE should be null, and the UPDATED_DATE must be over 24 hours earlier for the Cleanup Agent to pick up the records to delete. It also might take a couple runs of the Cleanup Agent to delete all of the associated records.

[Admin: This post is related to the 02.24.16 post about cleaning up after retiring a record, and the 07.14.15 post about cleaning up millions of workflow instance records. As a side note, starting with version 3.4, the Cleanup Agent name was changed to Platform Maintenance Scheduler.]

Continue reading

Can you remove invalid database objects after platform upgrade?


After a platform upgrade, certain invalid Database Views appear. But the TRIRIGA application works fine. So are these Database Views safe to remove? Here’s the list of Database Views:

  • M_TRIPAYMENTAUDITSETUP
  • M_TRISERVICEMATRIX
  • V_CLASSIFICATION
  • V_LOCATION
  • V_TRIASSET
  • V_TRIBUDGET
  • V_TRICOMMON
  • V_TRICOSTCODE
  • V_TRICOSTITEM
  • V_TRICOSTITEMLINK2
  • V_TRIINSPECTION
  • V_TRIPEOPLE
  • V_TRIPRODUCTSANDSERVICES
  • V_TRIPROJECT
  • V_TRIPROPOSAL
  • V_TRISETUP
  • V_TRISPECIFICATION
  • V_TRISUBMITTAL
  • V_TRITASK

The above invalid Database Views are doing fine in the minor platform releases, but are never in use. They were used for older pass-through BOs that newer 10.x application versions do not use. Consult with your DBA to drop the Database Views. They can always be recreated when you need them.

Continue reading

Did you know that free TRIRIGA courses are in the IoT Academy?


Watson IoT Academy includes courses and training to give you the edge you need to maximize your IoT experience. Our experts have developed detailed courses to keep you up to date on the latest features in your IBM IoT solutions, with offerings that include practical simulations and best practices.

Conquer Your Facilities Challenges

IBM Facilities Management solutions enable you to make faster, more informed decisions through identification of high-return real estate transactions, simplified facility planning, and automated facilities processes. Use business analytics to identify underperforming facilities, resources and management processes against planned performance targets. Leverage management dashboards to increase the effectiveness of anyone who uses the system…

Here’s the growing list of available TRIRIGA Platform II interactive simulations:

  • TRIRIGA Platform II – Actions (TRS001EN)
    • Actions
  • TRIRIGA Platform II – Advanced Queries (TRS002EN)
    • Charts
    • Business Object Queries
    • Introduction to Association Filters
    • User Identification Filters
    • Query Filters

20160322a

20160322b

Continue reading

UX: How do you use globalization & security in the UX Framework?


UX Framework: Globalization

Venice Inid, TRIRIGA Platform Developer, presents the new UX globalization options in our classic platform tools and UX designer tools, which support the UX Framework. First, she talks about the dictionary, translatable text, and other options. Next, she shows us where to find the options in the globalization tools.

20160229a

Continue reading

UX Framework: Security

Sandy Garcia, TRIRIGA Platform Developer, presents the new UX security options in our classic platform tools and UX designer tools, which support the UX Framework. First, she gives an overview of the classic security and UX security concepts. Next, she dives deeper into the UX licensing, UX data sources, and UX designers.

20160229b

Continue reading

[Admin: This post is related to the 12.11.15 post about the UX framework. This post is also related to the UX ArticlesUX Videos, and UX Lessons blog pages.]

Continue reading

UX: How do you build an app in the IBM TRIRIGA UX Framework?


UX Framework: Overview

Chris Jones, TRIRIGA Platform Architect, presents an overview of the UX Framework. First, he talks about the key objectives, key concepts, and new designer tools. Next, he shows us how to use the UX designers, WebViewSync tool, and component doc pages. Finally, he compares exposed names and navigation items.

20160220a

Continue reading

UX Framework: Building an Application

Chris Jones, TRIRIGA Platform Architect, presents a tutorial on how to build an application in the UX Framework. First, he talks about how to use the UX designers, WebViewSync tool, and component doc pages. Next, he shows us how to add components, like a header, card layout, custom page, toast popup, and floor plan.

20160220b

Continue reading

[Admin: This post is related to the 12.11.15 post about the UX framework. This post is also related to the UX ArticlesUX Videos, and UX Lessons blog pages.]

Continue reading

Having issues with TRIRIGA BIRT reports after upgrade to 3.4.2


I’m having issues with a platform upgrade to 3.4.2 on Linux and WebSphere (not Liberty). BIRT is failing to connect. But TRIRIGA is connecting to the database without issue. Any insight would be most appreciated.

error: JDBCException: There is an error in get connection, IO Error: The Network Adapter could not establish the connection.

Continue reading