1) Could take a while depending on how you changed your retention for example
if you went from 180 active version of a file to 20 then TSM would have to
potentially expire 60xeach changed file. In additional WIN2k is not know for
very fast I/O, not to mention if your tsm db is not layed out in an optimal way
(multiple disks etc) could affect performance of that process
If you need to cancel make sure and do "Cancel expiration" so when you start
expire inventory again it should pick up where it left off. Keep an eye on
your log, expiration could reek havoc on it.
2- 3 ) Hard to say, I think there's a way to find out object count other than
keeping an eye on the process which tells you how many expired and how many
processed.
Hope this helps
-----Original Message-----
From: Ken Sedlacek [mailto:Ken_Sedlacek AT KYRUS DOT COM]
Sent: Friday, August 22, 2003 7:10 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Expire Inventory process on a 24GB DB?
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
|
