Re: [ADSM-L] Moving DB , LOG , ARCHLOG
2015-07-22 13:18:12
Robert,
In order to move your TSM database,
and logs, you will have to perform a restore db and input the new directories/filespaces
that you want the database and logs to reside.
Moving both the database and recovery
log
You can move the database, active
log, and archive logs that are on the same file
system to various directories on
different file systems for better protection.
Procedure
1. Back
up the database by issuing the following command:
backup db type=full devclass=files
2. Halt
the server.
3. Create
directories for the database, active logs, and archive logs. The directories
must be accessible to the user ID
of the database manager. For example:
mkdir l:\tsm\db005
mkdir m:\tsm\db006
mkdir n:\tsm\db007
mkdir o:\tsm\db008
mkdir p:\tsm\activelog
mkdir q:\tsm\archivelog
4. Create
a file that lists the locations of the database directories. This file
is used
if the database must be restored.
Enter each location on a separate line. For
example, these are the contents
of the dbdirs.txt file:
l:\tsm\db005
m:\tsm\db006
n:\tsm\db007
o:\tsm\db008
5. Remove
the database instance by issuing the following command:
dsmserv removedb TSMDB1
6. Issue
the DSMSERV RESTORE DB utility
to move the database and create the new
active log. For example:
dsmserv restore db todate=today on=dbdirs.txt
activelogdir=p:\tsm\activelog
7. Restart
the server.
Best Regards,
_________________________________________________________
email: ron.delaware AT us.ibm DOT com
From:
Robert Ouzen <rouzen AT UNIV.HAIFA.AC DOT IL>
To:
ADSM-L AT VM.MARIST DOT EDU
Date:
07/22/15 09:44
Subject:
[ADSM-L] Moving
DB , LOG , ARCHLOG
Sent by:
"ADSM:
Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
Hello
I am in stage of moving my DB , Activelog and Archivelog from old storage
to faster storage, DB on SSD disks
I am wonder if I can do it in one step, meaning:
1. Creating new volumes for DB on SSD lists, create
a list on dbdir.file
2. Create a new volume of 150G for activelog
as: X:\tsmactlog
3. Create a new volume of 400G for archivelog as:
Y:\tsmarchlog
4. On dsmserv.opt update those entries as: ACTIVELOGDirectory
X:\tsmactlog
ARCHLOGDirectory
Y:\tsmarchlog
5. Run a full backup DB
6. Halt the server
7. Run dsmserv removedb TSMDB1
8. Run dsmserv restore DB todate=today on=dbdir.file
9. Restart the server
10. Move the archivelog from the old directory to the new directory
as:
Xcopy /s OLDDIRECTORY\* Y:\tsmarchlog
Or need to do it in 3 steps ? (meaning 3 halt of server)
1. ACTIVELOG change in dsmserv.opt , halt
server and restart server
2. ARCHIVELOG change in dsmser.opt , halt server
and restart server
3. DB , backupdb ,halt server , restore DB on=dbfile
, restart server
TSM server version 7.1.1.200 on Windows 2008R2 64B
Best Regards
Robert Ouzen
|
Previous by Date: |
[ADSM-L] Moving DB , LOG , ARCHLOG, Robert Ouzen |
Next by Date: |
Re: [ADSM-L] Moving DB , LOG , ARCHLOG, Karel Bos |
Previous by Thread: |
[ADSM-L] Moving DB , LOG , ARCHLOG, Robert Ouzen |
Next by Thread: |
Re: [ADSM-L] Moving DB , LOG , ARCHLOG, Remco Post |
Indexes: |
[Date]
[Thread]
[Top]
[All Lists] |
|
|