1. 首页 > ITPUX技术网 > 正文

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

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)

本文由风哥教程整理发布,仅用于学习测试使用,转载注明出处:http://www.fgedu.net.cn/10327.html

联系我们

在线咨询:点击这里给我发消息

微信号:itpux-com

工作日:9:30-18:30,节假日休息