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

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

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.