1:Identifying the catalog partitionIn a DPF environment, statements, such as the ROLLFORWARD DATABASEstatement, must be issued from the catalog partition. db2 list db directory 2:Switching partitions[db2inst@oc2522365484 ~]$ export DB2NODE=1[db2inst@o...(more)
1.通过db2_all,然后使用编辑器查看 db2_all "connect to dbname;db2 list tablespaces show detail"2.通过sysibmadm.SNAPTBSP_PART表函数格式化处理 selectchar(TBSP_NAME,50) as TBSP_NAME,TBSP_USABLE_PAGES,TBSP_USED_PAGES,1.00...(more)
1、查看表空间使用情况Select * from SYSIBMADM.TBSP_UTILIZATION根据表空间使用情况找到存在不均衡的表空间。2、统计各个表在节点6保存记录数db2 -x "select 'select '''||trim(a.tabschema)||'.'||trim(a.tabname)||''' as tabname, count(*) from '||trim(a.tabschem...(more)