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