beautypg.com

7 load and extract operations, 8 data processing, 9 troubleshooting – HP Neoview Release 2.4 Software User Manual

Page 5

background image

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