ADSM-L

Expire Inventory process on a 24GB DB?

2003-08-22 08:11:21
Subject: Expire Inventory process on a 24GB DB?
From: Ken Sedlacek <Ken_Sedlacek AT KYRUS DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 22 Aug 2003 08:10:22 -0400
Enviro:

W2K TSM 5.1.6.3

I have been doing an "expire inventory"  for some 14 hours now after
changing the MC  (# in retain extra versions) which is causing rebinding.

Number of nodes to rebind:
Node Name   Type  Filespace    FSID  Storage     Number of   Physical
Logical
                  Name               Pool Name       Files      Space
Space
                                                             Occupied
Occupied
                                                                 (MB)
(MB)
----------  ----  ----------  -----  ----------  ---------  ---------
---------
CIR_SERVER  Bkup  \\cir_ser-      1  DLTPOOL2       40,486   3,746.67
3,626.22
                   ver\c$
CIR_SERVER  Bkup  \\cir_ser-      2  DLTPOOL2       55,701  51,335.77
51,329.46
                   ver\d$
CIR_SERVER  Bkup  \\cir_ser-      3  DLTPOOL2          582   5,181.29
5,181.29
                   ver\f$
CIR_SERVER  Bkup  \\cir_ser-      4  DLTPOOL2           78   3,810.46
3,810.46
                   ver\g$
CIR_SERVER  Bkup  \\cir_ser-      5  DLTPOOL2          563   8,537.17
8,537.17
                   ver\h$
CIR_SERVER  Bkup  \\cir_ser-      6  DLTPOOL2       21,886  21,195.37
21,195.36
                   ver\i$
CIR_SERVER  Bkup  SYSTEM          7  DLTPOOL2       11,611   1,457.64
1,457.64
                   OBJECT
GV-GRIEG    Bkup  \\gv-grie-      1  DLTPOOL2        8,014   1,360.96
1,303.52
                   g\c$
GV-GRIEG    Bkup  \\gv-grie-      2  DLTPOOL2       16,136  708,755.7
708,365.9
                   g\d$                                             4  0
GV-HELPDE-  Bkup  \\gv-help-      1  DLTPOOL2        9,889     930.72
821.88
 SK                desk\c$
GV-HELPDE-  Bkup  \\gv-help-      2  DLTPOOL2      173,454  339,038.7
337,217.2
 SK                desk\d$                                          0  5
GV-HELPDE-  Bkup  \\gv-help-      3  DLTPOOL2            3       0.00
0.00
 SK                desk\e$
GV-ITDEV    Bkup  \\gv-itde-      1  DLTPOOL2       20,795   1,919.14
1,828.15
                   v\c$
GV-ITDEV    Bkup  \\gv-itde-      2  DLTPOOL2    26,319,35  2,201,544
2,188,569
                   v\d$                                  2        .79  .38
GV-ITDEV    Bkup  \\gv-itde-      3  DLTPOOL2            2       0.01
0.01
                   v\e$
GV-ITDEV    Bkup  \\gv-itde-      4  DLTPOOL2        1,381     584.32
584.32
                   v\f$
GV-ITDEV    Bkup  \\gv-itde-      5  DLTPOOL2           14       5.37
5.37
                   v\j$
GV-ITDEV    Bkup  SYSTEM          6  DLTPOOL2       38,194   4,773.29
4,773.29
                   OBJECT
GV-ODIN     Bkup  \\gv-odin-      1  DLTPOOL2        4,450     930.13
890.27
                   \c$
GV-ODIN     Bkup  \\gv-odin-      2  DLTPOOL2      319,636  40,882.39
40,738.97
                   \d$
GV-PVCS     Bkup  \\gv-pvcs-      1  DLTPOOL2       17,860   2,052.13
1,937.81
                   \c$
GV-SCDHCP   Bkup  \\gv-scdh-      1  DLTPOOL2        7,036     823.27
798.70
                   cp\c$
GV-TASKE    Bkup  \\gv-task-      1  DLTPOOL2        9,939   1,664.50
1,658.13
                   e\c$
GV-TASKE    Bkup  \\gv-task-      2  DLTPOOL2        4,039     280.37
280.37
                   e\e$
GV1         Bkup  \\gv1\c$        1  DLTPOOL2       10,380     991.95
972.94
GV1         Bkup  \\gv1\d$        2  DLTPOOL2        5,909   1,504.43
1,504.43
GV1         Bkup  \\gv1\f$        3  DLTPOOL2          541     195.28
195.28
GV1         Bkup  SYSTEM          4  DLTPOOL2       30,623   4,485.21
4,485.21
                   OBJECT
GV_NUTKIN   Bkup  \\gv_nutk-      1  DLTPOOL2        5,865     975.10
851.19
                   in\c$
GV_NUTKIN   Bkup  \\gv_nutk-      2  DLTPOOL2            2       0.01
0.01
                   in\d$
GV_NUTKIN   Bkup  \\gv_nutk-      3  DLTPOOL2          986   4,261.35
4,261.35
                   in\e$
GV_ROCKY    Bkup  \\gv_rock-      1  DLTPOOL2        4,533     656.26
601.28
                   y\c$
GV_ROCKY    Bkup  \\gv_rock-      2  DLTPOOL2        4,343  83,665.93
83,665.93
                   y\d$
GV_ROCKY    Bkup  \\gv_rock-      3  DLTPOOL2            2       0.01
0.01
                   y\e$
HOTSPALT    Bkup  /               1  DLTPOOL2        2,610      41.95
41.95
HOTSPALT    Bkup  /usr            2  DLTPOOL2       47,607   1,532.10
1,532.10
HOTSPALT    Bkup  /var            3  DLTPOOL2        1,758     951.87
951.40
HOTSPALT    Bkup  /home           4  DLTPOOL2        2,660      71.24
71.24
HOTSPALT    Bkup  /home/wor-      5  DLTPOOL2        1,114      80.45
80.45
                   kflow
HOTSPALT    Bkup  /opt            6  DLTPOOL2      114,104  31,088.24
31,088.24
HOTSPALT    Bkup  /opt2           7  DLTPOOL2           99  25,501.85
25,501.85
METRIXALT   Bkup  /               1  DLTPOOL2        1,386      45.93
45.93
METRIXALT   Bkup  /usr            2  DLTPOOL2       34,377     934.21
934.21
METRIXALT   Bkup  /var            3  DLTPOOL2          581     212.50
212.03
METRIXALT   Bkup  /home           4  DLTPOOL2          882      43.43
43.43
METRIXALT   Bkup  /u01            6  DLTPOOL2        6,432   1,900.38
1,900.38
METRIXALT   Bkup  /u02            7  DLTPOOL2       28,839  89,814.19
89,814.19
METRIXALT   Bkup  /u04            8  DLTPOOL2        3,436     905.88
905.88
OPSMAN      Bkup  \\opsman\-      1  DLTPOOL2       18,085   2,396.45
2,368.26
                   c$
OPSMAN      Bkup  \\opsman\-      2  DLTPOOL2        1,581     502.55
502.55
                   d$
REMINGTON   Bkup  \\remingt-      1  DLTPOOL2        8,192     888.72
832.49
                   on\c$
REMINGTON   Bkup  \\remingt-      2  DLTPOOL2       60,164   1,458.34
1,457.35
                   on\d$
REMINGTON   Bkup  \\remingt-      3  DLTPOOL2        1,275     240.98
240.98
                   on\e$
REMINGTON   Bkup  \\remingt-      4  DLTPOOL2          165   5,731.13
5,731.13
                   on\f$
REMINGTON   Bkup  SYSTEM          5  DLTPOOL2       28,238   3,482.55
3,482.55
                   OBJECT
SC-METAPP   Bkup  \\sc-meta-      1  DLTPOOL2       11,406     964.63
960.24
                   pp\c$
SC-METAPP   Bkup  \\sc-meta-      2  DLTPOOL2       40,121   5,527.85
5,518.97
                   pp\d$
SC-METAPP   Bkup  SYSTEM          3  DLTPOOL2       22,335   2,788.92
2,788.92
                   OBJECT
SC-METWEB   Bkup  \\sc-metw-      1  DLTPOOL2       14,612     939.54
935.31
                   eb\c$
SC-METWEB   Bkup  \\sc-metw-      2  DLTPOOL2        5,133   1,161.58
1,159.03
                   eb\d$
SC-METWEB   Bkup  SYSTEM          3  DLTPOOL2       35,876   4,455.33
4,455.33
                   OBJECT
SC-SECURI-  Bkup  \\sc-secu-      1  DLTPOOL2       17,912  12,362.90
12,336.03
 TY                rity\c$
SC-SECURI-  Bkup  SYSTEM          2  DLTPOOL2       37,920   4,732.53
4,732.53
 TY                OBJECT
SC-SMTP     Bkup  \\sc-smtp-      1  DLTPOOL2       13,241   5,596.53
5,595.94
                   \c$
SC-SMTP     Bkup  SYSTEM          2  DLTPOOL2       17,040   2,114.82
2,114.82
                   OBJECT
SC-SOFTWA-  Bkup  \\sc-soft-      1  DLTPOOL2       27,399   1,936.64
1,844.37
 RE                ware\c$
SC-SOFTWA-  Bkup  \\sc-soft-      2  DLTPOOL2      277,823  245,605.9
245,518.5
 RE                ware\d$                                          3  5
SC-SOFTWA-  Bkup  \\sc-soft-      3  DLTPOOL2       12,462  90,466.91
90,462.62
 RE                ware\e$
SC-SOFTWA-  Bkup  SYSTEM          4  DLTPOOL2        5,386     680.69
680.69
 RE                OBJECT


I have a 24GB DB size.

DB stats:

          Available Space (MB): 24,576
        Assigned Capacity (MB): 24,576
        Maximum Extension (MB): 0
        Maximum Reduction (MB): 2,996
             Page Size (bytes): 4,096
            Total Usable Pages: 6,291,456
                    Used Pages: 5,277,014
                      Pct Util: 83.9
                 Max. Pct Util: 87.8
              Physical Volumes: 12
             Buffer Pool Pages: 20,480
         Total Buffer Requests: 110,438,051
                Cache Hit Pct.: 97.57
               Cache Wait Pct.: 0.00
           Backup in Progress?: No
    Type of Backup In Progress:
  Incrementals Since Last Full: 0
Changed Since Last Backup (MB): 11,610.30
            Percentage Changed: 56.32
Last Complete Backup Date/Time: 08/20/2003 09:09:27


Here is the expiration process:

Process Process Description  Status
  Number
-------- --------------------
-------------------------------------------------
   1,484 Expiration           Examined 2450439 objects, deleting 2427768
backup
                               objects, 0 archive objects, 0 DB backup
volumes,
                               0 recovery plan files; 0 errors
encountered.

The TSM W2K server is a PIII/667 server.

Can someone tell me if:

1) Going  on 14 hrs now, is this a normal time to rebind a 24GB DB for the
PIII/667 processor?

2) Suggest a DB select statement to tell me how many total objects are in
the DB proper?

3) How can I gauge how much longer the expire inventory is going to take?

TIA.



Ken Sedlacek
AIX/TSM/UNIX Administrator
ksedlacek AT kyrus DOT com

IBM Certified Specialist: RS/6000 AIX v4.3 Support
IBM Certified Specialist: RS/6000 SP & PSSP 3
Tivoli Certified Consultant - Tivoli Storage Manager v4.1

<Prev in Thread] Current Thread [Next in Thread>