Neoview SQL Reference Manual (R2.4)

• Enables update statistics on the specified table:
maintain table t1_090, update statistics, enable;
• Examples of MAINTAIN invoked with optional task options:
maintain table t1, reorg ', rate 100';
Task: REORG_TABLE STATUS: Started Object: CAT.SCH.T1
Task: REORG_TABLE STATUS: Ended ET: 00:00:00.031
--SQL operation complete.
maintain table t1, reorg ', rate 100', display detail;
Task: REORG_TABLE STATUS: scheduled Command: REORG.TABLE.CAT.SCH.T1 , rate
100, no output;
• This example shows a reorg of multiple tables using the MAINTAIN command. The example
reorganizes three tables in one command:
MAINTAIN TABLES (t1,t2,t3), REORG;
Task: REORG_TABLE Status: Started Object: CAT.SCH.T1
Task: REORG_TABLE Status: Started Object: CAT.SCH.T2
Task: REORG_TABLE Status: Started Object: CAT.SCH.T3
Task: REORG_TABLE Status: Ended ET: 00:01:00.884
--- SQL operation complete.
Detailed Example With Reorg Statistics
>>maintain tables (t1,t2), reorg, return detail output;
Task: REORG_TABLE Status: Started Object: CAT.SCH.T1
Task: REORG_TABLE Status: Started Object: CAT.SCH.T2
Reorg Statistics:
=================
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.
216 SQL Utilities