DB2 reorg 出错的解决方案

cd /usr/local/db2home/2011_11_22/SHIPMENT_DATA
db2move SHIPMENT EXPORT -tc db2inst1 -u db2inst1 -p phxsha123 -l /usr/local/db2home/2011_11_22/SHIPMENT_DATA


db2move GLOBALT.TB_NOTIFICATION_ADDRESS -tc dwdev -u dwdev -p dwdev123 -l /home/dwdev/data0707


db2move GLOBALT export -t TB_NOTIFICATION_ADDRESS -u dwdev  -p dwdev123 -l /home/dwdev/data0707


db2move dbname export -t tabname1 tabname2 -u usr -p pwd

--指定表名时最多只支持八张表



db2 SET INTEGRITY FOR GLOBALT.TB_NOTIFICATION_ADDRESS GENERATED COLUMN, FOREIGN KEY, MATERIALIZED QUERY, CHECK, STAGING FULL ACCESS IMMEDIATE UNCHECKED

db2 reorg table DB2ADMIN.ebank_dfdk_log_h allow read access



reorg table TB_NOTIFICATION_ADDRESS  allow read access


SET INTEGRITY FOR DWDEV.TB_NOTIFICATION_ADDRESS IMMEDIATE CHECKED


db2 => SET INTEGRITY FOR DWDEV.TB_NOTIFICATION_ADDRESS IMMEDIATE CHECKED
DB20000I  The SQL command completed successfully.
db2 => reorg table TB_NOTIFICATION_ADDRESS
DB20000I  The REORG command completed successfully.


SET INTEGRITY FOR DWDEV.TB_NOTIFICATION_EVENT IMMEDIATE CHECKED
reorg table TB_NOTIFICATION_EVENT

SET INTEGRITY FOR DWDEV.TB_REPORT_TEMPLATE_RESULT_FIELD IMMEDIATE CHECKED
reorg table TB_REPORT_TEMPLATE_RESULT_FIELD

SET INTEGRITY FOR DWDEV.TB_REPORT_TEMPLATE_SORT_FIELD IMMEDIATE CHECKED
reorg table TB_REPORT_TEMPLATE_SORT_FIELD

SET INTEGRITY FOR DWDEV.TB_SHIPMENT_MOVEMENT_DET IMMEDIATE CHECKED
reorg table TB_SHIPMENT_MOVEMENT_DET