FAQ TSM

Creation: 12 mai 2010
Mise à jour: 18 aout 2014
Version: 1.3
Author: Jean-Louis Bicquelet-Salaün
Location: http://jlbicquelet.free.fr
Copyright: (c) 2010-2013 Jean-Louis BICQUELET-SALAÜN

TSM Frequently-Asked Questions

Cela faisait longtemps que je voulais écrire une FAQ pour TSM. Mais c'est vraiment difficile de savoir par quel bout prendre ce monument de la sauvegarde. Et pourtant depuis 1999, j'ai eu le temps de me familiariser avec lui.

Ca y est. Je me lance, en étant conscient que ce n'est pas exhaustif et en espérant que ce receuil de commandes en ligne va vous servir à vous aussi.

Pour plus d'information au sujet de cette faq, contactez Jean-Louis BICQUELET


FAQ Revised: Monday 18 August 2014 19:39:00


Table of Contents

1. generalites
2. utilisation
3. serveur
4. database
5. drives
6. librairie
7. nodes
8. bandes
9. management class
10. sauvegardes
11. archives
12. schedules
13. logs
14. db backup

1. generalites

1.1. comment obtenir plus d'information sur une commande?
Il ne faut pas hésiter à utiliser la commande help suivi du mot clé ou des mots clés de la commande.
help REDUCE DB
3.45.1 REDUCE DB (Decrease the assigned capacity of the database)

Use this command to decrease the space that can be used by the database.



Attention: Do not change the size of an allocated database volume after
      it has been defined to Tivoli Storage Manager. If you do, Tivoli
      Storage Manager may not initialize correctly and data could be
      lost.

You can issue the REDUCE DB command while users are accessing the
server. Use the QUERY DB command to determine how much you can reduce
the assigned capacity of the database.



Privilege class

To issue this command, you must have system privilege or unrestricted
storage privilege.



2. utilisation

2.1. comment lancer dsm en mode interractif?
Lancez dsmadmc et entrer votre nom de compte et votre mot de passe.
 dsmadmc
IBM Tivoli Storage Manager
Command Line Administrative Interface - Version 5, Release 3, Level 5.0
(c) Copyright by IBM Corporation and other(s) 1990, 2007. All Rights Reserved.

Enter your user id:  admin

Enter your password:

Session established with server TSM: AIX-RS/6000
  Server Version 5, Release 3, Level 6.2
  Server date/time: 16-04-2010 11:21:20  Last access: 16-04-2010 11:18:55


2.2. comment lancer une commande tsm en mode batch?
dsmadmc -id=batch -password=batch -outfile=clients.txt q node

Le résultat se trouvera dans le fichier clients.txt.

2.3. comment obtenir de l'aide?
tsm: TSM>help
  1 - Using Syntax Diagrams
  2 - Entering Administrative Commands
  3 - Using the Command Line Interface
  4 - Using the Server Console
  5 - Using the Administrative Command Line Client
  6 - Console Mode
  7 - Mount Mode
  8 - Batch Mode
  9 - Interactive Mode
 10 - Using Continuation Characters
 11 - Redirecting Command Output
 12 - Using Commands Based on Privilege Class
 13 - Commands Requiring System Privilege
 14 - Commands Requiring Policy Privilege
 15 - Commands Requiring Storage Privilege
 16 - Commands Requiring Operator Privilege
 17 - Commands Requiring Analyst Privilege
 18 - Commands Any Administrator Can Issue

Pour obtenir de l'aide sur un domaine précis on précise le numéro:

tsm: TSM>help 15
Commands Requiring Storage Privilege
  ------------------------------------------------------------------------

Commands Requiring Storage Privilege

An administrator with storage privilege can issue commands that allocate and
control storage resources for the server. The commands that an administrator
can issue depend on the authority granted to them by an administrator with
system privilege. As an administrator with storage privilege, you can have
unrestricted or restricted storage privilege.

Unrestricted storage privilege permits you to issue all of the administrator
commands that require storage privilege. You can issue commands that affect
all existing storage pools as well as any storage pools that are defined in
the future. You can also issue commands that affect the database and the
recovery log. An unrestricted storage administrator cannot define or delete
storage pools.

Restricted storage privilege permits you to issue administrator commands
that only affect a storage pool for which you have been granted authority.
For example, the DELETE VOLUME command only affects a storage pool volume
that is defined to a specific storage pool.

Table 7 lists the commands an administrator with storage privilege can
issue.

Table 7. Storage Privilege Commands
 Command Name                       Command Name
      AUDIT LIBRARY                      DELETE SPACETRIGGER
      AUDIT VOLUME (See note.)           DELETE VIRTUALFSMAPPING
      BACKUP DB                          DELETE VOLHISTORY
      BACKUP DEVCONFIG                   DELETE VOLUME (See note.)
      BACKUP STGPOOL                     EXTEND DB
      BACKUP VOLHISTORY                  EXTEND LOG
      CHECKIN LIBVOLUME                  GRANT PROXYNODE
      CHECKOUT LIBVOLUME                 LABEL LIBVOLUME
      DEFINE COLLOCGROUP                 MIGRATE STGPOOL
      DEFINE COLLOCMEMBER                MOVE DATA (See note.)
      DEFINE DATAMOVER                   MOVE MEDIA
      DEFINE DBBACKUPTRIGGER             QUERY TAPEALERTMSG
      DEFINE DBCOPY                      RECLAIM STGPOOL
      DEFINE DBVOLUME                    REDUCE DB
      DEFINE DEVCLASS                    REDUCE LOG
      DEFINE DRIVE                       RESTORE STGPOOL
      DEFINE LIBRARY                     RESTORE VOLUME
      DEFINE LOGCOPY                     REVOKE PROXYNODE
      DEFINE LOGVOLUME                   SET LOGMODE
      DEFINE PATH                        SET TAPEALERTMSG
      DEFINE VIRTUALFSMAPPING            UPDATE COLLOCGROUP
      DEFINE VOLUME (See note.)          UPDATE DATAMOVER
      DEFINE SPACETRIGGER                UPDATE DBBACKUPTRIGGER
      DELETE COLLOCGROUP                 UPDATE DEVCLASS
      DELETE COLLOCMEMBER                UPDATE DRIVE
      DELETE DATAMOVER                   UPDATE LIBRARY
more...   ( to continue, 'C' to cancel)

      DELETE DBBACKUPTRIGGER             UPDATE LIBRARY
      DELETE DBVOLUME                    UPDATE PATH
      DELETE DEVCLASS                    UPDATE SPACETRIGGER
      DELETE DRIVE                       UPDATE STGPOOL (See note.)
      DELETE LIBRARY                     UPDATE VIRTUALFSMAPPING
      DELETE LOGVOLUME
      DELETE PATH

 Note:
      This command can be restricted by storage pool. An administrator with
      unrestricted storage privilege or restricted storage privilege for a
      specified storage pool can issue this command.



3. serveur

3.1. Comment connaitre l'état du serveur?
tsm: TSM>q status
Storage Management Server for AIX-RS/6000 - Version 5, Release 3, Level 6.2


                                Server Name: TSM
             Server host name or IP address: SAVE.ORG.TM.FR
                  Server TCP/IP port number: 1500
                                 Server URL:
                                Crossdefine: On
                        Server Password Set: Yes
              Server Installation Date/Time: 03-06-2003 11:09:30
                   Server Restart Date/Time: 14-04-2010 09:19:35
                             Authentication: On
                 Password Expiration Period: 9 999 Day(s)
              Invalid Sign-on Attempt Limit: 3
                    Minimum Password Length: 8
WEB Admin Authentication Time-out (minutes): 120
                               Registration: Closed
                             Subfile Backup: No
                               Availability: Enabled
                                 Accounting: Off
                     Activity Log Retention: 10 Day(s)
             Activity Log Number of Records: 1082525
                          Activity Log Size: 97 M
          Activity Summary Retention Period: 30 Day(s)
                       License Audit Period: 30 Day(s)
                         Last License Audit: 14-04-2010 09:21:08
                  Server License Compliance: Valid
                          Central Scheduler: Active
                           Maximum Sessions: 3 000
                           ...


3.2. Comment connaitre l'espace occupée par les clients?
q occu

Node Name      Type     Filespace       FSID     Storage        Number of      Physical       Logical
                        Name                     Pool Name          Files         Space         Space
                                                                               Occupied      Occupied
                                                                                   (MB)          (MB)
----------     ----     ----------     -----     ----------     ---------     ---------     ---------
3Dserv      Bkup     \\3dserve-         1     STG_COPY_-        14 254      1 264,70      1 186,78
                         ur\c$                    RESEAU_A-
                                                  PP_SL8500
3Dserv      Bkup     \\3dserve-         1     STG_COPY_-         3 483        327,54        327,54
                         ur\c$                    X86_VTL_-
                                                  SL8500
3Dserv      Bkup     \\3dserve-         1     STG_TAPES-        14 254      1 283,54      1 186,78
                         ur\c$                    L8500_RE-
                                                  SEAU_APP
3Dserv      Bkup     \\3dserve-         2     STG_COPY_-           281      2 515,74      2 515,74
                         ur\d$                    RESEAU_A-
                                                  PP_SL8500
3Dserv      Bkup     \\3dserve-         2     STG_COPY_-            47      1 796,06      1 796,06
                         ur\d$                    X86_VTL_-
                                                  SL8500
                                                  ...



4. database

4.1. comment examiner la database TSM?
query 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
--------- -------- --------- --------- ------- --------- --------- ----- -----
   34,000       16    33,984        12   4,096     4,096       224   5.5   5.5

Si vous désirez plus de détail:

q db f=d

                   Available Space (MB): 34,000
                 Assigned Capacity (MB): 16
                 Maximum Extension (MB): 33,984
                 Maximum Reduction (MB): 12
                      Page Size (bytes): 4,096
                     Total Usable Pages: 4,096
                             Used Pages: 224
                               Pct Util: 5.5
                          Max. Pct Util: 5.5
                       Physical Volumes: 3
                      Buffer Pool Pages: 76,800
                  Total Buffer Requests: 2,919
                         Cache Hit Pct.: 94.24
                        Cache Wait Pct.: 0.00
                    Backup in Progress?: No
             Type of Backup In Progress:
           Incrementals Since Last Full: 0
         Changed Since Last Backup (MB): 0.88
                     Percentage Changed: 100.00
         Last Complete Backup Date/Time:
     Estimate of Recoverable Space (MB):
more...   ( to continue, 'C' to cancel)

Last Estimate of Recoverable Space (MB):


4.2. comment examiner les logs?
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
--------- -------- --------- --------- ------- --------- --------- ----- -----
    4,500    4,500         0     4,496   4,096 1,151,488       350   0.0   0.0

pour plus de détail on précisera l'option f=d.

q log f=d

       Available Space (MB): 4,500
     Assigned Capacity (MB): 4,500
     Maximum Extension (MB): 0
     Maximum Reduction (MB): 4,496
          Page Size (bytes): 4,096
         Total Usable Pages: 1,151,488
                 Used Pages: 350
                   Pct Util: 0.0
              Max. Pct Util: 0.0
           Physical Volumes: 3
             Log Pool Pages: 512
         Log Pool Pct. Util: 0.83
         Log Pool Pct. Wait: 0.00
Cumulative Consumption (MB): 3.86
Consumption Reset Date/Time: 01/30/09   15:03:18


4.3. comment surveiller les fichiers associés à la base?
q dbvol

Volume Name       Copy    Volume Name       Copy    Volume Name       Copy
(Copy 1)          Status  (Copy 2)          Status  (Copy 3)          Status
----------------  ------  ----------------  ------  ----------------  ------
/tsmdb/db/db.dsm  Sync'd                    Undef-                    Undef-
                                             ined                      ined
/tsmdb/db/db1.d-  Sync'd                    Undef-                    Undef-
 sm                                          ined                      ined
/tsmdb/db/db3.d-  Sync'd                    Undef-                    Undef-
 sm                                          ined                      ined


4.4. comment savoir où se trouvent les fichiers de log associés à la base?
q logvol

Volume Name       Copy    Volume Name       Copy    Volume Name       Copy
(Copy 1)          Status  (Copy 2)          Status  (Copy 3)          Status
----------------  ------  ----------------  ------  ----------------  ------
/tsmlog/log/log-  Sync'd                    Undef-                    Undef-
 1.dsm                                       ined                      ined
/tsmlog/log/log-  Sync'd                    Undef-                    Undef-
 2.dsm                                       ined                      ined
/tsmlog/log/log-  Sync'd                    Undef-                    Undef-
 .dsm                                        ined                      ined


4.5. comment détruire un volume db TSM?
delete dbvolume /tsmdb/db/db3.dsm
ANR2243I Database volume /tsmdb/db/db3.dsm deleted.


4.6. Comment lister les informations de la database?
tsm: TSM>SELECT * FROM db

   AVAIL_SPACE_MB: 165000
      CAPACITY_MB: 165000
 MAX_EXTENSION_MB: 0
 MAX_REDUCTION_MB: 12036
        PAGE_SIZE: 4096
     USABLE_PAGES: 42240000
       USED_PAGES: 35976110
     PCT_UTILIZED: 85.1
 MAX_PCT_UTILIZED: 86.0
 PHYSICAL_VOLUMES: 7
  BUFF_POOL_PAGES: 201216
 TOTAL_BUFFER_REQ: 2506000733
    CACHE_HIT_PCT: 99.3
   CACHE_WAIT_PCT: 0.0
   BACKUP_RUNNING: NO
      BACKUP_TYPE:
  NUM_BACKUP_INCR: 0
    BACKUP_CHG_MB: 5512.8
   BACKUP_CHG_PCT: 3.9
 LAST_BACKUP_DATE: 2010-05-12 07:06:25.000000
     DB_REORG_EST:
DB_REORG_EST_TIME:


4.7. Comment connaitre le pourcentage d'occupation de la database?
SELECT pct_utilized FROM db

PCT_UTILIZED
------------
        85.1


4.8. Comment connaitre le nombre de volume de la database non synchronisés ?
TSM > SELECT COUNT(*) FROM dbvolumes WHERE ( NOT copy1_status='Synchronized' OR NOT -
cont>   copy2_status='Synchronized' OR NOT copy3_status='Synchronized' )

 Unnamed[1]
-----------
          0


4.9. Comment obtenir un état d'occupation de la database ?

TSM > SELECT avail_space_mb,capacity_mb, pct_utilized, max_pct_utilized,last_backup_date FROM db

AVAIL_SPACE_MB     CAPACITY_MB     PCT_UTILIZED     MAX_PCT_UTILIZED       LAST_BACKUP_DATE
--------------     -----------     ------------     ----------------     ------------------
        165000          165000             85.1                 86.0             2010-05-12
                                                                            07:06:25.000000


4.10. Comment obtenir la date du dernier backup de la database ?
TSM > SELECT last_backup_date FROM db

  LAST_BACKUP_DATE
------------------
        2010-05-12
   07:06:25.000000



5. drives

5.1. comment connaitre le nombre de drives qui ne sont pas online ?
 TSM>SELECT COUNT(*) FROM drives WHERE NOT online='YES'

 Unnamed[1]
-----------
          0


5.2. Comment connaitre l'état des drives?
q mount
ANR8330I LTO volume 920117 is mounted R/W in drive DRIVE1 (/dev/rmt1), status: IN USE.
ANR8330I LTO volume 920035 is mounted R/W in drive DRIVE6 (/dev/rmt5), status: IN USE.
ANR8329I LTO volume 920810 is mounted R/W in drive VT2_C_DR21 (/dev/rmt26), status: IDLE.
ANR8334I         3 matches found.

On peut ajouter f=d pour avoir plus de détails.


6. librairie

6.1. comment lister les librairies ?
q libr

         Library Name: SL8500
         Library Type: ACSLS
               ACS Id: 0
     Private Category:
     Scratch Category:
WORM Scratch Category:
     External Manager:
               Shared: No
              LanFree:
   ObeyMountRetention:

         Library Name: VTL1_CACHE
         Library Type: SCSI
               ACS Id:
     Private Category:
     Scratch Category:
WORM Scratch Category:
     External Manager:
               Shared: Yes
              LanFree:
   ObeyMountRetention:


6.2. comment obtenir le numéro de série de la librairies ?
q libr VTL1_CACHE f=d

                  Library Name: VTL1_CACHE
                  Library Type: SCSI
                        ACS Id:
              Private Category:
              Scratch Category:
         WORM Scratch Category:
              External Manager:
                        Shared: Yes
                       LanFree:
            ObeyMountRetention:
       Primary Library Manager:
                           WWN:
                 Serial Number: 0TF9Q89O04
                     AutoLabel: Yes
                  Reset Drives: No
               Relabel Scratch:
Last Update by (administrator): ADMIN
         Last Update Date/Time: 03/11/09   17:33:54


6.3. comment afficher les caractéristiques de la librairie ?
q libr

Library Name   Library      ACS   Private    Scratch    WORM       External         Shared   LanFree   ObeyMountRetention
               Type         Id    Category   Category   Scratch    Manager
                                                        Category
------------   ----------   ---   --------   --------   --------   --------------   ------   -------   ------------------
SL8500         ACSLS        0                                                       No
VTL1_CACHE     SCSI                                                                 Yes
VTL1_NO_CAC-   SCSI                                                                 Yes
 HE
VTL2_CACHE     SCSI                                                                 Yes
VTL2_NO_CAC-   SCSI                                                                 Yes
 HE

On peut évidement obtenir plus de détails avec f=d.

6.4. comment afficher le contenu de la librairie?
q libv

Library Name     Volume Name     Status         Owner          Last Use      Home        Device
                                                                             Element     Type
------------     -----------     ----------     ----------     ---------     -------     ------
SL8500           920001          Private
SL8500           920002          Private
SL8500           920003          Private                       Data
SL8500           920004          Private                       Data
SL8500           920005          Private                       Data
SL8500           920012          Scratch
SL8500           920034          Private                       Data
SL8500           920035          Private                       Data
SL8500           920036          Private                       Data



7. nodes

7.1. comment obtenir la liste des nodes ?
TSM > TSM QUERY NODES
Node Name                     Platform     Policy Domain      Days Since     Days Since     Locked?
                                           Name               Last Acce-       Password
                                                                      ss            Set
-------------------------     --------     --------------     ----------     ----------     -------
ALCOR                         WinNT        DOM_RESEAU_SL-            169          1 979       No
                                            8500
ACTARUS                       WinNT        DOM_RESEAU_SL-             <1          2 365       No
                                            8500
BATMAN                        Linux86      DOM_RESEAU_SL-              1          1 629       No
                                            8500



7.2. comment lister tous les clients TSM d'un serveur avec un ordre donné?
On trie par plateforme et par nom de serveur.
select node_name,domain_name,platform_name,contact,tcp_address from nodes order by platform_name,node_name

Pour obtenir les paramètres possible pour select et order, il suffit d'utiliser la commande:

q node f=d


7.3. comment récupérer les informations concernant un node ?
q node belinda

Node Name                     Platform     Policy Domain      Days Since     Days Since     Locked?
                                           Name               Last Acce-       Password
                                                                      ss            Set
-------------------------     --------     --------------     ----------     ----------     -------
BELINDA                       Linux86      DOM_RESEAU_SL-             <1          2 148       No
                                            8500


7.4. comment récupérer les informations détaillées concernant un node ?
Comme toujours avec TSM pour obtenir des informations détaillées sous TSM, il faut ajouter f=d en fin de ligne.
TSM>q node  belinda f=d

                     Node Name: BELINDA
                      Platform: Linux86
               Client OS Level: 2.6.9-55.
                Client Version: Version 5, Release 3, Level 4.0
            Policy Domain Name: DOM_RESEAU
         Last Access Date/Time: 12-05-2010 00:33:32
        Days Since Last Access: <1
        Password Set Date/Time: 24-06-2004 11:07:55
       Days Since Password Set: 2 148
         Invalid Sign-on Count: 0
                       Locked?: No
                       Contact: RESEAU
                   Compression: Client
       Archive Delete Allowed?: No
        Backup Delete Allowed?: No
        Registration Date/Time: 30-01-2004 10:45:53
     Registering Administrator: MOI
Last Communication Method Used: Tcp/Ip
   Bytes Received Last Session: 14,02 M
       Bytes Sent Last Session: 6,67 M
      Duration of Last Session: 102,32
   Pct. Idle Wait Last Session: 1,50
  Pct. Comm. Wait Last Session: 2,48
  Pct. Media Wait Last Session: 0,00
                     Optionset:
                           URL: http://172.0.0.1:1581
                     Node Type: Client
    Password Expiration Period:
             Keep Mount Point?: No
  Maximum Mount Points Allowed: 2
        Auto Filespace Rename : No
             Validate Protocol: No
                   TCP/IP Name: belinda
                TCP/IP Address: 172.0.0.1
            Globally Unique ID: ae.0b.59.xx.xx.xx.xx.xx.xx.xx.00.xx.xx.xx.xx.x
         Transaction Group Max: 0
               Data Write Path: ANY
                Data Read Path: ANY
            Session Initiation: ClientOrServer
            High-level Address:
             Low-level Address:
        Collocation Group Name:
              Proxynode Target:
               Proxynode Agent:


8. bandes

8.1. comment connaitre le nombre de bandes scratch ?
select count(*) from libvolumes where status='Scratch'

 Unnamed[1]
-----------
        671

Et pour une commande précise le nom de la commande

help audit library
AUDIT LIBRARY

AUDIT LIBRARY (Audit Volume Inventories in an Automated Library)

Use this command to audit and synchronize volume inventories in an automated
library.

When the AUDIT LIBRARY command is issued on a library client, the client
synchronizes its inventory with the inventory on the library manager. If the
library client detects inconsistencies, it corrects them by changing the
ownership of the volume on the library manager.

When the AUDIT LIBRARY command is issued on a server where the library is
SCSI, 349X or ACSLS (LIBTYPE=SCSI, LIBTYPE=349X, or LIBTYPE=ACSLS), the
server synchronizes its inventory with the inventory of the library device.
If the server detects inconsistencies, it deletes missing volumes from its
inventory.

   * In SCSI libraries, the server also updates the locations of volumes in
     its inventory that have been moved since the last audit.
   * In 349X libraries, the server also ensures that scratch volumes are in
     the scratch category and that private volumes are in the private
     category.

When the AUDIT LIBRARY command is issued on a server that is a library
manager for the library (SHARED=YES), the server updates ownership of its
volumes if it detects inconsistencies.



9. management class

9.1. comment afficher les management class?
q mgmt

Policy        Policy        Mgmt          Default       Description
Domain        Set Name      Class         Mgmt
Name                        Name          Class ?
---------     ---------     ---------     ---------     ------------------------
DOMAINE_-     ACTIVE        MCB_ORGA-     Yes           BACKUP RESEAU
 ORGANIS-                    NIS_RES-
 _RESEAU-                    EAU_14J-
 _VTL1                       _DEF
DOMAINE_-     ACTIVE        MCB_ORGA-     No            BACKUP RESEAU
 ORGANIS-                    NIS_RES-
 _RESEAU-                    EAU_180J
 _VTL1*..


9.2. comment connaitre les management class ?
dsmc q mgmt -optfile=/usr/tivoli/tsm/client/ba/bin64/ar-dsm.opt
IBM Tivoli Storage Manager
Command Line Backup-Archive Client Interface
  Client Version 6, Release 2, Level 4.0
  Client date/time: 08/18/14   15:27:40
(c) Copyright by IBM Corporation and other(s) 1990, 2011. All Rights Reserved.

Node Name: BATMAN_AR
Session established with server SERVER01: AIX
  Server Version 6, Release 3, Level 4.300
  Server date/time: 08/18/14   15:27:40  Last access: 08/18/14   15:19:55

Domain Name               : FS
Activated Policy Set Name : FS-CR
Activation date/time      : 04/09/13   14:18:28
Default Mgmt Class Name   : AR_12M
Grace Period Backup Retn. : 35 day(s)
Grace Period Archive Retn.: 365 day(s)

MgmtClass Name                  : AR_12M
Description                     : Archivage SUR TAPE RETV 12Mois

MgmtClass Name                  : AR_36M
Description                     : Archivage SUR TAPE RETV 36Mois



10. sauvegardes

10.1. comment visualiser les systèmes de fichiers sauvegardés?
TSM Scrollable Window - Query Filespace

     #      Last Incr Date      Type    File Space Name
        --------------------------------------------------------------------------------------------------------------
     1. | 2010-11-16 09:42:12   JFS2    /
     2. | 2010-05-06 23:45:48   API:DominoData  /SDAPP
     3. | 2010-08-04 14:53:45   JFS2    /apps/domino/6.5
     4. | 2010-08-04 14:54:01   JFS2    /apps/domino/6.5
     5. | 2010-08-04 14:37:00   JFS2    /data/notes 
     6. | 0000-00-00 00:00:00   JFS2    /data/notes/mail
    20. | 2010-08-04 15:06:26   JFS2    /data/notes2/TL
        0---------10--------20--------30--------40--------50--------60--------70--------80--------90--------100-------
<U>=Up  <D>=Down  <R>=Right  <L>=Left  <O>=Ok  <Q>=Quit
query filespace

L’ajout de l’option –scrollprompt=yes (par défaut –scrollprompt=no) permet d’obtenir le défilement page par page.

  • L’option –ina permet de visualiser les versions inactives, c’est-à-dire d’anciennes versions, des fichiers. Si on ne met pas –ina, on n’a que la dernière version.
  • L’option –su=yes (par défaut –su=no) permet de visualiser les sous-répertoires des répertoires


10.2. comment visualiser les fichiers et les répertoires?
tsm> q b / -ina
           Size        Backup Date                Mgmt Class         A/I File
           ----        -----------              ----------          --- ----
         4,096  B  2010-11-16 09:42:10          mgt_class          A  /
           256  B  2010-08-04 13:45:10          mgt_class          A  /.SPOT
           256  B  2010-08-04 13:45:10          mgt_class          A  /apps
           256  B  2010-08-04 13:45:10          mgt_class          A  /audit
           256  B  2010-08-04 13:59:54          mgt_class          A  /data
        16,384  B  2010-08-04 13:45:10          mgt_class          A  /dev
        12,288  B  2010-08-04 13:45:10          mgt_class          A  /etc
           256  B  2010-08-04 13:45:10          mgt_class          A  /lost+found
        12,288  B  2010-08-04 13:45:10          mgt_class          A  /lpp



11. archives

11.1. comment lister les archives?
dsmc q arch  /data/project/*RECU*
IBM Tivoli Storage Manager
Command Line Backup-Archive Client Interface
  Client Version 6, Release 2, Level 4.0
  Client date/time: 08/18/14   14:46:00
(c) Copyright by IBM Corporation and other(s) 1990, 2011. All Rights Reserved.

Node Name: BATMAN_AR
Session established with server TSMXP12: AIX
  Server Version 6, Release 3, Level 4.300
  Server date/time: 08/18/14   14:46:00  Last access: 08/18/14   14:31:31

             Size  Archive Date - Time    File - Expires on - Description
             ----  -------------------    -------------------------------
   117,862,427  B  01/01/14   17:03:36    /data/project/CFT29_RECUS_H046.Z 03/09/24   archivage TSM 10 ans fichiers CTF29 - 2014-01-01
   107,081,831  B  02/01/14   17:04:55    /data/project/CFT29_RECUS_D141_H014.Z 04/09/24   archivage TSM 10 ans fichiers CFT29 - 2014-02-01
   114,424,947  B  05/31/14   17:02:47    /data/project/CFT29_RECU_D131_H0707.Z 08/06/24   archivage TSM 10 ans fichiers CFT29 - 2014-05-31
             0  B  08/05/14   17:02:22    /data/project/CFT29_RECUS_D140_H0125 10/11/24   archivage TSM 10 ans fichiers UNIX13 - 2014-08-05
             0  B  07/26/14   17:02:16    /data/project/CFT29_RECUS_D726_H010 10/01/24   archivage TSM 10 ans fichiers UNIX13 - 2014-07-26
 3,259,087,326  B  07/01/14   17:02:41    /data/project/CFT29_RECUS_D802_H02 09/06/24   archivage TSM 10 ans fichiers UNIX13 - 2014-07-0
 


11.2. comment restaurer une archive ?
dsmc retri  /data/project/CFT29_RECUS_D802_H02
IBM Tivoli Storage Manager
Command Line Backup-Archive Client Interface
  Client Version 6, Release 2, Level 4.0
  Client date/time: 08/18/14   15:04:01
(c) Copyright by IBM Corporation and other(s) 1990, 2011. All Rights Reserved.

Retrieve function invoked.

Node Name: SXPCOD01_AR
Session established with server TSMXP12: AIX
  Server Version 6, Release 3, Level 4.300
  Server date/time: 08/18/14   15:04:01  Last access: 08/18/14   15:02:16

Retrieving   3,259,087,326 /data/project/CFT29_RECUS_D802_H02 [Done]

Retrieve processing finished.

Total number of objects retrieved:        1
Total number of objects failed:           0
Total number of bytes transferred:     3.03 GB
Data transfer time:                   61.92 sec
Network data transfer rate:        51,394.40 KB/sec
Aggregate data transfer rate:      14,910.20 KB/sec
Elapsed processing time:           00:03:33



12. schedules

12.1. comment lister les serveurs qui n'ont pas de schedule associés ?
 TSM>SELECT node_name FROM nodes WHERE node_name NOT IN (SELECT node_name FROM associations)

NODE_NAME
------------------
C1_APP
C1_INC
C1_SYS



13. logs

13.1. comment afficher les logs ?
q actlog

Date/Time                Message
--------------------     ----------------------------------------------------------
16-04-2010 10:40:15      ANE4987E (Session: 36519, Node: BATMAN01)  Error
                          processing '\\asfosar01\d$\Profils\ASFMAG\ma
                          messagerie\parent.lock': the object is in use by another
                          process(SESSION: 36519)
16-04-2010 10:40:17      ANE4987E (Session: 36519, Node: BATMAN01)  Error
                          processing '\\asfosar01\d$\Profils\ASFMOU\ma
                          messagerie\parent.lock': the object is in use by another
                          process(SESSION: 36519)
16-04-2010 10:40:58      ANR0403I Session 36519 ended for node BATMAN01 (WinNT).
                          (SESSION: 36519)
16-04-2010 10:40:58      ANR0406I Session 42339 started for node BATMANR01 (WinNT)
                          (Tcp/Ip ftpasfosar.ccmsa.msanet(3472)). (SESSION: 42339)
16-04-2010 10:40:58      ANR0480W Session 42339 for node BATMAN01 (WinNT)
                          terminated - connection with client severed. (SESSION:
                          42339)
16-04-2010 10:40:58      ANR0406I Session 42340 started for node BATMAN01 (WinNT)
                          (Tcp/Ip batman01.monorg.fr(3473)). (SESSION: 42340)
16-04-2010 10:40:58      ANR0480W Session 42340 for node BATMAN01 (WinNT)
                          terminated - connection with client severed. (SESSION:
...


13.2. comment afficher les logs en cherchant en fonction d'un critere?

On peut chercher un serveur:

tsm: TSM>q actlog search=batgirl

Date/Time                Message
--------------------     ----------------------------------------------------------
16-04-2010 10:42:22      ANR0406I Session 42349 started for node CB_APP (AIX)
                          (Tcp/Ip batgirl(37535)). (SESSION: 42349)
16-04-2010 10:42:23      ANR0406I Session 42350 started for node CB_APP (AIX)
                          (Tcp/Ip batgirl(37537)). (SESSION: 42350)
16-04-2010 10:42:23      ANR0406I Session 42351 started for node CB_APP (AIX)
                          (Tcp/Ip batgirl(37539)). (SESSION: 42351)
16-04-2010 10:42:23      ANR0406I Session 42352 started for node CB_APP (AIX)
                          (Tcp/Ip batgirl(37543)). (SESSION: 42352)

On peut chercher une heure dans les messages:

tsm: TSM>q actlog search=11:02:49

Date/Time                Message
--------------------     ----------------------------------------------------------
16-04-2010 11:43:25      ANR2017I Administrator BATCH issued command: QUERY ACTLOG
                          searc=11:02:49  (SESSION: 42474)
16-04-2010 11:45:04      ANR2017I Administrator BATCH issued command: QUERY ACTLOG
                          search=11:02:49  (SESSION: 42474)

Il est aussi possible de chercher un code erreur (ici à partir d'une certaine heure).

tsm: TSM>q actlog begintime=05:00 search=ANR8325I


13.3. comment afficher les logs entre deux heures données?
q actlog begint='11:43:25' endtime='11:45:04'

Date/Time                Message
--------------------     ----------------------------------------------------------
16-04-2010 11:43:25      ANR2017I Administrator BATCH issued command: QUERY ACTLOG
                          searc=11:02:49  (SESSION: 42474)
16-04-2010 11:44:08      ANR0407I Session 42490 started for administrator cerbere
                          (WebBrowser) (HTTP 170.247.243.35(62025)). (SESSION:
                          42490)
16-04-2010 11:44:08      ANR0405I Session 42490 ended for administrator cerbere
                          (WebBrowser). (SESSION: 42490)
16-04-2010 11:44:10      ANR4391I Expiration processing node DOC03, filespace
                          SYSTEM OBJECT, fsId 2, domain DOM_RESEAU_SL8500, and
                          management class DEFAULT - for BACKUP type files.
                          (SESSION: 39964, PROCESS: 162)
16-04-2010 11:44:40      ANR4391I Expiration processing node CB_APP, filespace
                          /GETIMA/TECH, fsId 1, domain DOM_ORGANIS_APP_VTL2, and
                          management class MCAS_ORGANIS_APP_7J - for ARCHIVE type
                          files. (SESSION: 39964, PROCESS: 162)
16-04-2010 11:44:52      ANR2017I Administrator BATCH issued command: QUERY ACTOLOG
                           (SESSION: 42474)
16-04-2010 11:44:52      ANR2000E Unknown command - QUERY ACTOLOG. (SESSION: 42474)
16-04-2010 11:44:52      ANR2017I Administrator BATCH issued command: ROLLBACK
                          (SESSION: 42474)
16-04-2010 11:44:54      ANR2017I Administrator BATCH issued command: A  (SESSION:
                          42474)
16-04-2010 11:44:54      ANR2000E Unknown command - A. (SESSION: 42474)
16-04-2010 11:44:54      ANR2017I Administrator BATCH issued command: ROLLBACK
                          (SESSION: 42474)
16-04-2010 11:44:58      ANR4391I Expiration processing node CB_APP, filespace /,
                          fsId 2, domain DOM_ORGANIS_APP_VTL2, and management class
                          MCAS_ORGANIS_APP_30J - for ARCHIVE type files. (SESSION:
                          39964, PROCESS: 162)
16-04-2010 11:45:04      ANR2017I Administrator BATCH issued command: QUERY ACTLOG
                          search=11:02:49  (SESSION: 42474)


13.4. comment afficher les logs d'il y a deux jours?
On utilise l'option begindate suivie du nombre de jour (-1 pour hier, -2 pour avant-hier et ainsi de suite).

On peut bien sur cumuler avec begintime et endtime pour filtrer sur l'heure.

On eput aussi utiliser enddate pour donner un interval.

>q actlog begind=-2

Date/Time                Message
--------------------     ----------------------------------------------------------
14-04-2010 10:53:49      ANR0406I Session 776 started for node ironman (WinNT)
                          (Tcp/Ip 172.16.2.6(2105)). (SESSION: 776)
14-04-2010 10:53:50      ANR0403I Session 776 ended for node ironman (WinNT).
                          (SESSION: 776)
14-04-2010 10:54:53      ANE4952I (Session: 765, Node: CB_APP)  Total number of
                          objects inspected:        3(SESSION: 765)
14-04-2010 10:54:53      ANE4953I (Session: 765, Node: CB_APP)  Total number of
                          objects archived:         3(SESSION: 765)
14-04-2010 10:54:53      ANE4958I (Session: 765, Node: CB_APP)  Total number of
                          objects updated:          0(SESSION: 765)
14-04-2010 10:54:53      ANE4960I (Session: 765, Node: CB_APP)  Total number of
                          objects rebound:          0(SESSION: 765)
14-04-2010 10:54:53      ANE4957I (Session: 765, Node: CB_APP)  Total number of
                          objects deleted:          0(SESSION: 765)
14-04-2010 10:54:53      ANE4970I (Session: 765, Node: CB_APP)  Total number of
                          objects expired:          0(SESSION: 765)
14-04-2010 10:54:53      ANE4959I (Session: 765, Node: CB_APP)  Total number of
                          objects failed:           0(SESSION: 765)
14-04-2010 10:54:53      ANE4961I (Session: 765, Node: CB_APP)  Total number of


13.5. comment afficher les logs entre deux dates?
Il suffit de respecter la syntaxe suivante:
tsm: TSM>q actlog begindate='04/04/2010' enddate='06/04/2010'

Date/Time                Message
--------------------     ----------------------------------------------------------
06-04-2010 00:00:01      ANR2562I Automatic event record deletion started.
06-04-2010 00:00:01      ANR2102I Activity log pruning started: removing entries
                          prior to 03/27/10 00:00:00.



14. db backup

14.1. comment compter le nombre de db backup dans les 24 heures passées ?

On peut évidement remonter plus loin dans le temps ou compter en jours.

TSM > SELECT COUNT(*) FROM volhistory WHERE  type='BACKUPFULL' AND date_time>=current_timestamp-24 hours

 Unnamed[1]
-----------
          1

 TSM>SELECT COUNT(*) FROM volhistory WHERE type='BACKUPFULL' AND date_time>=current_timestamp-4 days

 Unnamed[1]
-----------
          3



14.2. comment lister les bandes de db backup ?
TSM > SELECT date_time, type, backup_series, volume_seq, devclass, volume_name FROM volhistory WHERE 
 ( type='BACKUPFULL' OR type='BACKUPINCR' OR type='DBSNAPSHOT' ) AND date_time>=current_timestamp- 48 hours

         DATE_TIME  TYPE                BACKUP_SERIES  VOLUME_SEQ  DEVCLASS            VOLUME_NAME
------------------  ------------------  -------------  ----------  ------------------  ------------------
        2010-05-11  BACKUPFULL                   2006           1  SL8500              930287
   05:55:07.000000
        2010-05-12  BACKUPFULL                   2007           1  SL8500              930222
   07:06:25.000000


14.3. comment vérifier si il y a eu des db backup incrémentales depuis ?
TSM > SELECT COUNT(*) FROM volhistory WHERE type='BACKUPINCR'  AND date_time>=current_timestamp-24 hours

 Unnamed[1]
-----------
          0



Copyright (c) 2001-2014 Jean-Louis BICQUELET

This list of questions and answers was generated by makefaq.