SMAPP_ACCESS_PATHS view

The SMAPP_ACCESS_PATHS view returns a list of access paths which are monitored by System-Managed Access Path Protection (SMAPP).

Some access paths are ineligible for SMAPP protection. See How the system chooses access paths to protect for more details.

Authorization: The caller must have *JOBCTL special authority.

The following table describes the columns in the view. The system name is SMAPP_AP. The schema is QSYS2.

Table 1. SMAPP_ACCESS_PATHS view
Column Name	System Column Name	Data Type	Description
SYSTEM_TABLE_SCHEMA	LIB_NAME	VARCHAR(10)	The library containing the database file associated with the access path.
SYSTEM_TABLE_NAME	FILE_NAME	VARCHAR(10)	The database file associated with the access path.
ASP_NUMBER	ASPNUMBER	INTEGER	The number of the auxiliary storage pool containing the access path.
IASP_NAME	IASP_NAME	VARCHAR(10)	The name of the auxiliary storage pool containing the access path. The special value of *SYSBAS is returned if ASP_NUMBER is not greater than or equal to 33.
STATUS	STATUS	VARCHAR(11)	The eligibility and protection status of the access path. INELIGIBLE This access path is not eligible to be protected by the system and may need to be rebuilt during an initial program load (IPL) or during the vary on of an independent ASP after an abnormal system end. PROTECTED This access path is protected by the system. UNPROTECTED This access path is not protected by the system and may need to be rebuilt during an initial program load (IPL) or during the vary on of an independent ASP after an abnormal system end.
INELIGIBLE_REASON	INELIG_RSN	VARCHAR(17) Nullable	The reason that the access path is not eligible for access protection. MULTIPLE JOURNALS The access path is built over physical files which are journaled to separate journals. JOURNAL STANDBY The access path is built over a physical file which is journaled to a journal whose journal state is currently STANDBY. Contains the null value if STATUS is not INELIGIBLE.
ESTIMATED_RECOVERY	EST_RECOV	BIGINT	The estimated amount of time, in seconds, that the system would take to recover the access path during an initial program load (IPL) or during the vary on of an independent ASP after an abnormal system end if the access path is not chosen for protection.

Example

List all the access paths in APPLIB that are not currently protected.

SELECT * FROM QSYS2.SMAPP_ACCESS_PATHS 
  WHERE LIB_NAME = 'APPLIB' AND STATUS <> 'PROTECTED'
  ORDER BY ESTIMATED_RECOVERY DESC;