IBM Sustainability Software - Ideas Portal


This portal is to open public enhancement requests against the products and services belonging to IBM Sustainability Software. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).


Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,

Post your ideas

  1. Post an idea.

  2. Get feedback from the IBM team and other customers to refine your idea.

  3. Follow the idea through the IBM Ideas process.


Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

Add a new idea Subscribe
Status Future consideration
Workspace IBM TRIRIGA Application Platform
Created by Guest
Created on Dec 19, 2022

RELATED IDEAS

Need of the nightly/daily batch options in Tririga to process CPU Intensive workloads

Implementation background -

As part of our application module rollouts and enhancements, we have enabled bulk processing on several CM, PM, and FM related functionalities. For example, CM users can upload excel sheet with capital projects and create several projects in one go using mass uploads. PM AR users can also use the bulk uploads to create abstracts, activate, approve, terminate contracts. We have over 30 bulk related functionalities and some of these are DB CPU Intensive.

Problem statement –

Business users can trigger any of bulk processes during business hours and some of these processes are DB CPU intensive thus causes the CPU Saturation on the database for the duration of the batch which in turn depends on the type and size of the batch. As Tririga do not have any built-in way of controlling the execution of batches or accepting them and scheduling for later in the day as evening/nightly batch, we foresee a scenario where our critical transactions like creation/approvals/assignments etc would run longer due to different batches running during the day.

Ideas to solve this problem -

A couple of solution approaches we have thought of are to either

 - Let the business users trigger the batches which can be batched into smaller batches with system controlling the size of the batch rather than letting system process everything as fast as possible. 

 - Let the business users trigger the batches and application accept these batches and queue them but implement strategies to trigger the processing of these batches at appropriate time (evening/night) rather than on demand. 

Expectations from submitting this idea - 

IBM Tririga Platform team should include the option to trigger large batches on demand /on schedule /on pre-defined priority/ run out of priority options in the Product so that business users can take full benefit of the Tririga capabilities on running bulk processes and limitations on controlling them effectively.

Idea priority High
Needed By Quarter
  • Post comment
  • Admin
    Lou Giambalvo
    Reply
    |     Apr 30, 2023

    Hi Jatinder, Thank you for the additional information.

    Thank you for taking the time to provide your ideas to IBM. Our team has evaluated your idea and we will leave it here and review periodically for possible inclusion in a future release. You can encourage others to show support by voting on this idea. Thank you again for your feedback.

  • Admin
    Lou Giambalvo
    Reply
    |     Apr 26, 2023

    The following was received from Jatinder:


    Yes, we discussed the high-level idea to develop an external intervention system that would retrieve the data from the database or through web service and use rules (business\priority\available capacity) to implement a gate control for the batches.


    At high level we want to use the following rules.

    1. Urgency or Business priority (some batches need to be done immediately, some don't).

    2. No. of batches of one type in queue and size of these batches.

    3. No. of workflows in the wf_event table.

    4. Estimated Run time of the batch processes.

    5. Utilization on the database/Proc server.

  • Admin
    Lou Giambalvo
    Reply
    |     Apr 25, 2023

    Jatinder, could you please provide more details on examples of specifc rules you would like to be able to use to prioritize different batch processes?

  • Admin
    Lou Giambalvo
    Reply
    |     Jan 25, 2023

    Hi Jatinder, Thank you for taking the time to provide your ideas to IBM.

    • Are you familiar with the the max workflow threads (WF_AGENT_MAX_ACTIVE_PER_USER) parameter?

    • Have you explored adjusting this parameter to improve results related to this use case?

    • What specific technologies are being used to trigger these batch processes? Data integrator, Intergration object, TRIRIGA offline, etc..

    I look forward to your response. Thank you again for your feedback

    1 reply

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.