backup_id

STRING

Veritas NetBackup Backup ID. This is sometimes referred to as the “image ID”. This is the unique backup identified that has the format <client_name>_<timestamp>

client_host_name

STRING

The host name associated with the ID

client_id

NUMBER

Foreign key to apt_v_server for the backup client.

expiration_date

DATE

For backup jobs, this is the date/time when the underlying Veritas NetBackup image will expire

finish_date

DATE

Date/time that the job completed

finished_readwrite

DATE

Date/time that the job try finished read/write.

is_active

CHAR

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_nbu_job.

This is the Hitachi Storage Viewer internal job ID and NOT the same as the NetBackup Job ID.

job_type

NUMBER

Enumeration field with the following possible values:

101 = Full backup

102 = Incremental backup

103 = Catalog backup

104 = Archive

105 = Restore

106 = Verification

107 = Duplicate

108 = Import

109 = Migration

110 = Label

111 = Media Erase

112 = Application backup

199 = Other

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

last_activity_date

DATE

The last activity date of the job

master_host_name

STRING

Name of the master server

media_host_name

STRING

Name of the media server

media_server_id

NUMBER

Foreign key to apt_v_server for the media server.

media_type

CHAR

D=Disk based backup, T=Tape based backup

nbr_of_copies

NUMBER

For NetBackup backup jobs, this field contains the number of copies that were made of the backup

nbr_of_files

NUMBER

Number of files affected by the backup job

nbu_job_id

NUMBER

Veritas NetBackup Job ID

parent_nbu_job_id

NUMBER

Foreign key to apt_v_nbu_policy_file_log.

policy_id

NUMBER

Foreign key to apt_v_nbu_policy.

policy_name

STRING

Name associated with the NetBackup policy ID

policy_type_name

STRING

Native NetBackup policy type.

product_type_name

STRING

Name of the backup product type

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.

schedule_name

STRING

Name of the schedule

schedule_type_name

STRING

Name of the schedule type

server_id

NUMBER

Foreign key to apt_v_server.

start_date

DATE

Date/time that the job started

started_readwrite

DATE

Date/time that the job try started read/write.

storage_unit_id

NUMBER

Foreign key to apt_v_nbu_storage_unit.

storage_unit_label

STRING

Label for the storage unit

stream_index

NUMBER

Stream index for multi-streaming jobs. This column is normally 0 for non-multi-streaming jobs

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 the backup skipping some of the files in a backup

summary_try_status

NUMBER

Calculated value

target_client_id

NUMBER

Foreign key to apt_v_server for the target client.

This field should only be used for restore jobs and contains the target client for a restore (i.e., Destination client). The client_id column above is the source and the server_id is the media server that performed the restore

try_count

NUMBER

For backup jobs, this field contains the number of “tries” or “attempts” of the backup job

try_finish_date

DATE

Date/time that the job try completed

try_index

NUMBER

Indicates which try—that is, first try, second try, etc.