Change TSM DB to different location

[mabdullah]

HI,

i have TSM 5.5 on windows 2003 server. recently i found that my C drive becoming out of disk space. it was TSM db causing this problem with size of 44 GB. here is the output of q db command:

[FONT=&quot]tsm: SHUBKP01_SERVER1>q db f=d[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot] Available Space (MB): 30,624[/FONT]
[FONT=&quot] Assigned Capacity (MB): 30,624[/FONT]
[FONT=&quot] Maximum Extension (MB): 0[/FONT]
[FONT=&quot] Maximum Reduction (MB): 19,104[/FONT]
[FONT=&quot] Page Size (bytes): 4,096[/FONT]
[FONT=&quot] Total Usable Pages: 7,839,744[/FONT]
[FONT=&quot] Used Pages: 2,644,828[/FONT]
[FONT=&quot] Pct Util: 33.7[/FONT]
[FONT=&quot] Max. Pct Util: 33.7[/FONT]
[FONT=&quot] Physical Volumes: 10[/FONT]
[FONT=&quot] Buffer Pool Pages: 8,192[/FONT]
[FONT=&quot] Total Buffer Requests: 637,987[/FONT]
[FONT=&quot] Cache Hit Pct.: 91.86[/FONT]
[FONT=&quot] Cache Wait Pct.: 0.00[/FONT]
[FONT=&quot] Backup in Progress?: No[/FONT]
[FONT=&quot] Type of Backup In Progress:[/FONT]
[FONT=&quot] Incrementals Since Last Full: 0[/FONT]
[FONT=&quot] Changed Since Last Backup (MB): 0.07[/FONT]
[FONT=&quot] Percentage Changed: 0.00[/FONT]
[FONT=&quot] Last Complete Backup Date/Time: 08/07/2010 09:52:42[/FONT]
[FONT=&quot] Estimate of Recoverable Space (MB):[/FONT]
[FONT=&quot]Last Estimate of Recoverable Space (MB):[/FONT]


i dont know what to do now. is it possible to reduce to TSM DB. or i have to change the location of TSM DB to different drive.



if i need to change the location to different drive how can i do it.


thanks
[FONT=&quot][/FONT]

 

[moon-buddy]

Does not say 44 GB but 30 GB. Where did you get the 44 GB value from?

tsm: SHUBKP01_SERVER1>q db f=d

Available Space (MB): 30,624
Assigned Capacity (MB): 30,624
Maximum Extension (MB): 0
Maximum Reduction (MB): 19,104
Page Size (bytes): 4,096
Total Usable Pages: 7,839,744
Used Pages: 2,644,828

 

[mabdullah]

thanks for your reply moon. 44gb is size of tsmdata folder which contains tsm db and recovery logs. as i mentioned in my previous post that my C drive is almost out of disk space!!! i need to solve this issue coz tsm db is increasing.

im not sure what to do now. shall change the tsm db location to different drive!!! if yes how can i move the current tsm db along with recovery logs to new location.

 

[Mita201]

It is easy.
Just create new db volumes on new drive, using define dbvol command. Make sure that you have enough space in new volumes, and then delete old volumes with delete dbvol commands. TSM will relocate yor database pages to new volumes during deletion of old.

 

[sandeepkontham]

It is easy.
Just create new db volumes on new drive, using define dbvol command. Make sure that you have enough space in new volumes, and then delete old volumes with delete dbvol commands. TSM will relocate yor database pages to new volumes during deletion of old.

yes the above is right.

1)First add dbvolumes

say(d drive): define dbvolume d:\.....\db1.dsm formatsize=35000

2)extend the DB size

extend db 35000

3) delete the DB volumes from C drive

delete dbvolume c:\......\

FYI,
you can get the dbvolumes using "q dbvolume" or else from dsmserv.dsk file

hope the above helps you

 

[Mita201]

No need to extend DB.
the DB is only 33.7 utilized.

 

[sandeepkontham]

No need to extend DB.
the DB is only 33.7 utilized.

I am not sure but without extending DB, the TSM cannot use the dbvolumes of another drive so while deleting the dbvolumes it goes to another dbvolume of same drive (here it it C drive) and it cannot use another drive DB volumes as we didn't assigned to TSM with "extend db".

Correct me if I am wrong.

and also before deleting i think we need to reduce the db using
reduce DB command

 

[mabdullah]

thanks for the replies guys

it seems easy steps but i still have 2 doubts and hope u clarify it to me.

1-when i create the new db volumes on the new drive.do i have to create same size and same names as the original one. or its ok if i create 1 db vol and size it with 50 gb for example.

please note that i have multiple db volumes with different sizes.

2-how the data will transfer from the original db volumes to the new db volumes by doing the delete option.

 

[sandeepkontham]

thanks for the replies guys

it seems easy steps but i still have 2 doubts and hope u clarify it to me.

1-when i create the new db volumes on the new drive.do i have to create same size and same names as the original one. or its ok if i create 1 db vol and size it with 50 gb for example.

please note that i have multiple db volumes with different sizes.

2-how the data will transfer from the original db volumes to the new db volumes by doing the delete option.

1A)you can create 1 db volume of 50GB or any number of DB volumes.

2A)TSM takes care of the data transfer, once you delete the DB volume, TSM moves that DB data to another available DB volume and once you start deleting one after the other (DB volumes of C drive) TSM will move data to only available another drive DB volumes.

It's internal process

 

[mabdullah]

my problem solved this is what i did

1- Create new db volumes on the new location.
2-delete the original db volumes one by one. its automatically moving the data from the deleted db volumes to the new volumes.

done.. now my C drive space is 30GB and its healthy.

thanks for every one for sharing the information.