Syn B/W Primary and Copy Stgpools

Syn B/W Primary and Copy Stgpools

Shows the difference b/w the primary and copy stgpools. SELECT SUM(BACKUP_MB/1024/1024) as PRI_TB,SUM(BACKUP_COPY_MB/1024/1024) as COPY_T... 10:57

Shows the difference b/w the primary and copy stgpools.

SELECT SUM(BACKUP_MB/1024/1024) as PRI_TB,SUM(BACKUP_COPY_MB/1024/1024) as COPY_TB,((SUM(BACKUP_MB)-SUM(BACKUP_COPY_MB))/1024/1024) as TB_DIFFERENCE from auditocc

PRI_TB COPY_TB TB_DIFFERENCE
------------ ------------ --------------
297 407 -117