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