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.
Column Name | System Column Name | Data Type | Description |
---|---|---|---|
DEVICE_DESCRIPTION_NAME | DEVD_NAME |
VARCHAR(10)
Nullable |
The name of the device description that brought the independent
ASP (IASP) to varyon/active state. Contains the null value if the ASP is not an IASP or if it is an IASP and ASP_STATE is VARIED OFF. |
ASP_NUMBER | ASP_NUM | INTEGER | A unique identifier for an ASP. Possible values are 1 through 255.
|
ASP_STATE | ASP_STATE | VARCHAR(10) | The device configuration status of an ASP.
|
ASP_TYPE | ASP_TYPE |
VARCHAR(9)
Nullable |
The use that is assigned to the 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 not PRIMARY or SECONDARY. |
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.
|
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. Contains the null value if this is not the system ASP. |
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.
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).
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.
|
COMPRESSED_DISK_UNITS | COMPRESSED | VARCHAR(4) | Whether there are compressed disk units in the 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.
|
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.
|
BALANCE_STATUS | BALANCE |
VARCHAR(8)
Nullable |
The current status of the balance function 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.
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.
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. |
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. |
Example
- Show ASP information for the partition.
SELECT * FROM QSYS2.ASP_INFO;