在Windows上调优DB2数据库的八个简单步骤
作者:应用开发 来源:系统运维 浏览: 【大中小】 发布时间:2025-11-05 09:32:57 评论数:
复制db2 "select varchar(tabschema,上数据20) as tabschema, varchar(tabname,20) as tabname, table_scans, sum(rows_read) as total_rows_read, sum(rows_inserted) as total_rows_inserted, sum(rows_updated) as total_rows_updated, sum(rows_deleted) as total_rows_deleted FROM TABLE(MON_GET_TABLE(,,-2)) AS t WHERE TBSP_ID = hot tablespace id GROUP BY tabschema, tabname ORDER BY total_rows_read DESC" 1.2.3.4.5.6.7.8.9.