Skip to Main Content
IBM Data and AI Ideas Portal for Customers


This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization. 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

Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the IBM team to refine your idea


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.

IBM Employees should enter Ideas at https://ideas.ibm.com


Status Planned for future release
Created by Guest
Created on Feb 3, 2025

Improve speed and stability of Controller when have large numbers company locks (XACCLOCK table)

If a customer has a complicated company structure (e.g. with many different actualities) then after they create company locks for all their periods/actualities, XACCLOCK becomes absolutely enormous

  • For example, one of our customers has 22 million records (in XACCLOCK) just for the single period 2412 !

    • 825,230 are in period 2412AC

    • 32,000 are in 2412BU

    • 900,000 in 2412F1

    • and so on...

The massive XACCLOCK SQL table causes very slow read/write queries to the table. This causes problems e.g.:

(a) User's sessions hang when they try to use the menu 'change status'. The hanging can last 2-120 minutes depending on how many changes they make in there

(b) During this 'hanging' period, no new users can logon to Controller (they all get “Communication link failure” …Timeout error [258]” errors)

=> Downtime

+++++++++++++++++

Please can you improve the product to achieve BOTH of the following:

(1) Method to delete old company locks (trim XACCLOCK) from inside the GUI (so the end user can do it - the method does not have to use SQL scripts)

(2) Method to prevent hanging/system-downtime when changing status (if there is a large XACCLOCK)

  • For example, create a better SQL index or (probably a better idea) partitioning of the SQL table XACCLOCK (e.g. a separate partition for each period or period/actuality-combination)

  • This would allow for faster queries (thereby not causing the hanging/timeout errors when changing status!)

+++++++++++++++++

Many thanks!

Needed By Quarter
  • Admin
    Maximilien de Chestret
    Reply
    |
    Feb 28, 2025

    Planned for end of Q2, probably would be part of the optimization screen