IBM相關文件位置

=========
 TSM相關
=========
IBM Tivoli Storage Manager 5.5 版說明文件
http://publib.boulder.ibm.com/infocenter/tivihelp/v1r1/index.jsp

IBM Tivoli Storage Manager Version 6.2 information center
http://pic.dhe.ibm.com/infocenter/tsminfo/v6r2/index.jsp


IBM Tivoli Storage Manager 6.3 版資訊中心
http://pic.dhe.ibm.com/infocenter/tsminfo/v6r3/index.jsp

Installing the Tivoli Storage Manager Linux x86_64 client
http://pic.dhe.ibm.com/infocenter/tsminfo/v6r3/index.jsp?topic=%2Fcom.ibm.itsm.client.doc%2Ft_inst_linuxx86client.html

Configure the Tivoli Storage Manager client
http://pic.dhe.ibm.com/infocenter/tsminfo/v6r3/index.jsp?topic=%2Fcom.ibm.itsm.client.doc%2Ft_inst_linuxx86client.html


ANS4042E Unrecognized characters during backup of data from Linux clients

http://www-01.ibm.com/support/docview.wss?uid=swg21290640

==========
 TS3500相關
==========
IBM System Storage TS3500 Tape Library Information Center
http://publib.boulder.ibm.com/infocenter/ts3500tl/v1r0/index.jsp?topic=%2Fcom.ibm.storage.ts3500.doc%2Fts3500_ichome.html

Resolving errors with the Ultrium tape drives
http://publib.boulder.ibm.com/infocenter/ts3500tl/v1r0/index.jsp?topic=%2Fcom.ibm.storage.ts3500.doc%2Fopg_3584_a69m4bfs0.html

TSM SQL常用語法

找尋還有哪些Volumes還是Scratch
SELECT STATUS, VOLUME_NAME FROM LIBVOLUMES WHERE STATUS='Scratch'

找尋有Error的Volumes
SELECT VOLUME_NAME, WRITE_ERRORS, READ_ERRORS FROM VOLUMES WHERE WRITE_ERRORS>1 OR READ_ERRORS>1

找尋沒有並置群組的Node
SELECT NODE_NAME,CONTACT,DOMAIN_NAME FROM NODES WHERE COLLOCGROUP_NAME IS NULL

找尋磁帶內有哪些Node資料
SELECT NODE_NAME, STGPOOL_NAME, VOLUME_NAME FROM VOLUMEUSAGE WHERE VOLUME_NAME='XXXXXX'

找尋磁帶內Node的詳細資料
SELECT FILE_NAME, FILESPACE_NAME, NODE_NAME, VOLUME_NAME FROM CONTENTS WHERE NODE_NAME='XXXXXX' AND VOLUME_NAME='YYYYYY'

找尋Node使用的磁帶
SELECT NODE_NAME, STGPOOL_NAME, VOLUME_NAME FROM VOLUMEUSAGE WHERE NODE_NAME='XXXXXX'

找尋檔案在哪捲磁帶
SELECT FILE_NAME, FILESPACE_NAME, NODE_NAME, VOLUME_NAME FROM CONTENTS WHERE FILE_NAME='AAA' AND FILESPACE_NAME='BBB' AND NODE_NAME='CCC' AND VOLUME_NAME='DDD'

!!!注意!!!，此指令耗費極久的搜尋時間

=============
  其餘相關指令
=============
SELECT DISTINCT =>橫列

DB2裡面需要查詢特定關鍵字則用%取代*
select * from VOLUMEUSAGE where node_name like '%NAGI%'

=============
 參考資料
=============
http://thobias.org/tsm/sql/index.html
http://www.tsmsql.com/query/5500/
http://www.lascon.co.uk/tsm-sql-queries.php#sqlnode

TSM client 啟動

nohup dsmc schedule 2> /dev/null &

tsmclient:2345:once:/usr/bin/dsmc sched > /dev/null 2>&1 # TSM scheduler