Neoview SQL Reference Manual (R2.5)

Table001: CAT.SCH.T1
Table002: CAT.SCH.T2
Rate: -1
Slack: -1
Status: COMPLETED
Completed: -001-00-00 00:00:00.000000
TableName: CAT.SCH.T1
Partition: NSK_SYSTEM_ZSDCNHM6_BSQJPG00
Location: \NSK.$SYSTEM.ZSDCNHM6.BSQJPG00
Status: NOT_INITIATED
Segment: \NSK
Cpu: 0
PctDone: 0
TableName: CAT.SCH.T2
Partition: NSK_SYSTEM_ZSDCNHM6_SFS6PG00
Location: \NSK.$SYSTEM.ZSDCNHM6.SFS6PG00
Status: NOT_INITIATED
Segment: \NSK
Cpu: 0
PctDone: 0
Total elapsed Time: 00:00:00.000
Task: REORG_TABLE Status: Ended ET: 00:00:00.031
--- SQL operation complete.
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 219