Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

How can I get information about tablespace in DB2 9.5?

I need to review information about if the autoresize option is enabled or disabled.

share|improve this question
add comment

1 Answer

up vote 2 down vote accepted

Use the TBSP_UTILIZATION administrative view - Retrieve table space configuration and utilization information. See the "Essential DB2 Health Check" for a recommendation on how to use it, especially the sections on File System Free Space and DMS Tablespace Free Space.

Example:

select substr(tbsp_name,1,10) "Name", tbsp_utilization_percent "Used%", tbsp_free_pages "FreePages", tbsp_usable_Pages "UsablePages", tbsp_used_pages "UsedPages", tbsp_page_top "HWM", tbsp_auto_resize_Enabled "AutoResize 1=Yes", tbsp_increase_size "Increase Size", tbsp_max_size "MaxSizeBytes -1=ulimited", tbsp_last_resize_failed "ResizeFailed 1=Yes", tbsp_page_size "PgSize Bytes"
from SYSIBMADM.TBSP_UTILIZATION
where tbsp_type = 'DMS';

Specifically, you are after the tbsp_increase_size field from the SYSIBMADM.TBSP_UTILIZATION table, where tbsp_type = 'DMS' as show in the query above. (The query has a few other things that are helpful in it too.)

share|improve this answer
    
Unfortunately no, it shouldn't. –  coms Feb 8 '12 at 13:31
    
So are you after a monitor then? Which monitor? I don't believe there is a "tablespace monitor" in DB2 9.5. Is it the Event Monitor you want? The Health Monitor? Regular DB2 tuning parameters? –  Chris Aldrich Feb 8 '12 at 14:03
    
I want to know value of AUTORESIZE for given tablespace. –  coms Feb 8 '12 at 14:17
    
I have found this info via ControlCenter. :) But I don't know how to get this via db2cmd. –  coms Feb 8 '12 at 14:23
    
Did my edit help any? –  Chris Aldrich Feb 8 '12 at 21:26
show 1 more comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.