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.


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

  • 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 clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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