The CommCellBackupInfo view provides information about the backup jobs. Jobs do not appear for subclients that have no assigned storage policy.
|
Column |
Description |
|---|---|
|
jobid |
The unique Job ID of the backup job. |
|
appid |
The unique subclient ID. |
|
jobinitfrom |
Where the operation was initiated. |
|
clientname |
The client computer name. |
|
idataagent |
The agent name. |
|
instance |
The name of the instance that conducted the backup job. If the instance option is not applicable for an iDataAgent, the information is displayed as NULL. |
|
backupset |
The backup set name. |
|
subclient |
The subclient name. |
|
data_sp |
The storage policy name. |
|
backuplevelint |
The backup level initialization |
|
backuplevel |
The backup type that was selected. Backup types can be Full, Incremental, Differential or Synthetic Full. |
|
incrlevel |
The incremental levels for Informix and Oracle backup jobs. |
|
jobstatusInt |
The job status initialization. |
|
jobstatus |
The status of the job. Job status can be Success, Killed, Failed, or Failed to Start. |
|
jobfailedreason |
The reason the backup job failed. |
|
transferTime |
Amount of time it took to transfer the data from client to media. |
|
startdateunixsec |
The UNIX start date and time of the backup job. This time represents the number of seconds that have elapsed since 1970. |
|
enddateunixsec |
The UNIX date and end time of the backup job. This time represents the number of seconds that have elapsed since 1970. |
|
startdate |
The start date and time of the backup job. This time appears in Coordinated Universal Time (UTC). |
|
enddate |
The end date and time of the backup job. This time appears in Coordinated Universal Time (UTC). |
|
durationunixsec |
The duration of UNIX seconds |
|
duration |
The length of time for the backup operation to complete. |
|
numstreams |
The number of data channels used by the storage policy to perform the backup. |
|
numbytesuncomp |
The amount of uncompressed data. |
|
numbytescomp |
The amount of compressed data. |
|
numobjects |
The number of objects that were backed up for the associated job. |
|
isAged |
The IS aged |
|
isAgeStr |
The IS aged string |
|
xmlJobOptions |
Not used. |
|
retentionDays |
Number of retention days configured for the backup job. |
|
systemStateBackup |
Indicates whether this was a system state backup. No is 0. Yes is 1. |
|
inPrimaryCopy |
Indicates whether the backup job is a primary copy. No is 0. Yes is 1. |
|
failedobjects |
Number of failed objects in the job. |
|
totalBackupSize |
Total size of the backup in KB. |
|
encrypted |
The backup job encryption information:
|
|
Company |
The company that the client computer belongs to. |