Backup Manager Database Views > Detailed View Descriptions (HP Data Protector)
  
Version 9.2.00
Detailed View Descriptions (HP Data Protector)
apt_v_hpd_backup_schedule
The apt_v_hpd_backup_schedule view contains a single row for each HP Data Protector backup schedule.
Table 3.76 apt_v_hpd_backup_schedule
Column Name
Data Type
Description
backup_specifiation_name
STRING
Backup specification name
backup_specification_id
NUMBER
Backup specification ID
backup_type
NUMBER
Enumeration field with the following possible values:
1 = Full backup
2 = Incremental backup
3 = Incremental One backup
4 = Incremental Two backup
5 = Incremental Three backup
6 = Incremental Four backup
7 = Incremental Five backup
8 = Incremental Six backup
9 = Incremental Seven backup
10 = Incremental Eight backup
11 = Incremental Nine backup
12 = Diff
98 = Restore
backup_type_name
STRING
Backup type name
client_id
NUMBER
Foreign key of the client ID for the client scheduled to be backed up (see apt_v_server)
client_name
STRING
Client name
description
STRING
Description
drive_id
NUMBER
Internal ID for tape drive (see apt_v_tape_drive)
is_active
STRING
Y=Yes, N=No
last_full_backup_date
DATE
Last full backup date
last_full_backup_kb
NUMBER
Last full backup KiB
last_incr_backup_date
DATE
Last incremental backup date
last_incr_backup_kb
NUMBER
Last incremental backup KiB
mount_point
STRING
Mount point
next_backup_date
DATE
Next backup date
next_backup_type
NUMBER
Enumeration field with the following possible values:
1 = Full backup
2 = Incremental backup
3 = Incremental One backup
4 = Incremental Two backup
5 = Incremental Three backup
6 = Incremental Four backup
7 = Incremental Five backup
8 = Incremental Six backup
9 = Incremental Seven backup
10 = Incremental Eight backup
11 = Incremental Nine backup
12 = Diff
98 = Restore
next_backup_type_name
STRING
Next backup type name
object_type
NUMBER
This is an enumeration field with the following values:
0 = Unknown
1 = filesystem
2 = winfs
3 = omnidb
4 = rawdisk
5 = sap
6 = sapdb
7 = stream
8 = oracle8
9 = mssql
10 = msexchange
11 = mbx
12 = informix
13 = sybase
14 = lotus
15 = vss
16 = db2
17 = IDB
object_type_name
STRING
Object type name
owner_group
STRING
Owner group
post_exec_script_name
STRING
Post execution script name
pre_exec_script_name
STRING
Pre execution script name
schedule_date
DATE
Schedule date
server_id
NUMBER
Foreign key of the server ID for the HPDP Cell Manager server (see apt_v_server)
server_instance_id
NUMBER
Server the schedule is associated with Foreign key to apt_v_server_instance
server_name
STRING
HPDP cell manager server name
volume_pool_id
NUMBER
Volume pool ID
apt_v_hpd_disk_drive
The apt_v_hpd_disk_drive view contains a single row for each HP Data Protector disk drive.
Table 3.77 apt_v_hpd_disk_drive
Column Name
Data Type
Description
description
STRING
Description of the drive
device_name
STRING
Device Name
disk_drive_id
NUMBER
Sequence generated Primary key
disk_drive_name
STRING
Disk Drive Name
drive_in_use
STRING
Y or N indicating if the drive is in use
drive_index
NUMBER
Drive index
drive_status
STRING
Status of the disk drive
management_server_id
NUMBER
ID of the management server
serial_nbr
STRING
Serial number
vendor_drive_status
STRING
Vendor drive status
vendor_drive_type
NUMBER
Vendor drive type
volume_pool_id
NUMBER
Foreign key from ptl_volume_pool
apt_v_hpd_job
The apt_v_hpd_job view contains a single row for each HP Data Protector backup job.
Table 3.78 apt_v_hpd_job
Column Name
Data Type
Description
access_type
CHAR
This is an enumeration field with the following values:
O = Unknown
V = Private
P = Public
access_type_name
STRING
Access type name
backup_id
STRING
HP Data Protector backup ID
backup_specification_id
NUMBER
Internal Id for the backup specification (see apt_v_hpd_backup_schedule)
backup_specification_name
STRING
Backup specification name (see apt_v_hpd_backup_schedule)
catalog_retention
STRING
Catalog retention
client_id
NUMBER
Foreign key of the client ID for the HPDP client (see apt_v_server)
client_name
STRING
Client host name
copy_id
STRING
Copy ID
data_protection
STRING
Data protection
description
STRING
Description
drive_id
NUMBER
Internal ID for the drive that was used to backup the job (see apt_v_tape_drive)
duration
NUMBER
Duration in Hour, Minute, Second
finish_date
DATE
Date/time that the job completed
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
job_id
NUMBER
Unique job ID. Primary key in this view. This is internal job ID and NOT the same as the HPDP Job ID.
job_type
NUMBER
Enumeration field with the following possible values:
601 = Full backup
602 = Incremental backup
603 = Incremental One backup
604 = Incremental Two backup
605 = Incremental Three backup
606 = Incremental Four backup
607 = Incremental Five backup
608 = Incremental Six backup
609 = Incremental Seven backup
610 = Incremental Eight backup
611 = Incremental Nine backup
612 = Diff
698 = Restore
699 = 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
mb_per_min
NUMBER
Mega bytes per minute
media_type
CHAR
D=Disk based backup, T=Tape based backup
mountpoint
STRING
mount point
nbr_of_errors
NUMBER
Number of errors
nbr_of_files
NUMBER
Number of files affected by the HPDP job
nbr_of_warnings
NUMBER
Number of warnings
object_type
NUMBER
This is an enumeration field with the following values:
0 = Unknown
1 = filesystem
2 = winfs
3 = omnidb
4 = rawdisk
5 = sap
6 = sapdb
7 = stream
8 = oracle8
9 = mssql
10 = msexchange
11 = mbx
12 = informix
13 = sybase
14 = lotus
15 = vss
16 = db2
17 = IDB
object_type_name
STRING
Object Type Name
product_type
NUMBER
Enumeration field with the following possible values:
1 - Symantec NetBackup
2 - Symantec Backup Exec
3 - EMC NetWorker
4 - IBM Tivoli Storage Manager
5 - CommVault Galaxy
6 - HP Data Protector
product_type_name
STRING
Product type name
server_id
NUMBER
Foreign key of the server ID for the HPDP Cell Manager server (see apt_v_server)
server_name
STRING
Server host name
session_id
NUMBER
Internal ID for HPDP session
session_name
STRING
HPDP Session Name
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.
vendor_job_id
STRING
HPDP job ID
vendor_state
NUMBER
Native HPDP job state codes. This is an enumeration field with the following values:
0 = Job has been closed / completed
1 = Job is running / in-process
2 = Job has Failed
3 = Other
vendor_state_name
STRING
Vendor state name
vendor_status
NUMBER
Native HPDP status code
vendor_status_name
STRING
Vendor status name
apt_v_hpd_session_errclient
The apt_v_hpd_session_errclient view contains a single row for each HP Data Protector session error client.
Table 3.79 apt_v_hpd_session_errclient
Column Name
Data Type
Description
backup_specification_id
NUMBER
Backup specification ID
client_id
NUMBER
Foreign key of the client ID for the client being backed up (see apt_v_server)
end_time
DATE
Date/time that the job finished
product_type
NUMBER
Enumeration field with the following possible values:
1 - Symantec NetBackup
2 - Symantec Backup Exec
3 - EMC NetWorker
4 - IBM Tivoli Storage Manager
5 - Comm Vault Galaxy
6 - HP Data Protector
server_id
NUMBER
Foreign key of the server ID for the HPDP Cell Manager server (see apt_v_server)
session_id
NUMBER
Internal ID for HPDP session
start_time
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.
apt_v_hpd_session_tape_media
The apt_v_hpd_session_tape_media view contains a single row for each HP Data Protector session tape media.
Table 3.80 apt_v_hpd_session_tape_media
Column Name
Data Type
Description
available_kb
NUMBER
Available KiB
description
STRING
Description
initialized_date
DATE
Date/Time the tape media was initialized
last_access_date
DATE
Last access date
last_overwrite_date
DATE
Last overwrite date
last_write_date
DATE
Last write date
library_id
NUMBER
Foreign key to the Tape Library that contains this tape media (See apt_v_tape_library)
library_name
STRING
Library name
library_slot_nbr
STRING
Library slot number
location
STRING
Location
media_name
STRING
Media Name
nbr_of_errors
NUMBER
Number of errors
nbr_of_overwrites
NUMBER
Number of overwrites
nbr_of_writes
NUMBER
Number of writes
protection
STRING
Protection
session_id
NUMBER
Internal ID for HPDP session
session_name
STRING
HPDP session name
tape_media_id
NUMBER
Internal ID for tape media (see apt_v_tape_media)
total_kb
NUMBER
Total KiB
used_kb
NUMBER
Used KiB
vendor_media_status
NUMBER
Enumeration field with the following possible values:
0 - Unknown
1 - Good
2 - Poor
3 - Fair
vendor_media_status_name
STRING
HPDP specific media status name
vendor_media_type
NUMBER
Enumeration field with the following possible values:
0 - Unknown
1 - File
2 - AIT
3 - DDS
4 - DLT
5 - DTF
6 - ExaByte
7 - LTO-Ultrium
8 - Optical
9 - QIC
10 - SAIT
11 - SD-3
12 - SuperDLT
13 - T3480/T4890/T9490
14 - T3480
15 - T4890
16 - T9490
17 - T3590
18 - T3592
19 - T9840
20 - T9940
21 - Tape
vendor_media_type_name
STRING
HP Data Protector-specific Media Type Name
volume_pool_id
NUMBER
Foreign key to the volume pool to which this tape media belongs
volume_pool_name
STRING
Volume pool name
apt_v_hpd_tape_library
The apt_v_hpd_tape_library view contains a single row for each HP Data Protector tape library.
Table 3.81 apt_v_hpd_tape_library
Column Name
Data Type
Description
barcode_as_label
STRING
Barcode as label
barcode_reader
STRING
Barcode reader
busy_drive_to_slot
STRING
Busy drive to slot
controlling_server_id
NUMBER
Key to the media server that is controlling the library (see apt_v_server)
controlling_server_name
STRING
Media server name
description
STRING
Description
device_name
STRING
Device name
is_online
CHAR
Y=Yes, N=No
lib_virtual
STRING
Library virtual
library_id
NUMBER
Foreign key to the Tape Library that contains this tape media (See apt_v_tape_library)
library_name
STRING
Library name
media_capacity
NUMBER
Media capacity
media_type
NUMBER
Media type
mgmt_console_url
STRING
URL for management console
nbr_of_drives
NUMBER
Number of drives
nbr_of_slots
NUMBER
Number of slots in library
san_statble_address
STRING
SAN address
serial_number
STRING
Library serial number
server_id
NUMBER
Foreign key of the server ID for the HP Data Protector Cell Manager server (see apt_v_server)
server_instance_id
NUMBER
Server the directive is associated with Foreign key to apt_v_server_instance
server_name
STRING
HP Data Protector cell manager server name
vendor_library_nbr
NUMBER
HP Data Protector library number
vendor_library_type
NUMBER
Enumeration field with the following possible values:
0 - Unknown
1 - Standalone
2 - Stacker
3 - SCSI-II
4 - Jukebox
5 - Filelibrary
6 - External control
7 - GRAU DAS Library
8 - storageTek ACS Library
vendor_library_type_name
STRING
HP Data Protector specific Library Type Name
apt_v_hpd_tape_media
The apt_v_hpd_tape_media view contains a single row for each HP Data Protector tape media.
Table 3.82 apt_v_hpd_tape_media
Column Name
Data Type
Description
available_kb
NUMBER
Available KiB
description
STRING
Description
initialized_date
DATE
Date/Time the tape media was initialized
last_access_date
DATE
Last access date
last_write_date
DATE
Last write date
laste_overwrite_date
DATE
Last overwrite date
library_id
NUMBER
Foreign key to the tape library that contains this piece of tape media (See apt_v_tape_library)
library_name
STRING
Library name
library_slot_nbr
NUMBER
Library slot number
location
STRING
Location
media_name
STRING
HP Data Protector media name
media_status
CHAR
This field contains the media status. The following is a list of the enumeration values:
Y = Deleted
E = Empty
D = Filling
F = Full
P = Error
X = Unavailable
C = Cleaning
V = Status in vendor media status column
media_status_name
STRING
Media status name
nbr_of_errors
NUMBER
Number of errors
nbr_of_overwrites
NUMBER
Number of overwrites
nbr_of_writes
NUMBER
Number of writes
product_type
NUMBER
Enumeration field with the following possible values:
1 - Symantec NetBackup
2 - Symantec Backup Exec
3 - EMC NetWorker
4 - IBM Tivoli Storage Manager
5 - Comm Vault Galaxy
6 - HP Data Protector
product_type_name
STRING
Product type name
protection
STRING
Protection
server_id
NUMBER
Foreign key of the server ID for the HP Data Protector Cell Manager server (see apt_v_server)
server_name
STRING
HPDP cell manager server name
tape_media_id
NUMBER
Internal ID for HP Data Protector tape media (see apt_v_tape_media)
total_kb
NUMBER
Total KiB
used_kb
NUMBER
Used KiB
vendor_media_status
NUMBER
Enumeration field with the following possible values:
0 - Unknown
1 - Good
2 - Poor
3 - Fair
vendor_media_status_name
STRING
HP Data Protector specific media status name
vendor_media_type
NUMBER
Enumeration field with the following possible values:
0 - Unknown
1 - File
2 - AIT
3 - DDS
4 - DLT
5 - DTF
6 - ExaByte
7 - LTO-Ultrium
8 - Optical
9 - QIC
10 - SAIT
11 - SD-3
12 - SuperDLT
13 - T3480/T4890/T9490
14 - T3480
15 - T4890
16 - T9490
17 - T3590
18 - T3592
19 - T9840
20 - T9940
21 - Tape
vendor_media_type_name
STRING
HP Data Protector specific media type name
volume_pool_id
NUMBER
Foreign key to the volume pool that this piece of tape to which media belongs
volume_pool_name
STRING
Volume pool name