db2查询表空间使用情况

最新推荐文章于 2023-12-21 17:36:47 发布

Kevin-anycode

最新推荐文章于 2023-12-21 17:36:47 发布

阅读量3.2k

点赞数 1

本文链接：https://blog.csdn.net/lk1985021/article/details/89357466

版权

	select tablespace_name,                                                   
       sum(float(total_pages*page_size)/(1024*1024*1024)) total_GB , 
       sum(float(usable_pages*page_size)/(1024*1024*1024)) usable_GB, 
       sum(float(used_pages*page_size)/(1024*1024*1024)) used_GB,
       sum(float(free_pages*page_size)/(1024*1024*1024)) free_all_GB
 from table(snapshot_tbs_cfg('数据库名',-2)) as aa                            
 group by tablespace_name;