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 Storage Viewer 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 |