QUSRBRM.CG_BACKUP_STATUS View
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. |
TYPE | TYPE | VARCHAR(7) Nullable | Specifies the type of control group that was backed up. The possible values are:
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:
|
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 |
Privacy Policy | Cookie Policy | Impressum
From time to time, this website may contain technical inaccuracies and we do not warrant the accuracy of any posted information.
Copyright © Fortra, LLC and its group of companies. All trademarks and registered trademarks are the property of their respective owners.