TSM备份系统查询每个节点每天数据量

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:182

tsm: TSM53>select entity,sum(bytes)/1024/1024/1024 as gb from summary where activity='BACKUP' and start_time >= current_timestamp - 24 hours group by entity
ANR2963W This SQL query may produce a very large result table, or may require a
significant amount of time to compute.

Do you wish to proceed? (Yes (Y)/No (N)) y

ENTITY GB
------------------ ---------------------------------
CRMDB1RAC 49
(DB__P595CRM1__C-
RMDB1)
CRMDB1RAC 56
(DB__P595CRM2__C-
RMDB1)
CRMDB2RAC 139
(DB__P595CRM1__C-
RMDB2)
CRMDB2RAC 67
(DB__P595CRM2__C-
RMDB2)
DB__P570BL1__INVD- 52
B1
DB__P570BL1__USGD- 482
B1
DB__P570BL2__INVD- 13
B1
DB__P570BL2__USGD- 7423
B1
DB__P570_YKT1__YKT 0
DB__P570_YKT2__YKT 395
DB__P595CRM1__CRM- 49
DB1
DB__P595CRM1__CRM- 139
DB2
DB__P595CRM2__CRM- 56
DB1
DB__P595CRM2__CRM- 67
DB2
DB__P750LOY1__HQY- 209
DB1
DB__P750LOY2__HQY- 2
DB1
FS_P550APP3 0
FS_P550BL3 0
INVDBRAC (DB__P57- 52
0BL1__INVDB1)
INVDBRAC (DB__P57- 13
0BL2__INVDB1)
ORA_P570PRM1 1472
ORA_P570PRM2 0
more... ( to continue, 'C' to cancel)

P550TSM_ORACLE 48
USGDBRAC (DB__P57- 482
0BL1__USGDB1)
USGDBRAC (DB__P57- 7423
0BL2__USGDB1)
YKTDBRAC (DB__P57- 0
0_YKT1__YKT)
YKTDBRAC (DB__P57- 395
0_YKT2__YKT)

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】