Have you tried using the SQL service QUSRBRM.CG_STATUS - might be easier / cleaner to digest .....It doesn't look like it has the retention info, but it has the backup size you need/want.
BRMS SQL Services - IBM Partnership -
------------------------------
Rich Malloy
------------------------------
Original Message:
Sent: Mon January 13, 2025 01:08 AM
From: STEPHEN LINSDELL
Subject: PRTRPTBM *CTLGRPSTAT
A customer is trying to size their VTL space requirements for BRMS backups. They ran the PRTRPTBRM *CTLGRPSTAT command, after creating the data area to get the retention info included.
A customer with many (over 150) BRMS backup control groups in an LPAR finds that when they run the PRTRPTBRM *CTLGRPSTAT report it provides the usual info for the first 20 or 30 control groups that have been doing backups. Then midway through the listing of daily backups for a control group the report includes the Retention information page containing info expected for the backup control groups reported on so far (alphabetically).
Then it seems to list the cartridges used for the remaining backup control groups but provides no info on the amount of data being backed up or the run dates/times. Then it completes with a second Retention details page for this latter group of control groups.
This occurs in all their LPARs with large numbers of backup control groups used.
Has anyone seen this before? I am trying to help them with the sizing but without the backup size info for most of the backup control groups it is difficult.
------------------------------
Stephen Linsdell
IBM Australia
------------------------------