QUSRBRM.CG_BACKUP_STATUS View

Owned by Aaron Fistler
Last updated: Sept 20, 2023

The control group backup status view contains information about BRMS Control Group backups.

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.

Authorization:  

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

  • *OBJOPR and *READ authority to the QUSRBRM/CG_STATUS object.

Result Table

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

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.

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.

Examples

Example 1 : Report all failed control group backups

SELECT CGNAME, QUAL_JOB, SAVE_START, SAVE_END, BACKUPMN FROM QUSRBRM/CG_STATUS WHERE STATUS = 'FAILED'

Example output:

CONTROL_GROUP

QUALIFIED_JOB_NAME

SAVE_START

SAVE_END

BACKUP_MINUTES

CONTROL_GROUP

QUALIFIED_JOB_NAME

SAVE_START

SAVE_END

BACKUP_MINUTES

QCLDUUSRA

701331/USERA/DSP01

2021-10-28-13.09.04

2021-10-28-13.09.18

0

USRASPLF

701331/USERA/DSP01

2021-10-28-13.09.18

2021-10-28-12.56.11

0

DHVERS

698158/USERB/QPADEV0001

2021-10-14-13.26.48

2021-10-14-13.27.13

0

QCLDUUSRA

698158/USERB/QPADEV0001

2021-10-28-12.53.16

2021-10-14-13.27.13

0

QCLDUUSRA

701331/USERA/DSP01

2021-10-28-12.56.11

2021-10-14-13.27.13

0


Example 2 : Report the 5 longest running control group backups:

SELECT CGNAME, QUAL_JOB, SAVE_START, BACKUPMN, SAVE_SIZE FROM QUSRBRM/CG_STATUS ORDER BY BACKUPMN DESC LIMIT 5

Example output:

CONTROL_GROUP

QUALIFIED_JOB_NAME

SAVE_START

BACKUP_MINUTES

SAVE_SIZE

CONTROL_GROUP

QUALIFIED_JOB_NAME

SAVE_START

BACKUP_MINUTES

SAVE_SIZE

QCLDBSYS01

674006/USERA/QPADEV0006

2021-07-28-12.33.11

108

149,375,567,872

QNFSIPLFUL

613990/USERA/DSP01

2021-03-04-08.28.14

89

13,780,372,480

QNFSIPLFUL

612357/USERA/DSP01

2021-03-03-18.46.20

89

11,883,060,224

QNFSIPLFUL

613033/USERA/DSP01

2021-03-03-21.07.21

85

13,615,770,624

QNFSIPLFUL

611240/USERA/DSP01

2021-03-02-18.13.21

82

11,870,256,128

Example 3 : Report backups that used volume 000500:

SELECT CGNAME, QUAL_JOB, SAVE_START, STATUS, VOLUMES FROM QUSRBRM/CG_STATUS WHERE VOLUMES LIKE '%000500%' 
ORDER BY SAVE_START DESC                            

Example output:

CONTROL_GROUP

QUALIFIED_JOB_NAME

SAVE_START

STATUS

VOLUMES

CONTROL_GROUP

QUALIFIED_JOB_NAME

SAVE_START

STATUS

VOLUMES

USRA

696536/USERA/QPADEV0006

2021-10-08-08.40.22

COMPLETE

000045 000500 000121 000501

USRA

696521/USERA/QPADEV0006

2021-10-08-07.25.27

COMPLETE

000500 000045 000121 000501

USRATEST

564806/USERA/QPADEV0006

2020-12-07-09.42.38

COMPLETE

000191 001152 000500 000499

Example 4 : Report number of volumes used by control group with how much data was saved:

SELECT SAVE_START, CONTROL_GROUP, (LENGTH(TRIM(VOLUMES)) + 1) / 7 AS VOLUMES_USED, SAVE_SIZE, BACKUP_MINUTES, SAVE_STATUS FROM QUSRBRM.CG_BACKUP_STATUS ORDER BY CONTROL_GROUP                           

Example output:

SAVE_START

CONTROL_GROUP

VOLUMES_USED

SAVE_SIZE

BACKUP_MINUTES

SAVE_STATUS

SAVE_START

CONTROL_GROUP

VOLUMES_USED

SAVE_SIZE

BACKUP_MINUTES

SAVE_STATUS

2023-08-30-07:48:43

*SYSTEM

2

91294412824

15

INCOMPLETE

2023-09-01-07:02:14

*SYSTEM

3

150198183936

67

COMPLETE

2023-09-15-09:35:23

*SYSTEM

3

150291857408

72

COMPLETE

2023-09-07-14:23:33

ALLUSRFULL

1

28507672576

7

COMPLETE

2023-09-08-15:31:13

ALLUSRFULL

3

73800369152

34

COMPLETE

Copyright © Fortra, LLC and its group of companies. All trademarks and registered trademarks are the property of their respective owners.