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:
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,
Post an idea
Upvote ideas and add comments to ideas that matter most to you
Get feedback from the IBM team to refine your idea
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.
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.
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.
The table QSYS2/SYSFILES doesn't contain tables in an iASP.
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.