TSM Database grown to 76.2%

[Danesh]

I have TSM v5.5.4.0 running on Windows Server 2008 R2.

I have noticed the TSM database is gradually grown to 76.2%.

The output of "query db" displays Pct Util is 76.2 and Max Pct Util is 76.2

What are the steps to make sure TSM database size does not grow to 100% in size.

Any help would be appreciated as I'm fairly new to TSM.

Thank you

 

[rowl]

Make sure you have a daily process to expire inventory. This will free up space in the DB for reuse.

 

[TSMCON]

The other good thing to know, is exactly what is causing your database to grow. From the OCCUPANCY table, list each node name and the SUM of num_files (order by largest number of files).

It may be that one particular node has a lot of files in TSM storage.

As Rowl says, make sure expiration is running.

select affected from summary where activity = 'EXPIRATION '

 

[Mita201]

It might be OK, it grows since there is a number of new files backed up - load on server grows.
If this is your case, you can simply ad more database volumes, and extend your TSM database manually, or you can set database trigger to extend it automatically. Check this:
http://publib.boulder.ibm.com/infoc...smcw.doc/anrwgd55618.htm?path=6_1_6_2_3#addsp