Backup Manager Database Views > Detailed View Descriptions (TSM)
  
Version 9.2.01
Detailed View Descriptions (TSM)
apt_v_tsm_client_option
The apt_v_tsm_client_option view contains a single row for each TSM client option.
Table 3.141 apt_v_tsm_client_option
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
apt_v_tsm_client_association
The apt_v_tsm_client_association view contains a single row for each TSM client association.
Table 3.142 apt_v_tsm_client_association
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
schedule_name
STRING
TSM schedule name
server_instance_id
NUMBER
Foreign key to apt_v_server_instance
apt_v_tsm_client_schedule
The apt_v_tsm_client_schedule view contains a single row for each TSM client schedule.
Table 3.143 apt_v_tsm_client_schedule
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
apt_v_tsm_copy_group
The apt_v_tsm_copy_group view contains a single row for each TSM copy group.
Table 3.144 apt_v_tsm_copy_group
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
apt_v_tsm_database
The apt_v_tsm_database view provides details about the TSM backup database.
Table 3.145 apt_v_tsm_database
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
apt_v_tsm_database_log
The apt_v_tsm_database_log view provides details about the TSM backup database log.
Table 3.146 apt_v_tsm_database_log
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
apt_v_tsm_disk_media
The apt_v_tsm_disk_media view contains a single row for each TSM disk media.
Table 3.147 apt_v_tsm_disk_media
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
apt_v_tsm_device_class
The apt_v_tsm_device_class view contains a single row for each TSM device class.
Table 3.148 apt_v_tsm_device_class
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
apt_v_tsm_drive_media_log
The apt_v_tsm_drive_media_log view contains a single row for each TSM job/tape/drive contents.
Table 3.149 apt_v_tsm_drive_media_log
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.
apt_v_tsm_drive_srvrinst
The apt_v_tsm_drive_srvrinst view contains a single row for each TSM drive path.
Table 3.150 apt_v_tsm_drive_srvrinst
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
apt_v_tsm_filespace
The apt_v_tsm_filespace view provides details about TSM file spaces.
Table 3.151 apt_v_tsm_filespace
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
apt_v_tsm_fs_mgmt_class_usage
The apt_v_tsm_fs_mgmt_class_usage view provides details about filesystem management class usage.
Table 3.152 apt_v_tsm_fs_mgmt_class_usage
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
apt_v_tsm_job
The apt_v_tsm_job view provides details for the TSM backup jobs.
Table 3.153 apt_v_tsm_job
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
apt_v_tsm_job_instance
The apt_v_tsm_job_instance view provides descriptions of TSM instances.
Table 3.154 apt_v_tsm_job_instance
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
apt_v_tsm_job_message
The apt_v_tsm_job_message view provides the particulars from TSM job messages.
Table 3.155 apt_v_tsm_job_message
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
apt_v_tsm_management_class
The apt_v_tsm_management_class view contains a single row for each TSM management class.
Table 3.156 apt_v_tsm_management_class
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
apt_v_tsm_node
The apt_v_tsm_node view provides details about TSM nodes.
Table 3.157 apt_v_tsm_node
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_system_architecture
STRING
System architecture of the node's client.
client_type
STRING
Client Type
compress_data
STRING
Y=Yes and N=No
contact
STRING
Contact information for the client node.
deduplication
STRING
Location where data is deduplicated.
Possible values:
ServerOnly = data stored by this node can be deduplicated on the server only.
Clientorserver = data stored by this node can be deduplicated on either the client of the server.
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
guid
STRING
Globally unique identifier (GUID) that identifies the host on which the node is located. Based on the last time the client node contacted the server.
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
is_locked
STRING
Indicates if the client node is locked out of Tivoli Storage Manager (TSM): Y or N.
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_name
STRING
Name of the TSM node.
node_registration_date
DATE
Date of the node registration
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
registering_admin
STRING
The name of the administrator who registered the client node.
repl_archive_rule
STRING
Sets a replication rule that determines replication of archive data in the file space.
Possible values:
ALL_DATA = all data is replicated with normal priority.
ALL_DATA_HIGH_PRIORITY = all data is replicate with high priority.
DEFAULT = data is replicated according to the domain rule for the data type.
NONE = no data that belongs to the node is replicated.
repl_backup_rule
STRING
Sets a replication rule that determines replication of backup data in the file space.
Possible values:
ALL_DATA = all data is replicated with normal priority.
ACTIVE_DATA = active backup data is replicated with normal priority.
ALL_DATA_HIGH_PRIORITY = all data is replicate with high priority.
ACTIVE_DATA_HIGH_PRIORITY = active backup data is replicated with high priority.
DEFAULT = data is replicated according to the domain rule for the data type.
NONE = no data that belongs to the node is replicated.
repl_space_mgmt_rule
STRING
Sets a replication rule that determines replication of space-managed data in the file space.
Possible values:
ALL_DATA = all data is replicated with normal priority.
ALL_DATA_HIGH_PRIORITY = all data is replicate with high priority.
DEFAULT = data is replicated according to the domain rule for the data type.
NONE = no data that belongs to the node is replicated.
replication_mode
STRING
Indicates if the node is the source or the target for replicated data. Possible values:
Send = node is the source of data for replication.
Receive = node is the target of data for replication.
SyncSend = during replication, data that belongs to the node is to be synchronized with the node data on the target replication server; applies only to nodes whose data was imported from a source replication server to the target replication server.
SyncReceive = during replication, data that belongs to the node is to be synchronized with the node data on the source replication server; applies only to nodes whose data was imported from a source replication server to the target replication server.
None = node is not configured for replication.
replication_state
STRING
Indicates if the node is enabled for replication.
Possible values:
Enabled = node is configured for replication and is ready to replicate.
Disabled = node is configured for replication, but is not ready to replicate.
None = node is not configured for replication.
server_instance_id
NUMBER
Foreign key to apt_v_server_instance, the Internal StorageConsole server instance ID
apt_v_tsm_occupancy_log
The apt_v_tsm_occupancy_log view provides information from the TSM occupancy logs.
Table 3.158 apt_v_tsm_occupancy_log
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
apt_v_tsm_policy_domain
The apt_v_tsm_policy_domain view provides information from the TSM policy domains.
Table 3.159 apt_v_tsm_policy_domain
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
apt_v_tsm_policy_set
The apt_v_tsm_policy_set view contains a single row for each TSM policy set.
Table 3.160 apt_v_tsm_policy_set
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
apt_v_tsm_poll_date_audit
The apt_v_tsm_poll_date_audit view provides details about the TSM poll audit.
Table 3.161 apt_v_tsm_poll_date_audit
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
apt_v_tsm_poll_date_log
The apt_v_tsm_poll_date_log view provides TSM log message details.
Table 3.162 apt_v_tsm_poll_date_log
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
apt_v_tsm_process
The apt_v_tsm_process view provides details about TSM processes.
Table 3.163 apt_v_tsm_process
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
apt_v_tsm_recovery_log
The apt_v_tsm_recovery_log view provides details about TSM recovery log entries.
Table 3.164 apt_v_tsm_recovery_log
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
apt_v_tsm_recovery_aud
The apt_v_tsm_recovery_aud view provides details about TSM recovery audit log details.
Table 3.165 apt_v_tsm_recovery_aud
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
apt_v_tsm_restore_job
The apt_v_tsm_restore_job view provides details about TSM restore jobs.
Table 3.166 apt_v_tsm_restore_job
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
apt_v_tsm_scratch_tape_log
The apt_v_tsm_scratch_tape_log view contains a single row for each TSM scratch tape audit log.
Table 3.167 apt_v_tsm_scratch_tape_log
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)
apt_v_tsm_session
The apt_v_tsm_session view provides TSM session details.
Table 3.168 apt_v_tsm_session
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
apt_v_tsm_stgpool_contents
The apt_v_tsm_stgpool_contents view provides details for TSM storage pool contents.
Table 3.169 apt_v_tsm_stgpool_contents
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.
apt_v_tsm_storage_pool
The apt_v_tsm_storage_pool view provides TSM storage pool details.
Table 3.170 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
apt_v_tsm_storage_pool_log
The apt_v_tsm_storage_pool_log view contains a single row for each storage pool.
Table 3.171 apt_v_tsm_storage_pool_log
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.
apt_v_tsm_tape_library
The apt_v_tsm_tape_library view provides TSM tape library details.
Table 3.172 apt_v_tsm_tape_library
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
 
apt_v_tsm_tape_media
The apt_v_tsm_tape_media view provides access to TSM backup tape details.
Table 3.173 apt_v_tsm_tape_media
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
apt_v_tsm_volume_contents
The apt_v_tsm_volume_contents view provides details about TSM volume contents.
Table 3.174 apt_v_tsm_volume_contents
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