Re: TSM DB unload

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.