No, I use the same deviceclass. I dont know how much smaller it will get
before it is unloaded. Even if there are some
selects that will help me calculate wasted space.
//Henrik
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Lawrence Clark
Sent: den 13 juni 2005 16:06
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: TSM DB unload
Your area to unload is smaller than your area to backup the database?
>>> SHWL AT STATOIL DOT COM 06/13/2005 9:54:57 AM >>>
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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Lawrence Clark
Sent: den 13 juni 2005 15:36
To: ADSM-L AT VM.MARIST DOT 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.
-------------------------------------------------------------------
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.
|