Capacity Manager Database Views > EMC Isilon Array Database Views
  
Version 9.2.00
EMC Isilon Array Database Views
aps_v_isi_array_performance
The aps_v_isi_array_performance view contains a single row for each EMC Isilon array performance entry.
Table 4.77 aps_v_isi_array_performance
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
AVG_CPU_PCT
NUMBER
Average CPU usage (percent) across the cluster at collection time.
AVG_DISK_BUSY_PCT
NUMBER
Average disk busy (percent) across the cluster at collection time.
AVG_DISK_LATENCY_MS
NUMBER
Average disk latency (milliseconds) across the cluster at collection time.
AVG_DISK_RATE_IN_BPS
NUMBER
Disk rate: Average disk write performance (bytes/second) across the cluster at collection time.
AVG_DISK_RATE_IN_OPS
NUMBER
Disk rate: Average disk write performance (IOPS) across the cluster at collection time
AVG_DISK_RATE_OUT_BPS
NUMBER
Disk rate: Average disk read performance (bytes/second) across the cluster at collection time.
AVG_DISK_RATE_OUT_OPS
NUMBER
Disk rate: Average disk read performance (IOPS) across the cluster at collection time.
AVG_IDLE_CPU_PCT
NUMBER
Average CPU idle (percent) across the cluster at collection time.
AVG_INTERRUPT_CPU_PCT
NUMBER
Average interrupt CPU usage (percent) across the cluster at collection time.
AVG_NICE_CPU_PCT
NUMBER
Average nice CPU (CPU scheduling priority) usage (percent) across the cluster at collection time.
AVG_SYSTEM_CPU_PCT
NUMBER
Average system CPU usage (percent) across the cluster at collection time.
AVG_USER_CPU_PCT
NUMBER
Average user CPU usage (percent) across the cluster at collection time.
EXTERNAL_NETWORK_RATE_IN_BPS
NUMBER
Total network rate (in bytes/second) for all external interfaces in the cluster at collection time.
EXTERNAL_NETWORK_RATE_OUT_BPS
NUMBER
Total network rate out (bytes/second) for all external interfaces in the cluster at collection time.
INTERNAL_NETWORK_RATE_IN_BPS
NUMBER
Total network rate (in bytes/second) for all internal interfaces in the cluster at collection time.
INTERNAL_NETWORK_RATE_OUT_BPS
NUMBER
Total network rate out (bytes/second) for all internal interfaces in the cluster at collection time.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
LOG_DATE
DATE
The date and time the samples were collected.
MAX_SINGLE_CPU_PCT
NUMBER
Single highest CPU usage (percent) in the cluster at collection time.
NBR_OF_ACTIVE_CLIENTS
NUMBER
Total number of clients actively transferring to/from the cluster at collection time.
NBR_OF_CONNECTED_CLIENTS
NUMBER
Total number of clients connected to the cluster at collection time.
aps_v_isi_array_prf_log_day
The aps_v_isi_array_prf_log_day view contains a single row for each Array Performance Daily Log.
Table 4.78 aps_v_isi_array_prf_log_day
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
AVG_CPU_PCT
NUMBER
Average CPU usage (percent) across the cluster for the day.
AVG_DISK_BUSY_PCT
NUMBER
Average disk busy (percent) across the cluster for the day.
AVG_DISK_LATENCY_MS
NUMBER
Average disk latency (milliseconds) across the cluster for the day.
AVG_DISK_RATE_IN_BPS
NUMBER
Disk rate: Average disk write performance (bytes/second) across the cluster for the day.
AVG_DISK_RATE_IN_OPS
NUMBER
Disk rate: Average disk write performance (IOPS) across the cluster for the day.
AVG_DISK_RATE_OUT_BPS
NUMBER
Disk rate: Average disk read performance (bytes/second) across the cluster for the day.
AVG_DISK_RATE_OUT_OPS
NUMBER
Disk rate: Average disk read performance (IOPS) for the day.
AVG_IDLE_CPU_PCT
NUMBER
Average CPU idle (percent) across the cluster for the day.
AVG_INTERRUPT_CPU_PCT
NUMBER
Average interrupt CPU usage (percent) across the cluster for the day.
AVG_NICE_CPU_PCT
NUMBER
Average nice CPU (CPU scheduling priority) usage (percent) across the cluster for the day.
AVG_SYSTEM_CPU_PCT
NUMBER
Average system CPU usage (percent) across the cluster for the day.
AVG_USER_CPU_PCT
NUMBER
Average user CPU usage (percent) across the cluster for the day.
CUM_INTERVAL_SEC
NUMBER
Time interval in seconds for the day for which the data was collected.
EXTERNAL_NETWORK_RATE_IN_BPS
NUMBER
Average network rate (in bytes/second) for all external interfaces in the cluster for the day.
EXTERNAL_NETWORK_RATE_OUT_BPS
NUMBER
Average network rate out (bytes/second) for all external interfaces in the cluster for the day.
INTERNAL_NETWORK_RATE_IN_BPS
NUMBER
Average network rate (in bytes/second) for all internal interfaces in the cluster for the day.
INTERNAL_NETWORK_RATE_OUT_BPS
NUMBER
Average network rate out (bytes/second) for all internal interfaces in the cluster for the day.
INTERVAL_TYPE
STRING
Interval type of the collection.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
LOG_DATE
DATE
Midnight time stamp of the day the record was aggregated for the log entry.
MAX_SINGLE_CPU_PCT
NUMBER
Maximum CPU usage (percent) in the cluster for the day.
NBR_OF_ACTIVE_CLIENTS
NUMBER
Total number of clients actively transferring to/from the cluster at collection time.
NBR_OF_CONNECTED_CLIENTS
NUMBER
Average number of connected clients to the cluster for the day.
aps_v_isi_array_prf_log_hr
The aps_v_isi_array_prf_log_hr view contains a single row for each EMC Isilon Array Performance Hourly Log.
Table 4.79 aps_v_isi_array_prf_log_hr
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
AVG_CPU_PCT
NUMBER
Average CPU usage (percent) across the cluster for the hour.
AVG_DISK_BUSY_PCT
NUMBER
Average disk busy (percent) across the cluster for the hour.
AVG_DISK_LATENCY_MS
NUMBER
Average disk latency (milliseconds) across the cluster for the hour.
AVG_DISK_RATE_IN_BPS
NUMBER
Disk rate: Average disk write performance (bytes/second) across the cluster for the hour.
AVG_DISK_RATE_IN_OPS
NUMBER
Disk rate: Average disk write performance (IOPS) across the cluster for the hour.
AVG_DISK_RATE_OUT_BPS
NUMBER
Disk rate: Average disk read performance (bytes/second) across the cluster for the hour.
AVG_DISK_RATE_OUT_OPS
NUMBER
Disk rate: Average disk read performance (IOPS) across the cluster for the hour.
AVG_IDLE_CPU_PCT
NUMBER
Average CPU idle (percent) across the cluster for the hour.
AVG_INTERRUPT_CPU_PCT
NUMBER
Average interrupt CPU usage (percent) across the cluster for the hour.
AVG_NICE_CPU_PCT
NUMBER
Average nice CPU (CPU scheduling priority) usage (percent) across the cluster for the hour.
AVG_SYSTEM_CPU_PCT
NUMBER
Average system CPU usage (percent) across the cluster for the hour.
AVG_USER_CPU_PCT
NUMBER
Average user CPU usage (percent) across the cluster for the hour.
CUM_INTERVAL_SEC
NUMBER
Time interval
EXTERNAL_NETWORK_RATE_IN_BPS
NUMBER
Average network rate (in bytes/second) for all external interfaces in the cluster for the hour.
EXTERNAL_NETWORK_RATE_OUT_BPS
NUMBER
Average network rate out (bytes/second) for all external interfaces in the cluster for the hour.
INTERNAL_NETWORK_RATE_IN_BPS
NUMBER
Average network rate (in bytes/second) for all internal interfaces in the cluster for the hour.
INTERNAL_NETWORK_RATE_OUT_BPS
NUMBER
Average network rate out (bytes/second) for all internal interfaces in the cluster for the hour.
INTERVAL_TYPE
STRING
Interval type for the array performance log collection.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
LOG_DATE
DATE
Hourly time stamp format (hh24:00:00) for the hour the log record was aggregated for the hourly array performance log.
MAX_SINGLE_CPU_PCT
NUMBER
Maximum CPU usage (percent) in the cluster for the hour.
NBR_OF_ACTIVE_CLIENTS
NUMBER
Total number of clients actively transferring to/from the cluster at collection time.
NBR_OF_CONNECTED_CLIENTS
NUMBER
Total number of clients connected to the cluster at collection time.
aps_v_isi_array_prf_log_min
The aps_v_isi_array_prf_log_min view contains a single row for each EMC Isilon Array Performance Minutes Log.
Table 4.80 aps_v_isi_array_prf_log_min
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
AVG_CPU_PCT
NUMBER
Average CPU usage (percent) across the cluster at collection time.
AVG_DISK_BUSY_PCT
NUMBER
Average disk busy (percent) across the cluster at collection time.
AVG_DISK_LATENCY_MS
NUMBER
Average disk latency (milliseconds) across the cluster at collection time.
AVG_DISK_RATE_IN_BPS
NUMBER
Disk rate: Average disk write performance (bytes/second) across the cluster at collection time.
AVG_DISK_RATE_IN_OPS
NUMBER
Disk rate: Average disk write performance (IOPS) across the cluster at collection time.
AVG_DISK_RATE_OUT_BPS
NUMBER
Disk rate: Average disk read performance (bytes/second) across the cluster at collection time.
AVG_DISK_RATE_OUT_OPS
NUMBER
Disk rate: Average disk read performance (IOPS) across the cluster at collection time.
AVG_IDLE_CPU_PCT
NUMBER
Average CPU idle (percent) across the cluster at collection time.
AVG_INTERRUPT_CPU_PCT
NUMBER
Average interrupt CPU usage (percent) across the cluster at collection time.
AVG_NICE_CPU_PCT
NUMBER
Average nice CPU (CPU scheduling priority) usage (percent) across the cluster at collection time.
AVG_SYSTEM_CPU_PCT
NUMBER
Average system CPU usage (percent) across the cluster at collection time.
AVG_USER_CPU_PCT
NUMBER
Average user CPU usage (percent) across the cluster at collection time.
CUM_INTERVAL_SEC
NUMBER
Time interval in seconds for which the data was collected.
EXTERNAL_NETWORK_RATE_IN_BPS
NUMBER
Total network rate (in bytes/second) for all external interfaces in the cluster at collection time.
EXTERNAL_NETWORK_RATE_OUT_BPS
NUMBER
Total network rate out (bytes/second) for all external interfaces in the cluster at collection time.
INTERNAL_NETWORK_RATE_IN_BPS
NUMBER
Total network rate (in bytes/second) for all internal interfaces in the cluster at collection time.
INTERNAL_NETWORK_RATE_OUT_BPS
NUMBER
Total network rate out (bytes/second) for all internal interfaces in the cluster at collection time.
INTERVAL_TYPE
STRING
Interval type of the collection.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
LOG_DATE
DATE
Date and time the samples were collected.
MAX_SINGLE_CPU_PCT
NUMBER
Single highest CPU usage (percent) in the cluster at collection time.
NBR_OF_ACTIVE_CLIENTS
NUMBER
Total number of clients actively transferring to/from the cluster at collection time.
NBR_OF_CONNECTED_CLIENTS
NUMBER
Total number of clients connected to the cluster at collection time.
aps_v_isi_chassis
The aps_v_isi_chassis view contains a single row for each EMC Isilon Chassis.
Table 4.81 aps_v_isi_chassis
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CHASSIS_MODEL
STRING
The model of the chassis.
CHASSIS_NBR
NUMBER
Chassis number.
CONFIG_NBR
STRING
The chassis configuration number.
CREATION_DATE
DATE
The date and time the Isilon chassis data was created in the StorageConsole database.
IS_LIGHT_ON
STRING
Indicates if the unit ID light on the chassis is lit (may be NULL): Y or N.
ISI_CHASSIS_ID
NUMBER
Isilon chassis ID for internal use by the StorageConsole database.
ISI_NODE_ID
NUMBER
Node ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
LAST_UPDATED
DATE
The date and time the Isilon chassis data was last updated in the StorageConsole database.
NODE_NAME
STRING
Node name
SERIAL_NBR
STRING
The chassis serial number.
aps_v_isi_cifs_share
The aps_v_isi_cifs_share view contains a single row for each EMC Isilon CIFS Share.
Table 4.82 aps_v_isi_cifs_share
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CHANGE_NOTIFY
STRING
Specifies the level of change notification alerts on a share.
CIFS_SHARE_NAME
STRING
Name of the share.
CIFS_SHARE_PATH
STRING
File system path of the share.
CREATE_PERMISSIONS
STRING
The create permissions for new files and directories in a share.
CREATION_DATE
DATE
The date and time the Isilon CIFS data was created in the APTARE StorageConsole database.
CSC_POLICY
STRING
Client-side caching policy.
DESCRIPTION
STRING
Description of the share.
FS_ROOT_PATH
STRING
File System root path
IMPERSONATE_GUEST
STRING
When access should be as guest.
IMPERSONATE_USERNAME
STRING
The user account to be used as a guest account.
IS_BROWSABLE
STRING
Indicates if the share is visible in browse lists: Y or N.
IS_DELETE_READONLY_ALLOW
STRING
Indicates if deletion of read-only files in the share is allowed: Y or N.
IS_DOT_FILES_HIDDEN
STRING
Indicates if filenames beginning with a dot are hidden: Y or N.
IS_EXECUTE_ALWAYS_ALLOW
STRING
Indicates if users can execute files for which they have read rights: Y or N.
IS_INHERITABLE_ACL
STRING
Indicates if access control lists (ACLs) are inheritable: Y or N.
IS_NTFS_ACL_SUPPORTED
STRING
Indicates if New Technology File System (NTFS) access control lists (ACLs) on files and directories are supported: Y or N.
IS_OPLOCK_REQUESTS_ALLOW
STRING
Indicates if opportunistic locks (oplocks) requests are supported: Y or N.
IS_STRICT_FLUSH
STRING
Indicates if server message block (SMB) flush operations are strict: Y or N.
IS_STRICT_LOCKING
STRING
Indicates if byte-range locks contend with the server message block (SMB) I/O: Y or N.
ISI_ONEFS_ID
NUMBER
OneFS ID, for internal use by the APTARE StorageConsole database.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the APTARE StorageConsole database.
LAST_UPDATED
DATE
The date and time the Isilon CIFS data was last updated in the APTARE StorageConsole database.
MANGLE_BYTE_START
STRING
Specifies the wchar_t starting point for automatic byte mangling.
MANGLE_MAP
STRING
The character mangle map.
aps_v_isi_disk
The aps_v_isi_disk view contains a single row for each EMC Isilon Disk.
Table 4.83 aps_v_isi_disk
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CHASSIS_NBR
NUMBER
Chassis number.
CREATION_DATE
DATE
The date and time the Isilon disk data was created in the APTARE StorageConsole database.
DISK_LOGICAL_NBR
NUMBER
The disk logical number within the node.
DISK_NBR
NUMBER
The disk number within the node.
DRIVE_BAY_NBR
NUMBER
Drive Bay number.
FS_FREE_CAPACITY_GB
NUMBER
Free filesystem capacity on the drive (KiB)
FS_FREE_CAPACITY_KB
NUMBER
Free file system capacity on the drive.
FS_TOTAL_CAPACITY_GB
NUMBER
Total filesystem capacity on the drive, including metadata (GiB)
FS_TOTAL_CAPACITY_KB
NUMBER
Total file system capacity on the drive, including metadata.
FS_USED_CAPACITY_GB
NUMBER
Used filesystem capacity on the drive (GiB)
FS_USED_CAPACITY_KB
NUMBER
Used file system capacity on the drive.
ISI_CHASSIS_ID
NUMBER
Chassis ID, for internal use by the APTARE StorageConsole database.
ISI_DRIVE_BAY_ID
NUMBER
Drive Bay ID, for internal use by the APTARE StorageConsole database.
ISI_NODE_ID
NUMBER
Node ID, for internal use by the APTARE StorageConsole database.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the APTARE StorageConsole database.
LAST_UPDATED
DATE
The date and time the Isilon disk data was last updated in the APTARE StorageConsole database.
NODE_NAME
STRING
Node name
PDEV_ID
NUMBER
Isilon disk physical device ID, for internal use by the APTARE StorageConsole database.
aps_v_isi_disk_performance
The aps_v_isi_disk_performance view contains a single row for each EMC Isilon Disk Performance.
Table 4.84 aps_v_isi_disk_performance
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
DISK_BUSY_PCT
NUMBER
Disk busy (percent) at collection time.
DISK_LATENCY_MS
NUMBER
Disk latency (milliseconds) at collection time.
DISK_RATE_IN_BPS
NUMBER
Disk rate: Disk write performance (bytes/second) at collection time.
DISK_RATE_OUT_BPS
NUMBER
Disk rate: Disk read performance (bytes/second) at collection time.
DRIVE_BAY_NBR
NUMBER
Drive Bay number.
ISI_DRIVE_BAY_ID
NUMBER
Drive Bay ID, for internal use by the APTARE StorageConsole database.
ISI_NODE_ID
NUMBER
Node ID, for internal use by the APTARE StorageConsole database.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the APTARE StorageConsole database.
LOG_DATE
DATE
Date and time the samples were collected.
NODE_NAME
STRING
Node name
OPERATION_RATE_IN_OPS
NUMBER
Disk rate: Disk write performance (IOPS) at collection time.
OPERATION_RATE_OUT_OPS
NUMBER
Disk rate: Disk read performance (IOPS) at collection time.
aps_v_isi_disk_pool
The aps_v_isi_disk_pool view contains a single row for each EMC Isilon Disk Pool.
Table 4.85 aps_v_isi_disk_pool
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CREATION_DATE
DATE
The date and time the Isilon disk pool data was created in the APTARE StorageConsole database.
DISK_POOL_NAME
STRING
Disk pool name.
DISK_POOL_TYPE
STRING
The type of disk pool.
HEALTH_STATUS
STRING
Overall health of the disk pool.
IS_HEALTH_OK
STRING
Indicates if the node is OK: Y or N.
IS_MISSING_DRIVES
STRING
Indicates if there are drives missing from the Isilon disk pool: Y or N.
IS_NEED_REPAIR
STRING
Indicates if some Isilon nodes and/or drives need repair: Y or N.
IS_OFFLINE
STRING
Indicates if some Isilon nodes and/or drives are down: Y or N.
IS_SMART_FAILED
STRING
Indicates if some Isilon nodes and/or drives are smart-failed: Y or N.
IS_TOO_FEW_NODES
STRING
Indicates if there are too few nodes: Y or N.
ISI_DISK_POOL_ID
NUMBER
Disk pool ID, for internal use by the APTARE StorageConsole database.
ISI_NODE_POOL_ID
NUMBER
Node pool ID, for internal use by the APTARE StorageConsole database.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the APTARE StorageConsole database.
LAST_UPDATED
DATE
The date and time the Isilon disk pool data was last updated in the APTARE StorageConsole database.
NODE_POOL_NAME
STRING
Node pool Name.
PROTECTION_POLICY
STRING
The protection policy of the disk pool.
aps_v_isi_disk_prf_log_day
The aps_v_isi_disk_prf_log_day view contains a single row for each EMC Isilon Disk Performance Daily Log.
Table 4.86 aps_v_isi_disk_prf_log_day
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CUM_INTERVAL_SEC
NUMBER
Time interval in seconds for the day for which the data was collected.
DISK_BUSY_PCT
NUMBER
Average disk busy percent for the day.
DISK_LATENCY_MS
NUMBER
Average disk latency(milliseconds) for the day.
DISK_RATE_IN_BPS
NUMBER
Disk rate: Average disk write performance(bytes/second) for the day.
DISK_RATE_OUT_BPS
NUMBER
Disk rate: Average disk read performance(bytes/second) for the day.
DRIVE_BAY_NBR
NUMBER
Drive Bay number.
INTERVAL_TYPE
STRING
Interval type of the collection.
ISI_DRIVE_BAY_ID
NUMBER
Drive Bay ID, for internal use by the StorageConsole database.
ISI_NODE_ID
NUMBER
Node ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
LOG_DATE
DATE
Midnight time stamp of the day the record was aggregated for.
NODE_NAME
STRING
Node name
OPERATION_RATE_IN_OPS
NUMBER
Disk rate: Average disk write performace(IOPS) for the day.
OPERATION_RATE_OUT_OPS
NUMBER
Disk rate: Average disk read performance(IOPS) for the day.
aps_v_isi_disk_prf_log_hr
The aps_v_isi_disk_prf_log_hr view contains a single row for each EMC Isilon Disk Performance Hourly Log.
Table 4.87 aps_v_isi_disk_prf_log_hr
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CUM_INTERVAL_SEC
NUMBER
Time interval in seconds for the hour for which the data was collected.
DISK_BUSY_PCT
NUMBER
Average disk busy percent for the hour.
DISK_LATENCY_MS
NUMBER
Average disk latency (milliseconds) for the hour.
DISK_RATE_IN_BPS
NUMBER
Disk rate: Average disk write performance (bytes/second) for the hour.
DISK_RATE_OUT_BPS
NUMBER
Disk rate: Average disk read performance(bytes/second) for the hour.
DRIVE_BAY_NBR
NUMBER
Drive Bay number.
INTERVAL_TYPE
STRING
Interval type of the collection.
ISI_DRIVE_BAY_ID
NUMBER
Drive Bay ID, for internal use by the StorageConsole database.
ISI_NODE_ID
NUMBER
Node ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
LOG_DATE
DATE
Hourly time stamp format (hh24:00:00) for the hour the log record was aggregated.
NODE_NAME
STRING
Node name
OPERATION_RATE_IN_OPS
NUMBER
Disk rate: Average disk write performance (IOPS) for the hour.
OPERATION_RATE_OUT_OPS
NUMBER
Disk rate: Average disk read performance (IOPS) for the hour.
aps_v_isi_disk_prf_log_min
The aps_v_isi_disk_prf_log_min view contains a single row for each EMC Isilon Disk Performance Minutes Log.
Table 4.88 aps_v_isi_disk_prf_log_min
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CUM_INTERVAL_SEC
NUMBER
Time interval in seconds for which the data was collected.
DISK_BUSY_PCT
NUMBER
Disk busy (percent) at collection time.
DISK_LATENCY_MS
NUMBER
Disk latency (milliseconds) at collection time.
DISK_RATE_IN_BPS
NUMBER
Disk rate: Disk write performance (bytes/second) at collection time.
DISK_RATE_OUT_BPS
NUMBER
Disk rate: Disk read performance (bytes/second) at collection time.
DRIVE_BAY_NBR
NUMBER
Drive Bay number.
INTERVAL_TYPE
STRING
Interval type of the collection.
ISI_DRIVE_BAY_ID
NUMBER
Drive Bay ID, for internal use by the StorageConsole database.
ISI_NODE_ID
NUMBER
Node ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
LOG_DATE
DATE
Date/time that the samples were collected.
NODE_NAME
STRING
Node name
OPERATION_RATE_IN_OPS
NUMBER
Disk rate: Disk write performance (IOPS) at collection time.
OPERATION_RATE_OUT_OPS
NUMBER
Disk rate: Disk read performance (IOPS) at collection time.
aps_v_isi_drive_bay
The aps_v_isi_drive_bay view contains a single row for each EMC Isilon Drive Bay.
Table 4.89 aps_v_isi_drive_bay
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CREATION_DATE
DATE
The date and time the Isilon drive bay data was created in the StorageConsole database.
DISK_POOL_NAME
STRING
Disk pool name.
DRIVE_BAY_NAME
STRING
The name of the drive bay.
DRIVE_BAY_NBR
NUMBER
Drive Bay number.
DRIVE_BAY_STATUS
STRING
The status of the drive bay or the drive in the bay (if any).
ISI_DISK_POOL_ID
NUMBER
Disk Pool ID, for internal use by the StorageConsole database.
ISI_DRIVE_BAY_ID
NUMBER
Unique drive bay ID, for internal use by the StorageConsole database.
ISI_NODE_ID
NUMBER
Node ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
LAST_UPDATED
DATE
The date and time the Isilon drive bay data was last updated in the StorageConsole database.
NODE_NAME
STRING
Node name
aps_v_isi_ftp
The aps_v_isi_ftp view contains a single row for each EMC Isilon FTP transaction.
Table 4.90 aps_v_isi_ftp
Column Name
Data Type
Description
ACCEPT_TIMEOUT_SEC
NUMBER
Accept timeout (seconds) for FTP.
ANONYMOUS_CHOWN_USERNAME
STRING
The owner of anonymously-uploaded files.
ANONYMOUS_PASSWORD_LIST
STRING
List of allowed anonymous passwords for FTP.
ANONYMOUS_ROOT_PATH
STRING
File system path for anonymous users for FTP.
ANONYMOUS_UMASK
STRING
Anonymous user file creation mask for FTP.
ARRAY_NAME
STRING
Array name
ASCII_MODE
STRING
Indicates if ASCII uploads and/or downloads are enabled for FTP: Y or N.
CHROOT_EXCEPTION_LIST
STRING
Exceptions to the chroot local mode setting.
CHROOT_LOCAL_MODE
STRING
Specifies which users are placed in a chroot jail after login.
CONNECT_TIMEOUT_SEC
NUMBER
Connect timeout (seconds) for FTP.
CREATION_DATE
DATE
The date and time the Isilon FTP data was created in the StorageConsole database.
DATA_TIMEOUT_SEC
NUMBER
Data timeout (seconds) for FTP.
DENIED_USER_LIST
STRING
The FTP denied user list.
DIR_LIST_NAMES
STRING
Specifies what user details are shown in directory lists for FTP.
FILE_CREATE_PERMISSIONS
STRING
File creation permissions for FTP.
FS_ROOT_PATH
STRING
File System root path
IS_ALWAYS_CHDIR_HOMEDIR
STRING
Indicates if changing to the home directory should always occur with FTP: Y or N.
IS_ANONYMOUS_ACCESS_ALLOW
STRING
Indicates if anonymous access is allowed for FTP: Y or N.
IS_ANONYMOUS_UPLOAD_ALLOW
STRING
Indicates if anonymous users can upload with FTP: Y or N.
IS_DIRECTORY_LISTS_ALLOW
STRING
Indicates if directory listing is allowed for FTP: Y or N.
IS_DIRLIST_USE_LOCALTIME
STRING
Indicates if the FTP directory list uses local time: Y or N.
IS_DOWNLOAD_ALLOW
STRING
Indicates if downloads are allowed for FTP: Y or N.
IS_LIMIT_ANONYMOUS_PASSWORDS
STRING
Indicates if anonymous passwords are limited for FTP: Y or N.
IS_LOCAL_ACCESS_ALLOW
STRING
Indicates if local access is allowed for FTP: Y or N.
IS_SERVER_TO_SERVER_ALLOW
STRING
Indicates if server-to-server file exchange protocol (FXP) transfers are allowed: Y or N.
IS_WRITE_ALLOW
STRING
Indicates if writes are allowed with FTP: Y or N.
ISI_ONEFS_ID
NUMBER
OneFS ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
LAST_UPDATED
DATE
The date and time the Isilon FTP data was last updated in the StorageConsole database.
LOCAL_UMASK
STRING
Local user file creation umask for FTP.
LOCAL_USER_ROOT_PATH
STRING
File system path for local users for FTP.
SESSION_TIMEOUT_SEC
NUMBER
Session timeout (seconds) for FTP.
USER_CONFIG_DIR
STRING
The user configuration directory.
aps_v_isi_hdsf
The aps_v_isi_hdfs view contains a single row for each EMC Isilon HDFS.
Table 4.91 aps_v_isi_hdfs
Column Name
Data Type
Description
ADDRESS_POOLS
STRING
IP pools assigned to the rack.
ARRAY_NAME
STRING
Array name
AUTHENTICATION
STRING
Authentication method.
BLOCK_SIZE_KB
NUMBER
Hadoop block size (KiB).
CLIENT_ADDRESSES
STRING
IP addresses and address ranges of clients.
CREATION_DATE
DATE
The date and time the Isilon Hadoop Distributed File System (HDFS) data was created in the StorageConsole database.
FS_ROOT_PATH
STRING
File System root path
HDFS_RACK_NAME
STRING
Name of Hadoop Distributed File System (HDFS) rack.
HDSF_ROOT_PATH
STRING
Hadoop (HDFS) root path in the file system.
ISI_ONEFS_ID
NUMBER
OneFS ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
LAST_UPDATED
DATE
The date and time the Isilon Hadoop Distributed File System (HDFS) was last updated in the StorageConsole database.
LOG_LEVEL
STRING
Logging level for Hadoop Distributed File System (HDFS).
NBR_OF_THREADS
NUMBER
Number of threads for Hadoop Distributed File System (HDFS) processing.
VERSION_SUPPORTED
STRING
Hadoop version supported.
aps_v_isi_license
The aps_v_isi_license view contains a single row for each EMC Isilon License.
Table 4.92 aps_v_isi_license
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CREATION_DATE
DATE
The date and time the Isilon license data was created in the StorageConsole database.
EXPIRATION_DATE
DATE
Date and time of the Isilon license expiration.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
LAST_UPDATED
DATE
The date and time the Isilon license data was last updated in the StorageConsole database.
LICENSE_STATUS
STRING
Activation status of the module.
MODULE_NAME
STRING
Name of Isilon module/feature.
aps_v_isi_nfs_client
The aps_v_isi_nfs_client view contains a single row for each EMC Isilon NFS Client.
Table 4.93 aps_v_isi_nfs_client
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CLIENT_ACCESS
STRING
Access type for the clients to the NFS export.
CREATION_DATE
DATE
The date and time the Isilon NFS client data was created in the StorageConsole database.
ISI_NFS_EXPORT_ID
NUMBER
NFS Export ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
LAST_UPDATED
DATE
The date and time the Isilon NFS client data was last updated in the StorageConsole database.
NFS_CLIENT_ADDRESS
STRING
Clients that can access this export.
NFS_EXPORT_ID
NUMBER
The NFS Export ID.
aps_v_isi_nfs_export
The aps_v_isi_nfs_export view contains a single row for each EMC Isilon NFS Export.
Table 4.94 aps_v_isi_nfs_export
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name.
BLOCK_SIZE_KB
NUMBER
Size of block used for the NFS export.
CREATION_DATE
DATE
The date and time the Isilon NFS export data was created in the StorageConsole database.
DESCRIPTION
STRING
Description of the NFS export.
DIRECTORY_TRANSFER_SIZE_GB
NUMBER
Directory transfer size (GiB)
DIRECTORY_TRANSFER_SIZE_KB
NUMBER
Directory transfer size (KiB).
ENCODING
STRING
Encoding method (character set).
FS_ROOT_PATH
STRING
File System root path.
IS_ALL_DIRECTORY
STRING
Indicates if mounting subdirectories directly is allowed: Y or N.
IS_COMMIT_ASYNC
STRING
Indicates if writes are committed asynchronously: Y or N.
IS_MAP_FULL
STRING
Indicates if full identity mapping resolution will be used for mapped users: Y or N.
IS_MAP_LOOKUP_UID
STRING
Indicates if incoming UNIX UIDs will be looked up locally: Y or N.
IS_MAP_RETRY
STRING
Indicates if failed user-mapping lookups will be retried: Y or N.
IS_READ_DIR_PLUS
STRING
Indicates if processing of readdir-plus requests are enabled: Y or N.
IS_READONLY
STRING
Indicates if the NFS export is read-only: Y or N.
IS_RETURN_32_BIT_FIELDS
STRING
Indicates if the size of file identifiers returned from readdir is limited to 32-bits: Y or N.
IS_SET_ATTR_ASYNC
STRING
Indicates if set-attributes operations are performed asynchronously for NFS exports: Y or N.
IS_SET_TIME_ALLOW
STRING
Indicates if the time can be set independent of the cluster system time: Y or N.
IS_SYMLINK_ALLOW
STRING
Indicates if support is advertised for symlinks: Y or N.
ISI_NFS_EXPORT_ID
NUMBER
NFS Export ID, for internal use by the StorageConsole database.
ISI_ONEFS_ID
NUMBER
OneFS ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
LAST_UPDATED
DATE
The date and time the Isilon NFS export data was last updated in the StorageConsole database.
MAP_ALL_GROUPS
STRING
The groups by which operations by any user will execute.
MAP_ALL_USER
STRING
The identity by which operations by any user will execute.
MAP_ROOT_GROUPS
STRING
The groups by which operations by root will execute.
MAP_ROOT_USER
STRING
The identity by which operations by root will execute.
MAX_FILE_SIZE_GB
NUMBER
Maximum allowed file size on the server (GiB)
MAX_FILE_SIZE_KB
NUMBER
Maximum allowed file size on the server (KiB).
NBR_OF_ACCESS_CLIENT_ADDR
NUMBER
Number of client addresses that have access to this NFS export.
NBR_OF_NFS_EXPORT_PATH
NUMBER
Number of NFS export paths in the cluster NFS export.
NBR_OF_READ_WRITE_CLIENT_ADDR
NUMBER
Number of client addresses that have read-write access to this NFS export.
NBR_OF_READONLY_CLIENT_ADDR
NUMBER
Number of client addresses that have read-only access to this NFS export.
NBR_OF_ROOT_CLIENT_ADDR
NUMBER
Number of client addresses that have root access to this NFS export.
NBR_OF_UNRESOLVED_CLIENT_ADDR
NUMBER
Number of client addresses that have access that is unresolved to this NFS export.
NFS_EXPORT_ID
NUMBER
The NFS Export ID.
READ_DIR_PLUS_PREFETCH
NUMBER
The number of file nodes to pre-fetch when a readdir-plus request is processed.
READ_TRANSFER_MAX_SIZE_GB
NUMBER
Maximum read transfer size to report to clients (GiB)
READ_TRANSFER_MAX_SIZE_KB
NUMBER
Maximum read transfer size to report to clients (KiB).
READ_TRANSFER_MULTIPLE
NUMBER
Suggested multiple read size to report to clients.
READ_TRANSFER_SIZE_GB
NUMBER
Preferred read transfer size to report to clients (GiB)
READ_TRANSFER_SIZE_KB
NUMBER
Preferred read transfer size to report to clients (KiB).
SECURITY_TYPE
STRING
Security flavor to support for NFS exports.
TIME_DELTA
NUMBER
Specifies host time granularity (in seconds).
TOTAL_NBR_OF_CLIENT_ADDR
NUMBER
Total number of client addresses in the NFS export.
WRITE_DATASYNC_ACTION
STRING
Specifies the datasync write method.
WRITE_DATASYNC_REPLY
STRING
Specifies the datasync reply method.
WRITE_FILESYNC_ACTION
STRING
Specifies the filesync write method.
WRITE_FILESYNC_REPLY
STRING
Specifies the filesync reply method.
WRITE_TRANSFER_MAX_SIZE_GB
NUMBER
Maximum write transfer size to report to clients (GiB)
WRITE_TRANSFER_MAX_SIZE_KB
NUMBER
Maximum write transfer size to report to clients (KiB)
WRITE_TRANSFER_MULITPLE
NUMBER
Suggested multiple write size to report to clients
WRITE_TRANSFER_SIZE_GB
NUMBER
Preferred wrote transfer size to report to clients (GiB)
WRITE_TRANSFER_SIZE_KB
NUMBER
Preferred write transfer size to report to clients (KiB)
WRITE_UNSTABLE_ACTION
STRING
Specifies the unstable-write method.
WRITE_UNSTABLE_REPLY
STRING
Specifies the unstable-reply method.
aps_v_isi_nfs_export_path
The aps_v_isi_nfs_export_path view contains a single row for each EMC Isilon NFS Export Path.
Table 4.95 aps_v_isi_nfs_export_path
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CREATION_DATE
DATE
The date and time the Isilon NFS export path data was created in the StorageConsole database.
ISI_NFS_EXPORT_ID
NUMBER
NFS Export ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
LAST_UPDATED
DATE
The date and time the Isilon NFS export path data was last updated in the StorageConsole database.
NFS_EXPORT_ID
NUMBER
The NFS Export ID.
NFS_EXPORT_PATH
STRING
File system paths available via this NFS export.
aps_v_isi_node
The aps_v_isi_node view contains a single row for each EMC Isilon Node.
Table 4.96 aps_v_isi_node
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CREATION_DATE
DATE
The date and time the Isilon node data was created in the StorageConsole database.
CURRENT_TIMESTAMP
DATE
Date/time and timezone of the Isilon node.
ENCODING
STRING
The default character encoding.
FS_SSD_FREE_CAPACITY_GB
NUMBER
Total SSD capacity free on the node (GiB)
FS_SSD_FREE_CAPACITY_KB
NUMBER
Total SSD capacity free on the node.
FS_SSD_TOTAL_CAPACITY_GB
NUMBER
Total SSD capacity on the node (GiB)
FS_SSD_TOTAL_CAPACITY_KB
NUMBER
Total SSD capacity on the node.
FS_SSD_USED_CAPACITY_GB
NUMBER
Total SSD capacity used on the node (GiB)
FS_SSD_USED_CAPACITY_KB
NUMBER
Total SSD capacity used on the node.
FS_TOTAL_CAPACITY_GB
NUMBER
Total filesystem capacity on the drive, including metadata (GiB)
FS_TOTAL_CAPACITY_KB
NUMBER
Total file system capacity on the node.
FS_TOTAL_FREE_CAPACITY_GB
NUMBER
Total filesystem capacity free on the node (GiB)
FS_TOTAL_FREE_CAPACITY_KB
NUMBER
Total file system capacity free on the node.
FS_TOTAL_USED_CAPACITY_GB
NUMBER
Total filesystem capacity used on the node (GiB)
FS_TOTAL_USED_CAPACITY_KB
NUMBER
Total file system capacity used on the node.
HEALTH_STATUS
STRING
Overall status/health of the node.
IS_READ_ONLY
STRING
Indicates if the node is read-only: Y or N.
IS_SMART_FAILED
STRING
Indicates if the node is SmartFailed: Y or N.
ISI_NODE_ID
NUMBER
Node ID, for internal use by the StorageConsole database.
ISI_NODE_POOL_ID
NUMBER
Node Pool ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
LAST_BOOT_TIME
DATE
Time at which the node was last booted.
LAST_UPDATED
DATE
The date and time the Isilon node data was last updated in the StorageConsole database.
LOGICAL_NODE_NBR
NUMBER
The logical number of the node.
MEMORY_GB
NUMBER
Total memory installed in the node (GiB)
MEMORY_KB
NUMBER
Total memory installed in the node.
NBR_OF_CPUS
NUMBER
The number of CPUs in the node.
NODE_DEVICE_ID
NUMBER
Unique ID assigned when the node joined the cluster.
NODE_GUID
STRING
Unique identifier (GUID) for the node.
NODE_NAME
STRING
Node name
NODE_POOL_NAME
STRING
Node pool Name.
NODE_TYPE
STRING
The type of Isilon node.
NVRAM_CHARGE_STATUS
STRING
Combined charge status for all batteries.
PRODUCT_NAME
STRING
The product name.
SERIAL_NBR
STRING
Serial number of the Isilon node.
UP_TIME_SEC
NUMBER
Seconds since the node was booted.
aps_v_isi_node_interface
The aps_v_isi_node_interface view contains a single row for each EMC Isilon Node Interface.
Table 4.97 aps_v_isi_node_interface
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CREATION_DATE
DATE
The date and time the Isilon node interface data was created in the StorageConsole database.
DEVICE_NAME
STRING
The Unix device name for the interface.
INTERFACE_IANA_TYPE
NUMBER
The type of interface (assigned IANA value).
INTERFACE_STATUS
STRING
The status of the Isilon node interface.
IS_ETHERNET
STRING
Indicates if the Isilon node interface is Ethernet: Y or N.
IS_INFINIBAND
STRING
Indicates if the Isilon node interface is Infiniband: Y or N.
IS_INTERNAL
STRING
Indicates if the interface is internal: Y or N.
ISI_NODE_ID
NUMBER
Node ID, for internal use by the StorageConsole database.
ISI_NODE_INTERFACE_ID
NUMBER
Node Interface ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
LAST_UPDATED
DATE
The date and time the Isilon node interface data was last updated in the StorageConsole database.
MTU_OCTETS
NUMBER
The largest packet size (octets) for the Isilon node interface.
NODE_INTERFACE_NAME
STRING
Node Interface Name
NODE_NAME
STRING
Node name
SPEED_MBPS
NUMBER
Estimate of the current bandwidth (Mbps) for the Isilon node interface.
aps_v_isi_node_ip_address
The aps_v_isi_node_ip_address view contains a single row for each EMC Isilon Node IP Address.
Table 4.98 aps_v_isi_node_ip_address
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CREATION_DATE
DATE
The date and time the Isilon node IP address data was created in the StorageConsole database.
IP_ADDRESS
STRING
The node’s IPv4 or IPv6 address.
ISI_NODE_ID
NUMBER
Node ID, for internal use by the StorageConsole database.
ISI_NODE_INTERFACE_ID
NUMBER
Node Interface ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
LAST_UPDATED
DATE
The date and time the Isilon node IP address data was last updated in the StorageConsole database.
NODE_INTERFACE_NAME
STRING
Node Interface Name
NODE_NAME
STRING
Node name
aps_v_isi_node_performance
The aps_v_isi_node_performance view contains a single row for each EMC Isilon Node Performance.
Table 4.99 aps_v_isi_node_performance
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
AVG_CPU_PCT
NUMBER
Average CPU usage (percent) across the node at collection time.
AVG_DISK_BUSY_PCT
NUMBER
Average disk busy (percent) across the node at collection time.
AVG_DISK_LATENCY_MS
NUMBER
Average disk latency (milliseconds) across the node at collection time.
AVG_DISK_RATE_IN_BPS
NUMBER
Disk rate: Average disk write performance (bytes/second) across the node at collection time.
AVG_DISK_RATE_IN_OPS
NUMBER
Disk rate: Average disk write performance (IOPS) across the cluster at collection time.
AVG_DISK_RATE_OUT_BPS
NUMBER
Disk rate: Average disk read performance (bytes/second) across the node at collection time.
AVG_DISK_RATE_OUT_OPS
NUMBER
Disk rate: Average disk read performance (IOPS) across the cluster at collection time.
AVG_IDLE_CPU_PCT
NUMBER
Average CPU idle (percent) across the node at collection time.
AVG_INTERRUPT_CPU_PCT
NUMBER
Average interrupt CPU usage (percent) across the node at collection time.
AVG_NICE_CPU_PCT
NUMBER
Average nice CPU (CPU scheduling priority) usage (percent) across the node at collection time.
AVG_SYSTEM_CPU_PCT
NUMBER
Average system CPU usage (percent) across the node at collection time.
AVG_USER_CPU_PCT
NUMBER
Average user CPU usage (percent) across the node at collection time.
EXTERNAL_NETWORK_RATE_IN_BPS
NUMBER
Total network rate (in bytes/second) for all external interfaces in the node at collection time.
EXTERNAL_NETWORK_RATE_OUT_BPS
NUMBER
Total network rate out (bytes/second) for all external interfaces in the node at collection time.
FS_DATA_IN_GB
NUMBER
Cumulative data (Gigabytes) written to the OneFS file system on the node since node boot.
FS_DATA_IN_KB
NUMBER
Cumulative data (Kilobytes) written to the OneFS file system on the node since node boot.
FS_DATA_OUT_GB
NUMBER
Cumulative data (Gigabytes) read from the OneFS file system on the node since node boot.
FS_DATA_OUT_KB
NUMBER
Cumulative data (Kilobytes) read from the OneFS file system on the node since node boot.
FS_OPERATION_RATE_IN_OPS
NUMBER
Transfer rate of writes to the OneFS file system on the node (IOPS) at collection time.
FS_OPERATION_RATE_OUT_OPS
NUMBER
Transfer rate of reads from the OneFS file system on the node (IOPS) at collection time.
FS_RATE_IN_BPS
NUMBER
Transfer rate of writes to the OneFS file system on the node (bytes/second) at collection time.
FS_RATE_OUT_BPS
NUMBER
Transfer rate of reads from the OneFS file system on the node (bytes/second) at collection time.
INTERNAL_NETWORK_RATE_IN_BPS
NUMBER
Total network rate (in bytes/second) for all internal interfaces in the node at collection time.
INTERNAL_NETWORK_RATE_OUT_BPS
NUMBER
Total network rate out (bytes/second) for all internal interfaces in the node at collection time.
ISI_NODE_ID
NUMBER
Node ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
LOG_DATE
DATE
Hourly time stamp format (hh24:00:00) for the hour the log record was aggregated.
MAX_CPU_PCT
NUMBER
Single highest CPU usage (percent) in the node at collection time.
MEMORY_CACHE_KB
NUMBER
Memory used for cache (KiB) on the node at collection time.
MEMORY_FREE_KB
NUMBER
Memory free (KiB) on the node at collection time.
MEMORY_USED_KB
NUMBER
Memory used (KiB) on the node at collection time.
NBR_OF_ACTIVE_CLIENTS
NUMBER
Total number of clients actively transferring to/from the node at collection time.
NBR_OF_CONNECTED_CLIENTS
NUMBER
Total number of clients connected to the node at collection time.
NODE_NAME
STRING
Node name
TOTAL_DISK_RATE_IN_BPS
NUMBER
Disk rate: Total disk write performance (bytes/second) across the node at collection time.
TOTAL_DISK_RATE_IN_OPS
NUMBER
Disk rate: Total disk write performance (IOPS) across the cluster at collection time.
TOTAL_DISK_RATE_OUT_BPS
NUMBER
Disk rate: Total disk read performance (bytes/second) across the node at collection time.
TOTAL_DISK_RATE_OUT_OPS
NUMBER
Disk rate: Total disk read performance (IOPS) across the cluster at collection time.
aps_v_isi_node_pool
The aps_v_isi_node_pool view contains a single row for each EMC Isilon Node Pool.
Table 4.100 aps_v_isi_node_pool
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CREATION_DATE
DATE
The date and time the Isilon node pool data was created in the StorageConsole database.
HEALTH_STATUS
STRING
Overall health of the Isilon node pool.
IS_HEALTH_OK
STRING
Indicates if the Isilon node is OK: Y or N.
IS_MISSING_DRIVES
STRING
Indicates if there are drives missing from the Isilon node pool: Y or N.
IS_NEED_REPAIR
STRING
Indicates if some nodes and/or drives need repair: Y or N.
IS_OFFLINE
STRING
Indicates if some nodes and/or drives are down: Y or N.
IS_SMART_FAILED
STRING
Indicates if some nodes and/or drives are smart-failed: Y or N.
IS_TOO_FEW_NODES
STRING
Indicates if there are too few Isilon nodes available.
ISI_NODE_POOL_ID
NUMBER
Node pool ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
ISI_TIER_ID
NUMBER
Isilon tier ID, for internal use by the StorageConsole database.
LAST_UPDATED
DATE
The date and time the Isilon node pool data was last updated in the StorageConsole database.
NODE_POOL_NAME
STRING
Node pool Name.
TIER_NAME
STRING
Tier Name
aps_v_isi_node_prf_log_day
The aps_v_isi_node_prf_log_day view contains a single row for each EMC Isilon Node Performance Daily Log.
Table 4.101 aps_v_isi_node_prf_log_day
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
AVG_CPU_PCT
NUMBER
Average CPU usage (percent) across the node for the day.
AVG_DISK_BUSY_PCT
NUMBER
Average disk busy (percent) across the node for the day.
AVG_DISK_LATENCY_MS
NUMBER
Average disk latency (milliseconds) across the node for the day.
AVG_DISK_RATE_IN_BPS
NUMBER
Disk rate: Average disk write performance (bytes/second) across the node for the day.
AVG_DISK_RATE_IN_OPS
NUMBER
Disk rate: Average disk write performance (IOPS) across the cluster for the day.
AVG_DISK_RATE_OUT_BPS
NUMBER
Disk rate: Average disk read performance (bytes/second) across the node for the day.
AVG_DISK_RATE_OUT_OPS
NUMBER
Disk rate: Average disk read performance (IOPS) across the cluster for the day.
AVG_IDLE_CPU_PCT
NUMBER
Average CPU idle (percent) across the node for the day.
AVG_INTERRUPT_CPU_PCT
NUMBER
Average interrupt CPU usage (percent) across the node for the day.
AVG_NICE_CPU_PCT
NUMBER
Average nice CPU (CPU scheduling priority) usage (percent) across the node for the day.
AVG_SYSTEM_CPU_PCT
NUMBER
Average system CPU usage (percent) across the node for the day.
AVG_USER_CPU_PCT
NUMBER
Average user CPU usage (percent) across the node for the day.
CUM_INTERVAL_SEC
NUMBER
Time interval in seconds for the day for which the data was collected.
EXTERNAL_NETWORK_RATE_IN_BPS
NUMBER
Average network rate (in bytes/second) for all external interfaces in the node for the day.
EXTERNAL_NETWORK_RATE_OUT_BPS
NUMBER
Average network rate out (bytes/second) for all external interfaces in the node for the day.
FS_DATA_IN_GB
NUMBER
Cumulative data (GiB) written to the OneFS file system on the node for the day.
FS_DATA_IN_KB
NUMBER
Cumulative data (KiB) written to the OneFS file system on the node for the day.
FS_DATA_OUT_GB
NUMBER
Cumulative data (GiB) read from the OneFS file system on the node for the day.
FS_DATA_OUT_KB
NUMBER
Cumulative data (KiB) read from the OneFS file system on the node for the day.
FS_OPERATION_RATE_IN_OPS
NUMBER
Average Transfer rate of writes to the OneFS file system on the node (IOPS) for the day.
FS_OPERATION_RATE_OUT_OPS
NUMBER
Average Transfer rate of reads from the OneFS file system on the node (IOPS) afor the day.
FS_RATE_IN_BPS
NUMBER
Average Transfer rate of writes to the OneFS file system on the node (bytes/second) for the day.
FS_RATE_OUT_BPS
NUMBER
Average Transfer rate of reads from the OneFS file system on the node (bytes/second) for the day.
INTERNAL_NETWORK_RATE_IN_BPS
NUMBER
Average network rate (in bytes/second) for all internal interfaces in the node for the day.
INTERNAL_NETWORK_RATE_OUT_BPS
NUMBER
Average network rate out (bytes/second) for all internal interfaces in the node for the day.
INTERVAL_TYPE
STRING
Interval type of the collection.
ISI_NODE_ID
NUMBER
Node ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
LOG_DATE
DATE
Midnight time stamp of the day the record was aggregated for the log entry.
MAX_CPU_PCT
NUMBER
Maximum CPU usage (percent) in the node for the day.
MEMORY_CACHE_KB
NUMBER
Average memory used for cache (KiB) on the node for the day.
MEMORY_FREE_KB
NUMBER
Average memory free (KiB) on the node for the day.
MEMORY_USED_KB
NUMBER
Average memory used (KiB) on the node for the day.
NBR_OF_ACTIVE_CLIENTS
NUMBER
Average clients actively transferring to/from the node for the day.
NBR_OF_CONNECTED_CLIENTS
NUMBER
Average clients connected to the node for the day.
NODE_NAME
STRING
Node name
TOTAL_DISK_RATE_IN_BPS
NUMBER
Disk rate: Average disk write performance (bytes/second) across the node for the day.
TOTAL_DISK_RATE_IN_OPS
NUMBER
Disk rate: Average disk write performance (IOPS) across the cluster for the day.
TOTAL_DISK_RATE_OUT_BPS
NUMBER
Disk rate: Average disk read performance (bytes/second) across the node for the day.
TOTAL_DISK_RATE_OUT_OPS
NUMBER
Disk rate: Average disk read performance (IOPS) across the cluster for the day.
aps_v_isi_node_prf_log_hr
The aps_v_isi_node_prf_log_hr view contains a single row for each EMC Isilon Node Performance Hourly Log.
Table 4.102 aps_v_isi_node_prf_log_hr
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
AVG_CPU_PCT
NUMBER
Average CPU usage (percent) across the node for the hour.
AVG_DISK_BUSY_PCT
NUMBER
Average disk busy (percent) across the node for the hour.
AVG_DISK_LATENCY_MS
NUMBER
Average disk latency (milliseconds) across the node for the hour.
AVG_DISK_RATE_IN_BPS
NUMBER
Disk rate: Average disk write performance (bytes/second) across the node for the hour.
AVG_DISK_RATE_IN_OPS
NUMBER
Disk rate: Average disk write performance (IOPS) across the cluster for the hour.
AVG_DISK_RATE_OUT_BPS
NUMBER
Disk rate: Average disk read performance (bytes/second) across the node for the hour.
AVG_DISK_RATE_OUT_OPS
NUMBER
Disk rate: Average disk read performance (IOPS) across the cluster for the hour.
AVG_IDLE_CPU_PCT
NUMBER
Average CPU idle (percent) across the node for the hour.
AVG_INTERRUPT_CPU_PCT
NUMBER
Average interrupt CPU usage (percent) across the node for the hour.
AVG_NICE_CPU_PCT
NUMBER
Average nice CPU (CPU scheduling priority) usage (percent) across the node for the hour.
AVG_SYSTEM_CPU_PCT
NUMBER
Average system CPU usage (percent) across the node for the hour.
AVG_USER_CPU_PCT
NUMBER
Average user CPU usage (percent) across the node for the hour.
CUM_INTERVAL_SEC
NUMBER
Time interval in seconds for the day for which the data was collected.
EXTERNAL_NETWORK_RATE_IN_BPS
NUMBER
Average network rate (in bytes/second) for all external interfaces in the node for the hour.
EXTERNAL_NETWORK_RATE_OUT_BPS
NUMBER
Average network rate out (bytes/second) for all external interfaces in the node for the hour.
FS_DATA_IN_GB
NUMBER
Average rate of writes to the OneFS file system on the node (bytes/second) for the hour.
FS_DATA_IN_KB
NUMBER
Cumulative data (KiB) written to the OneFS file system on the node since node boot.
FS_DATA_OUT_GB
NUMBER
Cumulative data (GiB) read from the OneFS file system on the node for the hour.
FS_DATA_OUT_KB
NUMBER
Average rate of reads from the OneFS file system on the node (bytes/second) for the hour.
FS_OPERATION_RATE_IN_OPS
NUMBER
Average rate of writes to the OneFS file system on the node (IOPS) for the hour.
FS_OPERATION_RATE_OUT_OPS
NUMBER
Average rate of reads from the OneFS file system on the node (IOPS) for the hour.
FS_RATE_IN_BPS
NUMBER
Average rate of writes to the OneFS file system on the node (bytes/second) for the hour.
FS_RATE_OUT_BPS
NUMBER
Average rate of reads from the OneFS file system on the node (bytes/second) for the hour.
INTERNAL_NETWORK_RATE_IN_BPS
NUMBER
Average network rate (in bytes/second) for all internal interfaces in the node for the hour.
INTERNAL_NETWORK_RATE_OUT_BPS
NUMBER
Average network rate out (bytes/second) for all internal interfaces in the node for the hour.
INTERVAL_TYPE
STRING
Interval type of the collection.
ISI_NODE_ID
NUMBER
Node ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
LOG_DATE
DATE
Hourly time stamp format (hh24:00:00) for the hour the log record was aggregated.
MAX_CPU_PCT
NUMBER
Maximum CPU usage (percent) in the node for the hour.
MEMORY_CACHE_KB
NUMBER
Memory used for cache (KiB) on the node for the hour.
MEMORY_FREE_KB
NUMBER
Average memory free (KiB) on the node for the hour.
MEMORY_USED_KB
NUMBER
Average memory used (KiB) on the node for the hour.
NBR_OF_ACTIVE_CLIENTS
NUMBER
Average number of clients actively transferring to/from the node for the hour.
NBR_OF_CONNECTED_CLIENTS
NUMBER
Average number of clients connected to the node for the hour.
NODE_NAME
STRING
Node name
TOTAL_DISK_RATE_IN_BPS
NUMBER
Disk rate: Average disk write performance (bytes/second) across the node for the hour.
TOTAL_DISK_RATE_IN_OPS
NUMBER
Disk rate: Average disk write performance (IOPS) across the cluster for the hour.
TOTAL_DISK_RATE_OUT_BPS
NUMBER
Disk rate: Average disk read performance (bytes/second) across the node for the hour.
TOTAL_DISK_RATE_OUT_OPS
NUMBER
Disk rate: Average disk read performance (IOPS) across the cluster for the hour.
aps_v_isi_node_prf_log_min
The aps_v_isi_node_prf_log_min view contains a single row for each EMC Isilon Node Performance Minutes Log.
Table 4.103 aps_v_isi_node_prf_log_min
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
AVG_CPU_PCT
NUMBER
Average CPU usage (percent) across the node at collection time.
AVG_DISK_BUSY_PCT
NUMBER
Average disk busy (percent) across the node at collection time.
AVG_DISK_LATENCY_MS
NUMBER
Average disk latency (milliseconds) across the node at collection time.
AVG_DISK_RATE_IN_BPS
NUMBER
Disk rate: Average disk write performance (bytes/second) across the node at collection time.
AVG_DISK_RATE_IN_OPS
NUMBER
Disk rate: Average disk write performance (IOPS) across the cluster at collection time.
AVG_DISK_RATE_OUT_BPS
NUMBER
Disk rate: Average disk read performance (bytes/second) across the node at collection time.
AVG_DISK_RATE_OUT_OPS
NUMBER
Disk rate: Average disk read performance (IOPS) across the cluster at collection time.
AVG_IDLE_CPU_PCT
NUMBER
Average CPU idle (percent) across the node at collection time.
AVG_INTERRUPT_CPU_PCT
NUMBER
Average interrupt CPU usage (percent) across the node at collection time.
AVG_NICE_CPU_PCT
NUMBER
Average nice CPU (CPU scheduling priority) usage (percent) across the node at collection time.
AVG_SYSTEM_CPU_PCT
NUMBER
Average system CPU usage (percent) across the node at collection time.
AVG_USER_CPU_PCT
NUMBER
Average user CPU usage (percent) across the node at collection time.
CUM_INTERVAL_SEC
NUMBER
Time interval in seconds for the day for which the data was collected.
EXTERNAL_NETWORK_RATE_IN_BPS
NUMBER
Total network rate (in bytes/second) for all external interfaces in the node at collection time.
EXTERNAL_NETWORK_RATE_OUT_BPS
NUMBER
Total network rate out (bytes/second) for all external interfaces in the node at collection time.
FS_DATA_IN_GB
NUMBER
Cumulative data (GiB) written to the OneFS file system on the node since node boot.
FS_DATA_IN_KB
NUMBER
Cumulative data (KiB) written to the OneFS file system on the node since node boot.
FS_DATA_OUT_GB
NUMBER
Cumulative data (GiB) read from the OneFS file system on the node since node boot.
FS_DATA_OUT_KB
NUMBER
Cumulative data (KiB) read from the OneFS file system on the node since node boot.
FS_OPERATION_RATE_IN_OPS
NUMBER
Transfer rate of writes to the OneFS file system on the node (IOPS) at collection time.
FS_OPERATION_RATE_OUT_OPS
NUMBER
Transfer rate of reads from the OneFS file system on the node (IOPS) at collection time.
FS_RATE_IN_BPS
NUMBER
Transfer rate of writes to the OneFS file system on the node (bytes/second) at collection time.
FS_RATE_OUT_BPS
NUMBER
Transfer rate of reads from the OneFS file system on the node (bytes/second) at collection time.
INTERNAL_NETWORK_RATE_IN_BPS
NUMBER
Total network rate (in bytes/second) for all internal interfaces in the node at collection time.
INTERNAL_NETWORK_RATE_OUT_BPS
NUMBER
Total network rate out (bytes/second) for all internal interfaces in the node at collection time.
INTERVAL_TYPE
STRING
Interval type of the collection.
ISI_NODE_ID
NUMBER
Node ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
LOG_DATE
DATE
Date/time that the samples were collected.
MAX_CPU_PCT
NUMBER
Single highest CPU usage (percent) in the node at collection time.
MEMORY_CACHE_KB
NUMBER
Memory used for cache (KiB) on the node at collection time.
MEMORY_FREE_KB
NUMBER
Memory free (KiB) on the node at collection time.
MEMORY_USED_KB
NUMBER
Memory used (KiB) on the node at collection time.
NBR_OF_ACTIVE_CLIENTS
NUMBER
Total number of clients actively transferring to/from the node at collection time.
NBR_OF_CONNECTED_CLIENTS
NUMBER
Total number of clients connected to the node at collection time.
NODE_NAME
STRING
Node name
TOTAL_DISK_RATE_IN_BPS
NUMBER
Disk rate: Total disk write performance (bytes/second) across the node at collection time.
TOTAL_DISK_RATE_IN_OPS
NUMBER
Disk rate: Total disk write performance (IOPS) across the cluster at collection time.
TOTAL_DISK_RATE_OUT_BPS
NUMBER
Disk rate: Total disk read performance (bytes/second) across the node at collection time.
TOTAL_DISK_RATE_OUT_OPS
NUMBER
Disk rate: Total disk read performance (IOPS) across the cluster at collection time.
aps_v_isi_onefs
The aps_v_isi_onefs view contains a single row for each EMC Isilon OneFS File System.
Table 4.104 aps_v_isi_onefs
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CREATION_DATE
DATE
The date and time the Isilon OneFS file system data was created in the StorageConsole database.
FS_AVAILABLE_CAPACITY_GB
NUMBER
Available filesystem capacity (GiB)
FS_AVAILABLE_CAPACITY_KB
NUMBER
Available OneFS file system capacity.
FS_BLOCK_SIZE_KB
NUMBER
The size of blocks allocated in the OneFS file system.
FS_CAPACITY_INCL_SPARE_GB
NUMBER
Total filesystem capacity (GiB)
FS_CAPACITY_INCL_SPARE_KB
NUMBER
Total OneFS file system capacity.
FS_DISK_RESERVED_CAPACITY_GB
NUMBER
Capacity reserved per disk (GiB)
FS_DISK_RESERVED_CAPACITY_KB
NUMBER
Capacity reserved per disk (OneFS).
FS_HOT_SPARE_CAPACITY_GB
NUMBER
Virtual Hot Spare reserved (GiB)
FS_HOT_SPARE_CAPACITY_KB
NUMBER
Virtual Hot Spare reserved (OneFS)
FS_ROOT_PATH
STRING
File System root path
FS_SSD_FREE_CAPACITY_GB
NUMBER
Total SSD capacity free on the node (GiB)
FS_SSD_FREE_CAPACITY_KB
NUMBER
Free SSD capacity (OneFS).
FS_SSD_TOTAL_CAPACITY_GB
NUMBER
Total SSD capacity on the node (GiB)
FS_SSD_TOTAL_CAPACITY_KB
NUMBER
Total SSD capacity (OneFS).
FS_SSD_USED_CAPACITY_GB
NUMBER
Total SSD capacity used on the node (GiB)
FS_SSD_USED_CAPACITY_KB
NUMBER
Used SSD capacity (OneFS).
FS_USABLE_CAPACITY_GB
NUMBER
Total usable filesystem capacity (GiB)
FS_USABLE_CAPACITY_KB
NUMBER
Total usable OneFS file system capacity.
FS_USED_CAPACITY_GB
NUMBER
Used filesystem capacity on the drive (GiB)
FS_USED_CAPACITY_KB
NUMBER
Used OneFS file system capacity.
ISI_ONEFS_ID
NUMBER
ID for the Isilon OneFS distributed file system, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
LAST_UPDATED
DATE
The date and time the Isilon OneFS file system data was last updated in the StorageConsole database.
aps_v_isi_onefs_performance
The aps_v_isi_onefs_performance view contains a single row for each EMC Isilon Onefs File System Performance.
Table 4.105 aps_v_isi_onefs_performance
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
FS_DATA_IN_GB
NUMBER
Cumulative data (GiB) written to the OneFS file system.
FS_DATA_IN_KB
NUMBER
Cumulative data (KiB) written to the OneFS file system.
FS_DATA_OUT_GB
NUMBER
Cumulative data (GiB) read from the OneFS file system.
FS_DATA_OUT_KB
NUMBER
Cumulative data (KiB) read from the OneFS file system.
FS_RATE_IN_BPS
NUMBER
Transfer rate of writes to the OneFS file system (bytes/second) at collection time.
FS_RATE_OUT_BPS
NUMBER
Transfer rate of reads from the OneFS file system (bytes/second) at collection time.
ISI_ONEFS_ID
NUMBER
OneFS ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
LOG_DATE
DATE
Date/time that the samples were collected.
aps_v_isi_onefs_prf_log_day
The aps_v_isi_onefs_prf_log_day view contains a single row for each EMC Isilon OneFS File System Performance Daily Log.
Table 4.106 aps_v_isi_onefs_prf_log_day
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CUM_INTERVAL_SEC
NUMBER
Time interval in seconds for the day for which the data was collected.
FS_DATA_IN_GB
NUMBER
Cumulative data (GiB) written to the OneFS file system for the day.
FS_DATA_IN_KB
NUMBER
Cumulative data (KiB) written to the OneFS file system for the day.
FS_DATA_OUT_GB
NUMBER
Cumulative data (GiB) read from the OneFS file system for the day.
FS_DATA_OUT_KB
NUMBER
Cumulative data (KiB) read from the OneFS file system for the day.
FS_RATE_IN_BPS
NUMBER
Average rate of writes to the OneFS file system (bytes/second) for the day.
FS_RATE_OUT_BPS
NUMBER
Average rate of reads from the OneFS file system (bytes/second) for the day.
INTERVAL_TYPE
STRING
Interval type of the collection.
ISI_ONEFS_ID
NUMBER
OneFS ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
LOG_DATE
DATE
Midnight time stamp of the day the record was aggregated for.
aps_v_isi_onefs_prf_log_hr
The aps_v_isi_onefs_prf_log_hr view contains a single row for each EMC Isilon OneFS File System Performance Hourly Log.
Table 4.107 aps_v_isi_onefs_prf_log_hr
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CUM_INTERVAL_SEC
NUMBER
Time interval in seconds for the day for which the data was collected.
FS_DATA_IN_GB
NUMBER
Cumulative data (GiB) written to the OneFS file system for the hour.
FS_DATA_IN_KB
NUMBER
Cumulative data (KiB) written to the OneFS file system for the hour.
FS_DATA_OUT_GB
NUMBER
Cumulative data (GiB) read from the OneFS file system for the hour.
FS_DATA_OUT_KB
NUMBER
Cumulative data (KiB) read from the OneFS file system for the hour.
FS_RATE_IN_BPS
NUMBER
Average rate of writes to the OneFS file system (bytes/second) for the hour.
FS_RATE_OUT_BPS
NUMBER
Average rate of reads from the OneFS file system (bytes/second) for the hour.
INTERVAL_TYPE
STRING
Interval type of the collection.
ISI_ONEFS_ID
NUMBER
OneFS ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
LOG_DATE
DATE
Hourly time stamp format (hh24:00:00) for the hour the log record was aggregated.
aps_v_isi_onefs_prf_log_min
The aps_v_isi_onefs_prf_log_min view contains a single row for each EMC Isilon OneFS File System Performance Minutes Log.
Table 4.108 aps_v_isi_onefs_prf_log_min
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CUM_INTERVAL_SEC
NUMBER
Time interval in seconds for the day for which the data was collected.
FS_DATA_IN_GB
NUMBER
Cumulative data (GiB) written to the OneFS file system.
FS_DATA_IN_KB
NUMBER
Cumulative data (KiB) written to the OneFS file system.
FS_DATA_OUT_GB
NUMBER
Cumulative data (GiB) read from the OneFS file system.
FS_DATA_OUT_KB
NUMBER
Cumulative data (KiB) read from the OneFS file system.
FS_RATE_IN_BPS
NUMBER
Transfer rate of writes to the OneFS file system (bytes/second) at collection time.
FS_RATE_OUT_BPS
NUMBER
Transfer rate of reads from the OneFS file system (bytes/second) at collection time.
INTERVAL_TYPE
STRING
Interval type of the collection.
ISI_ONEFS_ID
NUMBER
OneFS ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
LOG_DATE
DATE
Date/time that the samples were collected.
aps_v_isi_protocol_client
The aps_v_isi_protocol_client view contains a single row for each EMC Isilon Protocol Client.
Table 4.109 aps_v_isi_protocol_client
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name.
CLIENT_ADDRESS
STRING
Address of the client.
CREATION_DATE
DATE
The date and time the Isilon protocol data was created in the StorageConsole database.
ISI_NODE_ID
NUMBER
Node ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
LAST_UPDATED
DATE
The date and time the Isilon protocol data was last updated in the StorageConsole database.
NODE_NAME
STRING
Node name.
PROTOCOL_NAME
STRING
Name of the protocol for the client.
aps_v_isi_protocol_performance
The aps_v_isi_protocol_performance view contains a single row for each EMC Isilon Protocol Performance.
Table 4.110 aps_v_isi_protocol_performance
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name.
AVG_LATENCY_MS
NUMBER
The average latency in (milliseconds) for all operations for the protocol on this node.
AVG_OPERATION_SIZE_IN_BYTE
NUMBER
The average input size (bytes) of all operations for the protocol on this node.
AVG_OPS_SIZE_OUT_BYTE
NUMBER
The average output size (bytes) of all operations for the protocol on this node.
ISI_NODE_ID
NUMBER
Node ID, for internal use by the StorageConsole database.
isi_protocol_id
NUMBER
Protocol ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
LOG_DATE
DATE
Date/time that the samples were collected.
MAX_LATENCY_MS
NUMBER
The maximum latency in (milliseconds) for all operations for the protocol on this node.
MAX_OPERATION_SIZE_IN_BYTE
NUMBER
The largest input size (bytes) of all operations for the protocol on this node.
MAX_OPS_SIZE_OUT_BYTE
NUMBER
The largest output size (bytes) of all operations for the protocol on this node.
MIN_LATENCY_MS
NUMBER
The minimum latency (milliseconds) for all operations for the protocol on this node.
MIN_OPERATION_SIZE_IN_BYTE
NUMBER
The smallest input size (bytes) of all operations for the protocol on this node.
MIN_OPS_SIZE_OUT_BYTE
NUMBER
The smallest output size (bytes) of all operations for the protocol on this node.
NBR_OF_ACTIVE_CLIENTS
NUMBER
Number of clients actively transferring to/from the node via this protocol at collection time.
NBR_OF_CONNECTED_CLIENTS
NUMBER
Number of clients connected to the node via this protocol at collection time.
NODE_NAME
STRING
Node name
OPERATION_RATE_OPS
NUMBER
Transfer rate (IOPS) for this protocol on this node at collection time.
PROTOCOL_NAME
STRING
Protocol to which this performance data belongs.
TRANSFER_RATE_IN_BPS
NUMBER
Transfer rate (in bytes/second) for this protocol on this node at collection time.
TRANSFER_RATE_OUT_BPS
NUMBER
Transfer rate out (bytes/second) for this protocol on this node at collection time.
aps_v_isi_protocol_prf_log_day
The aps_v_isi_protocol_prf_log_day view contains a single row for each EMC Isilon Protocol Performance Daily Log.
Table 4.111 aps_v_isi_protocol_prf_log_day
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
AVG_LATENCY_MS
NUMBER
Average latency in (milliseconds) for all operations for the protocol on this node for the day.
AVG_OPERATION_SIZE_IN_BYTE
NUMBER
Average input size (bytes) of all operations for the protocol on this node for the day.
AVG_OPS_SIZE_OUT_BYTE
NUMBER
Average output size (bytes) of all operations for the protocol on this node for the day.
CUM_INTERVAL_SEC
NUMBER
Time interval in seconds for the day for which the data was collected.
INTERVAL_TYPE
STRING
Interval type of the collection.
ISI_NODE_ID
NUMBER
Node ID, for internal use by the StorageConsole database.
isi_protocol_id
NUMBER
Protocol ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
LOG_DATE
DATE
Midnight time stamp of the day the record was aggregated for.
MAX_LATENCY_MS
NUMBER
Maximum latency in (milliseconds) for all operations for the protocol on this node for the day.
MAX_OPERATION_SIZE_IN_BYTE
NUMBER
Maximum input size (bytes) of all operations for the protocol on this node for the day.
MAX_OPS_SIZE_OUT_BYTE
NUMBER
Maximum output size (bytes) of all operations for the protocol on this node for the day.
MIN_LATENCY_MS
NUMBER
Minimum latency (milliseconds) for all operations for the protocol on this node for the day.
MIN_OPERATION_SIZE_IN_BYTE
NUMBER
Minimum input size (bytes) of all operations for the protocol on this node for the day.
MIN_OPS_SIZE_OUT_BYTE
NUMBER
Minimum output size (bytes) of all operations for the protocol on this node for the day.
NBR_OF_ACTIVE_CLIENTS
NUMBER
Average number of clients actively transferring to/from the node via this protocol for the day.
NBR_OF_CONNECTED_CLIENTS
NUMBER
Average number of clients connected to the node via this protocol for the day.
NODE_NAME
STRING
Node name
OPERATION_RATE_OPS
NUMBER
Average transfer rate (IOPS) for this protocol on this node for the day.
PROTOCOL_NAME
STRING
Protocol to which this performance data belongs.
TRANSFER_RATE_IN_BPS
NUMBER
Average transfer rate (in bytes/second) for this protocol on this node for the day.
TRANSFER_RATE_OUT_BPS
NUMBER
Average transfer rate out (bytes/second) for this protocol on this node for the day.
aps_v_isi_protocol_prf_log_hr
The aps_v_isi_protocol_prf_log_hr view contains a single row for each EMC Isilon Protocol Performance Hourly Log.
Table 4.112 aps_v_isi_protocol_prf_log_hr
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
AVG_LATENCY_MS
NUMBER
Average latency in (milliseconds) for all operations for the protocol on this node for the day.
AVG_OPERATION_SIZE_IN_BYTE
NUMBER
Average input size (bytes) of all operations for the protocol on this node for the day.
AVG_OPS_SIZE_OUT_BYTE
NUMBER
Average output size (bytes) of all operations for the protocol on this node for the day.
CUM_INTERVAL_SEC
NUMBER
Time interval in seconds for which the data was collected.
INTERVAL_TYPE
STRING
Interval type of the collection.
ISI_NODE_ID
NUMBER
Node ID, for internal use by the StorageConsole database.
isi_protocol_id
NUMBER
Protocol ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
 
LOG_DATE
DATE
Hourly time stamp format (hh24:00:00) for the hour the log record was aggregated.
MAX_LATENCY_MS
NUMBER
Maximum latency in (milliseconds) for all operations for the protocol on this node for the day.
MAX_OPERATION_SIZE_IN_BYTE
NUMBER
Maximum input size (bytes) of all operations for the protocol on this node for the day.
MAX_OPS_SIZE_OUT_BYTE
NUMBER
Maximum output size (bytes) of all operations for the protocol on this node for the day.
MIN_LATENCY_MS
NUMBER
Minimum latency (milliseconds) for all operations for the protocol on this node for the day.
MIN_OPERATION_SIZE_IN_BYTE
NUMBER
Minimum input size (bytes) of all operations for the protocol on this node for the day.
MIN_OPS_SIZE_OUT_BYTE
NUMBER
Minimum output size (bytes) of all operations for the protocol on this node for the day.
NBR_OF_ACTIVE_CLIENTS
NUMBER
Average number of clients actively transferring to/from the node via this protocol for the day.
NBR_OF_CONNECTED_CLIENTS
NUMBER
Average number of clients connected to the node via this protocol for the day.
NODE_NAME
STRING
Node name
OPERATION_RATE_OPS
NUMBER
Average transfer rate (IOPS) for this protocol on this node for the day.
PROTOCOL_NAME
STRING
Protocol to which this performance data belongs.
TRANSFER_RATE_IN_BPS
NUMBER
Average transfer rate (in bytes/second) for this protocol on this node for the day.
TRANSFER_RATE_OUT_BPS
NUMBER
Average transfer rate out (bytes/second) for this protocol on this node for the day.
aps_v_isi_protocol_prf_log_min
The aps_v_isi_protocol_prf_log_min view contains a single row for each EMC Isilon Protocol Performance Minutes Log.
Table 4.113 aps_v_isi_protocol_prf_log_min
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
AVG_LATENCY_MS
NUMBER
The average latency in (milliseconds) for all operations for the protocol on this node.
AVG_OPERATION_SIZE_IN_BYTE
NUMBER
The average input size (bytes) of all operations for the protocol on this node.
AVG_OPS_SIZE_OUT_BYTE
NUMBER
The average output size (bytes) of all operations for the protocol on this node.
CUM_INTERVAL_SEC
NUMBER
Time interval, in seconds, for which the Isilon protocol performance data was collected.
INTERVAL_TYPE
STRING
Interval type of the protocol performance collection.
ISI_NODE_ID
NUMBER
Node ID, for internal use by the StorageConsole database.
isi_protocol_id
NUMBER
Protocol ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
LOG_DATE
DATE
Date and time the Isilon protocol performance samples were collected.
MAX_LATENCY_MS
NUMBER
The maximum latency in (milliseconds) for all operations for the protocol on this node.
MAX_OPERATION_SIZE_IN_BYTE
NUMBER
The largest input size (bytes) of all operations for the protocol on this node.
MAX_OPS_SIZE_OUT_BYTE
NUMBER
The largest output size (bytes) of all operations for the protocol on this node.
MIN_LATENCY_MS
NUMBER
The minimum latency (milliseconds) for all operations for the protocol on this node.
MIN_OPERATION_SIZE_IN_BYTE
NUMBER
The smallest input size (bytes) of all operations for the protocol on this node.
MIN_OPS_SIZE_OUT_BYTE
NUMBER
The smallest output size (bytes) of all operations for the protocol on this node.
NBR_OF_ACTIVE_CLIENTS
NUMBER
Number of clients actively transferring to/from the node via this protocol at collection time.
NBR_OF_CONNECTED_CLIENTS
NUMBER
Number of clients connected to the node via this protocol at collection time.
NODE_NAME
STRING
Node name
OPERATION_RATE_OPS
NUMBER
Transfer rate (IOPS) for this protocol on this node at collection time.
PROTOCOL_NAME
STRING
Protocol to which this performance data belongs.
TRANSFER_RATE_IN_BPS
NUMBER
Transfer rate (in bytes/second) for this protocol on this node at collection time.
TRANSFER_RATE_OUT_BPS
NUMBER
Transfer rate out (bytes/second) for this protocol on this node at collection time.
aps_v_isi_snapshot
The aps_v_isi_snapshot view contains a single row for each EMC Isilon Snapshot.
Table 4.114 aps_v_isi_snapshot
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CREATION_DATE
DATE
The date and time the Isilon snapshot data was created in the StorageConsole database.
FS_ROOT_PATH
STRING
File System root path
FS_USED_PCT
NUMBER
Percentage of the file system used by this snapshot.
IS_SNAPSHOT_LOCKED
STRING
Indicates if the snapshot has any locks: Y or N.
ISI_ONEFS_ID
NUMBER
OneFS ID, for internal use by the StorageConsole database.
ISI_SNAPSHOT_SCHEDULE_ID
NUMBER
Snapshot Schedule ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
LAST_UPDATED
DATE
The date and time the Isilon snapshot data was last updated in the StorageConsole database.
RESERVED_USED_PCT
NUMBER
Percentage of the snapshot reserve used by this snapshot.
SCHEDULE_NAME
STRING
Schedule Name
SCHEDULE_WHEN
STRING
When snapshots will be taken
SNAPSHOT_ALIAS
STRING
Alias for the snapshot.
SNAPSHOT_CREATION_DATE
DATE
The date and time the snapshot was created.
SNAPSHOT_EXPIRATION_DATE
DATE
The date and time the snapshot will expire.
SNAPSHOT_ID
NUMBER
Snapshot ID, for internal use by the StorageConsole database.
SNAPSHOT_NAME
STRING
Isilon snapshot name.
SNAPSHOT_PATH
STRING
Path for which the snapshot was taken.
SNAPSHOT_SHADOW_GB
NUMBER
The amount of data referenced from shadow stored (GiB)
SNAPSHOT_SHADOW_KB
NUMBER
The amount of data referenced from shadow stores (KiB).
SNAPSHOT_SIZE_GB
NUMBER
The size of the snapshot (GiB)
SNAPSHOT_SIZE_KB
NUMBER
The size of the snapshot (KiB).
SNAPSHOT_STATE
STRING
The state of the snapshot.
 
aps_v_isi_snapshot_schedule
The aps_v_isi_snapshot_schedule view contains a single row for each EMC Isilon Snapshot Schedule.
Table 4.115 aps_v_isi_snapshot_schedule
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CREATION_DATE
DATE
The date and time the Isilon snapshot data was created in the StorageConsole database.
ISI_SNAPSHOT_SCHEDULE_ID
NUMBER
Snapshot Schedule ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
LAST_UPDATED
DATE
The date and time the Isilon snapshot data was last updated in the StorageConsole database.
SCHEDULE_ALIAS
STRING
Alias for the latest snapshot generated by the schedule.
SCHEDULE_EXPIRE
STRING
When snapshots will expire (duration or date).
SCHEDULE_INDEX
NUMBER
The snapshot schedule index.
SCHEDULE_NAME
STRING
Schedule Name
SCHEDULE_PATH
STRING
The path that will be used by the schedule for the snapshot.
SCHEDULE_WHEN
STRING
When snapshots will be taken
aps_v_isi_storage_system
The aps_v_isi_storage_system view contains a single row for each EMC Isilon Storage System.
Table 4.116 aps_v_isi_storage_system
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
BUILD_VERSION
STRING
The build version string for the cluster.
CREATION_DATE
DATE
The date and time the Isilon storage system data was created in the StorageConsole database.
HEALTH_STATUS
STRING
Overall status/health of the cluster.
IS_ROOT_ACCESS_CIFS
STRING
Indicates if snapshot directories are accessible via CIFS: Y or N.
IS_ROOT_ACCESS_LOCAL
STRING
Indicates if snapshot directories are accessible via the local file system: Y or N.
IS_ROOT_ACCESS_NFS
STRING
Indicates if snapshot directories are accessible via NFS: Y or N.
IS_ROOT_VISIBLE_CIFS
STRING
Indicates if snapshot directories are visible via CIFS: Y or N.
IS_ROOT_VISIBLE_LOCAL
STRING
Indicates if snapshot directories are visible in the local file system: Y or N.
IS_ROOT_VISIBLE_NFS
STRING
Indicates if snapshot directories are visible via NFS: Y or N.
IS_SCHEDULE_CREATION_ENABLED
STRING
Indicates if scheduled snapshot creation is enabled: Y or N.
IS_SCHEDULE_DELETION_ENABLED
STRING
Indicates if scheduled snapshot deletion is enabled: Y or N.
IS_SUBDIR_ACCESS_CIFS
STRING
Indicates if snapshot subdirectories are accessible via CIFS: Y or N.
IS_SUBDIR_ACCESS_LOCAL
STRING
Indicates if snapshot subdirectories are accessible via the local file system: Y or N.
IS_SUBDIR_ACCESS_NFS
STRING
Indicates if snapshot subdirectories are accessible via NFS: Y or N.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
LAST_UPDATED
DATE
The date and time the Isilon storage system data was last updated in the StorageConsole database.
NBR_OF_CHASSIS
NUMBER
Number of chassis associated with the cluster.
NBR_OF_CIFS_SHARES
NUMBER
Number of CIFS Shares associated with the cluster.
NBR_OF_CPUS
NUMBER
# CPUs across the entire cluster.
NBR_OF_DRIVE_BAYS
NUMBER
Number of drive bays associated with the cluster.
NBR_OF_FTPS
NUMBER
Number of FTP associated with the cluster.
NBR_OF_HDFS
NUMBER
Number of HDFS (Hadoop Distributed File Systems) associated with the cluster.
NBR_OF_NFS_EXPORTS
NUMBER
Number of NFS Exports associated with the cluster.
NBR_OF_NODES
NUMBER
Number of nodes associated with the cluster.
NBR_OF_SNAPSHOTS
NUMBER
Number of snapshots associated with the cluster.
OS_TYPE
STRING
The cluster operating system name.
SNAPSHOT_RESERVED_PCT
NUMBER
Percentage of the file system reserved for snapshots.
SNAPSHOT_USED_GB
NUMBER
Number of snapshot used in the cluster (GiB)
SNAPSHOT_USED_KB
NUMBER
Number of snapshots used in the cluster.
aps_v_isi_tier
The aps_v_isi_tier view contains a single row for each EMC Isilon Tier.
Table 4.117 aps_v_isi_tier
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CREATION_DATE
DATE
The date and time the Isilon tier data was created in the StorageConsole database.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
ISI_TIER_ID
NUMBER
Tier ID, for internal use by the StorageConsole database.
LAST_UPDATED
DATE
The date and time the Isilon tier data was last updated in the APTARE StorageConsole database.
TIER_NAME
STRING
Tier Name