Neoview SQL Reference Manual (R2.4)

Reorg Task-Options Example
>>maintain table t1, reorg ',rate 40';
Task: REORG_TABLE Status: Started Object: CAT.SCH.T1
Task: REORG_TABLE Status: Ended ET: 00:00:00.016
--- SQL operation complete.
Reorg and Update Statistics Task-Options Example
>>maintain table t1, update statistics 'on every column, (A,B) sample 2000000
rows', reorg ',rate 40', display detail;
Task: REORG_TABLE Status: Scheduled Command: REORG TABLE CAT.SCH.T1 ,rate
40, no output;
Task: UPD_TABLE_STATS Status: Scheduled Command: UPDATE STATISTICS FOR TABLE
CAT.SCH.T1 on every column, (A,B) sample 2000000 rows
--- SQL operation complete.
>>maintain table t1, update statistics 'on every column, (A,B) sample 2000000 ro
ws', reorg ',rate 40';
Task: REORG_TABLE Status: Started Object: CAT.SCH.T1
Task: REORG_TABLE Status: Ended ET: 00:00:00.016
Task: UPD_TABLE_STATS Status: Started Object: CAT.SCH.T1
Task: UPD_TABLE_STATS Status: Ended ET: 00:00:14.453
--- SQL operation complete.
MAINTAIN Command 217