One simple approach that has been very effective in reducing the DB impact when archiving lots of small files for me has been to simply ensure the archived files a tar bundled before sending them to TSM.
Matt. Man Makes The Machine. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Stapleton, Mark Sent: Friday, September 17, 2004 8:49 PM To: [EMAIL PROTECTED] Subject: Re: Archives vs Back-up sets From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Mike Hagery >TSM-server AIX 5.2, TSM 5.1.7.3, 3494 library 3590 drives. No >tapes are checked out of the library, data is copied to a >remote 3494 library > >Our database is growing very fast. For some reasons we have 30 >clients that archives every 4 weeks a lot of small files. In >my opinion it is filling up the database, because every file >is having an entry in the database. We noticed that the >archives have never been retrieved so far, and we know that it >is not archived for government-purposes. The retention period >is only 3 months. > >Now, I was thinking of making back-ups sets in stead of >archives, because it is only one entry in the database and >there is no extra processing needed on the client (only back-up) That should alleviate your database size, since entries written to backupsets are not stored in the database. What it *will* do is start to eat up tapes, since it is one node's backupset=1 tape. Remember that you cannot browse a backupset. If you ever do restore something from a backupset, you'll either have to use the QUERY BACKUPSETCONTENTS command to find the exact directory and file to restore, or restore the entire contents of the backupset. -- Mark Stapleton ([EMAIL PROTECTED]) Berbee Information Networks Office 262.521.5627 ___________________________ 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. 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
