Column Name | Data Type | Description |
allow_client_override | STRING | Y=Yes, N=No |
option_set_id | NUMBER | Foreign key of option set ID for TSM option set |
option_set_name | STRING | Option set name |
option_type | NUMBER | Option type |
option_value | STRING | Option value |
Column Name | Data Type | Description |
client_id | NUMBER | Foreign key to apt_v_server |
client_name | STRING | TSM client name |
instance_name | STRING | Server instance name |
modification_date | DATE | Modified date |
node_id | NUMBER | Foreign key to apt_v_tsm_node |
node_name | STRING | Node Name |
schedule_id | NUMBER | Foreign key to apt_v_tsm_client_schedule |
schedule_name | STRING | TSM schedule name |
server_instance_id | NUMBER | Foreign key to apt_v_server_instance |
Column Name | Data Type | Description |
day_of_week | NUMBER | Day of week |
description | STRING | Description |
domain_id | NUMBER | Domain ID |
domain_name | STRING | Domain Name |
duration_minutes | NUMBER | Duration in minutes |
expiration_date | DATE | Expiration date |
frequency | NUMBER | Frequency |
frequency_unit | NUMBER | Frequency unit |
is_active | STRING | Y=Yes, N=No |
last_updated | DATE | Last updated date |
objects | STRING | Objects |
options | STRING | Options |
priority | NUMBER | Priority |
schedule_action | STRING | Schedule action |
schedule_id | NUMBER | Unique ID of the TSM client schedule |
schedule_name | STRING | Schedule Name |
start_date | DATE | Start date |
Column Name | Data Type | Description |
copy_frequency | NUMBER | Copy frequency |
copy_group_id | NUMBER | Unique ID of the TSM copy group |
copy_group_name | STRING | Copy group name |
copy_group_type | CHAR | Copy group type |
copy_mode | CHAR | Copy mode |
copy_serialization | NUMBER | Copy serialization |
management_class_id | NUMBER | Foreign key of the management class ID for TSM management class |
management_class_name | STRING | Name of the management class |
retain_extra_versions | NUMBER | Retain extra versions |
retain_only_versions | NUMBER | Retain only versions |
storage_pool_id | NUMBER | TSM Storage Pool ID |
storage_pool_name | STRING | TSM Storage Pool name |
versions_data_deleted | NUMBER | Versions data deleted |
versions_data_exists | NUMBER | Versions data exists |
Column Name | Data Type | Description |
avail_space_mbytes | NUMBER | Available space in MB |
buffer_pool_pages | NUMBER | Buffer pool pages |
cache_hit_pct | NUMBER | Cache hit PCT |
cache_wait_pct | NUMBER | Cache wait PCT |
capacity_mbytes | NUMBER | Capacity in MB |
change_since_backup_mbytes | NUMBER | Change since backup |
incrementals_since_full | NUMBER | Incremental since full |
is_backup_running | CHAR | Is backup running? |
last_backup_date | DATE | Last Backup Date |
max_extension_mbytes | NUMBER | Maximum Extension MBytes |
max_reduction_mbytes | NUMBER | Maximum Reduction MBytes |
page_size_bytes | NUMBER | Page size in bytes |
pct_changed | NUMBER | PCT Changed |
physical_volumes | NUMBER | Physical Volumes |
server_id | NUMBER | Foreign key to apt_v_server. |
server_instance_id | NUMBER | Foreign key to apt_v_server_instance. |
total_buffer_requests | NUMBER | Total Buffer requests |
used_pages | NUMBER | Number of used pages |
Column Name | Data Type | Description |
avail_space_mbytes | NUMBER | Available Capacity in Mbytes |
cache_hit_pct | NUMBER | Cache Hit PCT |
cache_wait_pct | NUMBER | Cache Wait PCT |
capacity_mbytes | NUMBER | Capacity in MB |
log_date | DATE | Audit log date/time |
mac_extension_mbytes | NUMBER | Max Extension MBytes |
max_reduction_mbytes | NUMBER | Max Reduction MBytes |
page_size_bytes | NUMBER | Page size in bytes |
server_id | NUMBER | Foreign key to apt_v_server for the TSM Master server. |
server_instance_id | NUMBER | Foreign key to apt_v_server_instance. |
used_pages | NUMBER | Number of used pages |
Column Name | Data Type | Description |
access_type | STRING | R=read-only, W=read/write, N=unavailable, O=offsite, D=destroyed, U=unknown |
device_class_id | NUMBER | Device Class ID |
disk_media_id | NUMBER | Unique ID of the TSM media |
est_mbyte_capacity | NUMBER | Estimated MB capacity |
last_read_date | DATE | Last read date |
last_update_date | DATE | Last update date |
last_write_date | DATE | Last write date |
media_name | STRING | Media name |
media_status | STRING | O=online, F=offline, E=empty, P=pending, I=filling, L=full, U=unknown |
pct_reclaim | NUMBER | Percentage of the media that can be reclaimed |
pct_utilized | NUMBER | Percentage of the media that is in use |
read_errors | NUMBER | Number of read errors |
server_id | NUMBER | Foreign key to the host details |
server_instance_id | NUMBER | Server with which the directive is associated |
storage_pool_id | NUMBER | Storage Pool ID |
write_errors | NUMBER | Number of write errors |
Column Name | Data Type | Description |
access_type | STRING | How data is written to the device class |
device_class_id | NUMBER | Internally generated sequential ID that uniquely identifies the device class |
device_class_name | STRING | The name of the device class |
device_type | NUMBER | The device type of the device class |
directory | STRING | The directory or directories for a shared FILE device class |
drive_encryption | STRING | Indicates if drive encryption is permitted. This field applies only to volumes in a storage pool associated with a device type of 3592, LTO, or ECARTRIDGE |
est_max_mbytes | NUMBER | The estimated or maximum capacity of a volume associated with the device class |
is_shared | STRING | Whether this FILE device class will be shared between the server and one or more storage agents |
library_id | NUMBER | Foreign key reference to tape library |
max_idle_dismount_mins | NUMBER | The number of minutes to retain an idle sequential access volume before dismounting it |
max_mount_count | NUMBER | The maximum number of sequential access volumes that can be mounted concurrently or specifies that drives is the mount limit |
max_mount_wait_mins | NUMBER | The maximum number of minutes to wait for a sequential access volume to be mounted |
recording_format | STRING | The recording format |
retry_interval_secs | NUMBER | How often the retries are done within a given retry period |
retry_period_mins | NUMBER | The interval, in minutes, over which the server should attempt to contact a target server if communications failure is suspected |
server_id | NUMBER | Foreign key reference to host table |
server_instance_id | NUMBER | A pointer to the server instance to which the backup job belongs |
tape_volume_prefix | STRING | The high-level qualifier of the data set name that the server writes into the sequential access media labels |
Column Name | Data Type | Description |
drive_id | NUMBER | Foreign key to apt_v_tape_drive.This is an internal ID for the drive. |
drive_name | STRING | Drive name |
job_id | NUMBER | Foreign key to apt_v_tsm_job.This is an internal ID. |
media_date | DATE | Date/Time the event occurred |
media_name | STRING | Tape media name |
tape_media_id | NUMBER | Foreign key to apt_v_tape_media.This is an internal ID. |
Column Name | Data Type | Description |
drive_id | NUMBER | Foreign key to apt_v_tape_drive. This is an internal ID for the drive. |
drive_path | STRING | The path of the drive |
instance_name | STRING | Server instance name |
is_active | STRING | Y=Active, N=Inactive |
library_id | NUMBER | Foreign key to apt_v_tsm_tape_library |
path_status | STRING | Path Status |
server_instance_id | NUMBER | Foreign key to apt_v_server_instance |
Column Name | Data Type | Description |
backup_finish_date | DATE | The date the backup completed |
backup_start_date | DATE | The date the backup started |
capacity_kbytes | NUMBER | File space capacity in KiB |
deleted_date | DATE | The date the file space was deleted |
filespace_id | NUMBER | Foreign key to apt_v_tsm_filespace. |
filespace_name | STRING | Name of TSM file space that contains the data that was backed up |
filespace_type | STRING | The type that the server used to interpret the file space name: Server, UNIcode, FSID |
node_id | NUMBER | Foreign key to apt_v_tsm_node. |
node_name | STRING | Name of the TSM node |
pct_utilized | NUMBER | % of the file space that is occupied |
tsm_filespace_id | NUMBER | Numeric ID of the TSM file space |
Column Name | Data Type | Description |
date_first_used | DATE | First used date |
date_last_used | DATE | Last used date |
filespace_id | NUMBER | Filespace ID |
filespace_name | STRING | Filespace name |
fs_mgmt_class_usage_id | NUMBER | Primary key for this view |
instance_name | STRING | Name of the server instance |
last_updated | DATE | Last updated |
management_class_name | STRING | Management class name |
server_instance_id | NUMBER | Server Instance ID |
Column Name | Data Type | Description |
backup_type | NUMBER | Numeric code for the backup type |
client_id | NUMBER | Foreign key of the client ID for TSM client (see apt_v_server) |
client_name | STRING | Name of the client. |
data_transfer_secs | NUMBER | Rate of transfer to backup media |
domain_id | NUMBER | Foreign key to apt_v_tsm_policy_domain. |
domain_name | STRING | Domain name |
duration | STRING | Duration in Hour, Minute, Second format |
duration_secs | NUMBER | Duration in seconds |
finish_date | DATE | Date/time that the job completed |
idle_secs | NUMBER | Backup job idle time |
instance_name | STRING | Name of the TSM server instance |
is_active | STRING | Y=Yes, N=No |
job_bitflags | Raw | This is a bit field that can be “OR’ed” to represent the following bitwise variables: Bit 0 = Manually started job Bit 1 = Compressed backup job Bit 2 = DB compressed backup job Bit 3 = Encrypted backup job |
job_id | NUMBER | Foreign key to apt_v_tsm_job. Primary key in this view. This is the internal job ID, NOT the same as the TSM Job ID. |
job_type_name | STRING | Job type name. |
kilobytes | NUMBER | For backup jobs, this is the number of kilobytes in the backup. For restore jobs, this is the number of kilobytes restored |
mbytes_sec | NUMBER | MBytes per second |
media_type | STRING | D=Disk based backup, T=Tape based backup |
media_wait_secs | NUMBER | Media wait time |
nbr_examined_objects | NUMBER | Number of examined objects |
nbr_failed_objects | NUMBER | Number of failed objects |
nbr_of_files | NUMBER | Number of files affected by the TSM job |
node_id | NUMBER | Foreign key to apt_v_tsm_node for the node being backed up |
node_name | STRING | Name of the TSM node. |
product_type_name | STRING | Descriptive name of the backup product type |
result_code | NUMBER | Code returned from TSM backup process |
sched_start_date | DATE | For a backup job, this is the date/time that the job was scheduled to start |
schedule_id | NUMBER | Foreign key to apt_v_nbu_schedule for the TSM Schedule details. |
schedule_name | STRING | Name of the schedule |
server_id | NUMBER | Foreign key of the server ID for TSM Master server (see apt_v_server) |
server_instance_id | NUMBER | Foreign key to apt_v_server_instance, the internal StorageConsole server instance ID |
server_name | STRING | Name of the master server |
start_date | DATE | Date/time that the job started |
storage_pool_id | NUMBER | Foreign key to apt_v_tsm_storage_pool. |
summary_status | NUMBER | This is an enumeration field with the following values: 0 =successful 1 = partial / warning 2 = failed / error This field can be inspected to determine the overall summary status of a job. If the job was a backup and the summary status was 1 (partial), this is a result of TSM skipping some of the files in a backup |
vendor_state | NUMBER | Is the job currently running? Y=Yes, No=No |
vendor_status | NUMBER | Native TSM status code |
Column Name | Data Type | Description |
instance_name | STRING | Name of the TSM server instance |
job_id | NUMBER | Foreign key to apt_v_tsm_job. Primary key in this view. This is the internal job ID, NOT the same as the TSM Job ID. |
server_instance_id | NUMBER | Foreign key to apt_v_server_instance. Internal StorageConsole server instance ID |
Column Name | Data Type | Description |
explanation | STRING | Description that corresponds to the code. |
job_id | NUMBER | Foreign key to apt_v_tsm_job. Primary key in this view. This is the internal job ID, NOT the same as the TSM Job ID. |
message | STRING | The text indicating the status of the job. |
msg_code | STRING | The alphanumeric code of the message from the TSM log file. |
msg_date | DATE | Date/time of the message |
msg_type | STRING | Message type code |
seq | NUMBER | Sequence number of the message |
Column Name | Data Type | Description |
auto_migrate_days | NUMBER | Auto migrate days |
default_class | STRING | Default class |
description | STRING | Description |
domain_id | NUMBER | Domain ID |
domain_name | STRING | Domain Name |
last_updated | DATE | Last updated date |
management_class_id | NUMBER | Unique ID of the TSM management class |
management_class_name | STRING | Name of the management class |
migration_requires_backup | STRING | Y=Yes, N=No |
migration_storage_pool_id | NUMBER | Migration storage pool ID |
policy_set_id | NUMBER | Foreign key of the policy set ID for TSM policy set |
policy_set_name | STRING | Policy set name |
space_management_technique | NUMBER | Space management technique |
storage_pool_name | STRING | Storage pool name |
Column Name | Data Type | Description |
auto_rename_filespace | STRING | Y=Yes and N=No |
bitmask_flags | RAW | |
client_id | NUMBER | Foreign key of the client ID for the client being backed up (see apt_v_server) |
client_software_version | STRING | OS version on client |
client_type | STRING | Client Type |
compress_data | STRING | Y=Yes and N=No |
display_name | STRING | Display name of the client being backed up. |
domain_id | NUMBER | Foreign key to apt_v_tsm_policy_domain. |
domain_name | STRING | Domain name |
host_name | STRING | Internal name of the client being backed up. |
instance_name | STRING | Name of the TSM server instance |
is_active | CHAR | Indicates if this is an active TSM node |
last_access | DATE | Date and time of last access |
last_updated | DATE | Date and time last updated |
max_mount_points | NUMBER | Maximum number of mount points for this TSM node |
node_id | NUMBER | Foreign key to apt_v_tsm_node. |
node_registration_date | DATE | Date of the node registration |
node_name | STRING | Name of the TSM node. |
option_set_id | NUMBER | Numeric ID of the client’s option set. An option set enables additional client options that may not be included in the client’s standard option file. |
option_set_name | STRING | Name of the client’s option set |
server_instance_id | NUMBER | Foreign key to apt_v_server_instance, the Internal StorageConsole server instance ID |
Column Name | Data Type | Description |
client_id | NUMBER | Foreign key to apt_v_server for the TSM client. |
filespace_id | NUMBER | Foreign key to apt_v_tsm_filespace for the file system or directory path |
filespace_name | STRING | Full pathname of file space |
host_name | STRING | Name of the client. |
instance_name | STRING | Server instance name |
nbr_of_volumes | NUMBER | Number of volumes in the storage pool |
node_id | NUMBER | Foreign key to apt_v_tsm_node. |
node_name | STRING | Name of the TSM node |
poll_date | DATE | The date that data was collected |
server_instance_id | NUMBER | Foreign key to apt_server_instance |
stg_pool_phy_mbytes | NUMBER | The physical size of the storage pool |
storage_pool_id | NUMBER | Foreign key to apt_v_tsm_storage_pool. |
storage_pool_name | STRING | Name of storage pool |
volume_type | STRING | TSM volume type code |
Column Name | Data Type | Description |
activated_date | DATE | Activated date |
activated_policy_set_id | NUMBER | Activated policy set ID |
archive_retention_days | NUMBER | Archive retention days |
backup_retention_days | NUMBER | Backup retention days |
default_management_class_id | NUMBER | Default management class ID |
description | STRING | Description |
domain_id | NUMBER | Foreign key to apt_v_tsm_policy_domain. |
domain_name | STRING | Domain Name |
exists_in_catalog | STRING | Y=Yes, N=No |
management_class_name | STRING | Management class name |
server_id | NUMBER | Foreign key to apt_v_server for the TSM master server |
server_instance_id | NUMBER | Foreign key to apt_v_server_instance. The server with which the directive is associated. |
server_instance_name | STRING | Server instance name |
server_name | STRING | Name of the TSM master server |
Column Name | Data Type | Description |
default_management_class_id | NUMBER | Default management class ID |
description | STRING | Description |
domain_id | NUMBER | Domain ID |
domain_name | STRING | Domain name |
last_updated | DATE | Last updated date |
management_class_name | STRING | Management class name |
policy_set_id | NUMBER | Unique key of policy set |
policy_set_name | STRING | Policy set name |
Column Name | Data Type | Description |
log_date | DATE | Date the log entry was written |
server_instance_id | NUMBER | Foreign key to apt_v_server_instance. The server with which the directive is associated. |
server_instance_name | STRING | Name of the TSM server instance |
trans_type | NUMBER | 402 - TSM_SUMMARY_POLL_TRANS 403 - TSM_FILESPACE_POLL_TRANS 404 - TSM_VOLCONTENTS_POLL_TRANS 405 - TSM_ACTLOG_POLL_TRANS 406 - TSM_DB_POLL_TRANS 407 - TSM_DOMAIN_POLL_TRANS 408 - TSM_STGPOOL_POLL_TRANS 409 - TSM_TAPE_MEDIA_POLL_TRANS 410 - TSM_DISK_MEDIA_POLL_TRANS 411 - TSM_DRIVE_STATUS_POLL_TRANS 412 - TSM_CONSOLE_START_TRANS 413 - TSM_CONSOLE_FINISH_TRANS 414 - TSM_SAVE_NODE_TRANS 415 - TSM_START_SAVE_NODE_TRANS 416 - TSM_FINISH_SAVE_NODE_TRANS 417 - TSM_START_OCCUPANCY_TRANS 418 - TSM_FINISH_OCCUPANCY_TRANS 419 - TSM_START_DOMAIN_POLL_TRANS 420 - TSM_FINISH_DOMAIN_POLL_TRANS 421 - TSM_START_STGPOOL_POLL_TRANS 422 - TSM_FINISH_STGPOOL_POLL_TRANS |
trans_type_name | STRING | Description associated with the numeric transaction type code |
Column Name | Data Type | Description |
last_processed_date | DATE | Date of last poll |
server_id | NUMBER | Foreign key to apt_v_server for the TSM Master server. |
server_instance_id | NUMBER | Foreign key to apt_v_server_instance. The server with which the directive is associated. |
server_instance_name | STRING | Name of server instance |
server_name | STRING | Name of the master server |
trans_type | NUMBER | 402 - TSM_SUMMARY_POLL_TRANS 403 - TSM_FILESPACE_POLL_TRANS 404 - TSM_VOLCONTENTS_POLL_TRANS 405 - TSM_ACTLOG_POLL_TRANS 406 - TSM_DB_POLL_TRANS 407 - TSM_DOMAIN_POLL_TRANS 408 - TSM_STGPOOL_POLL_TRANS 409 - TSM_TAPE_MEDIA_POLL_TRANS 410 - TSM_DISK_MEDIA_POLL_TRANS 411 -TSM_DRIVE_STATUS_POLL_TRANS 412 - TSM_CONSOLE_START_TRANS 413 - TSM_CONSOLE_FINISH_TRANS 414 - TSM_SAVE_NODE_TRANS 415 - TSM_START_SAVE_NODE_TRANS 416 - TSM_FINISH_SAVE_NODE_TRANS 417 - TSM_START_OCCUPANCY_TRANS 418 - TSM_FINISH_OCCUPANCY_TRANS 419 - TSM_START_DOMAIN_POLL_TRANS 420 - TSM_FINISH_DOMAIN_POLL_TRANS 421 TSM_START_STGPOOL_POLL_TRANS 422 TSM_FINISH_STGPOOL_POLL_TRANS |
trans_type_name | STRING | Description associated with the numeric transaction type, as shown above |
Column Name | Data Type | Description |
destination_stg_pool | STRING | Name of the destination TSM storage pool |
duration | STRING | Duration |
duration_secs | NUMBER | Duration in seconds |
finish_date | DATE | Date/time that the job completed |
idle_secs | NUMBER | Process idle time |
instance_name | STRING | Name of the TSM server instance |
is_active | STRING | Is the job currently running? Y=Yes, N=No |
job_bitflags | Raw | This is a bit field that can be “OR’ed” to represent the following bitwise variables: Bit 0 = Manually started job Bit 1 = Compressed backup job Bit 2 = DB compressed backup job Bit 3 = Encrypted backup job |
job_id | NUMBER | Foreign key to apt_v_tsm_job. Primary key in this view. This is the internal job ID, NOT the same as the TSM Job ID. |
job_type_name | STRING | Job type name |
kilobytes | NUMBER | For backup jobs, this is the number of kilobytes in the backup. For restore jobs, this is the number of kilobytes restored |
mbytes_sec | NUMBER | Megabytes per second |
media_type | STRING | D=Disk-based backup, T=Tape-based backup |
media_wait_secs | NUMBER | Media wait time |
nbr_examined_objects | NUMBER | Number of examined objects |
nbr_failed_objects | NUMBER | Number of failed objects |
nbr_of_files | NUMBER | Number of files affected by the TSM job |
nbr_of_processes | NUMBER | Number of TSM backup processes |
process_type_name | STRING | Process type name |
server_id | NUMBER | Foreign key to apt_v_server of the TSM Master server. |
server_instance_id | NUMBER | Foreign key to apt_v_server_instance. The server with which the directive is associated. |
server_name | STRING | Name of the master server |
source_stg_pool | STRING | Name of the source TSM storage pool |
start_date | DATE | Date/time that the job started |
summary_status | NUMBER | This is an enumeration field with the following values: 0 =successful 1 = partial / warning 2 = failed / error This field can be inspected to determine the overall summary status of a job. If the job was a backup and the summary status was 1 (partial), this is a result of TSM skipping some of the files in a backup |
vendor_state | NUMBER | Is the job currently running? Y=Yes, No=No |
vendor_status | NUMBER | Native TSM status code |
Column Name | Data Type | Description |
avail_space_mbytes | NUMBER | Available space in MBytes |
capacity_mbytes | NUMBER | Capacity in MBytes |
page_size_bytes | NUMBER | Page size in Bytes |
server_instance_id | NUMBER | Foreign key to the server instance |
used_pages | NUMBER | Number of used pages |
Column Name | Data Type | Description |
avail_space_mbytes | NUMBER | Available space in MBytes |
capacity_mbytes | NUMBER | Capacity in MBytes |
log_date | DATE | Date/time of Audit Log entry |
page_size_bytes | NUMBER | Page size in Bytes |
server_instance_id | NUMBER | Foreign key to the server instance |
used_pages | NUMBER | Number of used pages |
Column Name | Data Type | Description |
client_id | NUMBER | Foreign key of the client ID for TSM client |
client_name | STRING | Name of the client |
data_transfer_secs | NUMBER | Data transfer rate in seconds |
duration | STRING | Duration in Hour, Minute, Second |
duration_secs | NUMBER | Duration in seconds |
finish_date | DATE | Date/time that the job completed |
instance_name | STRING | Instance name |
is_active | STRING | Y=Yes, N=No |
job_bitflags | RAW | This is a bit field that can be OR-ed to represent the following bit-wise variables: Bit 0 = Manually started job Bit 1 = Compressed backup job Bit 2 = DB compressed backup job Bit 3 = Encrypted backup job |
job_id | NUMBER | Unique job ID. Primary key in this view. This is the internal job ID and NOT the same as the TSM Job ID |
job_type_name | STRING | Job type name |
kilobytes | NUMBER | For backup jobs, this is the number of kilobytes in the backup. For restore jobs, this is the number of kilobytes restored. |
media_type | STRING | D=Disk based backup, T=Tape based backup |
nbr_of_files | NUMBER | Number of files affected by the TSM job |
nbr_of_files_skipped | NUMBER | Number of files skipped while restoring |
node_id | STRING | Node ID |
node_name | STRING | Node name |
parent_session_ID | NUMBER | Parent session ID |
product_type_name | STRING | Name of the backup product |
server_id | NUMBER | Foreign key of the server ID for TSM Master server |
server_instance_ID | NUMBER | Server the directive is associated with. Foreign key to apt_v_server_instance |
server_name | STRING | Name of the master server |
session_ID | NUMBER | Session ID |
start_date | DATE | Date/time that the job started |
summary_status | NUMBER | This is an enumeration field with the following values: 0 = successful 1 = partial / warning 2 = failed / error This field can be inspected to determine the overall summary status of a job. If the job was a backup and the summary status was 1 (partial), this is a result of TSM skipping some of the files in a backup |
vendor_state | NUMBER | Is the job currently running? Y=Yes, N=No |
vendor_status | NUMBER | Native TSM status code |
Column Name | Data Type | Description |
instance_name | STRING | Instance name |
log_time | DATE | Audit log date and time |
logical_group_id | NUMBER | Storage Pool ID |
nbr_of_tapes | NUMBER | Number of tapes |
owner_instance_id | NUMBER | Owner instance ID |
owner_instance_name | STRING | Owner instance name |
primary_library_manager_id | NUMBER | Key to the primary library manager |
primary_library_manager_name | STRING | Primary library manager name |
server_instance_id | NUMBER | Foreign key of the server instance ID for the TSM server (see apt_v_server_instance) |
vendor_media_type | NUMBER | Codes for the media type (specific to backup product) |
Column Name | Data Type | Description |
instance_name | STRING | Server instance name |
is_active | STRING | Y=Yes, N=No |
job_id | NUMBER | Foreign key to apt_v_tsm_job. Unique job ID. Primary key in this view. This is the StorageConsole internal job ID and NOT the same as the TSM Job ID. |
kilobytes_recd | NUMBER | Number of kilobytes received during the session. |
kilobytes_send | NUMBER | Number of kilobytes sent during the session |
node_id | NUMBER | Foreign key to apt_v_tsm_node. |
node_session_id | NUMBER | Numeric identifier of the node for the session |
server_instance_id | NUMBER | Foreign key to apt_v_server_instance |
session_id | NUMBER | Numeric identifier of the session |
session_state | NUMBER | Current state of the session |
session_state_name | STRING | Possible values: UnKnown, Starting, Ending, Running, Idle Wait, Media Wait, Rec Wait, Send Wait |
start_date | DATE | Date the session started |
wait_time_secs | NUMBER | Wait time |
Column Name | Data Type | Description |
client_id | NUMBER | Foreign key to apt_v_server for the client ID for the client being backed up. |
copy_type | STRING | TSM copy type code |
filespace_id | NUMBER | Foreign key to apt_v_tsm_filespace. |
stg_pool_files | NUMBER | The number of storage pool files |
stg_pool_log_kbytes | NUMBER | Size of the storage pool log file |
stg_pool_phy_kbytes | NUMBER | Amount of physical storage pool space used by this item. |
stgpool_item_id | NUMBER | ID of the item using storage pool space. |
storage_pool_id | NUMBER | Foreign key to apt_v_tsm_storage_pool. |
Column Name | Data Type | Description |
cache_migrated_files | STRING | Cache enabled indicator: Y or N |
class_type | STRING | Class type |
collocate | STRING | Co-location enabled indicator: Y or N |
continue_copy_on_error | STRING | Continue copy indicator: Y or N |
continue_migration | STRING | Continue indicator: Y or N |
crc_data_checking | STRING | Cyclic redundancy checking enabled: Y or N |
data_format | STRING | Format of the data |
days_before_volume_reuse | NUMBER | Number of days (after all files have been deleted) before a volume can be rewritten or placed back into the scratch pool |
description | STRING | Description of the storage pool |
device_class_id | NUMBER | The device class assigned for the storage pool |
device_class_name | STRING | Name of the device class |
drive_encryption | STRING | Drive encryption from device class |
est_mbyte_capacity | NUMBER | Estimated storage pool capacity |
exists_in_catalog | STRING | Flag indicates that the pool exists in the catalog |
high_migration_percentage | NUMBER | Percentage of storage pool occupancy, when the server will migrate files to the next storage pool |
host_name | STRING | Name displayed in reports |
instance_name | STRING | Name of the instance |
is_migration_running | STRING | Status of migration: Y or N |
low_migration_percentage | NUMBER | Percentage when the migration will cease |
max_scratch_volumes | NUMBER | Maximum number of scratch volumes defined for the storage pool |
max_size_mbytes | NUMBER | Maximum file size allowed Certain special cases are handled as follows: If TSM returns an empty MAXSIZE value, StorageConsole stores it as 0 If TSM returns NOLIMIT, StorageConsole stores it as 999999999999999999 |
media_access_type | STRING | read/write, read-only, or unavailable |
migrated_pct | STRING | Migration percentage |
migration_delay_days | NUMBER | Minimum number of days that migration can be delayed |
migration_processes | NUMBER | The number of migration processes used for migrating files from this storage pool |
next_storage_pool_id | NUMBER | Foreign key to apt_v_tsm_storage_pool for the ID of the next storage pool in the storage pool hierarchy, where data will be stored |
next_storage_pool_name | NUMBER | Name of the next storage pool in the storage pool hierarchy, where data will be stored |
overflow_location | STRING | Name of the location of volumes that were ejected from an automated or external library |
reclaim_storage_pool_id | NUMBER | Foreign key to apt_v_tsm_storage_pool for the ID of the storage pool used for data from volumes that are reclaimed in this pool |
reclaim_storage_pool_name | STRING | Name of the storage pool used for data from volumes that are reclaimed in this storage pool. Used for storage pools where the device class has only one mount point. |
reclamation_threshold | NUMBER | Percentage of reclaimable space on a volume before the server begins reclaiming space for the volume |
server_id | NUMBER | Foreign key to apt_v_server. |
storage_pool_id | NUMBER | Foreign key to apt_v_tsm_storage_pool. |
storage_pool_name | STRING | Storage pool name |
storage_pool_type | STRING | Primary or Copy |
utilization_pct | NUMBER | Utilization percentage |
Column Name | Data Type | Description |
est_mbyte_capacity | NUMBER | Estimated megabyte capacity. |
host_name | STRING | Host name for the server_id. |
instance_name | STRING | Name of the TSM instance. |
log_date | DATE | Log date for TSM storage pool. |
max_size_mbytes | NUMBER | Maximum megabyte capacity size. |
server_id | NUMBER | Foreign key of the server ID for the master server. |
storage_pool_id | NUMBER | Storage pool id. |
storage_pool_name | STRING | Name of the TSM storage pool. |
utilization_pct | NUMBER | Percentage utilization. |
Column Name | Data Type | Description |
ACS_ID | NUMBER | ACS ID |
CONTROLLING_SERVER | STRING | Media server name that is controlling the library |
CONTROLLING_SERVER_ID | NUMBER | Foreign key to apt_v_server for the media server that is controlling the library |
DESCRIPTION | STRING | Description of the library |
DEVICE_NAME | STRING | Device name that controls the tape library |
EXTERNAL_LIBRARY_MANAGER | STRING | External library manager name |
EXTERNAL_MANAGER_ID | NUMBER | Foreign key to apt_v_server for the external library manager |
IS_LANFREE | STRING | Is Lan-free: Y or N |
IS_ONLINE | STRING | Is the library online: Y or N |
IS_SHARED | STRING | Is library shared: Y or N |
LIBRARY_ID | NUMBER | Foreign key to apt_v_tsm_tape_library. |
LIBRARY_NAME | STRING | Custom name that can be assigned to the library |
LIBRARY_TYPE | STRING | Library type name |
MEDIA_CAPACITY | NUMBER | Total number of tapes loaded in the tape library as of last data collection |
NBR_OF_DRIVES | NUMBER | Number of tape drives within the tape library |
OBEY_MOUNT_RETENTION | STRING | Should the library obey retention mount: Y or N |
PRIMARY_LIBRARY_MANAGER | STRING | Primary library manager name |
PRIMARY_LIBRARY_MANAGER_ID | NUMBER | Foreign key to apt_v_server for the primary library manager |
PRIVATE_CATEGORY | NUMBER | Private category |
SCRATCH_CATEGORY | NUMBER | Scratch category |
SERIAL_NBR | STRING | Serial number of the tape library |
SERVER_ID | NUMBER | Foreign key to apt_v_server for the server with which this library is associated |
SERVER_INSTANCE_ID | NUMBER | Foreign key to apt_v_server_instance for the TSM library instance |
SERVER_INSTANCE_NAME | STRING | Name of the TSM server instance |
SERVER_NAME | STRING | Server with which the library is associated |
VENDOR_LIBRARY_NBR | NUMBER |
Column Name | Data Type | Description |
access_type | STRING | Access type |
cleanings_left | NUMBER | Number of cleanings left |
est_mbyte_capacity | NUMBER | Estimated capacity in MB |
instance_name | STRING | Instance name |
is_error_state | STRING | Indicates if the tape is in an error state |
is_scratch | STRING | Indicates if this is a scratch tape |
last_read_date | DATE | Date the tape was last read |
last_update_date | DATE | Date the tape was last updated |
last_updated | DATE | Date the data collection database was updated |
last_write_date | DATE | Date the tape last had write access |
library_id | NUMBER | Foreign key to apt_v_tape_library view. |
library_name | STRING | Library name |
library_slot_nbr | NUMBER | Library slot number |
location | STRING | Location of the tape |
media_name | STRING | Media name |
media_state | STRING | Media state |
media_status_name | STRING | Media status |
media_type_name | STRING | Media type |
mount_count | NUMBER | Mount count |
owner_instance_id | NUMBER | Owner instance ID |
pct_reclaim | NUMBER | Reclaimed percentage |
pct_utilized | NUMBER | Utilized percentage |
read_errors | NUMBER | Number of read errors |
server_host_name | STRING | Server host name |
server_id | NUMBER | Foreign key to apt_v_server |
server_instance_ID | NUMBER | Foreign key to apt_v_server_instance |
storage_pool_id | NUMBER | Foreign key to apt_v_tsm_storage_pool |
storage_pool_name | STRING | Storage pool name |
tape_media_id | NUMBER | Primary key for this view |
volume_type | STRING | Volume type |
write_errors | NUMBER | Number of write errors |
write_pass | NUMBER | Write pass |
Column Name | Data Type | Description |
client_id | NUMBER | Foreign key to apt_v_server for the client ID for the client being backed up |
copy_type | STRING | TSM copy type code |
filespace_id | NUMBER | Foreign key to apt_v_tsm_filespace for the file system or directory path |
storage_pool_id | NUMBER | Foreign key to apt_v_tsm_storage_pool. |
volume_id | NUMBER | Numeric volume ID |
volume_item_id | NUMBER | Numeric volume item ID |
volume_type | STRING | 1 = BACKUPFULL 2 = BACKUPINCR 3 = DBDUMP 4 = EXPORT 5 = RPFILE Recovery plan file object volume 6 = STGDELETE Deleted sequential access storage pool volume 7 = STGNEW Added sequential access storage pool volume 8 = STGREUSE Reused sequential access storage pool volume |