TSM巡检

最新推荐文章于 2021-05-12 19:44:43 发布

cti27515

最新推荐文章于 2021-05-12 19:44:43 发布

阅读量339

点赞数

文章标签：数据库

检查数据库是否存在副本卷（如果在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)

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)

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 "*** ---&gt QUERY STATUS *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q stat

issu mess i "**************************************************"
issu mess i "*** ---&gt QUERY OPTION *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q opt

issu mess i "**************************************************"
issu mess i "*** ---&gt QUERY SESSION *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q sess

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

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

issu mess i "**************************************************"
issu mess i "*** ---&gt 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 "*** ---&gt 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 "*** ---&gt QUERY SCRIPT. * F=D                      *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q scri * f=d
issu mess i "**************************************************"
issu mess i "*** ---&gt QUERY ADMIN                             *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q admin
issu mess i "**************************************************"
issu mess i "*** ---&gt QUERY NODE                              *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q node
issu mess i "**************************************************"
issu mess i "*** ---&gt QUERY DEVCLASS                          *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q devc
issu mess i "**************************************************"
issu mess i "*** ---&gt QUERY DEVCLASS F=D                      *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q devc f=d
issu mess i "**************************************************"
issu mess i "*** ---&gt QUERY LIBRARY F=D                       *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q libr f=d
issu mess i "**************************************************"
issu mess i "*** ---&gt QUERY DRIVE F=D                         *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q drive f=d
issu mess i "**************************************************"
issu mess i "*** ---&gt QUERY PATH F=D                          *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q path f=d
issu mess i "**************************************************"
issu mess i "*** ---&gt QUERY STGPOOL                           *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q stgp
issu mess i "**************************************************"
issu mess i "*** ---&gt QUERY STGPOOL F=D                       *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q stgp f=d
issu mess i "**************************************************"
issu mess i "*** ---&gt QUERY STGPOOL F=D                       *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q stgp f=d
issu mess i "**************************************************"
issu mess i "*** ---&gt QUERY FILESPACE                         *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q files

issu mess i "**************************************************"
issu mess i "*** ---&gt QUERY COPYGROUP TYPE=Backup             *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q copyg t=b
issu mess i "**************************************************"
issu mess i "*** ---&gt QUERY COPYGROUP TYPE=Archive            *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q copyg t=a
issu mess i "**************************************************"
issu mess i "*** ---&gt 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 "*** ---&gt 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 "*** ---&gt QUERY DOMAIN                            *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q domain
issu mess i "**************************************************"
issu mess i "*** ---&gt QUERY MGMTCLASS F=D                     *"
issu mess i "**************************************************"
issu mess i ""
issu mess i ""
q mgmtc f=d

issu mess i "**************************************************"
issu mess i "*** ---&gt 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 "*** ---&gt 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 "*** ---&gt 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 "*** ---&gt 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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8242091/viewspace-618037/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8242091/viewspace-618037/