Neoview Database Administrator's Guide (R2.5)
Table of Contents
About This Manual.............................................................................................................7
Who Should Use This Manual................................................................................................................7
New and Changed Information in This Edition.....................................................................................7
Related Documentation..........................................................................................................................7
Neoview Customer Library ..............................................................................................................7
General Syntax Notation........................................................................................................................9
Publishing History..................................................................................................................................9
HP Encourages Your Comments..........................................................................................................10
1 Introduction to the HP Neoview Platform...................................................................11
About This Guide..................................................................................................................................11
For More Information ..........................................................................................................................11
2 Getting Started.............................................................................................................13
Security Considerations........................................................................................................................13
Limited Access on the Neoview Platform.......................................................................................13
Connection Timeout........................................................................................................................13
Neoview Roles and User IDs...........................................................................................................14
Working With Neoview Roles and User IDs.............................................................................14
Management Tools................................................................................................................................14
Installing Management Tools................................................................................................................15
Starting the HP Database Manager (HPDM)........................................................................................15
Starting the Neoview Command Interface (NCI).................................................................................15
Working With Database Objects...........................................................................................................15
Schemas...........................................................................................................................................16
Tables...............................................................................................................................................16
Indexes.............................................................................................................................................16
Views...............................................................................................................................................16
Materialized Views..........................................................................................................................17
Materialized View Groups..............................................................................................................17
Triggers............................................................................................................................................17
Synonyms........................................................................................................................................17
Data Types.............................................................................................................................................17
Stored Procedures in Java (SPJs)...........................................................................................................17
Viewing System Events.........................................................................................................................17
Loading and Extracting Data with Neoview Transporter....................................................................17
3 Guidelines for Database Administrators....................................................................19
Partitioning For Tables and Indexes.....................................................................................................19
Managing Database Objects..................................................................................................................19
4 Performing Database Operations...............................................................................21
Schedule Maintenance Tasks................................................................................................................21
Schedule Table Row Deletion...............................................................................................................21
Neoview VTS System Status Page........................................................................................................21
Displaying the VTS System Status Page..........................................................................................21
Interpreting the VTS System Status Page...................................................................................22
Data Recovery.......................................................................................................................................23
Table of Contents 3