Neoview Database Administrator's Guide (R2.2)
gcmd -rt CONFIG_TASK_LOAD \
-tk TASK_RECOVERY_ENABLED -rf Y \
-gs server1 -tn NEO-CMSERVER \
-it FILE \
-ii /opt/testdata/WISC-INSERT \
-ot TABLE -oi CAT.SCH.WISC \
-un user1 -pw mypassword \
-of N
Start the task using the start task request using this command:
gcmd -rt START_TASK -tk TASK_RECOVERY_ENABLED -un user1 -pw mypassword
Suppose you stop the task while it is running, using the stop task request in this command:
gcmd -rt STOP_TASK -tk TASK_RECOVERY_ENABLED -un user1 -pw mypassword
Once the stop task has completed successfully, rerun the task using same start task command:
gcmd -rt START_TASK -tk TASK_RECOVERY_ENABLED -un user1 -pw mypassword
The task will try to recover itself and load the data from the point of the last successful commit.
When the recovery run completes the task instance log file for the task contains the messages
from the initial run (up to the point that the task was stopped) as well as the messages from the
subsequent recovery run. Example 8-2 shows a sample portion of the task instance log file:
Example 8-2 Log File with Recovery
...
[16:24:03] WRITER_4> FATAL : CONN_16 No reply from loader.
[16:24:03] WRITER_4> FATAL : WRT_16 No reply from loader.
[16:24:03] WRITER_4> INFO : WRITER [ Dist.
Wait: 1658ms & Write Prepare Wait: 0ms & Write Execute Wait: 3324ms. ]
[16:24:03] MASTER> FATAL : ThreadMonitor Thread failed.
[16:24:03] MASTER> STATS
----------------------------------------------------------------
PNo. Requested Applied Rejected Affected
0 6000 6000 50 5850
1 6000 6000 49 5951
2 6100 6100 50 5950
3 6100 6100 60 5940
4 6000 6000 69 5831
Tot. 30200 30200 278 29522
CTot. 30200 30200 278 29522
----------------------------------------------------------------
[16:24:03] MASTER> MASTER Execution completed with error.
[16:29:20] MASTER> INFO : SESSION
----------------------------------------------------------------
SESSION PARAMETERS
--------------------
Task Name : TASK_RECOVERY_ENABLED
DB Object Name : CAT.SCH.WISC
Compress Data : false
Data Format : DELIM
Field Delimiter : ,
RowsToSkip : 0
Rowset Size : 1000
Operation Type : INSERT
Transaction Size : 1000
ExecutionParallelism : PARTITIONWISE
LogSeverityLevel : INFO
Recovery Flag : true
118 Using the Neoview Loader