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

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

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

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

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

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

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

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

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.

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

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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

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)

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

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.

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

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.

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

 

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

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