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:[EMAIL PROTECTED] Sent: Friday, August 22, 2003 7:10 AM To: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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
