• tsm查看磁带常用命令


    1. 如何查询每个Pool中使用了多少盘磁带?

    解决方法:

    Dsmadmc中

    select stgpool_name,devclass_name,count(*) as "VOLUMES" from volumes group by stgpool_name,devclass_name  

    输出:

    STGPOOL_NAME           DEVCLASS_NAME              VOLUMES
    
    ------------------     ------------------     -----------
    
    ABISFOREVER_POOL       3494_CLASS                       6
    
    AIPSFOREVER_POOL       3494_CLASS                       5
    
    LANPOOL                3494_CLASS                      15
    
    OTHERFOREVER_POOL      3494_CLASS                      20
    
    OTHERPOOL              3494_CLASS                       3
    
    S80FOREVER_POOL        3494_CLASS                     208
    
    S80POOL                3494_CLASS                       2
    
    S85FOREVER_POOL        3494_CLASS                     178
    
    S85POOL                3494_CLASS                       5
    
    TAPEPOOL               TAPECLASS                       52
    
    TULIPFOREVER_POOL      3494_CLASS                       7
    1. 如何查询备份时间 节点 和内容?

    方法:dsmadmc中使用SQL,(其中条件可以按节点,文件名,或日期来筛选)

    select node_name,filespace_name,hl_name,ll_name,backup_date from backups

    输出

    NODE_NAME              FILESPACE_NAME         HL_NAME                LL_NAME                       BACKUP_DATE
    
    ------------------     ------------------     ------------------     ------------------     ------------------
    
    F50                    /abis                  /                      dumpdir                        2005-04-08
    
                                                                                                   23:25:53.000000
    
    F50                    /abis                  /dumpdir/              d2.19.pax                      2005-04-08
    
                                                                                                   23:25:53.000000
    
    P610B                  /usr                   /lpp/bos/deinstl/-     bos.rte.man.inven-             2005-11-16
    
                                                   bos.rte.man/4.3.-      tory                     01:43:44.000000
    
                                                   3.76/                                                          
    
    P610B                  /usr                   /lpp/bos/deinstl/-     bos.rte.methods.al             2005-11-16
    
                                                   bos.rte.methods/-                               01:43:44.000000
    
                                                   4.3.3.76/                                                      
    
    P610B                  /usr                   /lpp/bos/deinstl/-     bos.rte.methods.i-             2005-11-16
    
                                                   bos.rte.methods/-      nventory                 01:43:44.000000
    
                                                   4.3.3.76/                                                      
    
    P610B                  /usr                   /lpp/bos/deinstl/-     bos.rte.methods.s-             2005-11-16
    
                                                   bos.rte.methods/-      m_dev.unodmadd           01:43:44.000000
    
                                                   4.3.3.76/                                                      
    1. 如何查询卷对应的备份内容和节点?

    方法:dsmadmc中使用SQL,(其中条件可以按节点,文件名来筛选)

    select VOLUME_NAME,NODE_NAME,FILESPACE_NAME,FILE_NAME from contents
    VOLUME_NAME            NODE_NAME              FILESPACE_NAME         FILE_NAME         
    
    ------------------     ------------------     ------------------     ------------------
    
                                                                          .20040804.5      
    
    000232                 S85B                   /cms/dumpdir           /qudump/ qudumpdb-
    
                                                                          .20040804.6      
    
    000232                 S85A                   /cms/backup            /data/btdata/     
    
                                                                          btdata.20040803.Z
    
    000232                 S85A                   /cms/backup            /data/qudata/     
    
                                                                          qudata.20040803.Z
    
    000232                 S85B                   /cms/dumpdir           /btdump/ btdumpdb-
    
                                                                          .20040805.1      
    
    000232                 S85B                   /cms/dumpdir           /btdump/ btdumpdb-
    
                                                                          .20040805.2      
    
    000232                 S85B                   /cms/dumpdir           /btdump/ btdumpdb-
    
                                                                          .20040805.3      
    
    000232                 S85B                   /cms/dumpdir           /btdump/ btdumpdb-
    
                                                                          .20040805.4      
    
    000232                 S85B                   /cms/dumpdir           /qudump/ qudumpdb-
    
                                                                          .20040805.1      
    
    000232                 S85B                   /cms/dumpdir           /qudump/ qudumpdb-
    
                                                                          .20040805.2    
    1. 如何查询哪个具体文件在哪盘带子上,是哪个节点备份的?(这是农行非常关心的内容)

    方法:dsmadmc中使用SQL,(其中条件可以按节点,文件名来筛选)

    select VOLUME_NAME,NODE_NAME,FILESPACE_NAME,FILE_NAME from contents where file_name like '%btdumpdb.20040805.2%'
    
     
    
    VOLUME_NAME            NODE_NAME              FILESPACE_NAME         FILE_NAME         
    
    ------------------     ------------------     ------------------     ------------------
    
    000232                 S85B                   /cms/dumpdir           /btdump/ btdumpdb-
    
                                                                          .20040805.2    
    1. 如何查询具体文件哪个节点什么时间备份的?

    方法:dsmadmc中使用SQL,(其中条件可以按节点,文件名来筛选)

    select node_name,filespace_name,hl_name,ll_name,backup_date from backups where  ll_name like '%btdumpdb.20040805.2%'
    
     
    
    NODE_NAME              FILESPACE_NAME         HL_NAME                LL_NAME                       BACKUP_DATE
    
    ------------------     ------------------     ------------------     ------------------     ------------------
    
    S85B                   /cms/dumpdir           /btdump/               btdumpdb.20040805-             2004-08-05
    
                                                                          .2                       01:05:25.000000
  • 相关阅读:
    JS原始类型Number数字类型
    JS数据类型基础知识
    JS基础循环语句和跳转语句
    JS对象类型数组方法篇
    JS对象类型数组基础篇
    JS基础逻辑运算符
    IE6,IE7,FF等浏览器不兼容原因及解决办法(转)
    DML、DDL、DCL区别
    Asp.net(c#)GridView分页时用图片显示上一页,下一页
    P3P完成跨域COOKIE
  • 原文地址:https://www.cnblogs.com/dahaoran/p/14210071.html
Copyright © 2020-2023  润新知