sqlbackuptivoli

IBM TSM - Select command to view size of Daily Backup

I am working with IBM Tivoli Management Storage and I have to run a a daily report of how much data have been backed-up.

The command below give me the result in Megabytes which is OK, But to save time I would like to have have the result in Gigabytes as my backups are on average bigger than 0ne Gigabyte.

I have tried few variation, but it didn't work, I know very little of SQL and TSM use similar command could someone help me with it.

SELECT substr(entity,1,20) AS "Node",  CAST(sum(bytes/1024/1024) AS decimal(8,2)) AS "MB Bkp" FROM summary WHERE activity='BACKUP' AND start_time>=current_timestamp - 24 hours GROUP BY entity order by 2 desc

The Result is:

Node                           MB Bkp
---------------------     -----------
SRWLON0xxxx                 510298.00
SRWLON0xxxx                  18999.00
SRWLON0xxxx                  18960.00
SRWLON0xxxx                   9023.00
SVWLON0xxxx                   7581.00
SRWLON0xxxx                   6436.00

Thank you in advance.

Solution

  • You have to add another /1024 and modify the name in "GB Bkp"

    SELECT substr(entity,1,20) AS "Node", CAST(sum(bytes/1024/1024/1024) AS decimal(8,2)) AS "GB Bkp" FROM summary WHERE activity='BACKUP' AND start_time>=current_timestamp - 24 hours GROUP BY entity order by 2 desc

    Hope this will help you