beautypg.com

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

Page 5

background image

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