We have a 112gb database that is 83% utilized and it only takes 30 minutes to complete an expire inventory. Either I have a real fast server or you have a real slow one!
-----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Rees, Chris (Corp) Sent: Friday, June 10, 2005 10:15 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: very very big DB!!!! Hi Rick Our unload/reload what about 10 weeks ago and halved our database from 100Gb for 50Gb... the database has grown by 20% since but expire inventory is still much quicker than it was prior to the unload/reload, it is however taking longer than immediately after the process... definitely a worthwhile exercise. Before 21 hours Immediately after unload/reload 6 hours Now 10 hours It examines 21million objects.. Chris -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Rhodes Sent: Friday, June 10, 2005 3:06 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] very very big DB!!!! Did you notice a performance improvement after the reorg. If you did, is it still performing better since it has grown? Thanks Rick "Warren, Matthew (Retail)" To: ADSM-L@VM.MARIST.EDU <[EMAIL PROTECTED] cc: RGEN.CO.UK> Subject: Re: very very big DB!!!! Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED] U> 06/10/2005 06:24 AM Please respond to "ADSM: Dist Stor Manager" It is different from DBBackup - there are specific load/unload abilities in TSM. The process results in the DB being re-orged. We recently went through the process and approximatley halved the size of our 120GB DB, the gain is fairly short lived though. The re-org was around 8 weeks ago and the DB is back up to 80% of its original size. Matt. Computer says 'No'.. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Clark Sent: Thursday, June 09, 2005 3:33 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: very very big DB!!!! unload / load? you mean backup then restore. will that reorg the db? >>> [EMAIL PROTECTED] 06/09/2005 10:23:23 AM >>> 30 GB is not outrageously large. I've worked with one that was almost twice that size. You can unload and load the database or perhaps do an audit on it. There's an entire section called utilities in the Admin Reference. Be forewarned that an audit could take days if not weeks...!!! --- Mario Di Pede <[EMAIL PROTECTED]> wrote: > Hi > I have a TSM DB of 30 Gb - there are a utilities for cleaning its????? > > thank's all > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___________________________ Disclaimer Notice __________________________ This message and any attachments are confidential and should only be read by those to whom they are addressed. If you are not the intended recipient, please contact us, delete the message from your computer and destroy any copies. Any distribution or copying without our prior permission is prohibited. Internet communications are not always secure and therefore Powergen Retail Limited does not accept legal responsibility for this message. The recipient is responsible for verifying its authenticity before acting on the contents. Any views or opinions presented are solely those of the author and do not necessarily represent those of Powergen Retail Limited. Powergen Retail Ltd is authorised and regulated by the Financial Services Authority for the sale and service of general insurance products. Registered addresses: Powergen Retail Limited, Westwood Way, Westwood Business Park, Coventry, CV4 8LG. Registered in England and Wales No: 3407430 Telephone +44 (0) 2476 42 4000 Fax +44 (0) 2476 42 5432 ----------------------------------------- The information contained in this message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately, and delete the original message. ___________________________ Disclaimer Notice ____________________ This message and any attachments are confidential and should only be read by those to whom they are addressed. If you are not the intended recipient, please contact us, delete the message from your computer and destroy any copies. Any distribution or copying without our prior permission is prohibited. Internet communications are not always secure and therefore the E.ON Group does not accept legal responsibility for this message. The recipient is responsible for verifying its authenticity before acting on the contents. Any views or opinions presented are solely those of the author and do not necessarily represent those of the E.ON Group. E.ON UK plc, Westwood Way, Westwood Business Park, Coventry, CV4 8LG. Registered in England & Wales No. 2366970 E.ON UK Trading Ltd, Westwood Way, Westwood Business Park, Coventry, CV4 8LG Registered in England & Wales No. 4178314 E.ON UK Trading Ltd is regulated by the Financial Services Authority to carry out investment activities. Telephone +44 (0) 2476 42 4000 Fax +44 (0) 2476 42 5432 Confidentiality Note: The information transmitted is intended only for the person or entity to whom or which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of this information by persons or entities other than the intended recipient is prohibited. If you receive this in error, please delete this material immediately. Please be advised that someone other than the intended recipients, including a third-party in the Seligman organization and government agencies, may review all electronic communications to and from this address.
