Neoview Database Administrator's Guide (R2.2)

Displaying Scheduled Operations’ Status............................................................................................82
Modifying Scheduled Operations...................................................................................................83
Deleting Scheduled Operations.......................................................................................................83
Data Backups........................................................................................................................................84
Neoview VTS System Status Page........................................................................................................84
Displaying the System Status Page.................................................................................................84
Data Recovery.......................................................................................................................................85
7 Other Operations.........................................................................................................87
Managing the Super ID.........................................................................................................................87
Viewing System Events.........................................................................................................................88
Monitoring real-time messages.......................................................................................................89
Viewing a selection of past messages..............................................................................................89
Viewing a summary of events.........................................................................................................90
Accessing Events Using a URL........................................................................................................91
Monitoring Queries...............................................................................................................................92
Performing Linux System Administration Tasks.................................................................................92
About the Sysadmin Account..........................................................................................................92
8 Using the Neoview Loader..........................................................................................93
Performance Considerations.................................................................................................................93
Loading (Importing) Data.....................................................................................................................94
Step 1: Configure a Data-Load Task................................................................................................94
Step 2: Start a Data-Load Task.........................................................................................................94
Step 3: Confirm Completion of the Data-Load Task.......................................................................95
Stopping a Data-Load Task.............................................................................................................97
Failed Load Tasks............................................................................................................................98
Transaction Size Limit.....................................................................................................................99
Input Data Considerations For Load Tasks........................................................................................100
Delimited Input Data.....................................................................................................................100
Fixed-Width Input Data.................................................................................................................103
Using a Format File........................................................................................................................105
Reflexive Update Support..............................................................................................................106
Identity Column Support..............................................................................................................107
Java Message System (JMS) Input.................................................................................................108
Using Named Pipes.......................................................................................................................108
Command-Line Arguments for Load Tasks.......................................................................................108
Required Arguments for Configuring a Data-Load Task..............................................................108
Optional Arguments for Configuring a Data-Load Task..............................................................110
Arguments for Starting a Task ......................................................................................................113
Arguments for Stopping a Task ....................................................................................................114
Arguments for Versioning ............................................................................................................114
User Name and Password.............................................................................................................115
Multi-Line Task Commands..........................................................................................................115
Logs.....................................................................................................................................................115
Rejected Data Records...................................................................................................................116
JMS Log..........................................................................................................................................116
Recovery..............................................................................................................................................116
Configuring A Recovery-Enabled Task.........................................................................................116
Running a Recovery-Enabled Task................................................................................................117
Stopping a Recovery Enabled Task................................................................................................117
Recovering a Recovery-Enabled Task............................................................................................117
Recovery Files................................................................................................................................117
Table of Contents 5