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 (

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 ( - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal ( - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM. - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

Status Not under consideration
Workspace IBM i
Categories Db2 for i
Created by Guest
Created on Jun 27, 2018

RPG IV extension regarding license program 5770SS1-27-DB2-Multisystem

RPG IV provides a file information data structure with database specific feedback information. In position 397 of the FIDS there is an unsigned integer field for the relative record number. This field contains the RRN of the record which was affected by the last I/O operation. With this field it is possible to uniquely identify every record in an ordinary file. In case you use the license program DB2 Multisystem and you create a partitioned table it is no longer possible to identify a record uniquely only with the RRN in position 397 of the FIDS. We need an additional field in the FIDS which specifies the member of the physical file the record belongs to. With the both fields member and RRN it would be possible to identify a record uniquely in a partitioned table.

Use Case:

There are more and more IBM i shops outside who have files with hundreds or even billions of records in a file. If such a file needs to be changed, e.g. a new field has to be added, you can do this by the commands CHGPFM or ALTER TABLE. The problem with this commands is, that the files are exclusive locked as long as the commands are running. This means the users cannot work with their application. Depending on the amount of the records in the file there could be a downtime of the application of hours or even days. Today a lot of companies are working 24 hours a day and 7 days a week and there is no time frame for such a installation. Because of this we created the open source project "Rapid Fire". Here is the link. With Rapid Fire it is possible to reduce the downtime of your application to minutes instead of hours or days if you have to change a file with hundreds or billions of records. The technique behind the scene is described here in section "Deploying Data File Changes With Rapid Fire". Rapid Fire works great for ordinary physical files but not for partitioned tables. To make Rapid Fire work for partitioned tables it is necessary to have additionally the member in the file information data structure.

Idea priority Urgent
  • Guest
    Feb 15, 2019

    Thank you for your request. Unfortunately, after investigating the effort to implement this request, we have found that it would require a very large effort to handle properly. This is not likely to reach the top of our priority list for quite some time, if ever, so we are declining it now.

  • Guest
    Jul 13, 2018

    Due to processing by IBM, this request was reassigned to have the following updated attributes:
    Brand - Servers and Systems Software
    Product family - Power Systems
    Product - IBM i
    Component - Db2 for i
    Operating system - IBM i
    Source - None

    For recording keeping, the previous attributes were:
    Brand - Servers and Systems Software
    Product family - Power Systems
    Product - IBM i
    Component - Languages - RPG
    Operating system - IBM i
    Source - None

  • Guest
    Jul 13, 2018

    The subfield in position 129 of the INFDS does allways contain the constant *FIRST, if a partitioned table is used. The value of this subfield never changes.

  • Guest
    Jul 10, 2018

    There is already a subfield in position 129 of the INFDS that indicates the member. Is that subfield not being filled with the member name in this scenario?