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 Feb 20, 2020

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
    May 8, 2020

    IBM does not intend to provide a solution to this request at this time, so it is being closed. The database team has a long list of higher priority requirements, so this request is not likely to be implemented anytime soon.

  • Guest
    Apr 21, 2020

    The CAAC has reviewed this requirement and recommends that IBM view this as a high priority requirement that is important to be addressed. While this enhancement would be only for those who use Db2 Multisystem, it is a critical need for those customers.

    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

    For more details about CAAC's role with RFEs, see

    Nancy Uthke-Schmucki - CAAC Program Manager