Capacity Manager Database Views > EMC Isilon Array Database Views
  
Version 10.1.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 81 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 82 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 83 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 84 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 85 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 86 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.
is_usage_exact
STRING
Indicates whether the usage is an exact value or an “at least” value: Y or Null.
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.
isi_zone_id
NUMBER
Zone ID, for internal use by the 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.
nbr_of_FIles_dirs
NUMBER
Combined count of files and directories of all paths in the NFS export.
usage_with_overhead_kb
NUMBER
Combined used capacity (in KiB) of all paths in the export (including OneFS overhead).
usage_without_overhead_kb
NUMBER
Combined used capacity (in KiB) of all paths in the export (not including OneFS overhead).
zone_name
STRING
Zone name.
aps_v_isi_cifs_share_log
The aps_v_isi_cifs_share_log view contains a single row for each EMC Isilon CIFS Share log.
Table 87 aps_v_isi_cifs_share_log
Column Name
Data Type
Description
CIFS_SHARE_NAME
STRING
Name of the share.
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.
log_date
DATE
The date and time the Isilon CIFS Log data was created in the database.
usage_with_overhead_gb
NUMBER
Combined used capacity (in GiB) of all paths in the export (including OneFS overhead).
usage_with_overhead_kb
NUMBER
Combined used capacity (in KiB) of all paths in the export (including OneFS overhead).
usage_without_overhead_gb
NUMBER
Combined used capacity (in GiB) of all paths in the export (not including OneFS overhead).
usage_without_overhead_kb
NUMBER
Combined used capacity (in KiB) of all paths in the export (not including OneFS overhead).
aps_v_isi_disk
The aps_v_isi_disk view contains a single row for each EMC Isilon Disk.
Table 88 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 89 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 90 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 91 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 92 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 93 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 94 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 95 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_rack
The aps_v_isi_hdfs_rack view contains a single row for each EMC Isilon HDFS rack.
Table 96 aps_v_isi_hdfs_rack
Column Name
Data Type
Description
address_pools
STRING
IP pools assigned to the rack.
ARRAY_NAME
STRING
Array name.
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.
HDSF_Rack_name
STRING
Hadoop (HDFS) rack name.
ISI_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
isi_ZONe_id
NUMBER
Zone ID, for internal use by the database.
LAST_UPDATED
DATE
The date and time the Isilon Hadoop Distributed File System (HDFS) was last updated in the StorageConsole database.
zone_name
STRING
Name of the Isilon zone.
aps_v_isi_hdsf_root
The aps_v_isi_hdfs_root view contains a single row for each EMC Isilon HDFS root.
Table 97 aps_v_isi_hdfs_root
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
AUTHENTICATION
STRING
Authentication method.
BLOCK_SIZE_KB
NUMBER
Hadoop block size (KiB).
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
HDSF_ROOT_PATH
STRING
Hadoop (HDFS) root path in the file system.
is_usage_exact
STRING
Indicates whether the usage is an exact value or an “at least” value: Y or Null.
is_web_hdfs_enabled
CHAR
Whether web HDFS is enabled or not: Y/N.
isi_hdfs_root_id
NUMBER
HDFS root ID, for internal use by the 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.
isi_ZONe_id
NUMBER
Zone ID, for internal use by the 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_FIles_dirs
NUMBER
Combined count of files and directories of all paths in the NFS export.
NBR_OF_THREADS
NUMBER
Number of threads for Hadoop Distributed File System (HDFS) processing.
usage_with_overhead_gb
NUMBER
Combined used capacity (in GiB) of all paths in the export (including OneFS overhead).
usage_with_overhead_kb
NUMBER
Combined used capacity (in KiB) of all paths in the export (including OneFS overhead).
usage_without_overhead_gb
NUMBER
Combined used capacity (in GiB) of all paths in the export (not including OneFS overhead).
usage_without_overhead_kb
NUMBER
Combined used capacity (in KiB) of all paths in the export (not including OneFS overhead).
VERSION_SUPPORTED
STRING
Hadoop version supported.
zone_name
STRING
Name of the Isilon zone.
aps_v_isi_hdsf_root_log
The aps_v_isi_hdfs_root_log view contains a single row for each EMC Isilon HDFS root log entry.
Table 98 aps_v_isi_hdfs_root_log
Column Name
Data Type
Description
isi_hdfs_root_id
NUMBER
HDFS Root ID, for internal use by the 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.
log_date
DATE
The date and time the Isilon HDFS log data was created in the database.
usage_with_overhead_gb
NUMBER
Combined used capacity (in GiB) of all paths in the export (including OneFS overhead).
usage_with_overhead_kb
NUMBER
Combined used capacity (in KiB) of all paths in the export (including OneFS overhead).
usage_without_overhead_gb
NUMBER
Combined used capacity (in GiB) of all paths in the export (not including OneFS overhead).
usage_without_overhead_kb
NUMBER
Combined used capacity (in KiB) of all paths in the export (not including OneFS overhead).
aps_v_isi_license
The aps_v_isi_license view contains a single row for each EMC Isilon License.
Table 99 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 100 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 101 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.
is_usage_exact
STRING
Indicates whether the usage is an exact value or an “at least” value: Y or Null.
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.
isi_zone_id
NUMBER
Zone ID, for internal use by the 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_FIles_dirs
NUMBER
Combined count of files and directories of all paths in the 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.
usage_with_overhead_kb
NUMBER
Combined used capacity (in KiB) of all paths in the export (including OneFS overhead).
usage_without_overhead_kb
NUMBER
Combined used capacity (in KiB) of all paths in the export (not including OneFS overhead).
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.
zone_name
STRING
Zone name.
aps_v_isi_nfs_export_log
The aps_v_isi_nfs_export_log view contains a single row for each EMC Isilon NFS Export log.
Table 102 aps_v_isi_nfs_export_log
Column Name
Data Type
Description
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
The date and time the Isilon NFS export Log data was created in the database.
NFS_EXPORT_ID
NUMBER
The NFS Export ID.
usage_with_overhead_gb
NUMBER
Combined used capacity (in GiB) of all paths in the export (including OneFS overhead).
usage_with_overhead_kb
NUMBER
Combined used capacity (in KiB) of all paths in the export (including OneFS overhead).
usage_without_overhead_gb
NUMBER
Combined used capacity (in GiB) of all paths in the export (not including OneFS overhead).
usage_without_overhead_kb
NUMBER
Combined used capacity (in KiB) of all paths in the export (not including OneFS overhead).
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 103 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 104 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 105 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 106 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 107 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 108 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 109 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