Neoview Transporter User Guide (R2.5)

Table of Contents
About This Document.........................................................................................................9
Intended Audience.................................................................................................................................9
New and Changed Information in This Edition.....................................................................................9
Related Documentation..........................................................................................................................9
Neoview Customer Library...............................................................................................................9
HP Encourages Your Comments..........................................................................................................11
General Syntax Notation.......................................................................................................................11
Publishing History................................................................................................................................13
1 Overview.......................................................................................................................15
Network Changes for the Neoview Platform ......................................................................................15
Load and Extract Operations................................................................................................................15
The Transporter Control File................................................................................................................15
Client Components...............................................................................................................................16
2 Transporter Configuration...........................................................................................17
Client Directory Structure.....................................................................................................................17
Security Parameters Saved....................................................................................................................17
The Transporter API.............................................................................................................................17
3 Functions and Features................................................................................................19
Enhanced Initial Load (EIL)..................................................................................................................19
Control File Options for EIL............................................................................................................19
Error Logging..................................................................................................................................19
EIL Exception Tables..................................................................................................................19
Error Threshold With EIL..........................................................................................................20
Restrictions for EIL..........................................................................................................................20
Staging Tables.......................................................................................................................................20
Parallel Streams.....................................................................................................................................21
Parallel Query Extract...........................................................................................................................21
Prehashing............................................................................................................................................21
JMS Trickle Feed For Data Loads..........................................................................................................21
Transporter Job Statistics on the Neoview Platform ............................................................................21
Reflexive Update...................................................................................................................................21
Reflexive Update Considerations....................................................................................................22
Updates Using Constant, NULL, or Expression...................................................................................22
Identity Columns..................................................................................................................................22
Data Compression.................................................................................................................................22
Multi-session Side-tree Inserts..............................................................................................................22
Using Virtual Partitions for Load and Extract......................................................................................23
4 Security..........................................................................................................................25
Password Encryption............................................................................................................................25
Encryption Files ...................................................................................................................................25
Installing the Encryption Utility...........................................................................................................25
The Encryption Utility — nvtencrsrv...................................................................................................26
Sample Commands for the nvtencrsrv Utility................................................................................26
Table of Contents 3