Neoview Database Administrator's Guide (R2.2)

Example 8-4 Extract Task Instance Log File Example
[15:07:10] MASTER> INFO : SESSION
----------------------------------------------------------------
SESSION PARAMETERS
--------------------
Task Name : EXT-II-1
Task Instance Name : EXT-II-1
Query : SELECT * FROM NEO.GENUS_TEST_DB.WISC_16 BROWSE ACCESS
Concatenate output files option : false
Data Format : DELIM
Field Delimiter : |
Rowset Size : 1000
Character set conversion option : true
Right trim option : false
Null Character : 63
LogSeverityLevel : INFO
Readers :
---------
1. 16.107.156.158:25076
Writers :
---------
1. /u02/genus/EXTRACT/testLogs/EXT/EXT-II-1/EXT-II-1-1
----------------------------------------------------------------
[15:07:10] MASTER> MASTER Execution Started.
[15:07:10] MASTER> INFO : INIT_TCGS Waiting for initialization threads to complete.
[15:07:10] MASTER> INFO : RDR_SOURCE ODBC/MX FastPath has been enabled.
[15:07:10] MASTER> INFO : INIT_SGS Waiting for source initialization threads to complete.
[15:07:10] MASTER> INFO : WRT_1 INIT: Connection location:
/u02/genus/EXTRACT/testLogs/EXT/EXT-II-1/EXT-II-1-1
[15:07:10] MASTER> INFO : MASTER Starting Threads.
[15:07:10] MASTER> INFO : MASTER Threads Started.
[15:07:12] READER_1> INFO : RDR_1 [ Network Wait: 1948ms & Dist. Wait: 0ms. ]
[15:07:12] DIST_1> INFO : DIST [ Write Wait: 0ms & Hash Time: 0ms & Copy Time: 0ms. ]
[15:07:12] DIST_1> INFO : DIST [ Read Wait: 1947ms. ]
[15:07:12] WRITER_1> INFO : WRITER [ Dist. Wait: 724ms & Write Prepare
Wait: 1204ms & Write Execute Wait: 0ms. ]
[15:07:12] MASTER> MASTER Threads completed with success.
[15:07:12] MASTER> STATS
----------------------------------------------------------------
PNo. Requested Applied Rejected Affected
0 100000 0 0 100000
Tot. 100000 0 0 100000
CTot. 100000 0 0 100000
----------------------------------------------------------------
[15:07:12] MASTER> SUMMARY STATS
----------------------------------------------------------------
Task started : Tue Mar 6 15:07:10 2007
Task completed : Tue Mar 6 15:07:12 2007
Task elapsed time : 2 seconds
Task completion status : Execution completed with success
Total records read at source : 100000
Total records rejected at source : 0
Total records written at target : 100000
Total records rejected at target : 0
----------------------------------------------------------------
[15:07:12] MASTER> MASTER Execution completed with success.
Command-Line Arguments for Extract Tasks 131