Neoview Database Administrator's Guide (R2.2)
----------------------------------------------------------------
PNo. Requested Applied Rejected Affected
0 52 52 7 45
1 52 52 5 47
2 52 52 4 48
3 58 58 3 55
4 67 67 9 58
5 60 60 5 55
6 49 49 5 44
7 59 59 5 54
8 60 60 8 52
9 47 47 3 44
10 62 62 12 50
11 63 63 7 56
12 67 67 9 58
13 46 46 4 42
14 39 39 4 35
15 67 67 10 57
Tot. 900 900 100 800
CTot. 900 900 100 800
----------------------------------------------------------------
[16:07:37] MASTER> SUMMARY STATS
----------------------------------------------------------------
Task started : Mon Mar 5 16:07:28 2007
Task completed : Mon Mar 5 16:07:37 2007
Task elapsed time : 9 seconds
Task completion status : Execution completed with warnings.
Bad records rejected on both source and target
Total records read at source : 1000
Total records rejected at source : 100
Total records written at target : 800
Total records rejected at target : 100
----------------------------------------------------------------
[16:07:37] MASTER> MASTER Execution completed with warnings.
Bad records rejected on both source and target.
2. Check the cmserver log for Start Task and End Task messages. Typically it is located at
/opt/tandem/genus/gel/log on the Linux system. These messages are logged at the
start time and end time of the load task and contain the process ID (PID) of the gelserver
process and other information.
This is an example of the cmserver log:
cmserver Log
[17:49:45] INITIALIZE> [INFO] MASTER Cmserver process is now up and running
[17:53:00] [INFO] START_TASK: Gelserver (PID=6383) started for
[TASK_NAME=LOAD1 (TASK_ID=212798900999060) TASK_INSTANCE NAME= RUN1
(TASK_INSTANCE_ID=1234567890123456789)]
[18;27:32] [INFO] END_TASK: Gelserver (PID=6383) completed execution
Stopping a Data-Load Task
To abruptly stop a data-load task while it is running, enter a gcmd command on the Linux
platform with requestType STOP_TASK:
gcmd -rt STOP_TASK argument-list
For example:
gcmd -rt STOP_TASK -tk MYTASK16 -un user1 -pw User9999
For descriptions of each command argument, see “Arguments for Stopping a Task ” (page 114).
The servers on the Neoview platform may take some time to stop depending on the activity at
the time that the STOP command was issued. In some cases, the servers might not detect the
Loading (Importing) Data 97