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