• Please help support our sponsors by considering their products and services.
    Our sponsors enable us to serve you with this high-speed Internet connection and fast webservers you are currently using at ADSM.ORG.
    They support this free flow of information and knowledge exchange service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions
  • Community Tip: Please Give Thanks to Those Sharing Their Knowledge.

    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.


    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

If TSM DB size is full


ADSM.ORG Moderator
What version of TSM are you running? Is Expiration running?

TSM versions 6 and later have auto DB reorganized capability UNLESS you have updated the TSM from older versions.

You can query the DB and see if reorganiztion runs: q db f=d and look fot the line - Last Database Reorganization:

If the date is very recent, then reorganization is running.

If the date is very old and this does not change day-after-day, then you can run manually reorganization:


Note that if reorganization is running (and also make sure expiration is running), and the DB is still FULL, you may need to add space. The gets FULL because of other reasons like many nodes, long retention, archive, etc.


ADSM.ORG Moderator
I'm using 7.1.6, Reorganization and expiration are running. there is any way to reduce size?
As I mentioned, the DB size grows as you keep data (retention period and number of versions) longer. The more nodes you backup, the bigger will your DB grow.

Take a look at these and if these are really set correctly based on Business and DR needs, all you can do is add DB space.


Ive just had a similar problem. I used an IBM Tool a perl script called analyze_DB2_formulas.pl. It calculates free space in tables and outputs to file giving you Table and Size saving. I ran one at a time o n tables and reduced DB Size. See https://www-01.ibm.com/support/docview.wss?uid=swg21683633#calc_space . SO run scripts as TSM Instance user on commandline it will create directory and summary.out showing tables. Then Enable online reorg to those tables (commands there) and run commands in SUMMARY.OUT the alter ones one at a time in TSM (quiet time better) and commands there to check progress I reduced DB by about 5%. There are other savings too doing offline but that requires TSM Down. This doesnt reduce to allocated DB space but the used it does.

Advertise at ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

UpCloud high performance VPS at $5/month

Get started with $25 in credits on Cloud Servers. You must use link below to receive the credit. Use the promo to get upto 5 month of FREE Linux VPS.

The Spectrum Protect TLA (Three-Letter Acronym): ISP or something else?

  • Every product needs a TLA, Let's call it ISP (IBM Spectrum Protect).

    Votes: 12 15.8%
  • Keep using TSM for Spectrum Protect.

    Votes: 48 63.2%
  • Let's be formal and just say Spectrum Protect

    Votes: 9 11.8%
  • Other (please comement)

    Votes: 7 9.2%

Forum statistics

Latest member