Re: backup database
2002-10-27 21:31:37
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
--- ---
|
|
|