Skip to Main Content
IBM Power 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:

Post your ideas

Start by posting ideas and requests to this portal to enhance a Power 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 and add comments to ideas that matter most to you

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

Help IBM prioritize your ideas and requests

The IBM team may need your help to refine the ideas so they may ask for more information or feedback. The Power teams will then decide if they can begin working on your idea. If they can start during the next development cycle, they will put the idea on the priority list. Each team at IBM works on a different schedule, where some ideas can be implemented right away, others may be placed on a different schedule.

Receive notification on the decision

Some ideas can be implemented at IBM, while others may not fit within the development plans for the product. In either case, the team will let you know as soon as possible. In some cases, we may be able to find alternatives for ideas which cannot be implemented in a reasonable time.


Specific link you will want to bookmark for future use

IBM Unified Ideas Portal - https://ideas.ibm.com/ - Use this site to create or search for existing Ideas across all IBM products that are outside of Power, and track all of your personal interactions with all Ideas.

Status Delivered
Workspace IBM i
Categories PowerHA
Created by Guest
Created on Jun 8, 2022

CHKENVRCY - Add functionality to check logical files that don’t have Access Paths Maintenance journaled

For Smart Assist tool CHKENVRCY add functionality to check for logical files that don’t have Access Paths Maintenance journaled

Idea priority High
  • Guest
    Jul 7, 2022

    The table QSYS2/SYSFILES doesn't contain tables in an iASP.

  • Guest
    Jul 1, 2022
    The great news is that many SQL services have been added to the system over the years. These SQL services provide capabilities to provide information such as that requested by this enhancement. Therefore, the PowerHA team believes this enhancement is delivered by the SQL services.

    Here is an example of an SQL query that we believe would return the information requested for the library named LIBNAME:

    select SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME from QSYS2.SYSFILES WHERE SYSTEM_TABLE_SCHEMA = 'LIBNAME'
    and NATIVE_TYPE = 'LOGICAL' and ACCESS_PATH_JOURNALED = 'NO';

    If the desire is to produce a result file similar to the Lab Services CHKENVRCY command, an SQL statement similar to the following can be used, which places the contents into QGPL.NOTJOURN:

    CREATE OR REPLACE TABLE QGPL.NOTJOURN AS (select SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME from QSYS2.SYSFILES WHERE SYSTEM_TABLE_SCHEMA = 'LIBNAME'
    and NATIVE_TYPE = 'LOGICAL' and ACCESS_PATH_JOURNALED = 'NO') WITH DATA ON REPLACE DELETE ROWS;

    The IBM Lab Services organization provides smart assist tools as a customized add-on to PowerHA. One of these smart assist tools is the CHKENVRCY command. If there is still a desire for customizations to the lab services offering, we encourage you to work with your IBM Lab Services representative to request additional enhancements to the lab services tools.