Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DMS space utilization

Status
Not open for further replies.
kozlow

kozlow

MIS
Mar 3, 2003
326
US
Is there any queries that I can run to tell me home much free space is available in my DMS tablespaces?

I currently run a "select sum(npages) from syscat.tables where tbspace = 'DATA01'" and subtract that number from the "list tablespace containers for 4 show detail" (4 = DATA01)

"select sum(nleaf) from syscat.indexes where tabname in ( select tabname from syscat.tables where index_tbspace = 'INDEX01')" and subtract that from 'list tablespace containers for 5 show detail" (5 = INDEX01)
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

handle907
  • Locked
  • Question
ADM10501W - Health indicator "Database Automatic Storage Utilization"
Replies
0
Views
353
handle907
handle907
handle907
  • Locked
  • Question
Tablespace utilization rate is 80% but only few small tables there.
Replies
0
Views
141
handle907
handle907
kozlow
  • Locked
  • Question
Move a DMS Tablespace to a new Raw Device. 1
Replies
1
Views
65
sathyarams
sathyarams
andytheautomator
  • Locked
  • Question
Email Notification for table space warning
Replies
3
Views
89
sathyarams
sathyarams
kozlow
  • Locked
  • Question
Extend a DMS tablespace
Replies
0
Views
47
kozlow
kozlow

Part and Inventory Search

Sponsor

Back
Top