• 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.

TSM DB Near Full - Suggestions Wanted. Thanks.


Active Newcomer
Any suggestions on this:

tsm: SERVER1>q db
Available Assigned Maximum Maximum Page Total
Space Capacity Extension Reduction Size Usable
(MB) (MB) (MB) (MB) (bytes) Pages
--------- -------- --------- --------- ------- ---------
34,000 34,000 0 0 4,096 8,704,000
tsm: SERVER1>q db f=d
Session established with server SERVER1: AIX-RS/6000
Server Version 5, Release 5, Level 0.0
Server date/time: 06/04/19 11:28:49 Last access: 06/04/19 08:16:26

Available Space (MB): 34,000
Assigned Capacity (MB): 34,000
Maximum Extension (MB): 0
Maximum Reduction (MB): 0
Page Size (bytes): 4,096
Total Usable Pages: 8,704,000
Used Pages: 8,694,867
Pct Util: 99.9
Max. Pct Util: 100.0
Physical Volumes: 17
Buffer Pool Pages: 8,192
Total Buffer Requests: 705,735,933
Cache Hit Pct.: 98.38
Cache Wait Pct.: 0.00
Backup in Progress?: No
Type of Backup In Progress:
Incrementals Since Last Full: 0
Changed Since Last Backup (MB): 307.65
Percentage Changed: 0.91
Last Complete Backup Date/Time: 06/03/19 13:02:52
Estimate of Recoverable Space (MB): 3,243


ADSM.ORG Moderator
Several things to think about:

1. Define more DB volumes to increase capacity. Are there enough PP's on the LV.
2. Increase the PP's on the LV, define more DB volumes.
3. Review the retention settings. Are we keeping too many files and/or are we keeping the files too long? What is the business requirements?
4. Do we have TSM Clients that are backing up EVERYTHING!
5. Do we have old TSM Clients that need to be removed from the TSM Server?
6. Are we adding new TSM Clients? In the future may need another TSM Server for load balancing.

Good Luck,

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: 18 18.6%
  • Keep using TSM for Spectrum Protect.

    Votes: 59 60.8%
  • Let's be formal and just say Spectrum Protect

    Votes: 12 12.4%
  • Other (please comement)

    Votes: 8 8.2%

Forum statistics

Latest member