db2数据库 相关

生成32位UUID函数 concat (hex (RAND ()), hex (RAND ()))

db2行转列函数
LISTAGG(vstr,';') WITHIN GROUP(ORDER BY 1)
db2列转行函数
SELECT S.Year, Q.Quarter, Q.Results
FROM SalesAgg AS S,
     TABLE (VALUES(1, S.q1),
                  (2, S.q2),
                  (3, S.q3),
                  (4, S.q4))
            AS Q(Quarter, Results);

--查询表空间剩余情况
SELECT
substr(tbsp_name,1,20) AS TABLESPACE_NAME,
--substr(tbsp_content_type,1,10) AS TABLESPACE_TYPE,
SUM(tbsp_total_size_kb)/1024 AS TOTAL_MB,
SUM(tbsp_used_size_kb)/1024 AS USED_MB,
SUM(tbsp_free_size_kb)/1024 AS FREE_MB
--tbsp_page_size AS PAGE_SIZE
FROM
 SYSIBMADM.TBSP_UTILIZATION
GROUP BY
 substr(tbsp_name,1,20)

系统所有表

select tabname, tbspace from syscat.tables

查询表所占空间大小(kb)

select DATA_OBJECT_P_SIZE  from table(sysproc.admin_get_tab_info(schema.tabname))