########################## # LAST CHANGE : 15.12.2006 ########################## OS LEVEL TSM: 5.1 5.2 # Wichtig! # Vor allen commands /etc/set_adsm_vars sourcen # auf dem ADSM-Server (derzeit pluesch.intern.rzag.net) dann folgendes: ######################### # admin-programm aufrufen ######################### colon07:/ !# dsmadmc ADSTAR Distributed Storage Manager Command Line Administrative Interface - Version 3, Release 1, Level 0.5 (C) Copyright IBM Corporation, 1990, 1997, All Rights Reserved. Enter your user id: kutz Enter your password: Session established with server DUESENTRIEB: AIX-RS/6000 Server Version 3, Release 1, Level 2.16 Server date/time: 01.06.2001 11:17:12 Last access: 01.06.2001 11:06:56 adsm> ####################################### # help aufrufen - Sehr gut Dokumentiert ####################################### adsm> help 1 - Using Syntax Diagrams 2 - Entering Administrative Commands 3 - Using the Command-Line Interface 4 - Using the Server Console Session 5 - Using the Administrative Client Session 6 - Console Mode 7 - Mount Mode 8 - Batch Mode 9 - Interactive Mode 10 - Using Administrative Client Options 11 - Using Continuation Characters 12 - Redirecting Command Output to a File in Batch and Interactive Modes 13 - Using Macros to Issue Commands 14 - Using Commands Based on Privilege Class 15 - Commands Requiring System Privilege 16 - Commands Requiring Policy Privilege 17 - Commands Requiring Storage Privilege 18 - Commands Requiring Operator Privilege 19 - Commands Requiring Analyst Privilege 20 - Commands Any Administrator Can Issue ########## # sessions ########## adsm> q sess Sess Comm. Sess Wait Bytes Bytes Sess Platform Client Name Number Method State Time Sent Recvd Type ------ ------ ------ ------ ------- ------- ----- -------- -------------------- 4 Tcp/Ip Run 0 S 970 179 Admin AIX KUTZ 6 Tcp/Ip MediaW 2,5 M 6,7 K 618 Node TDP ORA-HELENE Oracle AIX ####### # mount ####### welche tapes sind gemounted? adsm> q mount ANR8330I 3590 volume 000022 is mounted R/O in drive DRIVE1 (/dev/rmt1), status: IN USE. ANR8330I 3590 volume 000033 is mounted R/W in drive DRIVE0 (/dev/rmt0), status: IN USE. ANR8334I 2 volumes found. ########## # prozesse ########## welche prozesse laufen aktuell? adsm> q proc Process Process Description Status Number -------- -------------------- ------------------------------------------------- 2 Space Reclamation Volume 000032 (storage pool SERVERSTGP), Moved Files: 0, Moved Bytes: 0, Unreadable Files: 0, Unreadable Bytes: 0. Current Physical File (bytes): 11,447,251,694 Current input volume: 000022. Current output volume: 000033. ######## # drives ######## welche drives sind online/offline? adsm> q drive Library Name Drive Name Device Type Device ON LINE ------------ ------------ ----------- ---------------- ------------------- 3494LIB DRIVE0 3590 /dev/rmt0 Yes 3494LIB DRIVE1 3590 /dev/rmt1 Yes ######## # actlog ######## activitylog adsm> q 01.06.2001 12:01:01 ANR8468I 3590 volume 000099 dismounted from drive DRIVE0 (/dev/rmt0) in library 3494LIB. 01.06.2001 12:01:41 ANR8337I 3590 volume 000175 mounted in drive DRIVE1 (/dev/rmt1). 01.06.2001 12:01:43 ANR1360I Output volume 000175 opened (sequence number 1). 01.06.2001 12:01:50 ANR8337I 3590 volume 000028 mounted in drive DRIVE0 (/dev/rmt0). 01.06.2001 12:02:14 ANR4554I Backed up 24048 of 584483 database pages. 01.06.2001 12:02:45 ANR4554I Backed up 68160 of 584483 database pages. 01.06.2001 12:03:15 ANR4554I Backed up 115776 of 584483 database pages. 01.06.2001 12:03:46 ANR4554I Backed up 162240 of 584483 database pages. 01.06.2001 12:04:14 ANR2017I Administrator KUTZ issued command: QIVE 01.06.2001 12:04:14 ANR2000E Unknown command - QIVE. 01.06.2001 12:04:15 ANR2017I Administrator KUTZ issued command: ROLLBACK 01.06.2001 12:04:16 ANR4554I Backed up 208192 of 584483 database pages. 01.06.2001 12:04:18 ANR2017I Administrator KUTZ issued command: QUERY DRIVE 01.06.2001 12:04:46 ANR4554I Backed up 255088 of 584483 database pages. 01.06.2001 12:04:58 ANR2017I Administrator KUTZ issued command: QUERY ACTLOG more... ( to continue, 'C' to cancel) ######## # cancel ######## cancel einer session adsm> cancel 21345 ########### # ausloggen ########### adsm> quit ANS8002I Highest return code was 2. ############################### # restore auf client ausfuehren ############################### . /etc/set_tsm_vars cd dsmc restore /import/filer2/pago/extern/home/* -sub=yes -latest dsmc rest /home/* -sub=yes For a restore which is not restartable, enter: dsmc rest /home/file?.c -sub=yes ########## # tapeutil ########## root@raffael /usr/tivoli/tsm/devices#> /usr/bin/tapeutil -f/dev/smc0 audit Initializing element status... root@raffael /usr/tivoli/tsm/devices#> tapeutil -f/dev/smc0 elementinfo Getting element information... Number of Robots .............. 1 First Robot Address ........... 0 Number of Slots ............... 22 First Slot Address ............ 1 Number of Import/Exports ...... 0 Number of Drives .............. 2 First Drive Address ........... 23 root@raffael /usr/tivoli/tsm/devices#> tapeutil -f/dev/smc0 position 20 Positioning to element, destination 20... root@raffael /usr/tivoli/tsm/devices#> tapeutil -f/dev/smc0 position 23 Positioning to element, destination 23... # tapeutil -? Usage: tapeutil [-f Device Subcommand [Subcommand ...]] General Subcommands: devinfo inquiry [Page] print "Text" reserve release reqsense reset logpage "Page" modepage "Page" qrypath resetpath disablepath "Primary | Alternate | Number" path checkpath enablepath "Primary | Alternate | Number" tur vpd fuser passthru loop [Count] sleep "Seconds" kill Medium Changer Subcommands: allow prevent audit [Address [Count]] devids mount [Slot] position "Destination" elementinfo unmount [Slot] move "Source" "Destination" inventory [-i | -v Volid] exchange "Source" "Dest1" "Dest2" Tape Subcommands: append bsf [Count] bsr [Count] autoload eof [Count] weof [Count] noautoload eofimm [Count] weofimm [Count] compress fsf [Count] fsr [Count] nocompress erg logsense load erase display "Message" mtdevice rewind read -d Destination [-c Count] qrypos retension write -s Source seod status rtest [-b Blocksize] [-c Count] [-r Repetition] offline parms wtest [-b Blocksize] [-c Count] [-r Repetition] rewoffl sync rwtest [-b Blocksize] [-c Count] [-r Repetition] unload volid "Name" setpos [Blockid] list sdp "Number" chgpart "Number" [Blockid] density idp qrypart sili prevent allow nosili Service Aid Subcommands: dump [Filename] fmrtape resetdrive ucode "Name" trcstop trcstart [-q | [-d Directory] [-n Files] [-s Size] [-D]] ############################ # deleting tapes offsite tsm ############################ The mtlib command to mount a tape: mtlib -l (library) -f /dev/rmtxx -m -V (volume) The tapeutil command (I think): tapeutil -f /dev/rmtxx erase unload The mtlib command to dismount an unloaded tape: mtlib -l (library) -f /dev/rmtxx -d ################ # halting server ################ login halt ################################################ # disable server - preventing clients to connect ################################################ disable sessions ################# # enable sessions ################# enable sessions ################### # abbrechen session ################### cancel session NUMMER oder cancel session all ####################### # check restore im gang ####################### q restore ################### # abbrechen restore ################### cancel restore ################ # disable events ################ disable events ############### # enable events ############### enable events ################# # aktive sessions ################# tsm: TSM>q session Sess Comm. Sess Wait Bytes Bytes Sess Platform Client Name Number Method State Time Sent Recvd Type ------ ------ ------ ------ ------- ------- ----- -------- -------------------- 96 Tcp/Ip Run 0 S 122.1 K 143 Admin Linux86 ADMIN 113 Tcp/Ip Run 0 S 26.3 K 143 Admin Linux86 ADMIN 128 Tcp/Ip Run 0 S 62.0 K 1.1 K Admin Linux86 ADMIN 129 Tcp/Ip IdleW 2 S 395.1 K 1.5 K Node AIX RAFFAEL 130 Tcp/Ip IdleW 0 S 10.3 K 556.4 M Node AIX RAFFAEL ############################## # setup tsm server auf raffael ############################## ############# # DNS Eintrag ############# tsm1.kutz.media-support.de ################## # Software Install ################## Software wird nach /usr/tivoli/tsm/server installiert Anpassung bin/dsmserv.opt (siehe im aktuelle VZ dsmserv.opt) enable webgui ################ # Client Install ################ rpm -i package name ######### # dsm.opt ######### SErvername tsm1 DOMAIN ALL-LOCAL ######### # dsm.sys ######### SErvername TSM1 COMMmethod TCPip TCPPort 1500 * TCPServeraddress tsm1.kutz.media-support.de TCPServeraddress 172.29.73.20 PASSWORDACCESS GENERATE ###################### # licence registrieren ###################### tsm: TSM>register license file=spacemgr.lic number=10 ANR2852I Current license information: ANR2853I New license information: ANR2827I Server is licensed to support Tivoli Space Manager for a quantity of 10. tsm: TSM>register license file=mgsyslan.lic number=10 ANR2852I Current license information: ANR2827I Server is licensed to support Tivoli Space Manager for a quantity of 10. ANR2853I New license information: ANR2827I Server is licensed to support Tivoli Space Manager for a quantity of 10. ANR2827I Server is licensed to support Managed System for LAN for a quantity of 10. tsm: TSM>register license file=drm.lic ANR2852I Current license information: ANR2827I Server is licensed to support Tivoli Space Manager for a quantity of 10. ANR2827I Server is licensed to support Managed System for LAN for a quantity of 10. ANR2853I New license information: ANR2827I Server is licensed to support Tivoli Space Manager for a quantity of 10. ANR2860I Server is licensed to support Tivoli Disaster Recovery Manager. ANR2827I Server is licensed to support Managed System for LAN for a quantity of 10. tsm: TSM>register license file=libshare.lic number=1 ANR2852I Current license information: ANR2827I Server is licensed to support Tivoli Space Manager for a quantity of 10. ANR2860I Server is licensed to support Tivoli Disaster Recovery Manager. ANR2827I Server is licensed to support Managed System for LAN for a quantity of 10. ANR2853I New license information: ANR2827I Server is licensed to support Tivoli Space Manager for a quantity of 10. ANR2860I Server is licensed to support Tivoli Disaster Recovery Manager. ANR2828I Server is licensed to support Tape Library Sharing. ANR2827I Server is licensed to support Managed System for LAN for a quantity of 10. tsm: DUESENTRIEB>register lic file=domino.lic number=3 ANR2852I Current license information: ANR2860I Server is licensed to support Tivoli Disaster Recovery Manager. ANR2827I Server is licensed to support Tivoli Data Protection for Oracle for a quantity of 10. ANR2827I Server is licensed to support Tivoli Data Protection for Lotus Domino for a quantity of 1. ANR2828I Server is licensed to support Tape Library Sharing. ANR2827I Server is licensed to support Managed System for LAN for a quantity of 90. ANR2827I Server is licensed to support Managed Library for a quantity of 1. ANR2853I New license information: ANR2860I Server is licensed to support Tivoli Disaster Recovery Manager. ANR2827I Server is licensed to support Tivoli Data Protection for Oracle for a quantity of 10. ANR2827I Server is licensed to support Tivoli Data Protection for Lotus Domino for a quantity of 3. ANR2828I Server is licensed to support Tape Library Sharing. ANR2827I Server is licensed to support Managed System for LAN for a quantity of 90. ANR2827I Server is licensed to support Managed Library for a quantity of 1. ########################### # registrierung der clients ########################### per webgui http://tsm1.kutz.media-support.de:1580 - operation view - manage nodes - add new node eintraege vornehmen ################################# # erstellung database filesysteme ################################# mkvg -f -B -y'tsm01_VG' -s'16' '-n' hdisk4 hdisk5 hdisk6 hdisk7 hdisk8 hdisk9 hdisk10 hdisk11 chvg -a y tsm01_VG # mklv -y'tsm01_LV' -t'jfs2' tsm01_VG 32 tsm01_LV # crfs -v jfs2 -d tsm01_LV -m /tsm/database/primary -a logname=INLINE -A yes # mklv -y'tsm02_LV' -t'jfs2' tsm01_VG 32 tsm01_LV # crfs -v jfs2 -d tsm02_LV -m /tsm/log/primary -a logname=INLINE -A yes # mklv -y'tsm01mir_LV' -t'jfs2' tsm01_VG 1500 tsm01mir_LV # mklv -y'tsm02mir_LV' -t'jfs2' tsm01_VG 300 tsm02mir_LV # crfs -v jfs2 -d tsm01mir_LV -m /tsm/database/copy -a logname=INLINE -A yes mkfs completed successfully. 24542276 kilobytes total disk space. New File System size is 49152000 # crfs -v jfs2 -d tsm02mir_LV -m /tsm/log/copy -a logname=INLINE -A yes mkfs completed successfully. 4895388 kilobytes total disk space. New File System size is 9830400 # mklv -y'tsm3lv' -t'jfs2' tsm01_VG 1500 tsm3lv # crfs -v jfs2 -d tsm3lv -m /tsm/stgpool/primary -a logname=INLINE -A yes mkfs completed successfully. 24542276 kilobytes total disk space. New File System size is 49152000 # mklv -y tsm4lv -t'jfs2' tsm01_VG 64 tsm4lv # crfs -v jfs2 -d tsm4lv -m /tsm/dbvolume/backup -a logname=INLINE -A yes mkfs completed successfully. 1044244 kilobytes total disk space. New File System size is 2097152 # mklv -y'tsm5lv' -t'jfs2' tsm01_VG 1000 tsm5lv # crfs -v jfs2 -d tsm5lv -m /tsm/stgpool/disktape -a logname=INLINE -A yes mkfs completed successfully. 16350528 kilobytes total disk space. New File System size is 32768000 root@raffael /tsm#> mount /tsm/database/primary root@raffael /tsm#> mount /tsm/log/primary root@raffael /tsm#> mount /tsm/log/copy root@raffael /tsm#> mount /tsm/database/copy root@raffael /tsm#> mount /tsm/stgpool/primary root@raffael /tsm#> mount /tsm/stgpool/disktape root@raffael /tsm#> mount /tsm/dbvolume/backup root@raffael /tsm#> lsvg tsm01_VG VOLUME GROUP: tsm01_VG VG IDENTIFIER: 004d71aa00004c00000000f7edef58d2 VG STATE: active PP SIZE: 16 megabyte(s) VG PERMISSION: read/write TOTAL PPs: 3216 (51456 megabytes) MAX LVs: 512 FREE PPs: 164 (2624 megabytes) LVs: 8 USED PPs: 3052 (48832 megabytes) OPEN LVs: 7 QUORUM: 7 TOTAL PVs: 12 VG DESCRIPTORS: 12 STALE PVs: 0 STALE PPs: 0 ACTIVE PVs: 12 AUTO ON: yes MAX PPs per PV: 1016 MAX PVs: 128 LTG size: 128 kilobyte(s) AUTO SYNC: no HOT SPARE: no root@raffael /tsm#> lsvg -l tsm01_VG tsm01_VG: LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT tsm3lv jfs2 1500 1500 6 open/syncd /tsm/stgpool/primary loglv00 jfs2log 1 1 1 closed/syncd N/A tsm4lv jfs2 159 159 3 open/syncd /tsm/dbvolume/backup tsm1mirlv jfs2 65 65 2 open/syncd /tsm/dbvolume/copy tsm2mirlv jfs2 65 65 2 open/syncd /tsm/logvolume/copy tsm1lv jfs2 131 131 2 open/syncd /tsm/dbvolume/primary tsm2lv jfs2 131 131 2 open/syncd /tsm/logvolume/primary tsm5lv jfs2 1000 1000 5 open/syncd /tsm/stgpool/disktape root@raffael /tsm#> lsvg -p tsm01_VG tsm01_VG: PV_NAME PV STATE TOTAL PPs FREE PPs FREE DISTRIBUTION hdisk4 active 268 0 00..00..00..00..00 hdisk5 active 268 0 00..00..00..00..00 hdisk6 active 268 0 00..00..00..00..00 hdisk7 active 268 0 00..00..00..00..00 hdisk8 active 268 0 00..00..00..00..00 hdisk9 active 268 42 00..00..00..00..42 hdisk10 active 268 0 00..00..00..00..00 hdisk11 active 268 0 00..00..00..00..00 hdisk12 active 268 0 00..00..00..00..00 hdisk13 active 268 0 00..00..00..00..00 hdisk14 active 268 0 00..00..00..00..00 hdisk17 active 268 122 15..00..00..53..54 ################## # define dbvolumes ################## root@raffael /usr/tivoli/tsm/client/ba/bin#> . /etc/set_tsm_vars root@raffael /usr/tivoli/tsm/client/ba/bin#> dsmadmc Tivoli Storage Manager Command Line Administrative Interface - Version 5, Release 1, Level 0.0 (C) Copyright IBM Corporation 1990, 2002 All Rights Reserved. Enter your user id: admin Enter your password: Session established with server TSM: AIX-RS/6000 Server Version 5, Release 1, Level 0.0 Server date/time: 09/29/03 18:02:09 Last access: 09/29/03 17:08:16 tsm: TSM>define dbvolume /tsm/database/primary/file01 formatsize=509 wait=yes ANR0984I Process 5 for DEFINE DBVOLUME started in the FOREGROUND at 18:05:15. ANR7860W Insufficient Space Available for file /tsm/database/primary/file01. ANR0985I Process 5 for DEFINE DBVOLUME running in the FOREGROUND completed with completion state FAILURE at 18:05:15. ANS8001I Return code 14. tsm: TSM>define dbvolume /tsm/database/primary/file01 formatsize=509 wait=yes ANR0984I Process 6 for DEFINE DBVOLUME started in the FOREGROUND at 18:05:48. ANR2240I Database volume /tsm/database/primary/file01 defined. ANR0986I Process 6 for DEFINE DBVOLUME running in the FOREGROUND processed 1 items for a total of 25,062,014,976 bytes with a completion state of SUCCESS at 19:02:40. #################### # vergroessern dbvol #################### extend db 52 -> vergroesser tdb um 52 MB vorher mit q dbvol f=d pruefen, ob noch Platz vorhanden ist. ################## # define logvolume ################## tsm: TSM>define logvol /tsm/log/primary/file01 formatsize=509 wait=yes ANR0984I Process 9 for DEFINE LOGVOLUME started in the FOREGROUND at 18:22:48. ANR2260I Recovery log volume /tsm/log/primary/file01 defined. ANR0986I Process 9 for DEFINE LOGVOLUME running in the FOREGROUND processed 1 items for a total of 5,004,853,248 bytes with a completion state of SUCCESS at 18:34:36. #################### # logmode einstellen #################### tsm: TSM>set logmode rollforward Session established with server TSM: AIX-RS/6000 Server Version 5, Release 1, Level 0.0 Server date/time: 09/29/2003 21:53:02 Last access: 09/29/2003 18:20:11 ANR2294I Log mode set to ROLLFORWARD. ######## # status ######## tsm: TSM>q status Storage Management Server for AIX-RS/6000 - Version 5, Release 1, Level 0.0 Server Name: TSM Server host name or IP address: Server TCP/IP port number: 1500 Server URL: Crossdefine: Off Server Password Set: No Server Installation Date/Time: 09/21/2003 15:20:19 Server Restart Date/Time: 09/26/2003 10:35:19 Authentication: On Password Expiration Period: 90 Day(s) Invalid Sign-on Attempt Limit: 0 Minimum Password Length: 0 WEB Admin Authentication Time-out (minutes): 10 Registration: Closed Subfile Backup: No Availability: Enabled Accounting: Off Activity Log Retention Period: 1 Day(s) Activity Summary Retention Period: 30 Day(s) License Audit Period: 30 Day(s) Last License Audit: 09/21/2003 15:20:56 Server License Compliance: FAILED Central Scheduler: Active Maximum Sessions: 25 Maximum Scheduled Sessions: 12 Event Record Retention Period: 10 Day(s) Client Action Duration: 5 Day(s) Schedule Randomization Percentage: 25 Query Schedule Period: Client Maximum Command Retries: Client Retry Period: Client Scheduling Modes: Any Log Mode: RollForward Database Backup Trigger: Not Defined BufPoolSize: 2,048 K Active Receivers: CONSOLE ACTLOG Configuration manager?: Off Refresh interval: 60 Last refresh date/time: Context Messaging: Off Server Free Status: Not Supported ################## # database trigger ################## tsm: TSM>define spacetrigger db fullpct=85 spaceexpansion=25 expansionprefix=/ts m/database/primary/ maximumsize=1000 ANR2274I Data Base Space trigger defined and enabled. tsm: TSM> tsm: DUESENTRIEB>define spacetrigger db fullpct=97 spaceexpansion=100 expansionp refix=/usr/tivoli/tsm/server/db/ tsm: DUESENTRIEB>upd spacetrigger db maximumsize=9800 tsm: DUESENTRIEB>q spacetrigger db DB Full DB Space DB Expans- DB Maximum Percentage Expansion ion prefix Size (Mega- Percentage bytes) ---------- ---------- ---------- ----------- 97 100 /usr/tivo- 9.800 li/tsm/s- erver/db/ ######## # actlog ######## query actlog tsm: TSM>query actlog Date/Time Message -------------------- ---------------------------------------------------------- 09/29/2003 21:35:29 ANR2841W Server is NOT IN COMPLIANCE with license terms. 09/29/2003 21:53:02 ANR0407I Session 1004 started for administrator ADMIN (Linux86) (Tcp/Ip 172.29.73.19(33182)). 09/29/2003 21:53:03 ANR2017I Administrator ADMIN issued command: SET LOGMODE rollforward 09/29/2003 21:53:03 ANR2294I Log mode set to ROLLFORWARD. 09/29/2003 21:54:29 ANR2017I Administrator ADMIN issued command: DEFINE DBBACKUPTRIGGER devclass=3570 logfullpct=75 numincr=6 09/29/2003 21:54:29 ANR2351E DEFINE DBBACKUPTRIGGER: Device class 3570 is not defined. 09/29/2003 21:54:29 ANR2017I Administrator ADMIN issued command: ROLLBACK 09/29/2003 21:55:05 ANR2017I Administrator ADMIN issued command: QUERY STATUS 09/29/2003 21:58:09 ANR0405I Session 1004 ended for administrator ADMIN (Linux86). 09/29/2003 21:58:27 ANR0407I Session 1005 started for administrator ADMIN (Linux86) (Tcp/Ip 172.29.73.19(33183)). 09/29/2003 21:58:33 ANR2017I Administrator ADMIN issued command: DEFINE SPACETRIGGER db fullpct=85 spaceexpansion=25 expansionprefix=/tsm/database/primary/ maximumsize=1000 09/29/2003 21:58:33 ANR2274I Data Base Space trigger defined and enabled. ############################ # space trigger recovery log ############################ tsm: TSM>define spacetrigger log fullpct=75 spaceexpansion=30 expansionprefix=/t sm/log/primary/ maximumsize=500 ANR2279I Recovery Log Space trigger defined and enabled. ################ # query dbvolume ################ tsm: TSM>query dbvolume Volume Name Copy Volume Name Copy Volume Name Copy (Copy 1) Status (Copy 2) Status (Copy 3) Status ---------------- ------ ---------------- ------ ---------------- ------ /usr/tivoli/tsm- Sync'd Undef- Undef- /server/bin/db- ined ined .dsm /tsm/database/p- Sync'd Undef- Undef- rimary/file01 ined ined ######################### # mirror anlegen dbvolume ######################### root@raffael /tsm/database#> dsmfmt -db /tsm/database/copy/file01 509 by AIX Server DSMFMT Extent/Volume Formatting Program Licensed Materials - Property of IBM 5698-ISE (C) Copyright IBM Corporation 1990, 2002. All rights reserved. U.S. Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corporation. Actual allocation for /tsm/database/copy/file01 will be 23901 MB tsm: TSM>define dbcopy /tsm/database/primary/file01 /tsm/database/copy/file01 ANR2241I Database volume copy /tsm/database/copy/file01 defined. tsm: TSM>query dbvolume Volume Name Copy Volume Name Copy Volume Name Copy (Copy 1) Status (Copy 2) Status (Copy 3) Status ---------------- ------ ---------------- ------ ---------------- ------ /usr/tivoli/tsm- Sync'd Undef- Undef- /server/bin/db- ined ined .dsm /tsm/database/p- Sync'd /tsm/database/c- Sync'd Undef- rimary/file01 opy/file01 ined tsm: DUESENTRIEB>define dbcopy /usr/tivoli/tsm/server/db/db4.dsm /usr/tivoli/tsm /server/dbcopy/db4.dsm formatsize=1024 wait=yes ANR2241I Database volume copy /usr/tivoli/tsm/server/dbcopy/db4.dsm defined. ################ # mirror logfile ################ root@raffael /tsm#> dsmfmt -log /tsm/log/copy/file01 4770 by AIX Server DSMFMT Extent/Volume Formatting Program Licensed Materials - Property of IBM 5698-ISE (C) Copyright IBM Corporation 1990, 2002. All rights reserved. U.S. Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corporation. Actual allocation for /tsm/log/copy/file01 will be 4773 MB tsm: TSM>define logcopy /tsm/log/primary/file01 /tsm/log/copy/file01 Session established with server TSM: AIX-RS/6000 Server Version 5, Release 1, Level 0.0 Server date/time: 09/29/2003 22:54:00 Last access: 09/29/2003 21:53:02 ANR2261I Recovery log volume copy /tsm/log/copy/file01 defined. tsm: TSM>query logvolume Volume Name Copy Volume Name Copy Volume Name Copy (Copy 1) Status (Copy 2) Status (Copy 3) Status ---------------- ------ ---------------- ------ ---------------- ------ /usr/tivoli/tsm- Sync'd Undef- Undef- /server/bin/lo- ined ined g.dsm /tsm/log/primar- Sync'd /tsm/log/copy/f- Sync'd Undef- y/file01 ile01 ined ########################## # loeschen alter dbvolumes ########################## tsm: TSM>delete dbvolume /usr/tivoli/tsm/server/bin/db.dsm ANR2244I Delete process initiated for database volume /usr/tivoli/tsm/server/bin/db.dsm (process id 19). ANS8003I Process number 19 started. tsm: TSM>q proc Process Process Description Status Number -------- -------------------- ------------------------------------------------- 19 Database Volume Volume /usr/tivoli/tsm/server/bin/db.dsm - 4 Deletion megabytes of 16 ########################### # loeschen alter logvolumes ########################### tsm: TSM>delete logvolume /usr/tivoli/tsm/server/bin/log.dsm ANR2264I Delete process initiated for recovery log volume /usr/tivoli/tsm/server/bin/log.dsm (process id 20). ANS8003I Process number 20 started. ######################### # define library for tape ######################### vorher scsi-id herausfinden smitty devices --> Tivoli Storage Manager Devices --> SCSI Attached Devices --> Tape Drive --> Add a Tape Drive tsm: TSM>define library m8mm libtype=manual ANR8400I Library M8MM defined. tsm: TSM>define drive m8mm drv0 ANR8404I Drive DRV0 defined in library M8MM. tsm: TSM>q drive Library Name Drive Name Device Type On-Line ------------ ------------ ----------- ------------------- M8MM DRV0 UNKNOWN Yes tsm: TSM>define path tsm drv0 srctype=server desttype=drive library=m8mm device= /dev/mt0 online=yes ANR1720I A path from TSM to M8MM DRV0 has been defined. tsm: TSM>q drive Library Name Drive Name Device Type On-Line ------------ ------------ ----------- ------------------- M8MM DRV0 8MM Yes tsm: TSM>define devclass tapeclass devtype=8mm format=8500 library=m8mm ANR2203I Device class TAPECLASS defined. tsm: TSM>q devclass Device Device Storage Device Format Est/Max Mount Class Access Pool Type Capacity Limit Name Strategy Count (MB) --------- ---------- ------- --------- ------ -------- ------ DISK Random 3 TAPECLASS Sequential 1 8MM 8500 DRIVES tsm: TSM>define stgpool tapepool tapeclass maxscratch=20 ANR2200I Storage pool TAPEPOOL defined (device class TAPECLASS). tsm: TSM>q stgpool Storage Device Estimated Pct Pct High Low Next Stora- Pool Name Class Name Capacity Util Migr Mig Mig ge Pool (MB) Pct Pct ----------- ---------- ---------- ----- ----- ---- --- ----------- ARCHIVEPOOL DISK 0.0 0.0 0.0 90 70 BACKUPPOOL DISK 0.0 0.0 0.0 90 70 SPACEMGPOOL DISK 0.0 0.0 0.0 90 70 TAPEPOOL TAPECLASS 0.0 0.0 0.0 90 70 ############ # label tape ############ tsm: TSM>label libvolume m8mm dsm001 ANS8003I Process number 11 started. tsm: TSM>q actlog 09/30/03 10:44:47 ANR2017I Administrator ADMIN issued command: LABEL libvolume m8mm dsm001 09/30/03 10:44:47 ANR0984I Process 11 for LABEL LIBVOLUME started in the BACKGROUND at 10:44:47. 09/30/03 10:44:47 ANR8799I LABEL LIBVOLUME: Operation for library M8MM started as process 11. 09/30/03 10:44:47 ANR8326I 001: Mount 8MM volume DSM001 R/W in drive DRV0 (/dev/mt0) of library M8MM within 60 minutes. 09/30/03 10:46:27 ANR8372I 001: Remove 8MM volume DSM001 from drive DRV0 more... ( to continue, 'C' to cancel) (/dev/mt0) of library M8MM. 09/30/03 10:46:27 ANR1434W No files have been identified for automatically storing device configuration information. 09/30/03 10:46:27 ANR8800I LABEL LIBVOLUME for volume DSM001 in library M8MM completed successfully. 09/30/03 10:46:27 ANR0985I Process 11 for LABEL LIBVOLUME running in the BACKGROUND completed with completion state SUCCESS at 10:46:27. ##################### # define vols in pool ##################### tsm: TSM>define volume tapepool dsm001 ANR2206I Volume DSM001 defined in storage pool TAPEPOOL (device class TAPECLASS). ############################## # update stgpools set nextpool ############################## tsm: TSM>q stgpool Storage Device Estimated Pct Pct High Low Next Stora- Pool Name Class Name Capacity Util Migr Mig Mig ge Pool (MB) Pct Pct ----------- ---------- ---------- ----- ----- ---- --- ----------- ARCHIVEPOOL DISK 0.0 0.0 0.0 90 70 BACKUPPOOL DISK 0.0 0.0 0.0 90 70 SPACEMGPOOL DISK 0.0 0.0 0.0 90 70 TAPEPOOL TAPECLASS 0.0 0.0 0.0 90 70 tsm: TSM>update stgpool archivepool nextstgpool=tapepool ANR2202I Storage pool ARCHIVEPOOL updated. tsm: TSM>update stgpool BACKUPPOOL nextstgpool=tapepool ANR2202I Storage pool BACKUPPOOL updated. tsm: TSM>update stgpool SPACEMGPOOL nextstgpool=tapepool ANR2202I Storage pool SPACEMGPOOL updated. tsm: TSM>q stgpool Storage Device Estimated Pct Pct High Low Next Stora- Pool Name Class Name Capacity Util Migr Mig Mig ge Pool (MB) Pct Pct ----------- ---------- ---------- ----- ----- ---- --- ----------- ARCHIVEPOOL DISK 0.0 0.0 0.0 90 70 TAPEPOOL BACKUPPOOL DISK 0.0 0.0 0.0 90 70 TAPEPOOL SPACEMGPOOL DISK 0.0 0.0 0.0 90 70 TAPEPOOL TAPEPOOL TAPECLASS 0.0 0.0 0.0 90 70 ##################### # define disk stgpool ##################### tsm: TSM>define stgpool diskdata disk description="Data Storage" high=70 low=30 ANR2200I Storage pool DISKDATA defined (device class DISK). define volume diskdata /tsm/stgpool/diskdata1.dsm formatsize=50 ######################### # define disktape stgpool ######################### tsm: TSM>define stgpool disktape disk description="Data Storage for Migration" h igh=70 low=30 ANR2200I Storage pool DISKTAPE defined (device class DISK). tsm: TSM>define volume disktape /tsm/stgpool/disktape/disktape1.dsm formatsize=1 5960 ANR2491I Volume Creation Process starting for /tsm/stgpool/disktape/disktape1.dsm, Process Id 64. ################### # define new policy ################### tsm: TSM>copy domain standard dir2tape ANR1503I Policy domain STANDARD copied to domain DIR2TAPE. tsm: TSM>update copygroup dir2tape standard standard destination=tapepool ANR1532I Backup copy group STANDARD updated in policy domain DIR2TAPE, set STANDARD, management class STANDARD. tsm: TSM>update copygroup dir2tape standard standard type=archive destination=ta pepool ANR1537I Archive copy group STANDARD updated in policy domain DIR2TAPE, set STANDARD, management class STANDARD. tsm: TSM>activate policyset dir2tape standard Do you wish to proceed? (Yes (Y)/No (N)) y ANR1514I Policy set STANDARD activated in policy domain DIR2TAPE. tsm: TSM>define domain server description="Server nodes" backretention=30 archr etention=365 ANR1500I Policy domain SERVER defined. tsm: TSM>define domain workstn description="Workstation nodes" backretention=30 archretention=365 ANR1500I Policy domain WORKSTN defined. tsm: TSM>define policyset server server description="Server nodes" ANR1510I Policy set SERVER defined in policy domain SERVER. tsm: TSM>define policyset workstn workstn description="Workstation nodes" ANR1510I Policy set WORKSTN defined in policy domain WORKSTN. tsm: TSM>define mgmtclass server server data migdestination=NONE \ cont> description="Default management class for server domain" ANR1520I Management class DATA defined in policy domain SERVER, set SERVER. tsm: TSM>assign defmgmtclass server server data ANR1538I Default management class set to DATA for policy domain SERVER, set SERVER. tsm: TSM>define mgmtclass workstn workstn data migdestination=NONE \ cont> description="Default management class for workstn domain" ANR1520I Management class DATA defined in policy domain WORKSTN, set WORKSTN. tsm: TSM>assign defmgmtclass workstn workstn data ANR1538I Default management class set to DATA for policy domain WORKSTN, set WORKSTN. tsm: TSM>define mgmtclass server server special migdestination=NONE \ cont> description="Special management class for server domain" ANR1520I Management class SPECIAL defined in policy domain SERVER, set SERVER. tsm: TSM>define mgmtclass server server image migdestination=NONE \ cont> description="Image management class for server domain" ANR1520I Management class IMAGE defined in policy domain SERVER, set SERVER. tsm: TSM>define mgmtclass workstn workstn special migdestination=NONE \ cont> description="Special management class for workstn domain" ANR1520I Management class SPECIAL defined in policy domain WORKSTN, set WORKSTN. tsm: TSM>define mgmtclass workstn workstn image migdestination=NONE \ cont> description="Image management class for workstn domain" ANR1520I Management class IMAGE defined in policy domain WORKSTN, set WORKSTN. tsm: TSM>define copygroup server server special type=Backup destination=backupda ta frequency=1 verexists=3 verdeleted=1 retextra=100 retonly=365 \ cont> mode=modified serialization=shrdynamic ANR1530I Backup copy group STANDARD defined in policy domain SERVER, set SERVER, management class SPECIAL. tsm: TSM>define copygroup server server image type=backup destination=backupdata \ cont> frequency=1 verexists=3 verdeleted=1 retextra=120 retonly=365 \ cont> mode=modified serialization=static ANR1530I Backup copy group STANDARD defined in policy domain SERVER, set SERVER, management class IMAGE. tsm: TSM>define copygroup workstn workstn special type=Backup \ cont> destination=backupdata frequency=1 verexists=2 verdeleted=1 retextra=30 \ cont> retonly=100 mode=modified serialization=shrdynamic ANR1530I Backup copy group STANDARD defined in policy domain WORKSTN, set WORKSTN, management class SPECIAL. tsm: TSM>define copygroup workstn workstn image type=backup \ cont> destination=backupdata frequency=1 verexists=3 verdeleted=1 retextra=12 0 retonly=365 mode=modified serialization=static ANR1530I Backup copy group STANDARD defined in policy domain WORKSTN, set WORKSTN, management class IMAGE. tsm: TSM>define copygroup server server data type=Backup destination=backupdata \ cont> frequency=1 verexists=1 verdeleted=1 retextra=100 retonly=365 \ cont> mode=modified serialization=shrstatic ANR1530I Backup copy group STANDARD defined in policy domain SERVER, set SERVER, management class DATA. tsm: TSM>define copygroup workstn workstn data type=Backup \ cont> destination=backupdata frequency=1 verexists=1 verdeleted=1 retextra=30 \ cont> retonly=100 mode=modified serialization=shrstatic ANR1530I Backup copy group STANDARD defined in policy domain WORKSTN, set WORKSTN, management class DATA. tsm: TSM>activate policyset server server ANR1554W DEFAULT Management class DATA in policy set SERVER SERVER does not have an ARCHIVE copygroup: files will not be archived by default if this set is activated. Do you wish to proceed? (Yes (Y)/No (N)) y ANR1554W DEFAULT Management class DATA in policy set SERVER SERVER does not have an ARCHIVE copygroup: files will not be archived by default if this set is activated. ANR1514I Policy set SERVER activated in policy domain SERVER. tsm: TSM>activate policyset workstn workstn ANR1554W DEFAULT Management class DATA in policy set WORKSTN WORKSTN does not have an ARCHIVE copygroup: files will not be archived by default if this set is activated. Do you wish to proceed? (Yes (Y)/No (N)) y ANR1554W DEFAULT Management class DATA in policy set WORKSTN WORKSTN does not have an ARCHIVE copygroup: files will not be archived by default if this set is activated. ANR1514I Policy set WORKSTN activated in policy domain WORKSTN. tsm: TSM>q domain Policy Activated Activated Number of Description Domain Policy Default Registered Name Set Mgmt Nodes Class --------- --------- --------- ---------- ------------------------ DIR2TAPE STANDARD STANDARD 0 Installed default policy domain. SERVER SERVER DATA 0 Server nodes STANDARD STANDARD STANDARD 4 Installed default policy domain. WORKSTN WORKSTN DATA 0 Workstation nodes tsm: TSM>delete domain standard Do you wish to proceed? (Yes (Y)/No (N)) y ANR1501I Policy domain STANDARD deleted. tsm: TSM>delete domain DIR2TAPE Do you wish to proceed? (Yes (Y)/No (N)) y ANR1501I Policy domain DIR2TAPE deleted. tsm: TSM>query domain Policy Activated Activated Number of Description Domain Policy Default Registered Name Set Mgmt Nodes Class --------- --------- --------- ---------- ------------------------ SERVER SERVER DATA 1 Server nodes WORKSTN WORKSTN DATA 3 Workstation nodes tsm: TSM>update node luzifer domain=WORKSTN ANR2063I Node LUZIFER updated. tsm: TSM>q node luzifer Node Name Platform Policy Domain Days Since Days Since Locked? Name Last Acce- Password ss Set ------------------------- -------- -------------- ---------- ---------- ------- LUZIFER Linux86 WORKSTN <1 6 No tsm: TSM>define schedule workstn workstn_nightly starttime=22:00 duration=3 \ cont> durunits=hours description="Nightly backup schedule for WORKSTN domain" ANR2500I Schedule WORKSTN_NIGHTLY defined in policy domain WORKSTN. tsm: TSM>query schedule Domain * Schedule Name Action Start Date/Time Duration Period Day ------------ - ---------------- ------ -------------------- -------- ------ --- WORKSTN WORKSTN_NIGHTLY Inc Bk 10/04/2003 22:00:00 3 H 1 D Any tsm: TSM>define association workstn workstn_nightly luzifer ANR2510I Node LUZIFER associated with schedule WORKSTN_NIGHTLY in policy domain WORKSTN. tsm: TSM>define schedule server backup_nightly starttime=23:00 duration=3 \ cont> durunits=hours description="Nightly backup schedule for SERVER domain" ANR2500I Schedule BACKUP_NIGHTLY defined in policy domain SERVER. tsm: TSM>query schedule Domain * Schedule Name Action Start Date/Time Duration Period Day ------------ - ---------------- ------ -------------------- -------- ------ --- SERVER BACKUP_NIGHTLY Inc Bk 10/17/2003 23:00:00 3 H 1 D Any WORKSTN WORKSTN_NIGHTLY Inc Bk 10/04/2003 22:00:00 3 H 1 D Any tsm: TSM>define schedule server server_nightly starttime=23:00 duration=3 \ cont> durunits=hours description="Nightly backup schedule for SERVER domain" ANR2500I Schedule SERVER_NIGHTLY defined in policy domain SERVER. tsm: TSM>update node raffael DOmain=server ANR2063I Node RAFFAEL updated. tsm: TSM>define association server server_nightly raffael ANR2510I Node RAFFAEL associated with schedule SERVER_NIGHTLY in policy domain SERVER. tsm: TSM>query association Policy Domain Name: WORKSTN Schedule Name: WORKSTN_NIGHTLY Associated Nodes: LUZIFER tsm: TSM>query event * * Scheduled Start Actual Start Schedule Name Node Name Status -------------------- -------------------- ------------- ------------- --------- 10/04/2003 22:00:00 WORKSTN_NIGH- LUZIFER Future TLY ############# # query nodes ############# tsm: TSM>q node Node Name Platform Policy Domain Days Since Days Since Locked? Name Last Acce- Password ss Set ------------------------- -------- -------------- ---------- ---------- ------- CLIENT (?) STANDARD 12 12 No LUZIFER Linux86 STANDARD <1 5 No RAFFAEL AIX STANDARD 3 5 No URIEL Linux86 STANDARD <1 5 No ############## # query domain ############## tsm: TSM>q domain Policy Activated Activated Number of Description Domain Policy Default Registered Name Set Mgmt Nodes Class --------- --------- --------- ---------- ------------------------ DIR2TAPE STANDARD STANDARD 0 Installed default policy domain. STANDARD STANDARD STANDARD 4 Installed default policy domain. ######### # console ######### dsmadmc -console -id=admin -password= tsm: TSM>query auditoccupancy License information as of last audit on 09/21/03 at 15:20:56. Node Name Backup Archive Space-Managed Total Storage Storage Storage Used Storage Used (MB) Used (MB) (MB) Used (MB) ----------------------------------- --------- --------- ------------- --------- CLIENT 0 0 0 0 URIEL 0 0 0 0 LUZIFER 0 0 0 0 RAFFAEL 0 0 0 0 tsm: TSM>query event * * Scheduled Start Actual Start Schedule Name Node Name Status -------------------- -------------------- ------------- ------------- --------- 10/05/2003 22:00:00 WORKSTN_NIGH- URIEL Future TLY 10/05/2003 22:00:00 WORKSTN_NIGH- LUZIFER Future TLY tsm: TSM>query session Sess Comm. Sess Wait Bytes Bytes Sess Platform Client Name Number Method State Time Sent Recvd Type ------ ------ ------ ------ ------- ------- ----- -------- -------------------- 3,085 Tcp/Ip Run 0 S 134.9 K 139 Admin AIX ADMIN 3,232 Tcp/Ip Run 0 S 7.5 K 555 Admin Linux86 ADMIN tsm: TSM>query status Storage Management Server for AIX-RS/6000 - Version 5, Release 1, Level 0.0 Server Name: TSM Server host name or IP address: Server TCP/IP port number: 1500 Server URL: Crossdefine: Off Server Password Set: No Server Installation Date/Time: 09/21/2003 15:20:19 Server Restart Date/Time: 09/26/2003 10:35:19 Authentication: On Password Expiration Period: 90 Day(s) Invalid Sign-on Attempt Limit: 0 Minimum Password Length: 0 WEB Admin Authentication Time-out (minutes): 10 Registration: Closed Subfile Backup: No Availability: Enabled Accounting: Off Activity Log Retention Period: 1 Day(s) Activity Summary Retention Period: 30 Day(s) more... ( to continue, 'C' to cancel) License Audit Period: 30 Day(s) Last License Audit: 09/21/2003 15:20:56 Server License Compliance: Valid Central Scheduler: Active Maximum Sessions: 25 Maximum Scheduled Sessions: 12 Event Record Retention Period: 10 Day(s) Client Action Duration: 5 Day(s) Schedule Randomization Percentage: 25 Query Schedule Period: Client Maximum Command Retries: Client Retry Period: Client Scheduling Modes: Any Log Mode: RollForward Database Backup Trigger: Not Defined BufPoolSize: 2,048 K Active Receivers: CONSOLE ACTLOG Configuration manager?: Off Refresh interval: 60 Last refresh date/time: Context Messaging: Off Server Free Status: Not Supported more... ( to continue, 'C' to cancel) Server Free Batch Size: tsm: TSM>q stg Storage Device Estimated Pct Pct High Low Next Stora- Pool Name Class Name Capacity Util Migr Mig Mig ge Pool (MB) Pct Pct ----------- ---------- ---------- ----- ----- ---- --- ----------- BACKUPDATA DISK 23,960.0 0.2 0.2 70 30 TAPEPOOL DBBACKUP CFILE 0.0 0.0 0.0 100 70 TAPEPOOL TAPECLASS 68,759.5 25.6 25.9 90 70 tsm: TSM>backup devconfig filenames=/tsm/bkup_deviceconfig_20031012 Do you wish to proceed? (Yes (Y)/No (N)) y ANR2393I BACKUP DEVCONFIG: Server device configuration information was written to /tsm/bkup_deviceconfig_20031012. #################### # mountwait erhoehen #################### tsm: TSM>update devclass tapeclass2 MOUNTW=9999 ANR2205I Device class TAPECLASS2 updated. ############################ # migration von disk zu tape ############################ tsm: TSM>update stg BACKUPDATA highmig=0 lowmig=0 ANR2202I Storage pool BACKUPDATA updated. tsm: TSM>q proc Process Process Description Status Number -------- -------------------- ------------------------------------------------- 13 Migration Disk Storage Pool BACKUPDATA, Moved Files: 0, Moved Bytes: 0, Unreadable Files: 0, Unreadable Bytes: 0. Current Physical File (bytes): 274,432 Waiting for mount of output volume DLT001 (79 seconds). ############### # register node ############### REGISTER NODE gabriel ?***? CONTACT="Admin User TSM gabriel" DOMAIN=WORKSTN AUTOFSRENAME=NO ARCHDELETE=YES BACKDELETE=NO FORCEPWRESET=NO TYPE=CLIENT KEEPMP=NO MAXNUMMP=2 URL=http://gabriel.kutz.media-support.de:1581 USERID=admin VALIDATEPROTOCOL=ALL ANR2060I Node GABRIEL registered in policy domain WORKSTN. ANR2099I Administrative userid ADMIN defined for OWNER access to node GABRIEL. tsm: TSM>q node gabriel Node Name Platform Policy Domain Days Since Days Since Locked? Name Last Acce- Password ss Set ------------------------- -------- -------------- ---------- ---------- ------- GABRIEL (?) WORKSTN <1 <1 No tsm: TSM>q node gabriel Node Name Platform Policy Domain Days Since Days Since Locked? Name Last Acce- Password ss Set ------------------------- -------- -------------- ---------- ---------- ------- GABRIEL WinME WORKSTN <1 <1 No tsm: TSM>define association workstn workstn_nightly gabriel ANR2510I Node GABRIEL associated with schedule WORKSTN_NIGHTLY in policy domain WORKSTN. ANR2017I Administrator ADMIN issued command: DEFINE ASSOCIATION workstn workstn_nightly gabriel ANR2510I Node GABRIEL associated with schedule WORKSTN_NIGHTLY in policy domain WORKSTN. ######################## # register database node ######################## register node vpdepot xxxxxxx DO=PAGO-DB ARCHDEL=yes BACKDEL=yes maxnummp=3 passexp=9999 ################### # register node kbw ################### register node susi xxxxxxx DO=pago-srv-kbw ARCHDEL=no BACKDEL=no maxnummp=3 passexp=9999 Session established with server DUESENTRIEB: AIX-RS/6000 Server Version 5, Release 1, Level 8.0 Server date/time: 25.08.2005 08:17:28 Last access: 25.08.2005 08:14:13 ANR2060I Node SUSI registered in policy domain PAGO-SRV-KBW. ANR2099I Administrative userid SUSI defined for OWNER access to node SUSI. ##################### # register notes node ##################### tsm: DUESENTRIEB>register node notes-s notes-s DO=NOTES maxnummp=3 passexp=9999 ANR2060I Node NOTES-S registered in policy domain NOTES. ANR2099I Administrative userid NOTES-S defined for OWNER access to node NOTES-S. #################### # migration schedule #################### tsm: TSM>define schedule migration_stop type=administrative \ cont> cmd="update stgpool backupdata hi=70 lo=30" starttime=10:00 \ cont> desc="Stop migration on DISKDATA storage pool" ANR2577I Schedule MIGRATION_STOP defined. tsm: TSM>define schedule migration_start type=administrative \ cont> cmd="update stgpool backupdata hi=0 lo=0" starttime=07:00 \ cont> description="Start migration on backupdata storage pool" Session established with server TSM: AIX-RS/6000 Server Version 5, Release 1, Level 0.0 Server date/time: 10/19/2003 01:04:35 Last access: 10/18/2003 18:54:56 ANR2577I Schedule MIGRATION_START defined. ################## # expire inventory ################## tsm: TSM>define schedule expire_inventory type=administrative \ cont> cmd="expire inventory" startt=17:00 \ cont> description="Inventory expiration" ANR2577I Schedule EXPIRE_INVENTORY defined. #################### # activate schedules #################### tsm: TSM>update schedule BACKUP_VOLHIST type=administrative active=yes ANR2532I Schedule BACKUP_VOLHIST updated. tsm: TSM>update schedule delete_VOLHIST type=administrative active=yes ANR2532I Schedule DELETE_VOLHIST updated. tsm: TSM>update schedule expire_inventory type=administrative active=yes ANR2532I Schedule EXPIRE_INVENTORY updated. tsm: TSM>update schedule RECLAIM_TAPEDATA_START type=administrative active=yes ANR2532I Schedule RECLAIM_TAPEDATA_START updated. tsm: TSM>update schedule RECLAIM_TAPEDATA_STOP type=administrative active=yes ANR2532I Schedule RECLAIM_TAPEDATA_STOP updated. #################### # define reclamation #################### define schedule RECLAIM_TAPEDATA_START type=admin \ description="Start reclaim on the TAPEDATA storage pool" \ cmd="update stg tapepool rec=40" starttime=17:00 active=yes define schedule RECLAIM_TAPEDATA_STOP type=admin \ description="Stop reclaim on the TAPEDATA storage pool" \ cmd="update stg tapepool rec=100" starttime=19:00 active=yes ################# # delete a client ################# tsm: TSM>remove node client Do you wish to proceed? (Yes (Y)/No (N)) y ANR2061I Node CLIENT removed from policy domain STANDARD. ANR2129I Administrative userid CLIENT defined ONLY for authority over node CLIENT has been removed. ################### # client option set ################### definitionen aus zusatz redbook entnehmen mac.clientoptions node zu client opt assignen per update node xyz clo=aix || linux || windows ########### # webclient ########### cd $DSM_DIR ./dsmcad http://machine:1581 ##################### # tape offline setzen ##################### update drive m8mm drv0 online=no #################### # tape online setzen #################### update drive m8mm drv0 online=yes ##################### # vergroessern logvol ##################### root@raffael /usr/tivoli/tsm/server/bin#> ./dsmfmt -log /usr/local/src/logvol/logvol1 100 TIVOLI STORAGE MANAGER by Tivoli AIX Server DSMFMT Extent/Volume Formatting Program Licensed Materials - Property of IBM 5698-ISE (C) Copyright IBM Corporation 1990, 2002. All rights reserved. U.S. Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corporation. Actual allocation for /usr/local/src/logvol/logvol1 will be 101 MB Allocated space for /usr/local/src/logvol/logvol1: 105906176 bytes root@raffael /usr/tivoli/tsm/server/bin#> dsmserv extend log /usr/local/src/logvol/logvol1 101 ANR7800I DSMSERV generated at 02:47:47 on Feb 22 2002. Tivoli Storage Manager for AIX-RS/6000 Version 5, Release 1, Level 0.0 Licensed Materials - Property of IBM 5698-ISE (C) Copyright IBM Corporation 1999,2002. All rights reserved. U.S. Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corporation. ANR0900I Processing options file dsmserv.opt. ANR0901W Invalid FILEEXIT statement found in file dsmserv.opt. ANR0906I Line No. : 1017 ANR0907I Statement : FILEEXIT NO ANR0908W Error : ........... ANR0901W Invalid USEREXIT statement found in file dsmserv.opt. ANR0906I Line No. : 1043 ANR0907I Statement : USEREXIT NO ANR0908W Error : ........... ANR0902W Unsupported keyword found in file dsmserv.opt. ANR0906I Line No. : 1362 ANR0907I Statement : SELFTUNEBUPOOLSIZE YES ANR0908W Error : |..................... ANR7811I Direct I/O will be used for all eligible disk files. ANR0200I Recovery log assigned capacity is 508 megabytes. ANR0201I Database assigned capacity is 764 megabytes. ANR0306I Recovery log volume mount in progress. ANR0984I Process 1 for EXTEND LOG started in the BACKGROUND at 09:49:59. ANR0307I Recovery log extend in progress; 4 megabytes of 104 formatted. ANR0307I Recovery log extend in progress; 8 megabytes of 104 formatted. ANR0307I Recovery log extend in progress; 12 megabytes of 104 formatted. ANR0307I Recovery log extend in progress; 16 megabytes of 104 formatted. ANR0307I Recovery log extend in progress; 20 megabytes of 104 formatted. ANR0307I Recovery log extend in progress; 24 megabytes of 104 formatted. ANR0307I Recovery log extend in progress; 28 megabytes of 104 formatted. ANR0307I Recovery log extend in progress; 32 megabytes of 104 formatted. ANR0307I Recovery log extend in progress; 36 megabytes of 104 formatted. ANR0307I Recovery log extend in progress; 40 megabytes of 104 formatted. ANR0307I Recovery log extend in progress; 44 megabytes of 104 formatted. ANR0307I Recovery log extend in progress; 48 megabytes of 104 formatted. ANR0307I Recovery log extend in progress; 52 megabytes of 104 formatted. ANR0307I Recovery log extend in progress; 56 megabytes of 104 formatted. ANR0307I Recovery log extend in progress; 60 megabytes of 104 formatted. ANR0307I Recovery log extend in progress; 64 megabytes of 104 formatted. ANR0307I Recovery log extend in progress; 68 megabytes of 104 formatted. ANR0307I Recovery log extend in progress; 72 megabytes of 104 formatted. ANR0307I Recovery log extend in progress; 76 megabytes of 104 formatted. ANR0307I Recovery log extend in progress; 80 megabytes of 104 formatted. ANR0307I Recovery log extend in progress; 84 megabytes of 104 formatted. ANR0307I Recovery log extend in progress; 88 megabytes of 104 formatted. ANR0307I Recovery log extend in progress; 92 megabytes of 104 formatted. ANR0307I Recovery log extend in progress; 96 megabytes of 104 formatted. ANR0307I Recovery log extend in progress; 100 megabytes of 104 formatted. ANR0307I Recovery log extend in progress; 104 megabytes of 104 formatted. ANR2268I Recovery log assigned capacity has been extended. ANR0988I Process 1 for EXTEND LOG running in the BACKGROUND processed 109,051,904 bytes with a completion state of SUCCESS at 09:50:36. ANR7835I The server thread 9 terminated in response to server shutdown. ANR7835I The server thread 10 terminated in response to server shutdown. ANR0991I Server shutdown complete. ####################### # query admin schedules ####################### tsm: TSM>q sched * type=admin * Schedule Name Start Date/Time Duration Period Day - ---------------- -------------------- -------- ------ --- AUDIT_LICENSE 10/09/2003 00:00:00 1 H 1 D Any BACKUP_DATABASE 10/04/2003 07:00:00 1 H 1 D Any BACKUP_VOLHIST 10/04/2003 07:05:00 1 H 1 D Any DELETE_VOLHIST 10/04/2003 07:00:00 1 H 1 D Any EXPIRE_INVENTORY 10/19/2003 17:00:00 1 H 1 D Any MIGRATION_START 10/19/2003 07:00:00 1 H 1 D Any MIGRATION_STOP 10/19/2003 10:00:00 1 H 1 D Any RECLAIM_TAPEDAT- 10/28/2003 17:00:00 1 H 1 D Any A_START RECLAIM_TAPEDAT- 10/28/2003 18:00:00 1 H 1 D Any A_STOP tsm: TSM>q sched backup_database type=admin f=d Schedule Name: BACKUP_DATABASE Description: Database backup Command: backup db devclass=cfile type=full Priority: 5 Start Date/Time: 10/04/2003 07:00:00 Duration: 1 Hour(s) Period: 1 Day(s) Day of Week: Any Expiration: Active?: Yes Last Update by (administrator): ADMIN Last Update Date/Time: 10/04/2003 10:33:35 Managing profile: tsm: TSM>q sched backup_volhist type=admin f=d Schedule Name: BACKUP_VOLHIST Description: Backup volume history file Command: backup volhistory Priority: 5 Start Date/Time: 10/04/2003 07:05:00 Duration: 1 Hour(s) Period: 1 Day(s) Day of Week: Any Expiration: Active?: No Last Update by (administrator): ADMIN Last Update Date/Time: 10/04/2003 10:37:33 Managing profile: tsm: TSM>q sched delete_volhist type=admin f=d Schedule Name: DELETE_VOLHIST Description: Delete volume history information for database backups Command: delete volhistory type=dbbackup todate=today-5 Priority: 5 Start Date/Time: 10/04/2003 07:00:00 Duration: 1 Hour(s) Period: 1 Day(s) Day of Week: Any Expiration: Active?: No Last Update by (administrator): ADMIN Last Update Date/Time: 10/04/2003 10:37:00 Managing profile: tsm: TSM>q sched EXPIRE_INVENTORY type=admin f=d Schedule Name: EXPIRE_INVENTORY Description: Inventory expiration Command: expire inventory Priority: 5 Start Date/Time: 10/19/2003 17:00:00 Duration: 1 Hour(s) Period: 1 Day(s) Day of Week: Any Expiration: Active?: No Last Update by (administrator): ADMIN Last Update Date/Time: 10/19/2003 01:34:26 Managing profile: tsm: TSM>q sched MIGRATION_START type=admin f=d Schedule Name: MIGRATION_START Description: Start migration on backupdata storage pool Command: update stgpool backupdata hi=0 lo=0 Priority: 5 Start Date/Time: 10/19/2003 07:00:00 Duration: 1 Hour(s) Period: 1 Day(s) Day of Week: Any Expiration: Active?: No Last Update by (administrator): ADMIN Last Update Date/Time: 10/19/2003 01:04:35 Managing profile: tsm: TSM>q sched MIGRATION_STop type=admin f=d Schedule Name: MIGRATION_STOP Description: Stop migration on DISKDATA storage pool Command: update stgpool backupdata hi=70 lo=30 Priority: 5 Start Date/Time: 10/19/2003 10:00:00 Duration: 1 Hour(s) Period: 1 Day(s) Day of Week: Any Expiration: Active?: No Last Update by (administrator): ADMIN Last Update Date/Time: 10/19/2003 01:06:01 Managing profile: tsm: TSM>q sched RECLAIM_TAPEDATA_start type=admin f=d Schedule Name: RECLAIM_TAPEDATA_START Description: Start reclaim on the TAPEPOOL storage pool Command: update stgpool tapepool reclaim=75 Priority: 5 Start Date/Time: 10/28/2003 17:00:00 Duration: 1 Hour(s) Period: 1 Day(s) Day of Week: Any Expiration: Active?: No Last Update by (administrator): ADMIN Last Update Date/Time: 10/28/2003 21:00:55 Managing profile: tsm: TSM>q sched RECLAIM_TAPEDATA_stop type=admin f=d Schedule Name: RECLAIM_TAPEDATA_STOP Description: Stop reclaim on the TAPEPOOL storage pool Command: update stgpool tapepool reclaim=100 Priority: 5 Start Date/Time: 10/28/2003 18:00:00 Duration: 1 Hour(s) Period: 1 Day(s) Day of Week: Any Expiration: Active?: No Last Update by (administrator): ADMIN Last Update Date/Time: 10/28/2003 21:01:43 Managing profile: ############## # spacetrigger ############## tsm: TSM>q spacetrigger log LOG Full LOG Space LOG Expan- LOG Maximum Percentage Expansion sion pref- Size (Mega- Percentage ix bytes) ---------- ---------- ---------- ----------- 75 30 /tsm/log/- 500 primary/ tsm: TSM>q spacetrigger db DB Full DB Space DB Expans- DB Maximum Percentage Expansion ion prefix Size (Mega- Percentage bytes) ---------- ---------- ---------- ----------- 85 25 /tsm/data- 1,000 base/pri- mary/ ################### # incl/excl fuer DB ################### DB-Maschinen: for i in `mount|grep oradata|awk '{print $2}'` do echo "exclude.dir $i" done for i in `mount|grep oralog|awk '{print $2}'` do echo "exclude.dir $i" done tsm: DUESENTRIEB>select domain_name,num_nodes from domains DOMAIN_NAME NUM_NODES ------------------ ----------- LANGZEITARCHIV 1 NOTES 1 PAGO-DB 9 PAGO-SRV 47 tsm: DUESENTRIEB>select platform_name,count(*)as "Number of Nodes" from nodes gr oup by platform_name PLATFORM_NAME Number of Nodes ---------------- --------------- 1 AIX 28 Linux86 8 SUN SOLARIS 12 TDP Oracle AIX 9 #################### # zeigt alle backups #################### tsm: DUESENTRIEB>select Entity,Successful,Bytes,Examined,Affected,Failed from su mmary where activity='BACKUP' and cast((current_timestamp-start _time)hours as decimal(8,0)) < 24 order by Entity ################################ # zeigt alle backups mit fehlern ################################ tsm: DUESENTRIEB>select Entity,Successful,Bytes,Examined,Affected,Failed from su mmary where activity='BACKUP' and failed>0 and cast((current_ti mestamp-start_time)hours as decimal(8,0)) < 24 order by Entity ############################ # zeigt tapes von einem node ############################ tsm: DUESENTRIEB>select distinct node_name,volume_name,stgpool_name from volumeu sage where node_name='nimdenbus' ################### # last volume write ################### tsm: DUESENTRIEB>select volume_name,last_write_date from volumes order by last_write_date ################### # library inventory ################### tsm: DUESENTRIEB>select home_element, volume_name from libvolumes order by home_ element ################################# # amount of backup from yesterday ################################# tsm: DUESENTRIEB>SELECT date(days(current_date)-1) AS "DATA date",entity AS node name,((sum(bytes)/1024)/1024) AS MB_backed_up FROM summary WHER E activity='BACKUP' AND days(current_date)-days(start_time)=1 G ROUP BY entity ORDER BY MB_backed_up DATA date NODENAME MB_BACKED_UP ---------- ------------------ --------------------------------- 2004-11-17 AMBOSS 0 2004-11-17 PAGO-AF2VP 0 2004-11-17 PAGO-AT1 0 2004-11-17 PAGO-SB1VP 0 2004-11-17 PAGO-SB3 0 2004-11-17 FEILE 4 2004-11-17 KLOPFER 6 2004-11-17 HAMMER 10 2004-11-17 PAGO-AM2 12 2004-11-17 KENNY 14 2004-11-17 PAGO-AB3 16 2004-11-17 DEVDEPOT 20 2004-11-17 PAGO-LM2 38 2004-11-17 PAGO-AF3 48 2004-11-17 PAGO-LF1VP 48 2004-11-17 HOBEL 50 2004-11-17 PAGO-AF4 50 2004-11-17 VPDEPOT 50 2004-11-17 PAGO-LF3 52 2004-11-17 PAGO-AD3 88 2004-11-17 PAGO-AF5 92 2004-11-17 STAN 125 2004-11-17 PAGO-LF4 175 2004-11-17 PAGO-AD1VP 180 2004-11-17 PAGO-LF1 243 2004-11-17 KRONOS 255 2004-11-17 PAGO-AB5 298 2004-11-17 WENDY 740 2004-11-17 PAGO-AD4 936 2004-11-17 PAGO-AD2 1269 2004-11-17 DEVNET 1347 2004-11-17 ERIC 2385 2004-11-17 PAGO-AM1 2543 2004-11-17 PAGO-SF1VP 2646 2004-11-17 NIMDENBUS 5504 2004-11-17 BAMBI 6793 2004-11-17 PAGO-LM1 9639 2004-11-17 VPNET 15716 2004-11-17 MNET 152764 2004-11-17 MDEPOT 350244 ########################### # volumes with write errors ########################### tsm: DUESENTRIEB>select volume_name, read_errors,write_errors from volumes where (read_errors>0 or write_errors>0) VOLUME_NAME READ_ERRORS WRITE_ERRORS ------------------ ----------- ------------ 000133 0 1 ########################################################## # find out how much data is held per full tape, on average ########################################################## tsm: DUESENTRIEB>SELECT STGPOOL_NAME AS STGPOOL,CAST(MEAN(EST_CAPACITY_MB/1024) AS DECIMAL(5,2)) AS GB_PER_FULL_VOL FROM VOLUMES WHERE STATUS=' FULL' GROUP BY STGPOOL_NAME STGPOOL GB_PER_FULL_VOL ------------------ --------------- TP.DBEXP 8.88 TP.DBPOOL_LOG 26.94 TP.MDEPOT_DB 27.23 TP.MDEPOT_LOG 25.09 TP.MNET_DB 25.49 TP.MNET_LOG 20.68 TP.SERVER 13.62 TP.TWISTERLOG 10.45 TP.VPDEPOT_DB 31.82 TP.VPNET_DB 26.51 ##################### # TSM Client commands ##################### Client commands can produce a lot of output that will scroll off the screen, so you may prefer to pipe them into a file. For example SHOW OPTTABLE > output.txt SHOW OPTIONS Displays the active client options. SHOW OPTTABLE You can configure a client so it can get its option settings from either the client option file or from the server. This command will tell you which one is in use for this client. SHOW SESSION Displays capabilities that this client has for this connection to the server. The client and server report and negotiate the capabilities that each has when a session is started by a client to a server. This show command reports the capabilities available by this server and client. SHOW TRACEFLAGS Use this to determine which trace options could be used for this client. SHOW VERSION Use this command to find out what release and version of TSM is installed. ################# # server commands ################# SHOW CONFIG This is one of the long running commands that produce lots of output. It actually issues a set of QUERY and SHOW commands then uses these to build a quite comprehensive picture of the state of the server. This command is worth running as a diagnostic data gathering exercise, to be analysed when free time permits. Commands to help with session or tape drive problems SHOW ASQUEUED If you have a client session or process stuck, it may be waiting for a drive. You can use this command to see if there are sessions queued waiting for mount points. SHOW DEVCLASS Is also useful if you have problems with drives. It displays the status of each device class, including the status of allocated drives. SHOW MP Useful for determining which volume is in-use by a given mount point and other attributes for the assigned mount points. SHOW ASVOL If you are having problems with sessions or processes queued, or waiting for tape volumes, then this command will display the in-memory list of assigned volumes. ####################################################### # Commands to help manage the database and recovery log ####################################################### SHOW BUFSTATS Use this command to see if you need to increase your database buffer pool size. Example output is Database Buffer Pool Statistics: Total Buffer Latch Requests: 184217213 Times Scavenging Required: 1123642 0.61% Times Scavenging by Stealing: 1105210 0.60% Times Scavenging by Waiting: 0 0.00% Times Read Required: 1123574 0.61% Cache Hit Percentage: 99.39% An associated command is SHOW BUFV, but it is less obvious what the output means. SHOW DBTXNT Use this command to displays the database transaction table. Sample output looks like Open objects: name ->AS.Segments<- (sp=0) name ->SS.Pools<- (sp=0) name ->SS.Pool.Ids<- (sp=0) name ->AF.Clusters<- (sp=0) Tsn=0:813772319 --> Valid=1, inRollback=0, endNTA=0, State=2, Index=10, LatchCount=0, SavePoint=0, TotLogRecs=0, TotLogBytes=0, UndoLogRecs=0, UndoLogBytes=0, LogReserve=0, PageReserve=0, Elapsed=346279 (secs), MinLsn=0.0.0, MaxLsn=0.0.0, LastLsn=0.0.0, UndoNextLsn=0.0.0, logWriter=False, backupTxn=False This is showing that this transaction has 4 database tables open, that the transaction is valid, and that it is not writing log records. SHOW DBV Displays database global attributes. SHow DBBACKUPVOLS Use this command to get details on the latest full and incremental database backup volumes. SHOW LOGPINNED You can use this command if your logfile is running out of space. The oldest active record in the log is \x{2018}pinning\x{2019} the log. This command will tell you what task owns that oldest record. You could follow this up with SHOW LOGPINNED CANCEL which will cancel whatever is holding the pinned record. This is one of those 'UPDATE' SHOW commands that you need to use with extreme care, and preferably after advice from Tivoli. However, if your log is rapidly filling up, will you have time to make that support call? It would be best to investigate and test this command before you need to use it in an emergency. The command is only available in TSM version 5.1.7.0 or above. Example output is Dirty page Lsn=4597153.124.2199, Last DB backup Lsn=4596680.43.3348, Transaction table Lsn=4597152.240.3249, Running DB backup Lsn=0.0.0, Log truncation Lsn=4596680.43.3348 Lsn=4596680.43.3348, Owner=DB, Length=194 Type=Update, Flags=C2, Action=ExtInsert, Page=2171054, Tsn=0:818261705, PrevLsn=4596680.43.3137, UndoNextLsn=0.0.0, UpdtLsn=4596680.43.3137 ===> ObjName=AS.Segments, Index=26, RootAddr=14, PartKeyLen=3, NonPartKeyLen=4, DataLen=87 The recovery log is pinned by the last data base backup. Space will not be freed until data base backup is run again. The command tells you that the log is pinned by a backup. LOGV You can use this command to display the recovery log global attributes, but it is less obvious what they all mean. SHOW LOGstats Use this command to see statistics on log usage. An associated command is SHOW LOGRESET This command will RESET the log statistics back to 0. Commands to help with session hangs SHOW LOCK If your TSM server is running very slow it is worth trying this command. A TSM server uses locks to serialise updates to prevent corruption. You use this command to see what resources are locked. SHOW RESQUEUE The TSM server monitors resource usage and will cancel any resource users that are holding onto resources for too long. You use the SHOW RESQUEUE command to display the resource queue and it will display information about transactions, locks, and other resources. The only output I have ever seen for this command is RESOURCETimeout is 60 minutes. Resource list is unlocked. There are current no waiters. SHOW SESSION Useful for diagnosing hangs or other general session problems while a session is still connected to the server. This is also useful in cases where a session is cancelled or terminated and still appears in QUERY SESSION. SHOW TXNT You use this command to get information about active server transactions. Transactions are the low level operations that actually read or update the database. This command can be useful for diagnosing hangs or other transaction related problems, but the command produces a lot of output, and many of the fields are a bit obscure. Partial output for one single transaction is shown below. slot -> 51: Tsn=0:822996787, Resurrected=False, InFlight=True, Distributed=False, Addr 3b6458b8 ThreadId=119, Timestamp=05/31/04 09:04:02, Creator=dfmigr.c(1789) Participants=3, summaryVote=ReadOnly EndInFlight False, endThreadId 119, tmidx 0 0, processBatchCount 0. Participant DB: voteReceived=False, ackReceived=False Participant BF: voteReceived=False, ackReceived=False Participant SS: voteReceived=False, ackReceived=False Locks held by Tsn=0:822996787 : Type=34040, NameSpace=32997, SummMode=xLock, Mode=xLock, Key='127.0' SHow INVObject 0 ObjectId Use this command to show an inventory object, reporting its nodename, filespace, management class, and more. This command can be useful if you get errors with objects. For example, when exporting a server you may see a message like ANR9999D xibf.c(664): Return code 87 encountered in writing object 0.9041317 to export stream. ANR0661E EXPORT SERVER: Internal error encountered in accessing data storage. The 0. 9041317 is the Object ID. If you use the SHOW command SHow INVObject 0 9041317 The result below will tell you what the object is OBJECT: 0. 9041317 (Backup): Node: ACSN08 Filespace: /y2. /msg/rlds/ temp Type: 2 CG: 1 Size: 0.0 HeaderSize: 0 BACKUP OBJECTS ENTRY: State: 1 Type: 2 MC: 1 CG: 1 /y2 : / msg/rlds/ temp This (MC: DEFAULT) Active, Inserted 08/01/03 07:58:58 EXPIRING OBJECTS ENTRY: Expiring object entry not found. #################################### # Storage pool and LAN free commands #################################### SHOW SSPOOL Useful for displaying the states and attributes of defined storage pools. SHOW TRANSFERSTATS poolname You use this command to get statistics from the last migration process, for example - SHOW TRANSFERSTATS BACKUPPOOL Statistics for last migration from pool BACKUPPOOL Start date/time: 05/26/04 02:30:21 Elapsed time: 24128 seconds Total wait time: 17232 seconds Number of participating processes: 2 Total duration of all processes: 48169 seconds Total physical files: 11934 Total logical files: 316992 Total bytes: 273999794176 Average logical files per physical file: 26.6 Average physical file size: 22421.5 KB Number of batch/file transactions ended: 782 Number of batch transactions aborted: 0 Number of file transactions started: 0 Number of file transactions aborted: 0 SHOW LANFREE nodeName storageAgent. This command was added with TSM version 5.2.2. It will check out all possible destination storage pools for a given client node and tell you if this storage pool can support LAN-free backup and restore. ######################### # commandline +table view ######################### dsmadmc -se=blah -id=admin -pa=xxx -displaymode=table macro select.macro ################## # macro ausfuehren ################## macro macroname macro /home/kutz/austausch/betrieb/backup/tsm/scripte/mac.optionsets ################ # mtlib commands ################ # mtlib -? Usage: mtlib -[acdfiklmnqstvCDV?] Arguments: -f[filename] device special Filename, i.e. "/dev/rmt0". -x[number] device number, i.e. "518350". -l[filename] Library special filename, i.e. "/dev/lmcp0". -q[type] Query library information option. type should be one of the following: V Volume data. L Library data. S Statistical data. I Inventory data. C Category inventory data. D Device data. E Expanded volume data. K inventory volume count data. R Reserved Category List A Category Attribute List M All Mounted Volumes -m Mount option. -d Demount option. -D List of devices in library. -E Used with -D option for expanded device list -c[request id] Cancel pending request option. -n No wait mode. -i[request id] Query request id status option. -C Change the category of a volume. -a Audit the specifed volume. -k[flags] Assign a category to a device in the Library. flags should be the following: O Enable Category Order C Clear out ICL G Generate First Mount A Enable Auto Mount X Remove category assignment from drive Valid combinations: OG, OA, GA, OGA Loader associated with the Library. -r Reserve a category -R Release a category -S Set category attribute -s[category] Source or starting category. -t[category] Target category. -L[list] List of Volume serial numbers -V[volser] Volume serial number -N[name] Category Name Attribute to assign to category. -h[hostid] host id for reserve/release category or R/A option for query command -u Include usage date in expanded volume data. Default is ISO format with period separator. -F[flags] Format and/or separator for volume usage date flags can be: I ISO/Japan yyyy.mm.dd E European dd.mm.yyyy U USA mm.dd.yyyy p period separator mm.dd.yyyy d dash separator mm-dd-yyyy s slash separator mm/dd/yyyy -v Verbose. -#[number] Category sequence number or number of categories to reserve. -A Query library addresses and status -? this help text. NOTE: The -l argument is required. # mtlib -l /dev/helferlein -qL Library Data: operational state..........Automated Operational State Dual Write Disabled functional state...........00 input stations.............1 output stations............1 input/output status........ALL input stations empty ALL output stations empty Bulk input/output allowed machine type...............3494 sequence number............13597 number of cells............475 available cells............179 subsystems.................3 convenience capacity.......10 accessor config............01 accessor status............Accessor available Gripper 1 available Gripper 2 available Vision system operational comp avail status..........Primary library manager installed. Primary library manager available. Primary hard drive installed. Primary hard drive available. Convenience input station installed. Convenience input station available. Convenience output station installed. Convenience output station available. library facilities.........00 bulk input capacity........0 bulk input empty cells.....0 bulk output capacity.......10 bulk output empty cells....9 avail 3490 cleaner cycles..0 avail 3590 cleaner cycles..346 # mtlib -l /dev/lmcp0 -C -VAIX001 -t1000 This command changes the cartridge AIX001 library manager category to x'1000', which is not reserved by any other hosts or for any library manager function. # mtlib -l /dev/lmcp0 -m -f /dev/rmt0 -VAIX001 This command mounts cartridge AIX001 onto device rmt0. # mtlib -l /dev/lmcp0 -m -f /dev/rmt0 -VAIX002 This command mounts cartridge AIX002 onto device rmt1. tar -cvf /dev/rmt0 * This is the TAR command used to perform normal backup. It is normally used to back up the whole file system from which the MTLIB command is run. # mtlib -l /dev/lmcp0 -d -f /dev/rmt0 -VAIX001 This command demounts cartridge AIX001 from dev rmt0. In a script, this command is not issued until the TAR command has completed. # mtlib -l /dev/lmcp0 -d -f /dev/rmt1 -VAIX002 This command demounts cartridge AIX002 from dev rmt1. In a script, this command is not issued until the TAR command has completed. # mtlib -l /dev/lmcp0 -C -VAIX001 -tFF10 This command changes the library manager category of cartridge AIX001 to FF10. Setting the library manager category instructs the library manager to eject the cartridge from the library through the convenience I/O station (see Appendix C, Library manager volume categories on page 451, for a full list of library manager volume categories). # mtlib -l /dev/lmcp0 -qL This command requests status information about the library from the library manager (see Figure 8-7 for the response to this command). # mtlib -l /dev/lmcp0 -m -f /dev/rmt0 -VAIX002 This command remounts cartridge AIX002 to device rmt0. # tar -tvf /dev/rmt0 This is the TAR command to list the files on the cartridge. It can be used to ensure that all files are backed up as needed. # mtlib -l /dev/lmcp0 -d -f /dev/rmt0 -VAIX002 This command demounts the cartridge from rmt0. # detailed info about tape # mtlib -l /dev/helferlein -qE -V 000597 Expanded Volume Data: volume status............00 logical volume...........No volume class.............3590 1/2 inch cartridge tape volume type..............HPCT 320m nominal length volser...................000597 category.................012C # show tape infos # mtlib -l /dev/helferlein -D 0, 00393420 003590B1A00 1, 00224050 003590B1A01 2, 00B74100 003590B1A02 # show cleaning tapes # mtlib -l /dev/helferlein -vqK -s fffd Performing Query Inventory Volume Count Data using /dev/helferlein Inventory Volume Count Data: sequence number......13597 number of volumes....13 category.............FFFD # show scratch tapes # mtlib -l /dev/helferlein -vqK -s 12E Performing Query Inventory Volume Count Data using /dev/helferlein Inventory Volume Count Data: sequence number......13597 number of volumes....47 category.............012E # show private tapes # mtlib -l /dev/helferlein -vqK -s 12C Performing Query Inventory Volume Count Data using /dev/helferlein Inventory Volume Count Data: sequence number......13597 number of volumes....364 category.............012C # count all volumes # mtlib -l /dev/helferlein -vqK -s 0000 Performing Query Inventory Volume Count Data using /dev/helferlein Inventory Volume Count Data: sequence number......13597 number of volumes....415 category.............0000 # info about the lib # mtlib -l /dev/helferlein -qS Statistical Data: hour index...........7 machine type.........003494 model number.........L10 manufacturer.........IBM plant................13 sequence number......000000013597 drives...............3 mounted drives.......3 max mounted drives...3 min mounted drives...2 avg mounted drives...2 max mounted time.....1778 min mounted time.....352 avg mounted time.....1038 pending mounts.......0 max pending mounts...1 min pending mounts...0 avg pending mounts...1 mounts/hour..........7 index mounts/hour....0 pre-mounts/hour......0 max mount time.......51 min mount time.......28 avg mount time.......34 pending demounts.....0 max pending demounts.1 min pending demounts.0 avg pending demounts.1 demounts/hour........6 index demounts/hour..0 post-demounts/hour...0 max demount time.....9 min demount time.....5 avg demount time.....7 pending ejects.......0 max pending ejects...0 min pending ejects...0 avg pending ejects...0 ejects/hour..........0 max eject time.......0 min eject time.......0 avg eject time.......0 pending audits.......0 max pending audits...0 min pending audits...0 avg pending audits...0 audits/hour..........0 max audit time.......0 min audit time.......0 avg audit time.......0 input stores/hour....0 ####################### # How do I exclude the "Command Line Administrative Interface" verbiage # when I run a command? ####################### dsmadmc -DATAOnly=yes ###### # Is there a way to make the message column wider so that it isn't several lines # long? ###### Before your select command. SET SQLDISPLAYMODE WIDE ##################### # grant/revoke rights ##################### tsm: DUESENTRIEB>q admin tsm: DUESENTRIEB>gr auth bigbrother cl=Analyst ANR2160E GRANT AUTHORITY: No new privileges granted to administrator BIGBROTHER. ANS8001I Return code 10. tsm: DUESENTRIEB>help revoke REVOKE Commands REVOKE Commands Use the REVOKE command to revoke one or more privilege classes from an administrator for Tivoli Storage Manager. REVOKE AUTHORITY (Remove Administrator Authority) tsm: DUESENTRIEB>rev auth bigbrother cl=STorage ANR2086I Storage privilege revoked for administrator BIGBROTHER. tsm: DUESENTRIEB>gr auth bigbrother cl=STorage stg=dp.dir ANR2080I Restricted storage privilege granted to administrator BIGBROTHER - storage pool DP.DIR. ######################## # volume mount statistik ######################## select VOLUME_NAME, STGPOOL_NAME,TIMES_MOUNTED, WRITE_ERRORS, READ_ERRORS from volumes select VOLUME_NAME as Tapes, STGPOOL_NAME as pool, TIMES_MOUNTED as gemounted, WRITE_ERRORS as werror, READ_ERRORS as rerror from volumes where DEVCLASS_NAME='3590DEVCL' ##################### # mounts groesser 100 ##################### select VOLUME_NAME as Tapes, STGPOOL_NAME as pool, TIMES_MOUNTED as gemounted, WRITE_ERRORS as werror, READ_ERRORS as rerror from volumes where DEVCLASS_NAME='3590DEVCL' and TIMES_MOUNTED>100 ################ # label tape new ################ > LABEL libvol 3494lib 000577 checkin=scratch ANR8319I 017: Insert volume 000577 R/W into library 3494LIB within 60 minute(s). > repl 017 Volume in remote bulk einsetzten Hardware Error im Log normal da Tape kein Label hat ANR8810I Volume 000577 has been labeled in library 3494LIB. # massenweise tapes einlesen Tapes in bulk einlegen LIB holt sich die tapes und legt sie ab LABEL libvol 3494lib SEARCH=yes CHECKIN=scratch VOLR=000520,000528 ################################# # auslastung backup/archive in GB ################################# >select domain_name, sum(occ.backup_mb)/1024 as BACKUP_GB, sum(o cc.archive_mb)/1024 as ARCHIVE_GB from nodes n, auditocc occ wh ere n.node_name=occ.node_name group by domain_name DOMAIN_NAME BACKUP_GB ARCHIVE_GB ------------------ ----------- ----------- LANGZEITARCHIV 0 62 NOTES 74 0 PAGO-DB 1555 0 PAGO-SRV 1446 147 ################################################# # lese/schreibfehler/mountimes fuer tape anzeigen ################################################# >select VOLUME_NAME as Tapes, STGPOOL_NAME as pool, TIMES_MOUNTE D as gemounted, WRITE_ERRORS as werror, READ_ERRORS as rerror f rom volumes where DEVCLASS_NAME='3590DEVCL' and TIMES_MOUNTED>1 00 TAPES POOL GEMOUNTED WERROR RERROR ------------------ ------------------ ----------- ----------- ----------- 000107 TP.TWISTERLOG 410 0 0 000166 TP.TWISTERLOG 205 0 0 000203 TP.TWISTERLOG 199 0 0 000207 TP.TWISTERLOG 575 0 0 000216 TP.TWISTERLOG 426 0 0 000227 TP.TWISTERLOG 484 0 0 000240 TP.TWISTERLOG 431 0 0 ##################### # vary volume offline ##################### 1) UPDATE the volume to READONLY. 2) MOVE DATA on the volume. TSm will shuffle the data off to another volume in the same storage pool. ################# # create tapepool ################# DEFine STGpool tp.kbw_server 3590DEVCL HI=90 LO=70 MAXSCR=50 ############# # copy domain ############# copy domain PAGO-SRV PAGO-SRV-kbw ################## # define policyset ################## define pol PAGO-SRV-KBW PAGO-SRV-KBW desc='PAGO Server KBW' ######################## # define managementclass ######################## def mg PAGO-SRV-KBW PAGO-SRV-KBW pagosrvmc MIGDEST=SPACEMGPOOL DESC='Standard fuer Server KBW' ########################## # assign default mgmtclass ########################## ASsign DEFMGmtclass PAGO-srv-kbw PAGO-srv-kbw pagosrvmc ########################## # update desc of policyset ########################## upd POl PAGO-SRV PAGO-SRV DESC='PAGO Server PS' ############### # define domain ############### define domain PAGO-SRV-kbw DESC='PAGO Server KBW' BACKRET=365 ARCHRET=9999 ################## # define policyset ################## DEFine POlicyset PAGO-SRV-kbw pagosrvmc DESC='Policy Domain fuer PAGO Server KBW' #################### # validate policyset #################### val POl PAGO-SRV-kbw pagosrvmc val pol PAGO-SRV-kbw PAGO-SRV-kbw #################### # activate mgmtclass #################### act pol PAGO-SRV-kbw PAGO-SRV-kbw ######################### # define backup copygroup ######################### DEFine COpygroup PAGO-SRV-KBW PAGO-SRV-KBW PAGOSRVMC Type=backup DEST=tp.server_kbw ########################## # define archive copygroup ########################## DEFine COpygroup PAGO-SRV-KBW PAGO-SRV-KBW PAGOSRVMC Type=archive DEST=tp.server_kbw RETV=365 ######################### # update copygroup backup ######################### upd copygroup PAGO-SRV-kbw PAGO-SRV-kbw PAGOSRVMC Type=backup VERE=3 VERD=1 RETE=365 RETO=730 ########################## # update copygroup archive ########################## upd copygroup PAGO-SRV-kbw PAGO-SRV-kbw PAGOSRVMC Type=archive RETV=365 ######################################## # definiere disk storage pool als puffer ######################################## DEFINE STGPOOL dp.server_kbw disk DESC="Cache fuer Server-Backups KBW" ############################# # definiere volume in stgpool ############################# DEFINE VOLUME dp.server_kbw /opt/tsm/diskpools/dp.server_kbw/dp.server_kbw1.dsm ACC=READW Formatsize=1024 LO=/opt/tsm/diskpools/dp.server_kbw ############################################################### # anpassen der copygroup - zwischenschieben diskpool als puffer ############################################################### upd stg dp.kbw_server NEXTstgpool=tp.kbw_server upd copygroup PAGO-SRV-kbw PAGO-SRV-kbw PAGOSRVMC Type=archive DEST=dp.server_kbw upd copygroup PAGO-SRV-kbw PAGO-SRV-kbw PAGOSRVMC Type=backup DEST=dp.server_kbw ################# # define schedule ################# define sched pago-srv-kbw DAILY_INC_kbw DESC='daily incremental backup KBW' ACT=Incremental STARTTime='18:00:00' DUR=4 DURU=Hours PER=1 DAYofweek=ANY ANR2500I Schedule DAILY_INC_KBW defined in policy domain PAGO-SRV-KBW. #################### # define association #################### defi assoc pago-srv-kbw DAILY_INC_kbw susi ANR2510I Node SUSI associated with schedule DAILY_INC_KBW in policy domain PAGO-SRV-KBW. ################# # clientoptionset ################# select * from cloptsets ####################### # query clientoptionset ####################### QUERY CLOPTSET WINDOWS ################ # dsm.opt option ################ preschedulecmd "Kommando welches vor der sicherung ausgefuehrt wird" postschedulecmd "Kommando welches nach der sicherung ausgefuehrt wird" ############################# # update node clientoptionset ############################# upd node zora clopt=windows # check drives and paths Select Distinct Char(DRIVES.LIBRARY_NAME,12) As "Library Name" , Char(DRIVES.DRIVE_NAME,14) As "Drive Name" , Char(DRIVES.ONLINE,13) As "Drive Online?" , CHAR(DRIVES.DRIVE_STATE,11) As "Drive State" , Char((Select PATHS.DEVICE From Paths Where PATHS.DESTINATION_NAME =DRIVES.DRIVE_NAME),9) As "Device" , Char((Select PATHS.ONLINE From Paths Where PATHS.DESTINATION_NAME =DRIVES.DRIVE_NAME),12) As "Path Online?" From DRIVES, PATHS Library Name Drive Name Drive Online? Drive State Device Path Online? ------------ -------------- ------------- ----------- --------- ------------ 3494LIB DRIVE0 YES EMPTY /dev/rmt0 YES 3494LIB DRIVE1 YES LOADED /dev/rmt1 YES 3494LIB DRIVE2 YES EMPTY /dev/rmt2 YES ################ # copy stg pools ################ DEFine STGpool cp.LZ-ARCHIV 3494LIB POoltype=copy DESC='Copy Pool fuer LZ-ARCHIV ACC=READWRITE MAXSCR=15 COLlocate=Yes ##################################### # define schedule for backup stg pool ##################################### backup stg dp.LZ-ARCHIV cp.LZ-ARCHIV Save the file as 2copywrites.scr >From the TSM administrative command line: tsm> define script 2copywrites file=2copywrites.scr Schedule an administrative task: tsm> define sched 2copywrites t=a cmd='run 2copywrites' active=yes desc='Writeclient data from TP.LZ-ARCHIV to copypool cp.LZ-ARCHIV' ############################## # options on cmdline interface ############################## Using Administrative Client Options In all administrative client modes, the administrative client options modify your administrative client session responses. The following administrative client options can be specified with the DSMADMC command and are valid from an administrative client session only: -DISPLaymode=LISt or TABle Allows you to force the QUERY output to tabular or list format regardless of the command line window column width. If you want the output to go to a file and you are using the -DISPLaymode option, use redirection to write to the file. Do not use the -OUTfile option. -ID=userid Specifies the administrator’s user ID. -PAssword=password Specifies the administrator’s password. -NOConfirm Specifies that you do not want Tivoli Storage Manager to request confirmation before processing commands that affect the availability of the server or data managed by the server. -Quiet Specifies that Tivoli Storage Manager does not display standard output messages to your screen. However, when you use this option, certain error messages still appear. -CONsolemode Specifies that Tivoli Storage Manager runs in console mode. All unsolicited server console output is echoed to your screen. -MOUNTmode Specifies that Tivoli Storage Manager runs in mount mode. All server removable-media mount messages are echoed to your screen. -Itemcommit Specifies that Tivoli Storage Manager commits commands inside a script or a macro as each command is processed. -OUTfile=filename Specifies that output from a server query is redirected to a specified file. In batch mode, output is redirected to a file you specify and the format of the output matches the format of the output on your screen. In interactive, console, or mount mode sessions, output displays on your screen. -OUTfile Specifies that output from a server query is formatted one line per query. This option is available in batch mode only. -COMMAdelimited Specifies that any tabular output from a server query is to be formatted as comma-separated strings rather than in readable format. This option is intended to be used primarily when redirecting the output of an SQL query (SELECT command). The comma-separated value format is a standard data format which can be processed by many common programs, including spreadsheets, data bases, and report generators. -TABdelimited Specifies that any tabular output from a server query is to be formatted as tab-separated strings rather than in readable format. This option is intended to be used primarily when redirecting the output of an SQL query (SELECT command). The tab-separated value format is a standard data format which can be processed by many common programs, including spreadsheets, databases, and report generators. Besides the options listed here, you can also specify any option that is in the client options file. Each option must be preceded with a hyphen and delimited with a space. ########################### # define copy storage pools ########################### define stgpool cp.server_kbw 3590DEVCL pooltype=copy maxscratch=50 REUsedelay=30 DESC="Sicherung KBW und Archive KBW" ACC=UNAV define stgpool cp.offdata lto3_mr3 pooltype=copy description="Copy storage pool for data" maxscratch=10 reusedelay=5 ANR2200I Storage pool CP.OFFDATA defined (device class LTO3_MR3). ################################ # backup primary to copy stgpool ################################ backup stgpool tp.server_kbw cp.server_kbw ######################## # preview backup stgpool ######################## BACKUP STGPOOL tp.server_kbw cp.server_kbw Preview=VOLumesonly ############################### # welche tapes im copy stg pool ############################### query volume * stg=cp.server_kbw query volume * access=readwrite,readonly status=full,filling stgpool=cp.server_kbw #################### # checkout der tapes #################### checkout libv 3590DEVCL remove=bulk checkout libv 3494LIB remove=yes For 349x Libraries: o When REMOVE=BULK, the 3494 Library Manager ejects the cartridge to the high-capacity output facility o When REMOVE=YES, the 3494 Library Manager ejects the cartridge to the convenience I/O station o When REMOVE=NO, the server leaves the cartridge in the library in the INSERT category. ############################# # volumes auf offsite setzten ############################# update volume * access=offsite location="ITSO vault" whereaccess=readwrite,readonly wherestg=cp.server_kbw wherestatus=full,filling ################################## # Identify volumes to bring onsite ################################## query volume * access=offsite status=empty ##################################### # update volumes to bring them online ##################################### update volume * access=readwrite location="" wherestg=cp.server_kbw wherestatus=empty whereaccess=offsite ################# # checkin volumes ################# CHECKIN libvol 3494lib 000059 CHECKLabel=yes status=scratch # einlegen, dann zu library_1 zuordnen auf display dann checkin libvol 3576LIB search=bulk status=scratch checklabel=barcode rep ??? CHECKOUT libvol 3576LIB A00079L3 remove=no checklabel=no LABEL libvol 3576LIB search=yes checkin=scratch voll=A00079L3 labelsource=barcode oder LABEL libvol 3576LIB search=yes checkin=scratch volr=A00060L3,A00079L3 labelsource=barcode ###################### # mtlib look for tapes ###################### root@pago-at1 /home/root> mtlib -l /dev/helferlein -q I 000000 012C 00 10 00 000001 012C 00 10 00 000002 012C 00 10 00 FF00 = Unknown Tape ################################ # 3494 change tape status of lib ################################ private = 012C scratch = 012E mtlib -l /dev/helferlein -qI | grep mytapes mtlib -l /dev/helferlein -C -V yourtape -s 012C -t 012D mtlib -l /dev/helferlein -C -L /home/xxxx/scratchtapes -s 012C -t 012D ############# # update path ############# online update path DUESENTRIEB DRIVE1 SRCT=server DESTT=drive LIBR=3494LIB device=/dev /rmt1 online=yes offline update path DUESENTRIEB DRIVE1 SRCT=server DESTT=drive LIBR=3494LIB device=/dev /rmt1 online=no ################################## # find out what data on which tape ################################## select VOLUME_NAME from contents where NODE_NAME='NODE' and FILESPACE_NAME='\\teste\c$' and FILE_NAME='\xxxx\yyyy\file' ######################## # find out volume status ######################## SELECT VOLUMES.VOLUME_NAME, VOLUMES.PCT_UTILIZED, VOLUMES.STATU S,VOLUMES.ACCESS, VOLUMES.PCT_RECLAIM, VOLUMES.LAST_WRITE_DATE, VOLUMES.LAST_READ_DATE, VOLUMES.CHG_TIME, VOLUMES.STGPOOL_NAME FROM VOLUMES GROUP BY VOLUMES.VOLUME_NAME, VOLUMES.PCT_UTILIZED , VOLUMES.STATUS,VOLUMES.ACCESS, VOLUMES.PCT_RECLAIM, VOLUMES.L AST_WRITE_DATE,VOLUMES.LAST_READ_DATE, VOLUMES.CHG_TIME, VOLUME S.STGPOOL_NAME HAVING (((VOLUMES.PCT_UTILIZED)>0)) ORDER BY VOL UMES.ACCESS, VOLUMES.STGPOOL_NAME ... VOLUME_NAME: 000290 PCT_UTILIZED: 100.0 STATUS: FULL ACCESS: READWRITE PCT_RECLAIM: 0.0 LAST_WRITE_DATE: 2005-08-25 16:46:54.000000 LAST_READ_DATE: 2005-08-25 16:15:31.000000 CHG_TIME: 2005-08-25 16:15:28.000000 STGPOOL_NAME: TP.SERVER_KBW ... ############## # General Info ############## The www admin interface is operational and can be accessed via http://dataplus.isc.ucsb.edu:1580. You can issue command line commands via the "command" link at the bottom of most pages. Please be aware that the web interface seems to change with each point release of the server code. When using the Admin Command Line interface the output of most commands can be redirected to a local disk file: tsm> q node racerx f=d > c:\temp\rpt.txt The TSM admin command line client can be started with the "-mountmode" parameter which will start a tape console session. You should then start a second admin client session so you can issue commands to the server. This works on at least the AIX and Win32 clients. The AIX admin command line client can be issued from a telnet or xterm session as "/usr/bin/dsmadmc". The daily exception reports can be viewed at http://hoover.isc.ucsb.edu/tsm/except-report/ to aid in troubleshooting client backup problems. The System Configuration can be viewed by issuing "q system" at the TSM admin client prompt. A dedicated login to launch the TSMAdmin Command Line application exists on iscdev2. Simply ssh to iscdev2.isc.ucsb.edu and login using the proper account (which is not listed here for obvious reasons - check with KGG). Daily Administration Tasks In the following steps you are looking to determine that; * the previous night's activity completed properly 1) query server process and pending requests to determine if any jobs are waiting on operator action. tsm> q process tsm> q request 2) query stgpool to determine if the migration process has completed, i.e. the percentage utilization is between the high and low migration points on all storage pools tsm> q stgpool 3) query the volume libraries to determine present tape volume capacity / percentage utilization. tsm> q vol tsm* Note that there are three Storage Pools using the tape library: TAPEPOOL (normal migration path for data to tape), UOSGTAPE which is for USOG Backups only and COPYPOOL (tape copy of all data.) 4) query the library to determine what volumes are presently checked-in and are either PRIVATE or SCRATCH or Cleaner and Last Use as Data or DbBAckup. tsm> q libv Reviewing Recent Client Activity #to review scheduled event activity issue the following command: tsm> q event * * begindate=-1 begintime=18:00 type=client Scheduled Start Actual Start Schedule Name Node Name Status -------------------- -------------------- ------------- ------------- --------- 11/01/1999 20:00:00 11/01/1999 23:16:27 STANDARD ISC124-1 Completed 11/01/1999 20:00:00 11/01/1999 20:00:04 STANDARD ISC124-82 Failed 11/01/1999 20:00:00 STANDARD CADFDX Missed 11/01/1999 20:00:00 11/01/1999 20:00:03 STANDARD ISCNTZ Completed #to restrict the listing to only those nodes with a non-completed status: tsm> q event * * begindate=-1 begintime=18:00 type=client ex=yes Scheduled Start Actual Start Schedule Name Node Name Status -------------------- -------------------- ------------- ------------- --------- 11/01/1999 20:00:00 11/01/1999 20:00:04 STANDARD ISC124-82 Failed 11/01/1999 20:00:00 STANDARD CADFDX Missed 11/01/1999 20:00:00 STANDARD ISC124-24 Missed #to review future scheduled events: tsm> q event * * enddate=+1 type=client Scheduled Start Actual Start Schedule Name Node Name Status -------------------- -------------------- ------------- ------------- --------- 11/02/1999 20:00:00 STANDARD ISC124-1 Future 11/02/1999 20:00:00 STANDARD ISC124-82 Future 11/02/1999 20:00:00 STANDARD CADFDX Future #to review only those nodes associated with a specific policy domain, in this example "SYSTEMS", tsm> q event systems * begindate=+1 type=client Scheduled Start Actual Start Schedule Name Node Name Status -------------------- -------------------- ------------- ------------- --------- 11/03/1999 21:00:00 SYSTEMS RACERX Future 11/03/1999 21:00:00 SYSTEMS BORG Future 11/03/1999 21:00:00 SYSTEMS ISCLDAPM Future 11/03/1999 21:00:00 SYSTEMS ARLENE Future 11/03/1999 21:00:00 SYSTEMS ISANDCPDC Future 11/03/1999 21:00:00 SYSTEMS EQUIUM Future 11/03/1999 21:00:00 SYSTEMS SSWOO Future 11/03/1999 21:00:00 SYSTEMS ISANDCBDC Future User and Node Management Commands # querying info about a node tsm> q node racerx # querying info about a node detail mode, f=d works with most query commands tsm> q node racerx f=d # add a node and assign node to existing policy domain, permit node to delete # backup data tsm> reg node trixie trixiepw con="Kirk Grier" do=systems backdel=yes # assign node to existing domain and existing schedule # synatx is: def assoc policy-domain-name schedule-name nodename tsm> def assoc systems nightly trixie # change the password on the demo node to demopw tsm> update node demo demopw # renaming a node (retains all data, scheduling, etc) tsm> rename node oldname newname # query space in use by node(s) tsm> q occupancy * # deleting a node - first remove all filespaces owned by the node and then # remove the node tsm> delete filespace sjfio * type=any ANR2238W This command will result in the deletion of all inventory references to the data on filespaces that match the pattern * for node SJFIO, whereby rendering the data unrecoverable. Do you wish to proceed? (Yes/No) y ANS8003I Process number 10 started. tsm> q pro Process Process Description Status Number -------- -------------------- ------------------------------------------------- 10 DELETE FILESPACE Deleting file space * (backup/archive data) for node SJFIO: 672 files deleted. tsm> remove node sjfio Do you wish to proceed? (Yes/No) y ANR2061I Node SJFIO removed from policy domain STANDARD. tsm> # query schedules tsm> q sch Domain * Schedule Name Action Start Date/Time Duration Period Day ------------ - ---------------- ------ -------------------- -------- ------ --- STANDARD STANDARD Inc Bk 09/02/1998 20:00:00 5 H 1 D Any SYSTEMS SYSTEMS Inc Bk 09/02/1998 21:00:00 5 H 1 D Any # query what nodes are defined in each schedule tsm> q assoc Policy Domain Name: STANDARD Schedule Name: STANDARD Associated Nodes: BAP89 CADFDX DEHAN DWHOW EQUIUM GGLIN GSJOH HBSHA ISANDCNTY ISANDCPDC ISC124-1 ISC124-2 ISC124-24 ISC124-40 ISC124-82 ISCNTX ISCNTZ JMGOV JTHER KDSWA LNLUI MLWEN MRSTE PJROW PLCHE RESMI SJFIO SSWOO TOHOL VJGOV WYLUA Policy Domain Name: SYSTEMS Schedule Name: SYSTEMS Associated Nodes: ALAN ARLENE BORG DATAPLUS DWIGHT FAX ISANDCBDC ISCDEV1 ISCDEV2 ISCLDAPM ISCLDAPS JOEFIOR RACERX # determining last night's activity (the backup windows begins at 20:00). Use # "q actlog" or visit the node in question to view the client logs to # determine problem resolution. Add "ex=yes" to the command line to filter out # all but the exceptions, i.e. "missed" or "failed" status. tsm> query event * * begindate=-1 begintime=19:00 Scheduled Start Actual Start Schedule Name Node Name Status -------------------- -------------------- ------------- ------------- --------- 06/08/1999 20:00:00 06/08/1999 20:04:09 STANDARD RACERX Completed 06/08/1999 20:00:00 06/08/1999 20:17:43 STANDARD BORG Completed 06/08/1999 20:00:00 STANDARD ISC124-1 Missed 06/08/1999 20:00:00 STANDARD ISC124-82 Missed 06/08/1999 20:00:00 STANDARD CADFDX Missed 06/08/1999 20:00:00 STANDARD ISANDCNTY Missed 06/08/1999 20:00:00 06/08/1999 20:02:44 STANDARD ISANDCPDC Failed 06/08/1999 20:00:00 STANDARD EQUIUM Missed 06/08/1999 20:00:00 STANDARD SSWOO Missed # determine in which storage pool a nodes' data is stored tsm> q occ Node Name Type Filespace Storage Number of Physical Logical Name Pool Name Files Space Space Occupied Occupied (MB) (MB) ---------------- ---- ---------- ---------- --------- --------- --------- ABDER Bkup \\isc124-- 1 COPYPOOL 101,906 3,057.01 2,913.86 178\c$ ABDER Bkup \\isc124-- 1 DISKPOOL 1,556 396.25 395.30 178\c$ ABDER Bkup \\isc124-- 1 TAPEPOOL 100,350 2,637.10 2,518.75 178\c$ ABDER Bkup \\isc124-- 2 COPYPOOL 44,673 8,886.28 8,882.82 178\d$ ABDER Bkup \\isc124-- 2 DISKPOOL 44 34.52 34.52 178\d$ ABDER Bkup \\isc124-- 2 TAPEPOOL 44,629 8,851.13 8,848.32 178\d$ ACTGSCAN Bkup \\actg141- 1 COPYPOOL 67,734 2,540.19 2,537.59 -91\c$ ACTGSCAN Bkup \\actg141- 1 DISKPOOL 883 42.14 41.69 -91\c$ ACTGSCAN Bkup \\actg141- 1 TAPEPOOL 66,851 2,498.17 2,496.01 -91\c$ ACTGSCAN Bkup SYSTEM 2 COPYPOOL 3,334 275.43 275.43 OBJECT ACTGSCAN Bkup SYSTEM 2 DISKPOOL 3,334 275.48 275.48 OBJECT AHNOM Bkup \\isc124-- 1 COPYPOOL 29,043 3,056.18 2,878.43 55-2k\c$ AHNOM Bkup \\isc124-- 1 TAPEPOOL 29,043 3,054.40 2,878.43 55-2k\c$ AHNOM Bkup SYSTEM 2 COPYPOOL 3,272 270.15 270.15 OBJECT AHNOM Bkup SYSTEM 2 TAPEPOOL 3,272 270.15 270.15 OBJECT more... ( to continue, 'C' to cancel) Server Managment Commands # query for session(s) in process with the tsm server tsm> q session Sess Comm. Sess Wait Bytes Bytes Sess Platform Client Name Number Method State Time Sent Recvd Type ------ ------ ------ ------ ------- ------- ----- -------- -------------------- 1,082 Tcp/Ip Run 0 S 134.1 K 880 Admin WinNT KGRIER # query for active processes (jobs) running on the tsm Server tsm> q process ANR0944E QUERY PROCESS: No active processes found. ANS8001I Return code 11. # query the state of the storage pools defined to the tsm server tsm> q stgpool Storage Device Estimated Pct Pct High Low Next Pool Name Class Name Capacity Util Migr Mig Mig Storage (MB) Pct Pct Pool ----------- ---------- ---------- ----- ----- ---- --- ----------- ARCHIVEPOOL DISK 0.0 0.0 0.0 90 70 DISKPOOL BACKUPPOOL DISK 0.0 0.0 0.0 90 70 DISKPOOL COPYPOOL LTO2 10,052,714 8.2 .5 DISKPOOL DISK 600,000.0 13.7 7.8 90 15 TAPEPOOL SPACEMGPOOL DISK 0.0 0.0 0.0 90 70 TAPEPOOL LTO2 104,061,06 0.7 1.4 90 70 6.8 # query the state of the tsm database tsm> 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 --------- -------- --------- --------- ------- --------- --------- ----- ----- 3,092 3,092 0 2,820 4,096 791,552 68,983 8.7 8.8 # query the state of the log database tsm> 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 --------- -------- --------- --------- ------- --------- --------- ----- ----- 2,068 2,068 0 2,064 4,096 528,896 191 0.0 0.1 # query the state of the volumes assigned to tsm tsm: DATAPLUS_SERVER1>q vol Volume Name Storage Device Estimated Pct Volume Pool Name Class Name Capacity Util Status (MB) ------------------------ ----------- ---------- --------- ----- ------- G:\TSMDATA\SERVER1\DATA- DISKPOOL DISK 100,000.0 11.8 On-Line 1.DSM G:\TSMDATA\SERVER1\DATA- DISKPOOL DISK 100,000.0 9.8 On-Line 2.DSM G:\TSMDATA\SERVER1\DATA- DISKPOOL DISK 100,000.0 9.5 On-Line 3.DSM G:\TSMDATA\SERVER1\DATA- DISKPOOL DISK 100,000.0 11.1 On-Line 4.DSM G:\TSMDATA\SERVER1\DATA- DISKPOOL DISK 100,000.0 10.1 On-Line 5.DSM G:\TSMDATA\SERVER1\DATA- DISKPOOL DISK 100,000.0 8.7 On-Line 6.DSM TSM001 TAPEPOOL LTO2 221,944.8 55.0 Full TSM002 TAPEPOOL LTO2 198,004.5 42.7 Full TSM003 TAPEPOOL LTO2 227,769.9 63.8 Full ... # query for detailed information on a specific volume tsm> q vol dsm009 f=d Volume Name: DSM009 Storage Pool Name: 3590POOL Device Class Name: 3590CLASS Esti mated Capacity (MB): 12,906.6 Pct Util: 95.5 Volume Status: Full Access: Read/Write Pct. Reclaimable Space: 4.8 Scratch Volume?: No In Error State?: No Number of Writable Sides: 1 Number of Times Mounted: 9 Write Pass Number: 1 Approx. Date Last Written: 12/04/1998 08:45:24 Approx. Date Last Read: 12/02/1998 11:27:28 Date Became Pending: Number of Write Errors: 0 Number of Read Errors: 0 Volume Location: Last Update by (administrator): DSM2ADMN Last Update Date/Time: 12/02/1998 11:13:37 more... ((ENTER) to continue, 'C' to cancel) # query the contents of a specific volume (in this example a disk volume) tsm> q content /tsmdata2/backup5.dsm Node Name Type Filespace Client's Name for File Name ------------------------ ---- ---------- -------------------------------------- ISCDEV2 Bkup /BACKTRAC- /iscdev2/ K:sbacku- fsg_test-0.04-12-1998.10:16:49-34320 ps.physi- cal.noin- cremental ISCDEV2 Bkup /BACKTRAC- /iscdev2/ K:sbacku- sybsystemprocs-1.04-12-1998.10:18:03- ps.physi- -34850 cal.noin- cremental ISCDEV2 Bkup /BACKTRAC- /iscdev2/ K:sbacku- pubs3-0.07-12-1998.10:15:10-5386 ps.physi- cal.noin- cremental ISCDEV2 Bkup /BACKTRAC- /iscdev2/ K:sbacku- sybsystemprocs-1.07-12-1998.10:15:54- ps.physi- -33818 cal.noin- more... ((ENTER) to continue, 'C' to cancel) # query the activity log. Without a begintime parameter the default is the # previous hour's activity. tsm> q actlog Date/Time Message -------------------- ---------------------------------------------------------- 12/07/1998 12:46:11 ANR0406I Session 1078 started for node BORG (WinNT) (Tcp/Ip 128.111.124.127(3752)). 12/07/1998 12:46:11 ANR0403I Session 1078 ended for node BORG (WinNT). 12/07/1998 12:59:24 ANR0406I Session 1079 started for node ISC124-82 (WinNT) (Tcp/Ip 128.111.124.82(1335)). 12/07/1998 12:59:25 ANR0403I Session 1079 ended for node ISC124-82 (WinNT). 12/07/1998 13:01:54 ANR0406I Session 1080 started for node FAX (WinNT) (Tcp/Ip 128.111.124.117(4191)). 12/07/1998 13:01:54 ANR0403I Session 1080 ended for node FAX (WinNT). 12/07/1998 13:07:57 ANR0407I Session 1081 started for administrator DSM2ADMN (VM) (Tcp/Ip 128.111.125.3(31693)). 12/07/1998 13:11:11 ANR0407I Session 1082 started for administrator KGRIER (WinNT) (Tcp/Ip 128.111.124.101(4215)). 12/07/1998 13:12:34 ANR2060I Node ALAN registered in policy domain SYSTEMS. 12/07/1998 13:14:10 ANR2510I Node ALAN associated with schedule SYSTEMS in policy domain SYSTEMS. 12/07/1998 13:15:03 ANR2060I Node TRIXIE registered in policy domain SYSTEMS. 12/07/1998 13:15:09 ANR2510I Node TRIXIE associated with schedule SYSTEMS in policy domain SYSTEMS. 12/07/1998 13:22:55 ANR2207I Volume DSM009 updated. more... ((ENTER) to continue, 'C' to cancel) # query example with time range, example one minute after midnight today. tsm> q actlog begindate=today begintime=00:01 # query searching for a specific node or other string. tsm> q actlog begindate=12/05/1998 begintime=00:01 search=racerx Date/Time Message -------------------- ---------------------------------------------------------- 12/05/1998 20:00:21 ANR2561I Schedule prompter contacting RACERX (session 840) to start a scheduled operation. 12/05/1998 20:00:23 ANR0406I Session 841 started for node RACERX (WinNT) (Tcp/Ip 128.111.124.101(3482)). 12/05/1998 20:03:17 ANE14007 (Sessio: 841, Nod: RACERX) E Error processing '\\racerx\c$\WINNT\Profiles\kgrier\NTUSER.DAT': access to the object is denied 12/05/1998 20:03:17 ANE14007 (Sessio: 841, Nod: RACERX) E Error processing '\\racerx\c$\WINNT\Profiles\kgrier\ntuser.dat.LOG': access to the object is denied 12/05/1998 20:03:42 ANR0403I Session 841 ended for node RACERX (WinNT). 12/05/1998 20:03:42 ANR0406I Session 843 started for node RACERX (WinNT) (Tcp/Ip 128.111.124.101(3484)). 12/05/1998 20:03:42 ANR0403I Session 843 ended for node RACERX (WinNT). 12/06/1998 20:00:22 ANR2561I Schedule prompter contacting RACERX (session 966) to start a scheduled operation. 12/06/1998 20:00:23 ANR0406I Session 967 started for node RACERX (WinNT) (Tcp/Ip 128.111.124.101(3774)). 12/06/1998 20:03:16 ANE14007 (Sessio: 967, Nod: RACERX) E Error processing '\\racerx\c$\WINNT\Profiles\kgrier\NTUSER.DAT': access to ((snip)) # query for scheduled administrative tasks tsm> q sched type=a * Schedule Name Start Date/Time Duration Period Day - ---------------- -------------------- -------- ------ --- SETHIGH 12/08/1998 17:00:00 1 H 1 D Any SETLOW 12/08/1998 08:30:00 1 H 1 D Any tsm> q event * type=admin Scheduled Start Actual Start Schedule Name Status -------------------- -------------------- ------------- --------- 06/09/1999 08:30:00 06/09/1999 08:30:01 SETLOW Completed 06/09/1999 17:00:00 SETHIGH Future tsm> q event * begindate=-1 type=admin Scheduled Start Actual Start Schedule Name Status -------------------- -------------------- ------------- --------- 06/08/1999 08:30:00 06/08/1999 08:30:02 SETLOW Completed 06/08/1999 17:00:00 06/08/1999 17:00:01 SETHIGH Completed Tape Management Commands The Overland Neo4100 tape library contains 60 tape slots in four 15-slot magazines. Two of these slots are "mail" slots and are used to input/output individual tapes. The 'mail' slots are located on the left side of the library and either the top or bottom slot may be opened. Cleaning tapes also occupy slots in the library. The 'q libv' command gives the volser, status, use and home element (slot) containg each tape. The 'Status' may be Private, Scratch or Cleaner. Tapes that have not been assigned to a storage pool or used for Database Backups are in a general 'Scratch' pool and may be used for any process that needs a new tape. Tape Storage Pools There are two storage pools defined for the tapes in the tape library: TAPEPOOL, which is the normal migration target for the DISKPOOL storage pool, and; COPYPOOL, which is used to retain a second copy of all data whether on disk or tape. Because data is not automatically migrated to COPY storage pools, the administrative script DAILYCOPYPOOL copies the DISKPOOL to the COPYPOOL and then any files in the TAPEPOOL not already copied. This script is run at 6:30 am each day. Data is normally migrated from disk to tape based on percentage usage of the the disk storage pool DISKPOOL. Tape Drives will be automatically cleaned when they are detected to be dirty. Tapes in the Neo4100 tape library are set to dismount and return to their slots after 10 minutes of inactivity. It is possible that while the migration process is runnning a higher priority restore request will arrive from a client node. If this occurs TSM will preempt the migration and service the restore request. The tape volume utilization will be updated to indicate the balance of the data that still remains on the tape. Adding New Tapes to the Library New tapes may be added to the library if there are empty slots by first affixing a barcode label (currently in Dwight's office), then placing it (them) in one of the four magazines in any empty slot (this does not include the mailslots) and then issuing the command: label libv LB1.1.0.5 search=yes labels=barcode checkin=scratch or by running the predefined Admin command CHECKINNEWSCRATCH. TSM will locate each tape with a barcode label that is not currently in its database, label the tape and add it to the scratch pool. Any number of tapes may be added at once in this fashion. Warning: tapes put in mailslots will not be seen. Returning Old Tapes to the Library Scratch Pool Tapes that have been checked out because they are access=offsite or DB backup tapes need to be returned to the library when they are expired or no longer contain valid data. For 'offsite' tapes that have been reclaimed and marked empty and are returning to the scratchpool, they must first have their access reset to readwrite, which will also remove them from their storage pool.This can be done using Update Volume volumename access=readwrite Tapes are added back to the Scratch Pool with the following command: checkin libv LB1.1.0.5 volumename status=scratch A detailed description of the physical portion of this process complete with images is available here. COPYPOOL The COPYPOOL, as noted under 'Tape Storage Pools' above, acts as both a disk/tape failure backup and as the basis for disaster recovery through migration of tapes to 'offsite' status and subsequent removal from the tape library. Tapes in the COPYPOOL are marked 'Offsite' when they are full [this may change as we define our Disaster Recovery requirements] by the following command: update volume * access=offsite wherestgpool=copypool wherestatus=full To remove a tape from the library, particularly an 'offsite' volume: checkout libv LB1.1.0.5 volumename Space Usage Report Generation Procedure As of June 2000 the generation of the report at the tsm> prompt is run automatically on the 16th of every month via a crontab job on iscdev2. The report is emailed to tsm-admin@iscdev2.isc.ucsb.edu (presently logger@trixie and Kirk). It is then used as input to the Excel spreadsheet. As of November 1999 the space usage report is broken down by Policy Domains. Presently the following Policy Domain exist: tsm> q dom Policy Activated Activated Number of Description Domain Policy Default Registered Name Set Mgmt Nodes Class --------- --------- --------- ---------- ------------------------ ISC-ASG STANDARD STANDARD 16 IS&C ASG Nodes ISC-UOSG STANDARD STANDARD 1 IS&C UOSG nodes STANDARD STANDARD STANDARD 7 Installed default policy domain. SYSTEMS STANDARD STANDARD 27 Systems Group Backup Domain tsm> One way to construct an occupancy report listing each Policy Domain is to redirect each listing to a disk file that can then be imported into an Excel spreadsheet. 1) To build the disk file first start an tsm admin command line session from a PC workstation, then issue: tsm> q auditocc dom=ISC-ASG > c:\temp\991216-auditocc.txt Output of command redirected to file 'C:\TEMP\991216-AUDITOCC.TXT' tsm> q auditocc dom=ISC-UOSG >> c:\temp\991216-auditocc.txt Output of command redirected to file 'C:\TEMP\991216-AUDITOCC.TXT' tsm> q auditocc dom=STANDARD >> c:\temp\991216-auditocc.txt Output of command redirected to file 'C:\TEMP\991216-AUDITOCC.TXT' tsm> q auditocc dom=SYSTEMS >> c:\temp\991216-auditocc.txt Output of command redirected to file 'C:\TEMP\991216-AUDITOCC.TXT' Notice that the format of the filename is YYMMDD-AUDITOCC.TXT. You can substitute current date and file path as neccessary. You should now have "991216-auditocc.txt" in the directory you specified. You now need to import this file into Excel to generate summary data and to produce the versions of the report to post on the web. 3) Using Excel 97 SR-1 or later the import of the file you just created is straightforward. Choose OPEN, display all file types, select the 991216-auditocc.txt file and follow the prompts to map fix length fields to columns in the spreadsheet. You might check that the column boundaries get all the field. Excel should import and display the data in columns which you can resize as neccessary. 4) Once the new data is imported it is easiest to use a previously created report spreadsheet as a template to paste into. The major possible problem will be if there are more node rows in the new data than the template spreadsheet (likely if nodes were added so I pad the node rows with an extra 3-4 empties for this reason). If so just add additional rows in the template before the paste. Once the data is pasted into the appropriate sections you can use DATA:SORT to order by nodename. 5) Do some sanity checking on the calculated results post-paste, edit the header info, and SAVE AS an Excel worksheet (.xls) file using the YYMMDD-auditocc.xls format. Then CREATE PDF using the same basename and changing the extension. 6) Once the files are created move them to //borg/wwwroot/tsm/reports and edit the default.htm file to link to them. That's it for now. Turning this intoautomated misc billing records is TBD. - Kirk Database Backup Procedures The Database, which tracks the location and status of all the data on disk and tape is automatically backed up by scripts. This consists of doing incremental backups to disk each night and full backup to tape once a week. The Volhist for the Database backups is reatained for four weeks. The incrementals are copied off to Borg each night as part of the nightly script. tsm Tape Operator Response Procedures This section to be totally replaced. APPENDIX Command Script Index The following are the defined command scripts present in the system as of the last update to this howto. A script is run by executing "run script-name" at the tsm> prompt. The SET-STG-* scripts should only be used manually during database backup or tape reclaimation. Script Name Description Q-ACTLOG-24-FAILURE Query Activity Log for Failures in past 24 hours Q-EVENT-24 show previous 24 hour event history Q-EVENT-24-EX show previous 24 hour event history exceptions Q-EVENT-48 show previous 48 hour event history Q-EVENT-48-EX show previous 48 hour event history exceptions Q-EVENT-72 show previous 72 hour event history Q-EVENT-72-EX show previous 72 hour event history exceptions SET-STG-HI set high watermark on stgpools SET-STG-LO set low watermark on stgpools SET-STG-ZERO set stgpools to 0 to flush to tape SPACE-USAGE generate input to space mgmt spreadsheet report STATUS-CHECK check sessions, processes, request, stgpool SYSTEM-CONFIG output server configuration information tsm-mount-monitor program The tsm tape monitor program is located at /usr/local/bin/tsm-mount-monitor (amm for short) on iscdev2. amm is started by /usr/lpp/tsmserv/bin/rc.tsmserv at boot time via inittab. rc.tsmserv is the script that is used to start the adm server. If amm does not start for some reason it can be started manually as root with "nohup /usr/local/bin/tsm-mount-monitor &" - this will generate a nohup.out file in the current dir so you should start from your working directory or tmp so we don't get nohup all over the place. amm will check to see if a previous instance is running, if so it will kill it and then attempt to start. amm logs in /var/adm/ras/tsm/. amm works starting the dsmadmc client in mountmode which looks for activity concerning the tape drive. The putput is written to disk and periodically diff'd to see if an entries have been written. If so, the entries are grepped for keywords we care about. If these are found an email message is sent which get forwarded through the pager gateway thereby causing a page on to occur. The tsm-mount-monitor source as of 06/16/2000 looks like this: iscdev2:/usr/local/bin$ cat tsm-mount-monitor #!/usr/bin/ksh # # script to start tsm mountmode console, check for changes, and email alert # # 10/26/99 kgg # 03/22/00 kgg - made changes to cleanup routines to try and address the # occasionaly mystery email with stale mount messages. Also changed # logging so that alerts are written to a log as well to aid # debugging. # 03/23/00 kgg - moved "sleep xx" from rc.tsmserv to here to # circumvent the boot process checker from starting second instance # at boot time while the sleep was waiting. # see if you are root, which you need to be to write to log files if id | grep -v "^uid=0(" >/dev/null 2>&1 then echo "Hey!! - You need to be root to start this process!" exit fi # give the tsm server time to get up and spinning in case the # host was just rebooted. Otherwise the dsmadmc login will fail. # we should really test to see how we're called to determine if # we just rebooted but I don't have the time to dork with now. sleep 90 # setup vars for ease of maint logfile=/var/adm/ras/tsm/tsmmntlog msgfile=/tmp/msgfile alertlog=/var/adm/ras/tsm/tsmalertlog emailaddr=tsm-mnt-alert@trixie.isc.ucsb.edu sleeptime=300 # see if an existing, perhaps hung, instance is running and kill it # filter out lines that list the script being edited or running or # you kill yourself! ps -ef | grep tsm-mount-monitor | grep -v -E "grep|nedit|vi|$$" |\ kill -9 `awk '{print$2}'` >/dev/null 2>&1 # timestamp the restart in the history file echo "\n ** Restarting log monitor at `date`" >> $logfile.history echo "\n ** Restarting log monitor at `date`" >> $alertlog # keep running history file between restarts if [ -r $logfile ] then echo "\n ** Appending previous logfile at `date`" >> $logfile.history; cat $logfile >> $logfile.history ; rm -f $logfile ; fi # clean up any lingering temporary files rm -f $logfile.old rm -f $msgfile.* # start the command line tsm admin client in mountmode using account setup # for this script. sleep is req'd to wait for creation of logfile /usr/bin/dsmadmc -id=mountmon -password=xxxxxx -mountmode\ -outfile=$logfile >/dev/null 2>&1 & sleep 15 cp $logfile $logfile.old # hang out in this loop forever checking the logfile for changes # periodically. First grep in pipeline searches for changes in # the current logfile, second grep searches for strings we want # to send as notifications. if structure tests for non-empty # file (i.e. there were some differences) and formats a message # containing a timestamp and the logline(s) which is sent as an email. while : do diff $logfile.old $logfile | grep "\>" |\ grep -i -E "remove|insert|required|I/O Error|Media Fault"|\ uniq -c > $msgfile.2 if [ -s $msgfile.2 ] then echo "\n `date`" > $msgfile.1 ; cat $msgfile.1 $msgfile.2 > $msgfile.3 ; cat $msgfile.3 >> $alertlog ; mail -s "tsm-MNT-ALERT" $emailaddr < $msgfile.3 ; fi cp $logfile $logfile.old ; rm -f $msgfile.* ; sleep $sleeptime ; done iscdev2:/usr/local/bin$ The rc.tsmserv source as of 06/16/2000 looks like this: iscdev2:/usr/lpp/tsmserv/bin$ cat rc.tsmserv #!/bin/ksh # # Start up tsm Server.... # Get the language correct.... export LANG=en_US ulimit -d unlimited if [[ "$1" = 'kernel' ]]; then # Load the tsm kernel extension cd /usr/lpp/tsmserv/bin print "$(date '+%D %T') [tsm] Loading Kernel Extension" loadpkx -f pkmonx cd - else print "$(date '+%D %T') [tsm] Starting Server" # Start the server cd /usr/lpp/tsmserv/bin dsmserv quiet & # 10/11/99 kgg added to start monitor script on reboot # give the tsm server some time to fire up # 03/23/00 kgg moved sleep to tsm-mount-monitor script to # address boot process checker not seeing a-m-m running # and restarting # /usr/bin/sleep 90 /usr/local/bin/tsm-mount-monitor >/dev/null 2>&1 & fi iscdev2:/usr/lpp/tsmserv/bin$ daily exception report The daily execption report is generated by a script on trixietoo which is run by cron on a daily basis. The script runs a command script that is defined in the tsm configuration and documented elsewhere in this howto. The logfile is written to a directory that is published via the httpd server on trixietoo. # run the daily tsm exception report 45 07 * * * root /usr/local/bin/tsm-daily-ex-report 2>&1 >/dev/null [kgrier@trixietoo /etc]$ cat /usr/local/bin/tsm-daily-ex-report #!/bin/sh LOGFILE=/home/httpd/html/tsm/except-report/`date +%m-%d-%Y--%H%M`.log /usr/tsm/dsmadmc -id=operator -password=xxxxxx 'run q-event-24-ex' > $LOGFILE misc crontab jobs Generally the comment text makes these self-explanatory. # this tarballs up the tsmserv config files and vol history and ftps to borg 50 05 * * * /usr/lpp/tsmserv/bin/backup 2>&1 | mail -s "iscdev2 tsmserv backup" tsm-admin # this mails the tsm storage report to Kirk so he doesn't veg again 55 8 20 * * /usr/local/bin/tsm-monthly-report | mail -s "tsm monthly space usage report" tsm-report # iscdev2:/etc$ cat /usr/local/bin/tsm-monthly-report #!/bin/sh /usr/bin/dsmadmc -id=operator -password=xxxxxx 'run space-usage' iscdev2:/etc$ Tape Library Info Tape Library information, including numbers, warranty, location, etc. may be found here. Using Management Classes TSM is organized hiearchically by Policy Domain->Policy Set->Mgmt Class->Copy Group. Nodes exist in a Policy Domain and can choose to use one or more Mgmt Classes when backing up files. There is a default mgmt class typically called STANDARD which everyone in the Policy Domain gets unless they override manually via the dsm.opt file. I have created a Mgmt Class called "MCPIT90" in the ISC-ASG Policy Domain whose Copy Group settings are set to retain all data for 90 days thereby facilitating Point-In-Time restores over a sliding 90 day range. There is also a SYBDUMP Mgmt Class in the SYSTEMS Policy Domain whose Copy Group settings retain 1 inactive copy for 15 days before expiring. To use a mgmt class you need to edit it into your local dsm.opt file manually and assign via an INCLUDE directive. Locate your dsm.opt file and open in a text editor. There may ba link in the tsm program group to open the file in notepad. There should also be a link to the Online Help in the Program Group where there is more information. Here is a sample dsm.opt showing what you need to edit in. Note the other excludes. Please edit this in and then run an incremental using the tsm Command Line client - just type "i" at the dsmc> prompt. It should churn and then you should see many "rebinding" messages as the SYBDUMP management class is bound to the indicated files. The dsm.opt include / exclude directives are processed from the bottom of the list up until a match is found. In this example the Mgmt Class SYBDUMP is bound to the "\Program Files\" directory, files and subdirectories before and of the excludes are processed. ## dsm.opt snippet follows ## NODENAME DEFIANT PASSWORDACCESS GENERATE TCPSERVERADDRESS dataplus.isc.ucsb.edu EXCLUDE.DIR "D:\CD-IMAGES" EXCLUDE.DIR "D:\BACKUP" EXCLUDE.DIR "D:\MP3" EXCLUDE.DIR "D:\PUB" exclude "*:\microsoft uam volume\*" exclude "*:\microsoft uam volume\...\*" exclude "*:\...\ea data. sf" exclude "*:\...\pagefile.sys" exclude "*:\...\ibmbio.com" exclude "*:\ibmdos.com" exclude "*:\msdos.sys" exclude "*:io.sys" exclude.dir *:\recycled exclude.dir *:\recycler exclude.dir *:\...\system32\wins exclude.dir *:\...\system32\LServer exclude.dir *:\...\system32\dhcp exclude.dir *:\...\system32\config exclude.dir "*:\system volume information" exclude *:\...\system32\perflib*.dat exclude.dir "*:\...\temporary internet files" exclude.dir "*:\...\cache" exclude.dir "*:\wutemp" exclude "*:\documents and settings\...\ntuser.dat.LOG" exclude "*:\documents and settings\...\ntuser.dat" exclude "*:\documents and settings\...\usrclass.dat.LOG" exclude "*:\documents and settings\...\usrclass.dat" include "*:\program files\*" SYBDUMP include "*:\program files\...\*" SYBDUMP ########## # unloaddb ########## cd /usr/tivoli/tsm/server/bin ./dsmserv unloaddb devclass=TSMEXPORT |tee /tmp/unloaddb.log ANR7800I DSMSERV generated at 03:00:29 on Dec 8 2005. Tivoli Storage Manager for AIX-RS/6000 Version 5, Release 2, Level 7.0 Licensed Materials - Property of IBM (C) Copyright IBM Corporation 1999,2003. All rights reserved. U.S. Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corporation. ANR0900I Processing options file dsmserv.opt. ANR0902W Unsupported keyword found in file dsmserv.opt. ANR0906I Line No. : 13 ANR0907I Statement : TAPEIOBUFS 9 ANR0908W Error : |........... ANR7811I Direct I/O will be used for all eligible disk files. ANR0990I Server restart-recovery in progress. ANR0200I Recovery log assigned capacity is 3952 megabytes. ANR0201I Database assigned capacity is 7100 megabytes. ANR0306I Recovery log volume mount in progress. ANR0353I Recovery log analysis pass in progress. ANR0354I Recovery log redo pass in progress. ANR0355I Recovery log undo pass in progress. ANR0352I Transaction recovery complete. ANR1635I The server machine GUID, 4b.b5.90.fe.d4.4b.11.da.a0.0b.08.63.ac.1a.f1 .0c, has initialized. ANR2100I Activity log process has started. ANR4726I The NAS-NDMP support module has been loaded. ANR4726I The Centera support module has been loaded. ANR1305I Disk volume /opt/tsm/diskpools/dp.dir/dp.dir1.dsm varied online. ANR1305I Disk volume /opt/tsm/diskpools/dp.dbpool_log/dp.dbpool_log1.dsm varied online. ANR1305I Disk volume /opt/tsm/diskpools/dp.vpnet_log/dp.vpnet_log1.dsm varied online. ANR1305I Disk volume /opt/tsm/diskpools/dp.vpdepot_log/dp.vpdepot_log1.dsm varied online. ANR1305I Disk volume /opt/tsm/diskpools/dp.server/dp.server_kbw2.dsm varied online. ANR1305I Disk volume /opt/tsm/diskpools/dp.server/dp.server_kbw1.dsm varied online. ANR1305I Disk volume /opt/tsm/diskpools/dp.server/dp.server1.dsm varied online.ANR1305I Disk volume /opt/tsm/diskpools/dp.mnet_log/dp.mnet_log1.dsm varied online. ANR1305I Disk volume /opt/tsm/diskpools/dp.server/dp.server2.dsm varied online.ANR1412W Volume 000248 access mode is "unavailable". ANR1414W Volume 000125 access mode is "read-only" due to previous write error. ANR1305I Disk volume /opt/tsm/diskpools/dp.mdepot_log/dp.mdepot_log1.dsm varied online. ANR8200I TCP/IP driver ready for connection with clients on port 1500. ANR0610I UNLOADDB started by ADMINISTRATOR as process 0. ANR8340I FILE volume /tsmexport/45966928.DMP mounted. ANR1360I Output volume /tsmexport/45966928.DMP opened (sequence number 1). ANR8774W Volume 000099 not checked into library 3494LIB but is using category 300. ANR8451I 349X library 3494LIB is ready for operations. ANR0362W Database usage exceeds 92 % of its assigned capacity. ANR4013I UNLOADDB: Dumped 660823 database entries (cumulative). ANR4013I UNLOADDB: Dumped 1355730 database entries (cumulative). ... ############ # loadformat ############ ./dsmserv loadformat 1 /usr/tivoli/tsm/server/log/log1.dsm 1 /usr/tivoli/tsm/server/db/db1.dsm ./dsmserv loadformat 1 /usr/tivoli/tsm/server/logcopy/log1copy.dsm 1 /usr/tivoli/tsm/server/dbcopy/db1copy.dsm ANR7800I DSMSERV generated at 03:00:29 on Dec 8 2005. Tivoli Storage Manager for AIX-RS/6000 Version 5, Release 2, Level 7.0 Licensed Materials - Property of IBM (C) Copyright IBM Corporation 1999,2003. All rights reserved. U.S. Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corporation. ANR0900I Processing options file dsmserv.opt. ANR0902W Unsupported keyword found in file dsmserv.opt. ANR0906I Line No. : 13 ANR0907I Statement : TAPEIOBUFS 9 ANR0908W Error : |........... ANR7811I Direct I/O will be used for all eligible disk files. ANR0300I Recovery log format started; assigned capacity 3952 megabytes. ANR0301I Recovery log format in progress; 4 megabytes of 3952. ANR0301I Recovery log format in progress; 8 megabytes of 3952. ##################### # dsmserv.dsk fuellen ##################### loadformat loeschtr die eintraege aus der dsmserv.dsk diese eintraege muessen haendisch nachgepflegt werden. nach dem loaddb muessen die copyvols gesynced werden ######## # loaddb ######## ./dsmserv loaddb devclass=TSMEXPORT vol=45966928.dmp,45967953.dmp,45968825.dmp,45969833.dmp,45970945.dmp ANR7800I DSMSERV generated at 03:00:29 on Dec 8 2005. Tivoli Storage Manager for AIX-RS/6000 Version 5, Release 2, Level 7.0 Licensed Materials - Property of IBM (C) Copyright IBM Corporation 1999,2003. All rights reserved. U.S. Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corporation. ANR0900I Processing options file dsmserv.opt. ANR0902W Unsupported keyword found in file dsmserv.opt. ANR0906I Line No. : 13 ANR0907I Statement : TAPEIOBUFS 9 ANR0908W Error : |........... ANR7811I Direct I/O will be used for all eligible disk files. ANR0990I Server restart-recovery in progress. ANR0200I Recovery log assigned capacity is 3952 megabytes. ANR0201I Database assigned capacity is 7900 megabytes. ANR0306I Recovery log volume mount in progress. ANR0353I Recovery log analysis pass in progress. ANR0354I Recovery log redo pass in progress. ANR0355I Recovery log undo pass in progress. ANR0352I Transaction recovery complete. ANR4003I LOADDB: Database load process started. ANR8200I TCP/IP driver ready for connection with clients on port 1500. ANR8340I FILE volume /tsmexport/45966928.dmp mounted. ANR1363I Input volume /tsmexport/45966928.dmp opened (sequence number 1). ANR4038I LOADDB: Loading database information dumped on 04/25/06 at 14:08:49. ANR4403I LOADDB: Database dump image is consistent - a database audit (AUDITDB) will NOT be required if this load completes successfully. ANR4039I LOADDB: Loaded 562252 database entries (cumulative). ANR4039I LOADDB: Loaded 1113492 database entries (cumulative). ANR4039I LOADDB: Loaded 1679929 database entries (cumulative). ANR4039I LOADDB: Loaded 2252388 database entries (cumulative). ANR4039I LOADDB: Loaded 2846646 database entries (cumulative). ###################### # syncen der db/logvol ###################### define dbcopy /usr/tivoli/tsm/server/db/db1.dsm /usr/tivoli/tsm/server/dbcopy/db1copy.dsm define logcopy /usr/tivoli/tsm/server/log/log1.dsm /usr/tivoli/tsm/server/logcopy/log1copy.dsm ################# # volume preemted ################# Preemption of Client or Server Operations The server can preempt server or client operations for a higher priority operation when a mount point is in use and no others are available, or access to a specific volume is required. You can use the QUERY MOUNT command to see the status of the volume for the mount point. Mount Point Preemption The following high priority operations can preempt operations for a mount point: - Backup database - Restore - Retrieve - HSM recall - Export - Import The following operations cannot preempt other operations nor can they be preempted: - Audit Volume - Restore from a copy storage pool - Prepare a recovery plan - Store data using a remote data mover The following operations can be preempted and are listed in order of priority. The server selects the lowest priority operation to preempt, for example reclamation. 1. Move data 2. Migration from disk to sequential media 3. Backup, archive, or HSM migration 4. Migration from sequential media to sequential media 5. Reclamation You can disable preemption by specifying NOPREEMPT in the server options file. When this option is specified, the BACKUP DB command is the only operation that can preempt other operations. Volume Access Preemption A high priority operation that requires access to a specific volume currently in use by a low priority operation can automatically preempt the operation. For example, if a restore request requires access to a volume in use by a reclamation process and a drive is available, the reclamation process is canceled and message ANR0494I or ANR1441I is issued. The following high priority operations can preempt operations for access to a specific volume: - Restore - Retrieve - HSM recall The following operations cannot preempt other operations nor can they be preempted: - Audit Volume - Restore from a copy storage pool - Prepare a recovery plan - Store data using a remote data mover The following operations can be preempted, and are listed in order of priority. The server preempts the lowest priority operation, for example reclamation. 1. Move data 2. Migration from disk to sequential media 3. Backup, archive, or HSM migration 4. Migration from sequential media 5. Reclamation You can disable preemption by specifying NOPREEMPT in the server options file. When this option is specified, no operation can preempt another operation for access to a volume. ########################################################## # Using the IBM Tivoli Storage Manager (TSM) SQL interface ########################################################## This tip describes the SQL interface (enhanced in IBM Tivoli Storage Manager 5.1) and some typical uses for monitoring the Tivoli Storage Manager server. For additional information on the Tivoli Storage Manager implementation of SQL please refer to \u201cUsing SQL to Query Tivoli Storage Manager Database\u201d in the manual - Tivoli Storage Manager for Administrator \u2019s Guide Version 5 Release 1; (such as, for Windows, GC32-0782). For Windows environments, Tivoli Storage Manager also provides an ODBC driver. This driver supports the ODBC 3.5 specification. Because Tivoli Storage Manager supports only the select SQL query command, the driver does not conform to any ODBC API or SQL grammar conformance level. After you install this driver, you can use a spreadsheet or database application that supports ODBC (such as Lotus Approach, Lotus 1-2-3 or Microsoft Access) to access the database. Command syntax The basic syntax description for the select SQL query command is: SELECT [ALL |DISTINCT ] column1 [,column2 ] FROM table1 [,table2 ] [WHERE "conditions"] [GROUP BY "column-list"] [HAVING "conditions ] [ORDER BY "column-list"[ASC |DESC ] ] Note the following differences from "standard" SQL: The Tivoli Storage Manager implementation of the select SQL query command does not support the following operations: * UNION * INTERSECT * EXCEPT * Correlated subqueries (returning multiple values) * Semicolon cannot be used as a command terminator The TSM database system catalog Tivoli Storage Manager provides three system catalog tables so you can discover information is available in the database: * SYSCAT.TABLES Contains information about all tables that can be queried with the select SQL query command. * SYSCAT.COLUMNS Contains information about the columns in each table. * SYSCAT.ENUMTYPES Contains information about the valid values for each enumerated type and the order of the values for each type. SQL usage restrictions Because complicated or lengthy queries can affect Tivoli Storage Manager server performance, the usage of the select SQL query command has restrictions imposed. These should be considered before you use SQL to query the TSM database: * You cannot issue the select SQL query command from a server console. * If an select SQL query command requires significant server time or resources, you will be asked to confirm your request. * Select SQL query commands use temporary table storage in the database and require at least one free 4 MB partition. Without this partition, temporary table storage space will become exhausted. The more processing that a query requires, the greater requirement for free space. SQL example queries To illustrate the versatility of the SQL query interface, we provide below some typical administration questions, together with a corresponding select SQL query which will generate an answer: * Which client nodes currently locked from server access? select node_name from nodes where locked='YES' * Which administrative clients currently locked from server access? select admin_name from admins where locked='YES' * Which client nodes that has not specified the correct password lately? select node_name from nodes where invalid_pw_count <>0 * Which administrative clients that has not specified the correct password lately? select admin_name from admins where invalid_pw_count <>0 * Which nodes in the WINDOWS policy domain are not associated with the daily backup schedule STANDARD? select node_name from nodes where domain_name='WINDOWS'and node_name- not in (select node_name from associations - where domain_name='WINDOWS'and schedule_name='STANDARD') * Which administrators have policy authority? select admin_name from admins - where upper(system_priv)<>'NO'or upper(policy_priv)<>'NO' * What messages of type E (ERROR) or W (WARNING) have been issued in the time period for which activity log records have been maintained? select date_time,msgno,message from actlog where severity='E'or severity='W' * Which administrative schedules have been defined or altered by administrator ADMIN ? select schedule_name from admin_schedules where chg_admin='ADMIN' * What are the relative administrative schedule priorities? select schedule_name,priority from admin_schedules order by priority * Which management classes have an archive copy group with a retention period greater than 365 days? select domain_name,set_name,class_name - from ar_copygroups where retver='NOLIMIT'or cast(retver as integer)>365 * Which management classes specify more than 5 backup versions? select domain_name,set_name,class_name - from bu_copygroups where verexists ='NOLIMIT'or cast(verexists as integer)>5 * Which client nodes are using the client option set named SECURE ? select node_name from nodes where option_set='SECURE' * How many client nodes are in each policy domain? select domain_name,num_nodes from domains * How many files have been archived from each node? select node_name,count(*)from archives group by node_name * Which clients are using space management? select node_name from auditocc where spacemg_mb <>0 * If the reclamation threshold were to be changed to 50 percent for storage pool TAPE , how many volumes would be reclaimed? select count(*)from volumes - where stgpool_name='TAPE'and upper(status)='FULL'and pct_utilized <50 * If the DAILY management class in the STANDARD policy domain is changed or deleted, how many backup files would be affected for each node? select node_name,count(*)as "Files"- from backups where class_name='DAILY'and - node_name in (select node_name from nodes where domain_name='STANDARD')- group by node_name * For all active client sessions, determine how long have they been connected and their effective throughput in bytes per second. select session_id as "Session",- client_name as "Client",state as "State",- current_timestamp-start_time as "Elapsed Time",(- cast(bytes_sent as decimal(18,0))/cast((current_timestamp-start_time)- seconds as decimal(18,0)))as "Bytes sent/second",- (cast(bytes_received as decimal(18,0))/cast((current_timestamp-start_time)- seconds as decimal(18,0)))as "Bytes received/second"- from sessions * How long have the current background processes been running and what is their effective throughput in time and files per second? select process_num as "Number",process,- current_timestamp-start_time as "Elapsed Time",- (cast(files_processed as decimal(18,0))/cast((current_timestamp-start_time)- seconds as decimal(18,0)))as "Files/second",- (cast(bytes_processed as decimal(18,0))/cast((current_timestamp-start_time)- seconds as decimal(18,0)))as "Bytes/second"- from processes * How many client nodes are there for each platform type? select platform_name,count(*)as "Number of Nodes" from nodes group by platform_name * How many filespaces does each client node have, listed in default ascending order? select node_name,count(*)as "number of filespaces"- from filespaces group by node_name order by 2 * How to display all columns for all tables from syscat.columns without headers select char(concat(concat(t.tabname,'.'),c.colname),35)as "TC",char - (coalesce(nullif(substr(c.typename,1,posstr(c.typename,'(')-1)- ,''),c.typename),10),char(c.length,5),c.remarks - from syscat.columns as c,syscat.tables AS t - where c.tabname =t.tabname order by tc * How to examine which volumes are UNAVAILABLE select VOLUME_NAME,ACCESS from volumes where access ='UNAVAILABLE' * How to examine which volumes have more than three write errors select VOLUME_NAME,WRITE_ERRORS from volumes where write_errors >3 * How to examine which volumes have read errors select VOLUME_NAME,READ_ERRORS from volumes where read_errors >0 * How to examine which volumes have an error state different from No select VOLUME_NAME,ERROR_STATE from volumes where error_state !='No' * How to examine which volumes have access different from READWRITE select VOLUME_NAME,ACCESS from volumes where access !='READWRITE' * How to examine which volumes have less than ten percent utilization in device class beginning with the letters SUN select volume_name,pct_utilized,status,access from volumes- where pct_utilized <10 and devclass_name like 'SUN%' * How to examine which volumes do not have an access beginning with the letters READ select volume_name,pct_utilized,pct_reclaim,stgpool_name,- status,access from volumes where access not like 'READ%' * How to list the content of all volumes and display the filesize in MB, ordered by client node name, volume name and size select node_name,- volume_name,- decimal(file_size/1024/1024,12,2)mb,- concat(substr(file_name,1,posstr(file_name,'')-1),- substr(file_name,posstr(file_name,'')+1))- from contents - order by node_name,volume_name,mb * How to find all clients which store their backup data in the DISKPOOL storage pool select node_name as "CLIENT NODENAME",- bu_copygroups.destination as "STGPOOL DESTINATION",- nodes.domain_name as "CLIENT DOMAIN",- bu_copygroups.domain_name as "COPYGROUP DOMAIN"- from nodes,bu_copygroups where - nodes.domain_name =bu_copygroups.domain_name and - bu_copygroups.destination=upper('diskpool')and - bu_copygroups.set_name=upper('active')- order by nodes.domain_name * How to find all volumes which have data for a specified client, and their status select volumeusage.volume_name,- volumes.access,- volumes.error_state,- volumeusage.stgpool_name - from volumeusage,volumes - where volumeusage.node_name='ONE-ON-ONE'and- volumeusage.volume_name=volumes.volume_name - order by volume_name * How to find all storage pools where a client (FRED) has stored data select distinct(STGPOOL_NAME)from OCCUPANCY where node_name='FRED'