Increase tsm DB

[rbg000]

Hello, My situation is:
I already extended 50GB, my DB is full!!
Available Assigned Maximum Maximum Page Total Used Pct Max.
Space Capacity Extension Reduction Size Usable Pages Util Pct
(MB) (MB) (MB) (MB) (bytes) Pages Util
--------- -------- --------- --------- ------- --------- --------- ----- -----
250,000 250,000 0 25,288 4,096 64,000,00 57,492,66 89.8 89.9
0 2

Question: can i increase this tsm db without create a new one? I have more 200GB free in the same disk volume! how can i do to tsm know that i have more 200gb free to increase?

Can i do??? define dbvolume \path\dbvolume.dsm formatsize=1500 -> 1500mb = 150gb
extend db 500

this is will increase my database from 200gb to 350gb and the extend from 50gb to 100gb????

 

[ad283m]

Why don't you create a trigger to increase the DB volume?, it's easier and you'll not have to be concerned to increase the size manually.

 

[rbg000]

increase DB

Why don't you create a trigger to increase the DB volume?, it's easier and you'll not have to be concerned to increase the size manually.

Can i do like this, just this?
define spacetrigger stg spaceexpansion=40 stgpool=mystgpoolname
I got 2 storage pool names, i do for both?

Thank u

 

[ad283m]

No, you want to expand the database, so it goes like this:

def spacetri db full=AA space=BB expansionprefix=CC

AA you put the full percentaje that must be reached to trigger the expansion
BB the porcentage to increase the database
CC the complete route where you want the new database volumes to be created

After you do it a q spacetrigger db should look like this (in my case a 2% increase when it reaches 85 % full and the new volumes are created on
e:\tsmdataserver1\
DB Full PercentageDB Space Expansion PercentageDB Expansion prefixDB Maximum Size (Megabytes)Mirror Prefix 1Mirror Prefix 2852e:\tsmdata\server1\0

Regards

 

[rbg000]

I think i understood! I got 200gb free in f:\tsmDB then: the percentual could be 10%
My actual database is in f:\tsmDB
i dont have mirrors
def spacetri db full=200gb space=10 expansionprefix=f:\tsmDB
Is that correct?

 

[ad283m]

No, it goes like this:

def spacetri db full=80 space=10 expansionprefix=f:\tsmDB

When it reaches 80% it will expand 10 %, since you already are on 90 % you just wait like 10 min to see the results on the act and on the database

 

[ad283m]

10 % would be like 25 G on you current DB.

On the next one since it 250 + 25 = 275 the expansion will be 27.5 and so on.

 

[rbg000]

ahh ok! my situation is:


Available Space (MB): 250,000
Assigned Capacity (MB): 250,000
Maximum Extension (MB): 0
Maximum Reduction (MB): 25,288
Page Size (bytes): 4,096
Total Usable Pages: 64,000,000
Used Pages: 56,913,494
Pct Util: 88.9
Max. Pct Util: 89.9
Physical Volumes: 25
Buffer Pool Pages: 262,144
Total Buffer Requests: 513,012,951
Cache Hit Pct.: 99.24
Cache Wait Pct.: 0.00
Backup in Progress?: No
Type of Backup In Progress:
Incrementals Since Last Full: 0
Changed Since Last Backup (MB): 13,321.80
Percentage Changed: 5.99
Last Complete Backup Date/Time: 05/30/2011 10:33:44
Estimate of Recoverable Space (MB):
st Estimate of Recoverable Space (MB):

 

[rbg000]

new status after i did!
tsm: TSM_ALESC>q db f=d

Available Space (MB): 302,500
Assigned Capacity (MB): 302,500
Maximum Extension (MB): 0
Maximum Reduction (MB): 77,788
Page Size (bytes): 4,096
Total Usable Pages: 77,440,000
Used Pages: 56,905,403
Pct Util: 73.5
Max. Pct Util: 74.3
Physical Volumes: 27
Buffer Pool Pages: 262,144
Total Buffer Requests: 58,466
Cache Hit Pct.: 100.00
Cache Wait Pct.: 0.00
Backup in Progress?: No
Type of Backup In Progress:
Incrementals Since Last Full: 0
Changed Since Last Backup (MB): 224,784.72
Percentage Changed: 101.12
Last Complete Backup Date/Time: 05/30/2011 10:33:44
Estimate of Recoverable Space (MB):
Last Estimate of Recoverable Space (MB):
Thank u very much for your help!!
the best solution!!