ASP_INFO view

The ASP_INFO view returns information about auxiliary storage pools (ASPs).

The values returned for the columns in the view are similar to the values returned by the Work with Configuration Status (WRKCFGSTS) CL command and the Open List of ASPs (QYASPOL) API.

Authorization: None required.

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

Table 1. ASP_INFO view
Column Name	System Column Name	Data Type	Description
DEVICE_DESCRIPTION_NAME	DEVD_NAME	VARCHAR(10) Nullable	The name of the device description that most recently brought the independent ASP (IASP) to varyon/active state. Contains the null value if the ASP is not an IASP.
ASP_NUMBER	ASP_NUM	INTEGER	A unique identifier for an ASP. Possible values are 1 through 255. 1 The system ASP 2-32 User ASPs 33-255 IASPs
ASP_STATE	ASP_STATE	VARCHAR(10)	The device configuration status of an ASP. ACTIVE The status of the ASP is active. AVAILABLE The status of the ASP is available. FAILED The status of the ASP is failed. NONE There is no status. This value is used for the system ASP and any basic user ASPs. VARIED OFF The status of the ASP is varyoff. VARIED ON The status of the ASP is varyon.
ASP_TYPE	ASP_TYPE	VARCHAR(9) Nullable	The use that is assigned to the ASP. PRIMARY The ASP is a primary ASP. SECONDARY The ASP is a secondary ASP. SYSTEM The ASP is the system ASP. UDFS The ASP is a user-defined file system ASP. USER The ASP is a user ASP. Contains the null value for an IASP when the type cannot be determined.
RDB_NAME	RDB_NAME	VARCHAR(18) Nullable	The name that is assigned to the database that this ASP defines. Contains the null value if `ASP_TYPE` is `UDFS` or `USER`.
NUMBER_OF_DISK_UNITS	DISK_UNITS	INTEGER	The total number of disk units in the ASP. If mirroring is active for disk units within the ASP, the mirrored pair of units is counted as one.
DISK_UNITS_PRESENT	PRESENT	VARCHAR(4)	Indicates whether disk units in the ASP were found. ALL All disk units were found. NONE No disk units were found. SOME The disk unit that is used to provide the identity of the ASP was found but some other disk units were not found.
ENCRYPTED_ASP	ENCRYPTED	VARCHAR(3)	Whether the data contained in the ASP is encrypted. NO The data in the ASP is not encrypted. YES The data in the ASP is encrypted.
TOTAL_CAPACITY	TOTCAP	BIGINT Nullable	The total number of used and unused megabytes in the ASP. A special value of -2 is returned if the size of this field is exceeded. Contains the null value if the capacity cannot be determined.
TOTAL_CAPACITY_AVAILABLE	TOTCAPA	BIGINT Nullable	The total number of unused megabytes in the ASP. A special value of -2 is returned if the value was too big to return. Contains the null value if the capacity cannot be determined.
PROTECTED_CAPACITY	PROTCAP	BIGINT Nullable	The total number of used and unused megabytes in the ASP that are protected by mirroring or device parity. A special value of -2 is returned if the value was too big to return. Contains the null value if the capacity cannot be determined.
PROTECTED_CAPACITY_AVAILABLE	PROTCAPA	BIGINT Nullable	The number of unused megabytes in the ASP that are protected by mirroring or device parity. A special value of -2 is returned if the value was too big to return. Contains the null value if the capacity cannot be determined.
UNPROTECTED_CAPACITY	UNPROTCAP	BIGINT Nullable	The total number of used and unused megabytes in the ASP that are not protected by mirroring or device parity. A special value of -2 is returned if the value was too big to return. Contains the null value if the capacity cannot be determined.
UNPROTECTED_CAPACITY_ AVAILABLE	UNPROTCAPA	BIGINT Nullable	The number of unused megabytes in the ASP that are not protected by mirroring or device parity. A special value of -2 is returned if the value was too big to return. Contains the null value if the capacity cannot be determined.
SYSTEM_STORAGE	SYS_STG	INTEGER Nullable	The amount of storage in megabytes currently allocated in the ASP for operating system use.
OVERFLOW_STORAGE	OVER_STG	BIGINT Nullable	The number of megabytes of storage that has overflowed from the user ASP into the system ASP. A special value of -2 is returned if the value was too big to return. Contains the null value if this is an IASP.
STORAGE_THRESHOLD_PERCENTAGE	THRESHOLD	INTEGER	When the storage in the ASP reaches this percentage, a warning message is sent to the QSYSOPR message queue. When this percentage is reached for the system ASP (ASP 1), message CPF0907 is sent. When this percentage is reached for a user ASP, message CPI0953 is sent.
OVERFLOW_RECOVERY_RESULT	OVER_RES	VARCHAR(7) Nullable	An indicator of the result of the ASP overflow recovery operation, which is performed during IPL at the user's request. When this operation is requested, an attempt is made to recover the user ASP from an overflow condition by moving overflowed auxiliary storage from the system ASP back to the user ASP during the storage management recovery step of an IPL. CANCEL ASP overflow recovery was canceled prior to completion. FAIL ASP overflow recovery failed due to insufficient space in the user ASP. SUCCESS All overflowed storage was successfully moved. Contains the null value if this is an IASP.
ERROR_LOG_SPACE	ERR_SPACE	INTEGER Nullable	The number of megabytes of auxiliary storage allocated to the error log. Contains the null value if this is not the system ASP.
MACHINE_LOG_SPACE	LOG_SPACE	INTEGER Nullable	The number of megabytes of auxiliary storage allocated to the machine log. Contains the null value if this is not the system ASP.
MACHINE_TRACE_SPACE	TRC_SPACE	INTEGER Nullable	The number of megabytes of auxiliary storage allocated to the machine trace. Contains the null value if this is not the system ASP.
MAIN_STORAGE_DUMP_SPACE	MSD_SPACE	INTEGER Nullable	The number of megabytes of auxiliary storage allocated to the main storage dump space. Contains the null value if this is not the system ASP.
MICROCODE_SPACE	MIC_SPACE	INTEGER Nullable	The number of megabytes of auxiliary storage allocated to the microcode and space used by the microcode. Contains the null value if this is an IASP that is varied off.
END_IMMEDIATE	END_IMMED	VARCHAR(3) Nullable	This column only applies to the system ASP (ASP 1). NO If a request for space in the system ASP cannot be satisfied because there is not enough storage, the system will be allowed to continue running. YES If a request for space in the system ASP cannot be satisfied because there is not enough storage, the system will be ended immediately. Contains the null value if this is not the system ASP.
COMPRESSION_RECOVERY_POLICY	COMP_RECOV	VARCHAR(18)	The compression recovery policy for the ASP. If the ASP has compressed drives as part of its configuration, this value controls how overflow situations are handled for this ASP. The following policies allow the user to control what is done when the ASP appears full. OVERFLOW DELAY When the ASP capacity is about to be exceeded, the operating system posts system reference code (SRC) A6xx 0277 in the system control panel and waits for a limited time for space to become available. If space becomes available before the limited time ends, the SRC is removed from the system control panel and normal operations resume. If space does not become available before the limited time ends, data overflows into the system ASP. OVERFLOW IMMEDIATE When the ASP capacity is about to be exceeded, the data immediately overflows into the system ASP. WAIT When the ASP capacity is about to be exceeded, the operating system posts SRC A6xx 0277 in the system control panel and waits indefinitely for space to become available. The user must take action before normal operation resumes. Possible actions include deleting objects from the ASP or changing the compression recovery policy to a value that allows the ASP to overflow.
COMPRESSED_DISK_UNITS	COMPRESSED	VARCHAR(4)	Whether there are compressed disk units in the ASP. ALL All disk units in this ASP are compressed. NONE No compressed disk units in this ASP. SOME Compressed and uncompressed disk units in this ASP.
CHANGES_WRITTEN_TO_DISK	WRITTEN	VARCHAR(3)	An indicator of whether all changes made the previous time the IASP was online were written to disk. Varyoff processing attempts to write changed IASP storage but, in some failures, it may not be successful. NO Not all changes were written to disk. YES All changes were written to disk.
MULTIPLE_CONNECTION_DISK_UNITS	MULT_CONN	VARCHAR(3)	A disk unit may have multiple resource names. Each resource name represents a unique connection to the disk unit. All active connections are used to communicate with the disk unit. This attribute indicates whether the disk unit has more than one connection. NO The disk unit has only one connection. YES The disk unit has more than one connection.
BALANCE_STATUS	BALANCE	VARCHAR(8) Nullable	The current status of the balance function for this ASP. COMPLETE The ASP balance function has completed running. The ASP is completely balanced. ENDED The ASP balance function has run, but was ended before the ASP was completely balanced. The Start ASP Balance (STRASPBAL) command can be used to restart the balance function. ENDING The ASP balance function is currently in the process of ending. Either the time limit has run out or the End ASP Balance (ENDASPBAL) command was issued for this ASP. NONE No balance activity has occurred for this ASP. RUNNING The ASP balance function is currently running for this ASP. Contains the null value if `ASP_STATE` is not `ACTIVE` or `AVAILABLE` for IASP.
BALANCE_TYPE	BAL_TYPE	VARCHAR(21) Nullable	The type of balance activity that is currently running or was done last. CAPACITY BALANCING Capacity balancing. Capacity balancing redistributes data so that the percentage of disk space used is the same on all disk units within the ASP. CLEAR COLLECTION DATA Clear collection data. Clear collection data removes the trace data created by running the Trace ASP Balance (TRCASPBAL) command. HSM BALANCING Hierarchical Storage Management (HSM) balancing. HSM balancing can be run only on an ASP that contains a mixture of high-performance and low-performance disk units. An example of low-performance disk units is compressed disk units. The HSM balance function moves high-use data to high-performance units and moves low-use data to low-performance units. The high-use and low-use data is identified by running the Trace ASP Balance (TRCASPBAL) command. MOVE DATA Move data. Move data is used to reduce the down time associated with removing a disk unit. The Check ASP Balance (CHKASPBAL) command can be used to determine which units are currently marked to no longer receive new allocations and to have their existing allocations moved to other disk units. MP BALANCING Media Preference (MP) balancing. MP balancing can be run only on an ASP that contains a mixture of Solid State Disk (SSD) units and Hard Disk Drive (HDD) units. The goal of the MP balance function is to have high-use data on SSD units and low-use data on HDD units. The high-use and low-use data is identified by running the Trace ASP Balance (TRCASPBAL) command. NONE No ASP balance activity was requested for the ASP. USAGE BALANCING Usage balancing. Usage balancing redistributes data so that the percentage of disk activity is the same on all disk units within the ASP. High-use and low-use data is identified by running the Trace ASP Balance (TRCASPBAL) command. Usage balancing moves data among the disk units, guided by the trace results, in an attempt to equalize the utilizations. Contains the null value if `ASP_STATE` is not `ACTIVE` or `AVAILABLE` for IASP.
BALANCE_DATA_MOVED	BAL_MOVED	BIGINT Nullable	The number of megabytes that have been moved by the balance function. A special value of -2 is returned if the value was too big to return. Contains the null value if `BALANCE_STATUS` is not `RUNNING`.
BALANCE_DATA_REMAINING	BAL_REMAIN	BIGINT Nullable	The number of megabytes that remain to be moved by the balance function before the move is considered complete. A special value of -2 is returned if the value was too big to return. Contains the null value if `BALANCE_STATUS` is not `RUNNING`.
BALANCE_TIMESTAMP	BAL_TIME	TIMESTAMP(0) Nullable	The timestamp of the last status change for the balance function. Contains the null value when `BALANCE_TYPE` is `NONE` or the null value.
TRACE_STATUS	TRC_STATUS	VARCHAR(10) Nullable	The current status of the trace function. The trace gathers statistics about the data on the disk units within the ASP. This data is used by the balance functions. CLEARING The trace data for this ASP is being cleared. COMPLETE 1 The trace function has completed running. The statistics for the ASP have been gathered and are ready for the balance function to start. COMPLETE 2 The trace function has completed and the statistics for the ASP have been gathered. The ASP is ready for further collection or for the balance function to start. ENDING The trace function is currently in the process of ending. Either the time limit has run out or the trace was stopped through use of the Trace ASP Balance (TRCASPBAL) command. NONE There is no current trace data for this ASP. RUNNING The trace function is currently running for this ASP. Contains the null value if `ASP_STATE` is not `ACTIVE` or `AVAILABLE` for IASP.
TRACE_DURATION	TRC_DUR	INTEGER Nullable	The number of minutes that the trace function has run collecting data for this ASP. The trace can be run multiple times for an ASP. Contains the null value when `TRACE_STATUS` is `NONE` or the null value.
TRACE_TIMESTAMP	TRC_TIME	TIMESTAMP(0) Nullable	The timestamp of the last status change for the trace function. Contains the null value when `TRACE_STATUS` is `NONE` or the null value.
GEOGRAPHIC_MIRROR_ROLE	GEO_ROLE	VARCHAR(10) Nullable	The current role of the geographically mirrored IASP. DETACHED System owns a detached mirror copy. MIRROR System owns the mirror copy. PRODUCTION System owns the production copy. UNKNOWN The geographic mirror role is unknown. Contains the null value if geographic mirroring is not configured.
GEOGRAPHIC_MIRROR_MODE	GEO_MODE	VARCHAR(12) Nullable	The performance mode of the geographic mirroring. ASYNCHRONOUS Control is returned to the application before the mirrored write actually makes it to the mirror copy. SYNCHRONOUS Data is mirrored before write operations complete on the production system. UNKNOWN The performance mode is not known. Contains the null value if geographic mirroring is not configured.
GEOGRAPHIC_MIRROR_COPY_STATE	GEO_CSTATE	VARCHAR(14) Nullable	The mirror state of the geographic mirror copy. ACTIVE Geographic mirroring is actively replicating. RESUME PENDING The system will attempt to perform geographic mirroring when the IASP is online. RESUMING The system is resuming and the IASP is online and performing synchronization.. SUSPENDED The geographic mirroring mirror copy is suspended and geographic mirroring is not being performed. UNKNOWN The mirror copy state is not known. Contains the null value if geographic mirroring is not configured.
GEOGRAPHIC_MIRROR_DATA_STATE	GEO_DSTATE	VARCHAR(12) Nullable	The condition of the data on the geographic mirror copy. INCOHERENT There is incoherent data in the mirror copy and the data cannot be used. SYNCHRONIZED The remote copy is in sync with the production copy. UNKNOWN The state of the data is not known. USABLE The remote copy contains usable data. A detached mirror copy always has this state. Contains the null value if geographic mirroring is not configured.
GEOGRAPHIC_MIRROR_RESUME_PRIORITY	GEO_RESUME	VARCHAR(7) Nullable	The priority given to resynchronize the geographic mirror production copy with the mirror copy following a suspend. HIGH This priority completes synchronization as quickly as possible, but consumes the most resources. LOW This priority uses the fewest resources, but synchronization will take longer to complete. MEDIUM This priority provides a balance between resource usage and time to synchronization completion. UNKNOWN The priority is not known. Contains the null value if geographic mirroring is not configured.
GEOGRAPHIC_MIRROR_SUSPEND_TIMEOUT	GEO_WAIT	INTEGER	The number of seconds the production node waits for a response from the mirror copy node before suspending geographic mirroring. Contains the null value if geographic mirroring is not configured.
GEOGRAPHIC_MIRROR_TRANSMISSION_ COMPRESSION	GEO_TCOMP	VARCHAR(15)	Indicates whether geographic mirror data is compressed when sent between systems. NONE Data is not compressed. SYNCHRONIZATION Data is compressed during a full or partial synchronization. Contains the null value if geographic mirroring is not configured.
RESOURCE_NAME	RESOURCE	VARCHAR(10) Nullable	The resource name that identifies the ASP by which a collection of disks is known. Contains the null value for the system ASP, any user ASPs, and for an IASP where the name cannot be determined.
PRIMARY_ASP_RESOURCE_NAME	PRIMARY	VARCHAR(10) Nullable	The resource name of the primary ASP for a secondary ASP. Contains the null value if `ASP_TYPE` is not `SECONDARY`.
ACCESS_PATH_TARGET_ RECOVERY_TIME	SMAPP	VARCHAR(7) Nullable	The time, in minutes, targeted for access path protection for this ASP. 1-1440 The number of minutes set for the system access path recovery time. NONE No system access path recovery time is set. The access paths for this ASP are protected only if they need to be protected to reach the system access path recovery time. MIN All of the eligible access paths for this ASP are protected. The system uses the minimum time needed for access path recovery. Contains the null value when system-managed access path protection is off, if the user does not have *JOBCTL authority, or if this is an IASP that is varied off.
ACCESS_PATH_ESTIMATED_ RECOVERY_TIME	AP_RECOV	INTEGER Nullable	The amount of time, in minutes, that the system will take to recover the access paths during the vary on of this independent storage pool (IASP). This value assumes that all access paths that are protected are recovered during vary on of the IASP. The estimated system access path recovery time is influenced by the include access paths setting for the system. If the include access paths setting is ELIGIBLE, this value is the estimated system access path recovery time of all the eligible access paths that are not chosen for protection. If the include access paths setting is ALL, this value is the estimated system access path recovery time of all the eligible access paths that are not chosen for protection plus all the access paths that are not eligible for protection. Contains the null value when system-managed access path protection is off, if the user does not have *JOBCTL authority, or if this is an IASP that is varied off.
SMAPP_DISK_STORAGE_USED	SMAPP_STG	BIGINT Nullable	The total amount of auxiliary disk storage, in megabytes, used by internal objects that are used exclusively for system-managed access path protection (SMAPP) for this IASP. Contains the null value when system-managed access path protection is off, if the user does not have *JOBCTL authority, or if this is an IASP that is varied off.

Example

Show ASP information for the partition.
```
SELECT * FROM QSYS2.ASP_INFO;
```