and then, when all is done, check the db2 settings for active log, and archive 
log, fix them and restart, despite what the dsmserv.opt says....

Op 22 jul. 2015, om 19:15 heeft Ron Delaware <ron.delaware AT US.IBM DOT COM> 
het volgende geschreven:

> 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,
> 
> _________________________________________________________
> <Mail-bijlage.jpeg>  <Mail-bijlage.jpeg>  <Mail-bijlage.jpeg>
> 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
> 
> 



-- 

 Met vriendelijke groeten/Kind Regards,

Remco Post
r.post AT plcs DOT nl
+31 6 248 21 622