Versions Compared

Version Old Version 8 New Version Current
Changes made by

Aaron Fistler

Aaron Fistler

Saved on

Key

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

...

The values returned for the columns in this view are similar to backup status presented by the BRMS Enterprise services in the Navigator for i. This view is based on the content for the Backup Control Group Status Report.

Authorization:  

The authorization ID of the statement must include the following privileges:

...

The following table describes the columns in the view. The system name is CG_STATUS. The schema is QUSRBRM.

When using QUSRBRM.CG_BACKUP_STATUS the records change:

  • Records with a SAVE_STATUS of COMPLETE or INCOMPLETE are removed one year after the backup history expires, even if the media has been reused.

  • Records with a SAVE_STATUS of ACTIVE are changed to FAILED if the job no longer exists.

  • Records with a SAVE_STATUS of FAILED or CANCELLED are removed after 30 days.

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

...