Detailed View Descriptions (TSM) Version 9.2.00

Table 3.137 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

Table 3.138 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

Table 3.139 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

Table 3.140 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

Table 3.141 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

Table 3.142 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

Table 3.143 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.

Table 3.144 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

Table 3.145 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

Table 3.146 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

Table 3.147 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

Table 3.148 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

Table 3.149 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

Table 3.150 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

Table 3.151 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_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

Table 3.152 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

Table 3.153 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

Table 3.154 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

Table 3.155 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

Table 3.156 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

Table 3.157 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

Table 3.158 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

Table 3.159 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

Table 3.160 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

Table 3.161 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)

Table 3.162 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

Table 3.163 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.

Table 3.164 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

Table 3.165 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.

Table 3.166 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

Table 3.167 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

Table 3.168 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