The Database Member attribute group contains attributes that you can use to monitor storage and work management.
Coding specific compare values for Member, File, and Library reduces the amount of data that the product has to handle. This improves system performance. Failing to specify one or more of these attributes will overload the product, which results in situations not being evaluated.
Note: You can not use the OR function between any of the predicates when building situations using this group of attributes.
File The name of the file from which the member list was retrieved. The valid value is an alphanumeric string with a maximum of 10 characters.
File Attribute The type of file found. The valid values include:
PF |
Physical file |
LF |
Logical file |
Increments Left The remaining number of increments that can be automatically added to the member size. This value applies only to physical files The value for logical files is 0. The valid value is an integer in the range 0 through 2147483647. The attribute can be used with the *AVG, *MAX, *MIN, and *SUM functions.
Library The name of the library that contains the object. The valid value is an alphanumeric string with a maximum of 10 characters.
Member The name of the member whose description is being retrieved. The valid value is an alphanumeric string with a maximum of 10 characters.
ORIGINNODE The host name for the monitored system. The valid value is an alphanumeric string with a maximum length of 64 characters.
Percent Delete Records The percentage of the current number of records that have been deleted. This applies to data files only. The valid value is an integer in the range 0 through 100. The attribute can be used with the *AVG, *MAX, *MIN, and *SUM functions.
Percent Used The percentage of the capacity of the member that is currently being used. The valid value is an integer in the range 0 through 100. The attribute can be used with the *AVG, *MAX, *MIN, and *SUM functions.
Records Unused The number of records that are not being used. The valid value is an integer in the range 0 through 2147483647. The attribute can be used with the *AVG, *MAX, *MIN, and *SUM functions.
Records Used The number of records used. The valid value is an integer in the range 0 through 2147483647. The attribute can be used with the *AVG, *MAX, *MIN, and *SUM functions.
Source File Flag Indicates whether the file is a source file or a data file. The valid values include:
*DATA |
File is a data file. |
*SOURCE |
File is a source file. |
Source Member Type If this is a source file, this is the type of source member. The valid value is an alphanumeric string with a maximum of 10 characters.
SQL Type The type of Structured Query Language (SQL) file. The valid values include:
Blank |
The file is not an SQL file. |
TABLE |
The file is a non-keyed physical file that contains field characteristics. |
VIEW |
The file is a logical file over one or more tables or views. This SQL file type provides a subset of data in a particular table or a combination of data from more than one table or view. |
INDEX |
The file is keyed logical file over one table. The keyed logical file is used whenever access to records in a certain order is requested frequently. |