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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
up vote 3 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.


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"
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

Your Answer


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.