Versions Compared

Version Old Version 5 New Version 6
Changes made by

Aaron Fistler

Aaron Fistler

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Column Name

System Column Name

Data Type

Description

BACKUP_SYSTEM

SYSTEM

VARCHAR(17)

The name of the system where the backup was performed.

Note: The system format is nnnnnnnn.ssssssss where nnnnnnnn is the network identifier and ssssssss is the local location name.

CONTROL_GROUP

CGNAME

VARCHAR(10)

The name of the Control Group that was backed up.

TYPE

Info

Column Name added with PTFs 5770-BR1 7.4 SJ01196, 5770-BR1 7.5 SI01197 SJ01197, 5770-BR2 7.4 SJ00271 and 5770-BR2 7.5 SJ00272.  Not available in earlier PTF levels.

TYPE

VARCHAR(7)

Nullable

Specifies the type of control group that was backed up.

The possible values are:

  • ARCHIVE              Archive control group backup type.

  • BACKUP     Backup control group type.

Contains the null value if the field is not set.

QUALIFIED_JOB_NAME

QUAL_JOB

VARCHAR(28)

The qualified name of the job that performed the backup.

SAVE_START

SAVE_START

TIMESTAMP(0)

The start timestamp of the backup.

SAVE_END

SAVE_END

TIMESTAMP(0)

The ending timestamp of the backup.

BACKUP_MINUTES

BACKUPMN

INT

The number of minutes the backup ran.

OBJECTS_SAVED

SAVED

BIGINT

The number of objects saved.

OBJECTS_NOT_SAVED

NOTSAVED

BIGINT

The number of objects not saved.

SAVE_SIZE

SAVE_SIZE

BIGINT

The number of bytes saved.

SAVE_STATUS

STATUS

VARCHAR(10)

The status of the backup.

The possible values are:

  • ACTIVE              The backup is currently running and has not completed.

  • CANCELLED      The backup was cancelled.

  • COMPLETE       The backup completed with no errors.

  • FAILED              The backup failed.

  • INCOMPLETE   The backup completed but not all objects were saved.

  • UNKNOWN      The current state of the backup is unknown.  This can occur while QUSRBRM is being saved or if an older level of QUSRBRM is restored.

MEDIA_CLASS

CLASS

VARCHAR(10)

The media class that was used for the backup.

DEVICE_NAMES

DEVICES

VARCHAR(43)

The device names used by the backup. 

Note: The string contains 10 character blank separated device names, up to a maximum of 4.

VOLUMES

VOLUMES

VARCHAR(700)

The volumes that were used for the backup.

Note: The string contains 6 character blank separated volume names, up to a maximum of 100.

...