7 Load and Extract Operations ....................................................................................61
Steps for Performing Load and Extract Operations.............................................................................61
Starting the Transporter Client ............................................................................................................61
Starting the Client on UNIX-type Systems......................................................................................62
Starting the Client on Windows Systems........................................................................................62
Displaying the Installed Version of Transporter.............................................................................62
Stopping the Client...............................................................................................................................62
The Transporter Job...............................................................................................................................63
Sources and Targets..............................................................................................................................63
Parallel Streams.....................................................................................................................................63
Parallel Streams for Load Jobs.........................................................................................................63
Parallel Streams for Extract Jobs......................................................................................................63
Transaction Modes for Load Jobs.........................................................................................................64
Loading Data With JMS Trickle Feed....................................................................................................64
Requirements...................................................................................................................................65
Parallel Processing for Load Operations..............................................................................................65
Considerations for Extract Jobs.............................................................................................................66
Considerations for Update Operations.................................................................................................66
Considerations for Upsert Operations .................................................................................................66
Considerations for Delete Operations..................................................................................................67
8 Data Processing............................................................................................................69
Data For Load Operations....................................................................................................................69
Processing Data for Load Operations...................................................................................................69
Delimited Data for Load Operations...............................................................................................69
Fixed—Width Data for Load Operations........................................................................................70
Delimited Data......................................................................................................................................70
Field Delimiter Character................................................................................................................70
Record Separator Character ............................................................................................................70
Quote Processing For Load Operations..........................................................................................71
Quote Processing For Extract Operations.......................................................................................71
Considerations for Character Data.......................................................................................................72
9 Troubleshooting............................................................................................................73
Logs.......................................................................................................................................................73
Log Files on the Client.....................................................................................................................73
Setting Up a Custom Log File Location...........................................................................................73
Logging to the Console....................................................................................................................74
The EMS Log....................................................................................................................................74
Job Recovery..........................................................................................................................................74
Considerations for Job Recovery.....................................................................................................74
The -recover Command Line Option..........................................................................................74
Job Statistics on the Neoview Platform ................................................................................................75
Control File Metadata Tables...........................................................................................................76
Using Transporter Metadata Tables................................................................................................76
A Control File Examples..................................................................................................79
B Control File Editor and Control File Generator.......................................................107
Control File Editor ..............................................................................................................................107
Features..........................................................................................................................................107
Table of Contents 5
Komentarze do niniejszej Instrukcji