LOCKING_POLICY_INFO view

The LOCKING_POLICY_INFO view returns a list of the NVMe devices under the partition with their locking capabilities and state.

One row is returned for each device.

Authorization: The caller must have *IOSYSCFG and *SERVICE special authorities.

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

Table 1. LOCKING_POLICY_INFO view
Column Name	System Column Name	Data Type	Description
RESOURCE_NAME	RESOURCE	VARCHAR(10)	Resource name of the NVMe device.
SERIAL_NUMBER	SERIAL	VARCHAR(12)	Serial number of the NVMe device.
TYPE	TYPE	VARCHAR(4)	Device type number of the NVMe device.
LOCKING_SUPPORTED	LOCKING	VARCHAR(3)	Whether this device supports locking. NO The device does not support locking. YES The NVMe device supports TCG Opal and has the correct firmware allowing it to be locked.
ELIGIBLE_POLICY	ELIGIBLE	VARCHAR(3)	Whether the device is eligible to be added to the NVMe locking policy. NO The device is not eligible. YES The NVMe device is in the proper state that makes it eligible to be added to a policy.
UNDER_POLICY	IN_POLICY	VARCHAR(3)	Whether the device is currently under the NVMe locking policy. NO The device is not under the policy. YES The device is under the policy.
LOCK_STATE	LOCK_STATE	VARCHAR(3)	Whether device is locked. When a device is locked, it is read/write protected. NO The device is not locked. YES The device is not locked.
UNLOCK_ATTEMPTS_EXHAUSTED	ATTEMPTS	VARCHAR(3)	Whether the user has exhausted their attempts to unlock the NVMe device. NO Additional attempts are allowed. YES A power cycle of the NVMe decide is required before additional attempts are allowed.
PASSWORD_FIXUP_REQUIRED	FIXUP	VARCHAR(3) Nullable	Whether password fixup is required. NO The NVMe device is synchronized with the password stored in Platform KeyStore (PKS). YES The NVMe device is not synchronized with the password stored in PKS. The QSYS2.CHANGE_DEVICE_LOCKING POLICY procedure with the 'FIXUP' parameter must be run to resynchronize the values. Returns the null value if UNDER_POLICY is NO.

Example

List information about all NVMe devices, including whether they are eligible to be included in a locking policy and whether a locking policy is in effect.
```
SELECT RESOURCE_NAME, LOCKING_SUPPORTED, ELIGIBLE_POLICY, UNDER_POLICY FROM QSYS2.LOCKING_POLICY_INFO;
```