检查数据库是否存在副本卷（如果在RAID保护的磁盘上可以忽略）

     tsm: TSMSERVER_SERVER1>q dbv

    

     Volume Name          Copy       Volume Name          Copy       Volume Name          Copy 

     (Copy 1)             Status     (Copy 2)             Status     (Copy 3)             Status

     ----------------     ------     ----------------     ------     ----------------     ------

     C:\TSMDATA\SERV-     Sync'd                          Undef-                          Undef-

      ER1\DB1.DSM                                          ined                            ined

    

     tsm: TSMSERVER_SERVER1>q logv

    

     Volume Name          Copy       Volume Name          Copy       Volume Name          Copy 

     (Copy 1)             Status     (Copy 2)             Status     (Copy 3)             Status

     ----------------     ------     ----------------     ------     ----------------     ------

     C:\TSMDATA\SERV-     Sync'd                          Undef-                          Undef-

      ER1\LOG1.DSM                                         ined                            ined

    

    处理：在OS上创建卷

     C:\Program Files\Tivoli\tsm\console>dsmfmt -db C:\tsmdata\server1\db2.dsm 1024

     TIVOLI STORAGE MANAGER by Tivoli

    

     Tivoli Storage Manager (C)

     Copyright IBM Corporation 1990, 2006.

     All rights reserved.

     U.S. Government Users Restricted Rights - Use, duplication

     or disclosure restricted by GSA ADP Schedule Contract with IBM Corporation.

     Licensed Materials - Property of IBM.

     IBM Product ID 5608-ISM, 5608-ISX

     Allocated space for C:\tsmdata\server1\db2.dsm: 1074790400 bytes.

    

     C:\Program Files\Tivoli\tsm\console>dsmfmt -log C:\tsmdata\server1\log2.dsm 517

     TIVOLI STORAGE MANAGER by Tivoli

    

     Tivoli Storage Manager (C)

     Copyright IBM Corporation 1990, 2006.

     All rights reserved.

     U.S. Government Users Restricted Rights - Use, duplication

     or disclosure restricted by GSA ADP Schedule Contract with IBM Corporation.

     Licensed Materials - Property of IBM.

     IBM Product ID 5608-ISM, 5608-ISX

     Allocated space for C:\tsmdata\server1\log2.dsm: 542113792 bytes.

    

    在dsmadmc中创建镜像

     tsm: TSMSERVER_SERVER1>define DBCopy C:\TSMDATA\SERVER1\DB1.DSM C:\tsmdata\server1\db2.dsm

     Session established with server TSMSERVER_SERVER1: Windows

       Server Version 5, Release 3, Level 6.0

       Server date/time: 2009-11-03 15:03:53  Last access: 2009-11-03 14:54:41

    

     ANR2242I Database volume copy C:\TSMDATA\SERVER1\DB2.DSM defined; synchronization process started

     (process ID 2).

    

     tsm: TSMSERVER_SERVER1>define logcopy C:\TSMDATA\SERVER1\log1.dsm C:\TSMDATA\SERVER1\log2.dsm

     ANR2262I Recovery log volume copy C:\TSMDATA\SERVER1\LOG2.DSM defined; synchronization process started

     (process ID 3).

    

     tsm: TSMSERVER_SERVER1>q process

    

      Process     Process Description      Status                                          

       Number                             

     --------     --------------------     -------------------------------------------------

            2     Database Copy            Volume C:\TSMDATA\SERVER1\DB2.DSM - 680 megabytes

                   Synchronization          of 1024                                        

            3     Recovery Log Copy        Volume C:\TSMDATA\SERVER1\LOG2.DSM - 16 megabytes

                   Synchronization          of 516                                         

检查利用率  

     tsm: TSMSERVER_SERVER1>q db

    

     Available    Assigned      Maximum      Maximum       Page        Total         Used      Pct     Max.

         Space    Capacity    Extension    Reduction       Size       Usable        Pages     Util      Pct

          (MB)        (MB)         (MB)         (MB)    (bytes)        Pages                           Util

     ---------    --------    ---------    ---------    -------    ---------    ---------    -----    -----

         1,024       1,024            0        1,020      4,096      262,144          590      0.2      0.2

    

     tsm: TSMSERVER_SERVER1>q log

    

     Available    Assigned      Maximum      Maximum       Page        Total         Used      Pct     Max.

         Space    Capacity    Extension    Reduction       Size       Usable        Pages     Util      Pct

          (MB)        (MB)         (MB)         (MB)    (bytes)        Pages                           Util

     ---------    --------    ---------    ---------    -------    ---------    ---------    -----    -----

           516         516            0          512      4,096      131,584          324      0.2      0.5

    

如果不够需要处理：先在OS上格式化文件

tsm: TSMSERVER_SERVER1>define dbvolume C:\TSMDATA\SERVER1\DB_1.dsm

ANR2240I Database volume C:\TSMDATA\SERVER1\DB_1.DSM defined.

 

tsm: TSMSERVER_SERVER1>q dbv

 

Volume Name          Copy       Volume Name          Copy       Volume Name          Copy 

(Copy 1)             Status     (Copy 2)             Status     (Copy 3)             Status

----------------     ------     ----------------     ------     ----------------     ------

C:\TSMDATA\SERV-     Sync'd     C:\TSMDATA\SERV-     Sync'd                          Undef-

 ER1\DB1.DSM                     ER1\DB2.DSM                                          ined

C:\TSMDATA\SERV-     Sync'd                          Undef-                          Undef-

 ER1\DB_1.DSM                                         ined                            ined

 

tsm: TSMSERVER_SERVER1>define dbcopy C:\TSMDATA\SERVER1\DB_1.dsm C:\TSMDATA\SERVER1\DB_2.dsm

ANR2241I Database volume copy C:\TSMDATA\SERVER1\DB_2.DSM defined.

 

tsm: TSMSERVER_SERVER1>q dbv

 

Volume Name          Copy       Volume Name          Copy       Volume Name          Copy 

(Copy 1)             Status     (Copy 2)             Status     (Copy 3)             Status

----------------     ------     ----------------     ------     ----------------     ------

C:\TSMDATA\SERV-     Sync'd     C:\TSMDATA\SERV-     Sync'd                          Undef-

 ER1\DB1.DSM                     ER1\DB2.DSM                                          ined

C:\TSMDATA\SERV-     Sync'd     C:\TSMDATA\SERV-     Sync'd                          Undef-

 ER1\DB_1.DSM                    ER1\DB_2.DSM                                         ined

查看TSMSERVER是否存在操作失败的情况

     tsm: TSMSERVER_SERVER1>q actlog begindate=today-2 search=fail

    

     Date/Time                Message                                                  

     --------------------     ----------------------------------------------------------

     2009-11-03 13:25:46      ANR1792W HBAAPI vendor library failed to load or is      

                               missing.                                                

     2009-11-03 13:25:47      ANR0985I Process 1 for EXPIRATION running in the          

                               BACKGROUND completed with completion state FAILURE at   

                               13:25:47. (PROCESS: 1)                                  

     2009-11-03 13:41:51      ANR1792W HBAAPI vendor library failed to load or is      

                               missing.                                                

     2009-11-03 13:41:52      ANR0985I Process 1 for EXPIRATION running in the         

                               BACKGROUND completed with completion state FAILURE at   

                               13:41:52. (PROCESS: 1)                                  

     2009-11-03 13:45:50      ANR0985I Process 1 for EXPIRATION running in the         

                               BACKGROUND completed with completion state FAILURE at   

                               13:45:50. (PROCESS: 1)                                  

     2009-11-03 13:53:29      ANR1792W HBAAPI vendor library failed to load or is      

                               missing.                                                

     2009-11-03 13:53:29      ANR0985I Process 1 for EXPIRATION running in the         

                               BACKGROUND completed with completion state FAILURE at   

                               13:53:29. (PROCESS: 1)                                  

     2009-11-03 14:05:08      ANE4959I (Session: 10, Node: WESTZQ)  Total number of    

                               objects failed:           0 (SESSION: 10)               

     2009-11-03 14:05:29      ANE4959I (Session: 10, Node: WESTZQ)  Total number of    

                               objects failed:           0 (SESSION: 10)               

     2009-11-03 14:12:55      ANR1792W HBAAPI vendor library failed to load or is      

                               missing.                                                

     2009-11-03 14:13:47      ANR1792W HBAAPI vendor library failed to load or is      

                               missing.                                                

     2009-11-03 14:35:31      ANR2017I Administrator ADMIN issued command: QUERY ACTLOG     

 

处理：错误代码手册叫Messages,5.3的书号为SC32-9090-03

查看最近2天TSM自身数据库备份情况

     tsm: TSMSERVER_SERVER1>q actlog begindate=today-2 search="backup db"

    

     Date/Time                Message                                                  

     --------------------     ----------------------------------------------------------

     2009-11-03 14:36:55      ANR2017I Administrator ADMIN issued command: QUERY ACTLOG

                               begindate=today-2 search="backup db"  (SESSION: 17)     

 

处理：

手工备份DB

tsm: TSMSERVER_SERVER1>backup db dev=filedev1 type=full

ANR2280I Full database backup started as process 4.

ANS8003I Process number 4 started.

查看过去3天和未来3天自动任务如何安排，主要查看是否安装自身数据库备份   

     tsm: TSMSERVER_SERVER1>q event * t=a begindate=today-3 enddate=today+3

 

查看TSM数据库备份卷的情况：何时备份，卷标等。

     tsm: TSMSERVER_SERVER1>q volh type=dbbackup        

 

       Date/Time: 2009-11-03 15:16:18

     Volume Type: BACKUPFULL

   Backup Series: 1

Backup Operation: 0

      Volume Seq: 1

    Device Class: FILEDEV1

     Volume Name: C:\TSMDATA\SERVER1\57232579.DBB

 Volume Location:

         Command:

查看驱动器状态是否均为online。

     tsm: TSMSERVER_SERVER1>q drive

查看是否有访问异常的存储池卷（状态为unavailable）

     tsm: TSMSERVER_SERVER1>q vol * access=unavailable

查看存储池卷的状态

     tsm: TSMSERVER_SERVER1>q vol

查看存储池状态。

     tsm: TSMSERVER_SERVER1>q stgp

    

     Storage         Device          Estimated       Pct       Pct     High     Low     Next Stora-

     Pool Name       Class Name       Capacity      Util      Migr      Mig     Mig     ge Pool   

                                                                        Pct     Pct    

     -----------     ----------     ----------     -----     -----     ----     ---     -----------

     BACKUPPOOL      FILEDEV1            0.0 M       0.0       0.0       90      70               

     DISKPOOL        DISK              257.0 M       0.0       0.0       90      70                

     ORACLEPOOL      DISK              512.0 M      13.2      13.2       50      20     ORACLEPOOL2

     ORACLEPOOL2     FILEDEV1              5 G      20.0      20.5      100      50     BACKUPPOOL

     ORACLEPOOL3     FILEDEV1            0.0 M       0.0                                                

    

TSM错误手册 Messages.pdf

DSMCADMC命令手册 Administrator's Reference.pdf

TSM客户机配置 Installation and User's Guide - Backup-Archive Clients.pdf

             

        

在加个配置收集脚本

issu mess i ""
issu mess i ""
issu mess i "**************************************************"
issu mess i "*** ---> QUERY STATUS                            *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q stat

issu mess i "**************************************************"
issu mess i "*** ---> QUERY OPTION                            *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q opt

issu mess i "**************************************************"
issu mess i "*** ---> QUERY SESSION                           *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q sess

issu mess i "**************************************************"
issu mess i "*** ---> QUERY DB F=D                            *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q db f=d
issu mess i "**************************************************"
issu mess i "*** ---> QUERY LOG F=D                           *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q log f=d
issu mess i "**************************************************"
issu mess i "*** ---> QUERY DBVOLUME F=D                      *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q dbv f=d
issu mess i "**************************************************"
issu mess i "*** ---> QUERY LOGVOLUME F=D                     *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q logv f=d

issu mess i "**************************************************"
issu mess i "*** ---> QUERY VOLUME                            *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q vol
issu mess i "**************************************************"
issu mess i "*** ---> QUERY LIBVOLUME                         *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q libv

issu mess i "**************************************************"
issu mess i "*** ---> QUERY SCHEDULE TYPE=Administrative F=D  *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q sche t=a f=d
issu mess i "**************************************************"
issu mess i "*** ---> QUERY SCHEDULE TYPE=Client F=D          *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q sche t=c f=d
issu mess i "**************************************************"
issu mess i "*** ---> QUERY SCRIPT. * F=D                      *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q scri * f=d
issu mess i "**************************************************"
issu mess i "*** ---> QUERY ADMIN                             *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q admin
issu mess i "**************************************************"
issu mess i "*** ---> QUERY NODE                              *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q node
issu mess i "**************************************************"
issu mess i "*** ---> QUERY DEVCLASS                          *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q devc
issu mess i "**************************************************"
issu mess i "*** ---> QUERY DEVCLASS F=D                      *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q devc f=d
issu mess i "**************************************************"
issu mess i "*** ---> QUERY LIBRARY F=D                       *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q libr f=d
issu mess i "**************************************************"
issu mess i "*** ---> QUERY DRIVE F=D                         *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q drive f=d
issu mess i "**************************************************"
issu mess i "*** ---> QUERY PATH F=D                          *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q path f=d
issu mess i "**************************************************"
issu mess i "*** ---> QUERY STGPOOL                           *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q stgp
issu mess i "**************************************************"
issu mess i "*** ---> QUERY STGPOOL F=D                       *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q stgp f=d
issu mess i "**************************************************"
issu mess i "*** ---> QUERY STGPOOL F=D                       *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q stgp f=d
issu mess i "**************************************************"
issu mess i "*** ---> QUERY FILESPACE                         *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q files

issu mess i "**************************************************"
issu mess i "*** ---> QUERY COPYGROUP TYPE=Backup             *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q copyg t=b
issu mess i "**************************************************"
issu mess i "*** ---> QUERY COPYGROUP TYPE=Archive            *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q copyg t=a
issu mess i "**************************************************"
issu mess i "*** ---> QUERY COPYGROUP TYPE=Backup F=D         *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q copyg t=b f=d
issu mess i "**************************************************"
issu mess i "*** ---> QUERY COPYGROUP TYPE=Archive F=D        *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q copyg t=a f=d
issu mess i "**************************************************"
issu mess i "*** ---> QUERY DOMAIN                            *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q domain
issu mess i "**************************************************"
issu mess i "*** ---> QUERY MGMTCLASS F=D                     *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q mgmtc f=d

issu mess i "**************************************************"
issu mess i "*** ---> QUERY VOLHISTORY BEGIND=Today-5         *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q volh begind=today-5

issu mess i "**************************************************"
issu mess i "*** ---> QUERY ACTLOG BEGIND=Today-5         *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q actlog begind=today-5

issu mess i "**************************************************"
issu mess i "*** ---> select platform_name,count(*) from nodes group by platform_name"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
select platform_name,count(*) from nodes group by platform_name

issu mess i "**************************************************"
issu mess i "*** ---> select stgpool_name,devclass_name,count(*) as "VOLUMES" from volumes group by stgpool_name,devclass_name"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
select stgpool_name,devclass_name,count(*) as "VOLUMES" from volumes group by stgpool_name,devclass_name