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.
|