Neoview Transporter User Guide (R2.5)

truncate.................................................................................................................................................65
url..........................................................................................................................................................65
user........................................................................................................................................................66
7 Load and Extract Operations ....................................................................................67
Steps for Performing Load and Extract Operations.............................................................................67
Starting the Transporter Client ............................................................................................................67
Starting the Client on UNIX-type Systems......................................................................................68
Starting the Client on Windows Systems........................................................................................68
Displaying the Installed Version of Transporter.............................................................................68
Stopping the Client...............................................................................................................................68
The Transporter Job...............................................................................................................................69
Sources and Targets..............................................................................................................................69
Parallel Streams.....................................................................................................................................69
Parallel Streams for Load Jobs.........................................................................................................69
Parallel Streams for Extract Jobs......................................................................................................69
Transaction Modes for Load Jobs.........................................................................................................70
Loading Data With JMS Trickle Feed....................................................................................................70
Requirements...................................................................................................................................71
Parallel Processing for Load Operations..............................................................................................71
Considerations for Extract Jobs.............................................................................................................72
Considerations for Update Operations.................................................................................................73
Considerations for Upsert Operations .................................................................................................73
Considerations for Delete Operations..................................................................................................73
8 Data Processing............................................................................................................75
Data For Load Operations....................................................................................................................75
Processing Data for Load Operations...................................................................................................75
Delimited Data for Load Operations...............................................................................................75
Fixed—Width Data for Load Operations........................................................................................76
Delimited Data......................................................................................................................................76
Field Delimiter Character................................................................................................................76
Record Separator Character ............................................................................................................76
Quote Processing For Load Operations..........................................................................................77
Quote Processing For Extract Operations.......................................................................................77
Considerations for Character Data.......................................................................................................78
9 Troubleshooting............................................................................................................79
Logs.......................................................................................................................................................79
Log Files on the Client.....................................................................................................................79
Setting Up a Custom Log File Location...........................................................................................79
Logging to the Console....................................................................................................................80
The EMS Log....................................................................................................................................80
Job Recovery..........................................................................................................................................80
Considerations for Job Recovery.....................................................................................................80
The -recover Command Line Option..........................................................................................80
Job Statistics on the Neoview Platform ................................................................................................81
Control File Metadata Tables...........................................................................................................82
Using Transporter Metadata Tables................................................................................................82
Table of Contents 5