ADSM-L

Re: backup database

2002-10-27 21:31:37
Subject: Re: backup database
From: Justin Bleistein <justin.bleistein AT SUNGARD DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Sun, 27 Oct 2002 21:09:56 -0500
      The devclass option is there to specify what sort of device you want
the backup to goto. In our environment for example we have an IBM 3494
library so I state devclass: "3590dev" and it directs my backup to media
belonging to that devclass.  Below is the a procedure I typed up for
backing it up to a file:

      This procedure details how to backup a TSM database to a file on the
system rather then a tape. First pick a directory which lies on a file
system which has enough disk space which exceeds the current database
utilization limit so you know you have enough room. You do that by entering
this command (EX: /usr):

# df -k /usr <ENTER>

Filesystem    1024-blocks      Free %Used    Iused %Iused Mounted on
/dev/hd2          4096000   2585352   37%    22432     3% /usr

#

Now you have determined that the "/usr" filesystem has enough room for a
"2" gig database. Now login to TSM as the admin (dsmadmc). Once in you must
create a file device class, you do that by entering the following:

> define devclass diskdbbackups devtype=file directory=/usr/dbbackups/
<ENTER>

To verify that device class now exists, type in the following:

> q devclass <ENTER>

Device        Device         Storage     Device        Format      Est/Max
Mount
Class         Access            Pool     Type                     Capacity
Limit
Name          Strategy         Count                                  (MB)
---------     ----------     -------     ---------     ------     --------
------
DISK          Random               3
diskdbbackups     Sequential           0     FILE          DRIVE
4.0          1
NULL          Sequential           1     FILE          DRIVE       3,000.0
256

As you can see from the output above it does now exist. Now to perform the
backup to disk type in the following:

> backup db devclass=diskdbbackups type=full
volumename=/usr/dbbackups/todaysbackup <ENTER>
ANR2280I Full database backup started as process 1.
ANS8003I Process number 1 started.

To check the progress of this database backup type in the following:

> q pro <ENTER>

 Process     Process Description      Status
  Number
--------     --------------------
-------------------------------------------------
       1     Database Backup          Full backup: 192 pages of 219 backed
up. Current
                                       output volume:
/usr/tivoli/tsm/server/bin/dbbac-
                                       kup.

--Justin




                      Alexander
                      Lazarevich               To:       ADSM-L AT VM.MARIST 
DOT EDU
                      <alazarev AT HERA DOT IT        cc:
                      G.UIUC.EDU>              Subject:  backup database
                      Sent by: "ADSM:
                      Dist Stor
                      Manager"
                      <[email protected]
                      .EDU>


                      10/27/2002 09:09
                      PM
                      Please respond to
                      "ADSM: Dist Stor
                      Manager"






we've got adsmserv 3.1 running on an AIX 4.3.3 system, with a IBM 3575
library.

i need to backup the database, but i dont understand how to do it exactly.
ive read the manual but it sucks.

okay so the command is adsm>backup db devclass=file type=full

i need to do a full because ive never backed up the database before. but i
dont understand the devclass option. do i just type in a path to the file
that i want the backup to be? for example, if i want to backlup the
datebase to a file in /home/servercrap/adsmstuff/DBbackup, then i just do
this command:

adsm>backup db devclass=/home/servercrap/adsmstuff/DBbackup type full

if that directory already exsists, will the above command will do it?

thanks in advance!

alex
---                                                        ---
   Alex Lazarevich | Systems | Imaging Technology Group
   alazarev AT itg.uiuc DOT edu | (217)244-1565 | www.itg.uiuc.edu
---                                                        ---

<Prev in Thread] Current Thread [Next in Thread>