Skip to Main Content
IBM Power Ideas Portal


This portal is to open public enhancement requests against IBM Power Systems products, including IBM i. 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.

Status Delivered
Workspace IBM i
Categories IBM i Access Family
Created by Guest
Created on Aug 20, 2021

ACS Sql scripts F4 Prompt is too slow

IBM does not support CA for Windows so IBM is wanting users to move to ACS. IBM wants us to move away from greenscreen SQL and use the ACS SQL Scripts. Well there have been many issues I have found with this ACS software.
But this case concerns the F4 Prompt to get the field list. On the IBM greenscreen the prompt is instant. I knew it would be slow on the PC side but not this slow. We prompt several, several times while creating a single SQL statement and the ACS app takes about 10-15 seconds each time (sometimes it has been 25-30 seconds) to display the field list for us to choose the fields we want to use. If IBM wants us to use this tool it needs to be faster. It should either cache the field list on the first prompt, or it should maintain a file/field list based on the default libraries in the setup. If you want people to move to a product it needs to perform well. It's usually the little things that kill a great app. Joined files really kill time when using the prompt.


Use Case:

Daily reporting. Ad Hoc reporting. Data Analysis/repair.


Idea priority Low
  • Guest
    Reply
    |
    Apr 15, 2024
    This support is available in version 1.1.9.5. Performance improvements have been made.
    IBM Power Systems Development
  • Guest
    Reply
    |
    Feb 14, 2024
    Improvements have been made and will be available in our next update.
    IBM Power Systems Development
  • Guest
    Reply
    |
    Oct 20, 2023

    I also fine the RSS prompting slow, especially if an SQL view is used in the SQL script. I don't think remote access has anything to do with this issue, acts the same with a local connection.

  • Guest
    Reply
    |
    Jun 15, 2023

    I too find the Run SQL Scripts prompting slow and at times unusable. I nearly always work remotely (connecting over a VPN) so I imagine this is a factor, however it is a very common practice to work remotely.

  • Guest
    Reply
    |
    Feb 22, 2022

    The CAAC has reviewed this requirement and recommends that IBM view this as a medium priority requirement that should be addressed. At times the slow behavior makes the content assist almost unusable.

    Background: The COMMON Americas Advisory Council (CAAC) members have a broad range of experience in working with small and medium-sized IBM i customers. CAAC has a key role in working with IBM i development to help assess the value and impact of individual RFEs on the broader IBM i community, and has therefore reviewed your RFE.

    For more information about CAAC, see www.common.org/caac

    Nancy Uthke-Schmucki - CAAC Program Manager

  • Guest
    Reply
    |
    Jan 25, 2022

    Have you checked the network connection? or have the admin check the line description? if you are running on a slower network, or you are running on a VPN and the VPN is throttled or the line description is configured to use a lower line speed, that can all effect the speed of the ACS content assist.

  • Guest
    Reply
    |
    Sep 13, 2021

    The CEAC has reviewed this requirement and recommends that IBM view this as a HIGH priority requirement that is important to address.
    Interacting with SQL via the RSS function is a key part of life in IBM i today. Anything that improves the performance of content assists in RSS would be welcomed.

    Background: The COMMON Europe Advisory Council (CEAC) members have a broad range of experience in working with small and medium-sized IBM i customers. CEAC has a crucial role in working with IBM i development to help assess the value and impact of individual RFEs on the broader IBM i community and has therefore reviewed your RFE.

    To find out how CEAC help to shape the future of IBM i, see CEAC @ ibm.biz/BdYSYj and the article "The Five Hottest IBM i RFEs Of The Quarter" at ibm.biz/BdYSZT

    Therese Eaton – CEAC Program Manager, IBM

  • Guest
    Reply
    |
    Aug 25, 2021

    IBM has received this request and will consider it for a future code update. No commitment is made or implied.

  • Guest
    Reply
    |
    Aug 25, 2021

    IBM has modified some of the information in this request. Please contact us if you have any questions.

    In particular, information that was not related to this specific RFE was removed, so others may more easily read the details about this specific request, and decide whether to add a comment or vote for it.

  • Guest
    Reply
    |
    Aug 25, 2021

    Hi DSANDERS

    I think there might be a problem with you network or system configuration, possibly the Antivirus running on you PCs.

    I say this as I have 30+ LPARs of IBM i and my team look after another 50 LPARs for clients and I am not seeing anything like that response time on any support hardware or IBM i OS. (I.E Power8 or 9, IBM i 7.3 or 7.4) In fact, I don't remember it being that bad on a POWER6 at 7.1.

    As a test, I've just accessed by smallest LPAR for the first time this week (0.1 Processors with 4GB RAM, running 7.3) and the first time I prompted in ACS RSS it took a little over a second to complete, if I were to then repeat the prompt, it's instant.

    I'm not saying IBM cannot do more to optimise their code, but the behaviour you describe is not normal.

    I hope you find out what the issue is as ACS should be a lot more fun for you when it's running faster.

    Best wishes, Brad
    Steve Bradshaw
    IBM Champion, Member of CEAC, TD if i-UG.co.uk
    and Friendly Techie Bloke at Rowton.IT

    PS
    When if comes to the RFE website, I feel your pain, it does get easier as you submit more of them. Ironically, you an submit an RFE for the improvement of the RFE website. I have done this and to be fair they did make the change.
    That said, I am sometime tempted to submit another RFE to ask them to rewrite the RFE website to run on IBM i but I suspect that would fall well on truly on deaf ears.