Folgende Befehle sind an der TSM Befehlszeile mittels “Cut and Paste” einzufügen und die Ergebnisse an tiri GmbH zu übermitteln.
Es ist zunächst sicherzustellen, dass keine alte Version des Skripts existiert und die Löschung mit “Y” zu bestätigen.
DELETE SCRIPT TIRI_STATUS
Ferner ist die Summary Retention auf mindestens 30 Tage anzupassen.
set summaryret 30
Jetzt wird das tiri_status Skript neu definiert.
DEFINE SCRIPT TIRI_STATUS descr="*** tiri GmbH * Status Informationen * www.tiri.li ***" UPDATE SCRIPT TIRI_STATUS "audit license" UPDATE SCRIPT TIRI_STATUS "issue message I '# TSM Datenbank + Recovery Log'" UPDATE SCRIPT TIRI_STATUS "q db f=d" UPDATE SCRIPT TIRI_STATUS "q dbvolume" UPDATE SCRIPT TIRI_STATUS "q log f=d" UPDATE SCRIPT TIRI_STATUS "q logvolume" UPDATE SCRIPT TIRI_STATUS "select date(end_time) as Datum, -" UPDATE SCRIPT TIRI_STATUS " decimal(bytes/1024/1024.0,12,3) as MB_DB_bkp -" UPDATE SCRIPT TIRI_STATUS " from summary -" UPDATE SCRIPT TIRI_STATUS " where activity='FULL_DBBACKUP' order by 1,2" UPDATE SCRIPT TIRI_STATUS "issue message I '# TSM Clients'" UPDATE SCRIPT TIRI_STATUS "q auditocc po=pri" UPDATE SCRIPT TIRI_STATUS "q auditocc po=copy" UPDATE SCRIPT TIRI_STATUS "q node f=d" UPDATE SCRIPT TIRI_STATUS "select entity as node_name, max(examined) -" UPDATE SCRIPT TIRI_STATUS " as cnt_Obj_online from summary -" UPDATE SCRIPT TIRI_STATUS " where activity='ARCHIVE' group by entity -" UPDATE SCRIPT TIRI_STATUS " order by 2 desc, 1" UPDATE SCRIPT TIRI_STATUS "select entity as node_name, max(affected) -" UPDATE SCRIPT TIRI_STATUS " as cnt_Obj_bkp from summary -" UPDATE SCRIPT TIRI_STATUS " where activity='ARCHIVE' group by entity -" UPDATE SCRIPT TIRI_STATUS " order by 2 desc, 1" UPDATE SCRIPT TIRI_STATUS "select entity as node_name, max(decimal(bytes/1024/1024.0,12,3)) -" UPDATE SCRIPT TIRI_STATUS " as max_GB_bkp from summary -" UPDATE SCRIPT TIRI_STATUS " where activity='ARCHIVE' group by entity -" UPDATE SCRIPT TIRI_STATUS " order by 2 desc" UPDATE SCRIPT TIRI_STATUS "select entity as node_name, sum(decimal(bytes/1024/1024.0,12,3)) -" UPDATE SCRIPT TIRI_STATUS " as total_GB_bkp from summary -" UPDATE SCRIPT TIRI_STATUS " where activity='ARCHIVE' group by entity -" UPDATE SCRIPT TIRI_STATUS " order by 2 desc" UPDATE SCRIPT TIRI_STATUS "select entity as Node_Name, -" UPDATE SCRIPT TIRI_STATUS " decimal(avg(bytes/1024/1024/1024.0),12,3) as avg_GB_bkp -" UPDATE SCRIPT TIRI_STATUS " from summary -" UPDATE SCRIPT TIRI_STATUS " where activity='BACKUP' or activity='ARCHIVE' -" UPDATE SCRIPT TIRI_STATUS " group by entity order by 2 desc" UPDATE SCRIPT TIRI_STATUS "select entity as Node, -" UPDATE SCRIPT TIRI_STATUS " max(cast((end_time-start_time) minutes as integer)) as duration -" UPDATE SCRIPT TIRI_STATUS " from summary -" UPDATE SCRIPT TIRI_STATUS " where activity='BACKUP' or activity='ARCHIVE' -" UPDATE SCRIPT TIRI_STATUS " group by entity -" UPDATE SCRIPT TIRI_STATUS " order by 2 desc" UPDATE SCRIPT TIRI_STATUS "select entity as Node_Name,examined,affected,-" UPDATE SCRIPT TIRI_STATUS " decimal(bytes/1024/1024.0,12,3) as MB_bkp from summary -" UPDATE SCRIPT TIRI_STATUS " where activity='BACKUP' or activity='ARCHIVE' -" UPDATE SCRIPT TIRI_STATUS " group by entity,affected,examined,bytes -" UPDATE SCRIPT TIRI_STATUS " order by 4 desc, 3, 2, 1" UPDATE SCRIPT TIRI_STATUS "select node_name,total_mb,backup_mb,archive_mb,spacemg_mb -" UPDATE SCRIPT TIRI_STATUS " from auditocc -" UPDATE SCRIPT TIRI_STATUS " order by 2 desc,3 desc,4 desc,1 desc" UPDATE SCRIPT TIRI_STATUS "select node_name,decimal(total_mb/1024/1024.0,12,3) as total_tb,-" UPDATE SCRIPT TIRI_STATUS " decimal(backup_mb/1024.0,12,3) as GB_bkp, -" UPDATE SCRIPT TIRI_STATUS " decimal(archive_mb/1024.0,12,3) as GB_arc from auditocc -" UPDATE SCRIPT TIRI_STATUS " order by 2 desc,3 desc,1 desc" UPDATE SCRIPT TIRI_STATUS "issue message I '# Schedules'" UPDATE SCRIPT TIRI_STATUS "q sched * t=a f=d" UPDATE SCRIPT TIRI_STATUS "q sched * * f=d" UPDATE SCRIPT TIRI_STATUS "issue message I '# Scripts'" UPDATE SCRIPT TIRI_STATUS "q script f=l" UPDATE SCRIPT TIRI_STATUS "issue message I '# Q SYS'" UPDATE SCRIPT TIRI_STATUS "q sys" UPDATE SCRIPT TIRI_STATUS "issue message I '# Copygroups'" UPDATE SCRIPT TIRI_STATUS "q copygr f=d" UPDATE SCRIPT TIRI_STATUS "q copygr t=a f=d" UPDATE SCRIPT TIRI_STATUS "issue message I '# Hardware'" UPDATE SCRIPT TIRI_STATUS "q library f=d" UPDATE SCRIPT TIRI_STATUS "q drive f=d" UPDATE SCRIPT TIRI_STATUS "q path f=d" UPDATE SCRIPT TIRI_STATUS "q libvol"
Das Skript ist dann mittels
RUN tiri_status > c:\tiri-(datum).txt
auszuführen.
Sofern der TSM Server auf einem Linux-System läuft, werden zusätzlich folgende Informationen benötigt:
cat /proc/scsi/TSM*
cd /opt/tivoli/tsm/devices/bin ./autoconf
Die Ausgabe zeigt sich dann in etwa wie folgt:
******************************************
* IBM TIVOLI STORAGE MANAGER *
* Autoconf Utility Program for Linux *
******************************************
Licensed Materials - Property of IBM
(C) Copyright IBM Corporation 2009. All rights reserved.
U.S. Government Users Restricted Rights - Use, duplication or disclosure
restricted by GSA ADP Schedule Contract with IBM Corporation.
-----------------------------------------------------------------------
| Note: To allow non-root users to use devices configured with |
| the Tivoli Storage Manager passthru driver, issue autoconf -g or |
| autoconf -a. Issue autoconf -? for more information on these options. |
-----------------------------------------------------------------------
Tivoli Tape Drives:
===================
Index Minor Host CHN ID LUN Type Vendor_ID Device_Serial_Number Product_ID Rev.
000 012 001 000 001 000 001 HP HUE0XXXXXX Ultrium 3-SCSI GXXX
001 013 002 000 002 000 001 HP HU10XXXXXX Ultrium 3-SCSI GXXX
Tivoli Medium Changer Devices:
==============================
Index Minor Host CHN ID LUN Type Vendor_ID Device_Serial_Number Product_ID Rev.
000 011 001 000 000 000 008 HP USXXXXXXXX MSL6000 Series 0520
cat /proc/scsi/IBM*
Die Ausgabe zeigt sich dann in etwa wie folgt:
IBMtape version: 3.0.5 IBMtape major number: 252 Attached Tape Devices: Number Model SN HBA FO Path 0 3573-TL 00X4UXXXXXXX_LL0 qla2xxx Primary 1 3573-TL 00X4UXXXXXXX_LL0 qla2xxx Alternate IBMtape version: 3.0.5 IBMtape major number: 252 Attached Tape Devices: Number Model SN HBA FO Path 0 ULT3580-TD3 1234567890 qla2xxx NA 1 ULT3580-TD3 1234567891 qla2xxx NA
Desweiteren sind die folgenden Dateien sinnvoll