db2 -x "select 'set INTEGRITY for CMCS_XJ.'||substr(tabname,1,30)||' IMMEDIATE CHECKED;' from syscat.tables where status='C'" > 1.sql
db2 -tvf 1.sql
SET INTEGRITY for CMBBCD_JX1.CMCS3_IO_FILE_FORMAT IMMEDIATE CHECKED;
db2 -x "select 'set INTEGRITY for CMCS_XJ.'||substr(tabname,1,30)||' IMMEDIATE CHECKED;' from syscat.tables where status='C'" > 1.sql
db2 -tvf 1.sql
SET INTEGRITY for CMBBCD_JX1.CMCS3_IO_FILE_FORMAT IMMEDIATE CHECKED;