DB2 ALTER TABLESPACE

Query Space usageSelect Char(Tbsp_name, -) asTbsp_name, Tbsp_total_pages,tbsp_usable_pages, Tbsp_used_pages, RTrim ( -*tbsp_used_pages/tbsp_usable_pages) | |'%'  asUsed_rate fromSysibmadm. Snaptbsp_partwhereTbsp_usable_pages>0ORDER by Tbsp_name,dbpartitionnumtbsp_name Tbsp_total_pages Tbsp_usable_ PAGES tbsp_used_pages used_rate-------------------------------------------------- -------------------- -------------------- -------------------- - --------------------Syscatspace32768                32764                29428  the%Systoolspace8192                 8188                   the 1%ts_user1861200                61152                    the 0%Ts_user8 +                  960                    the Ten%USERSPACE18192                 8160                 1184  -%

Querying tables and Index structures

DB2 describe table Syscat.tables Show Detail

Querying table state Information

" Select Tabname,tbspace,stats_time,create_time,status from Syscat.tables "

DB2 ALTER TABLESPACE