RHEL 8.x Spectrum Protect Backup schedule status commands

Home > RHEL > RHEL 8.x > Backup tools > Spectrum Protect Backup > Spectrum Protect Backup schedule status commands

1. On the backup server, open backup console

   dsmadmc

2. Check How much data backed up in last 24 hours

   > SELECT entity, CAST(FLOAT(SUM(bytes)) / 1024 / 1024 / 1024 AS DECIMAL(8,2)) as "GB" FROM summary WHERE ( activity='ARCHIVE' OR activity='BACKUP' ) AND end_time>current_timestamp-24 hours GROUP BY entity ORDER BY "GB"

3. Check how much data backed up in specified time range

   > SELECT entity, CAST(FLOAT(SUM(bytes)) / 1024 / 1024 / 1024 AS DECIMAL(8,2)) as "GB" FROM summary WHERE ( activity='ARCHIVE' OR activity='BACKUP' ) AND start_time >{'2022-04-22 19:00:00'} AND start_time <{'2022-04-23 19:00:00'} GROUP BY entity ORDER BY "GB"

4. Find out the backup status

   > SELECT TO_CHAR(CHAR(scheduled_start),'YYYY-MM-DD HH24:MI:SS') as SCHEDULED_START, TRANSLATE('a bc:de:fg', DIGITS(completed - actual_start), '_______abcdefgh_____',' ') as "ELAPTIME (D HHMMSS)", schedule_name, status, reason FROM events WHERE node_name IS NULL

5. Search the status

   > SELECT date_time,severity,message FROM actlog WHERE originator='SERVER' AND ( message LIKE'ANR2507I%' OR message LIKE'ANR2110I%' OR  message LIKE'ANR2751I%' OR message LIKE'ANR2578W%' OR message LIKE'ANR2579E%') AND date_time>current_timestamp-24 hours

Home > RHEL > RHEL 8.x > Backup tools > Spectrum Protect Backup > Spectrum Protect Backup schedule status commands