Hi, Yes, since the unload will re-org and shrink the database I always use disk, devt=file, when I do an unload/load DB. My DB backup to disk is 26GB, an unload DB is 16GB.
Mostly I do this drill (test all utilities on my DB) in upgrade times on a test server, hardly never on my production server.. //Henrik -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Clark Sent: den 13 juni 2005 15:36 To: ADSM-L@VM.MARIST.EDU Subject: TSM DB unload Each day we do a TSM DB backup to disk: backup db devclass=adsmdbbk type=full We want to do a DB unload and load off hours since this has never been performed. Questions: If the backup db will fit on the disk devclass created for that purpose, will the unload also? Can we use the TSM disk devclass to store the unload? The manual examples all use tape media............... ADSMDBBK Sequential 0 FILE DRIVE 9,216.0 1 tsm: BACKUP>q db Available Assigned Maximum Maximum Page Total Used Pct Max. Space Capacity Extension Reduction Size Usable Pages Util Pct (MB) (MB) (MB) (MB) (bytes) Pages Util --------- -------- --------- --------- ------- --------- --------- ----- ----- 16,628 14,668 1,960 1,076 4,096 3,755,008 3,146,986 83.8 83.8 ------------------------------------------------------------------- The information contained in this message may be CONFIDENTIAL and is intended for the addressee only. Any unauthorised use, dissemination of the information or copying of this message is prohibited. If you are not the addressee, please notify the sender immediately by return e-mail and delete this message. Thank you.
