Column Name | Data Type | Description |
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 | Host name associated with the client ID |
client_id | NUMBER | Foreign key to the apt_v_server for the NetBackup client. |
copy_index | NUMBER | If the backup was set to make multiple copies (inline tape copies), this column will indicate the copy index |
drive_id | NUMBER | Foreign key to apt_v_nbu_su_group_member. |
duration | STRING | Duration in Hour, Minute, Second |
duration_secs | NUMBER | Duration in seconds |
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 |
master_host_name | STRING | Name of the master server |
media_host_name | STRING | Media host name |
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 |
mybtes_sec | NUMBER | Megabytes per second |
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 NetBackup job |
nbu_job_id | NUMBER | Veritas NetBackup Job ID |
parent_nbu_job_id | NUMBER | Veritas NetBackup Parent Job ID. This is normally NULL but may exist for certain parent/child jobs such as multi-streaming jobs or database backup jobs |
policy_id | NUMBER | Foreign key to apt_v_nbu_policy for the NetBackup policy. |
policy_name | STRING | Descriptive name associated with the ID |
policy_type_name | STRING | Native NetBackup policy type. |
product_type_name | STRING | Text description of the backup product type, such as NetBackup, IBM Tivoli Storage Manager, etc. |
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 | The name of the schedule. |
schedule_type_name | STRING | The name of the schedule type |
server_id | NUMBER | Foreign key to apt_v_server for the NetBackup master 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 | NetBackup 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 NetBackup skipping some of the files in a backup |
tape_kilobytes | NUMBER | Kilobytes written to the tape |
tape_media_id | NUMBER | Foreign key to apt_v_nbu_tape_media. |
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_start_date | DATE | Date/time that the job try started |
try_status | NUMBER | The status of the attempt |
vendor_state | NUMBER | Native NetBackup job state codes. This is an enumeration field with the following values: 0 = Job is queued 1 = Job is running / in-process 2 = Job has been re-queued 3 = Job has been closed / completed 4 = Job has been closed / deleted 5 = No client software installed 6 = Job is pending |
vendor_state_name | STRING | Descriptive name of the job state |
vendor_status | NUMBER | Native NetBackup status code |
vendor_status_name | STRING | Descriptive name associated with the status |