Neoview Database Administrator's Guide (R2.4)

About This Manual
This guide describes concepts and tasks that users need to perform in order to use the HP Neoview
platform to manage very large databases.
Who Should Use This Manual
This guide is intended for those who perform standard database administration tasks.
It provides basic concepts and task information to get you started quickly and easily. You can
find additional information about installing and maintaining the hardware in the HP Neoview
Owner’s Manual.
New and Changed Information in This Edition
New and Changed InformationChapters
Updated security informationChapter 3 (page 21)
Removed Age Table. The operation has been removed from DB Admin.
Added information about purging tables using the Neoview Command Interface
(NCI).
Chapter 6 (page 87)
Added the EXCLUDE keyword to the HP_USTAT.CHG_AUTO_LIST() Stored
Procedure.
Chapter 8 (page 105)
Maximum row and block size is now 32,768.Appendix A (page 119)
Information about Mode_Special_2 features has been moved to the Neoview SQL
Reference Manual.
Appendix B (page 123)
Added new commands for managing multiple Neoview users:
• Creating and dropping users
• Granting and revoking roles
• Changing user passwords
Added error messages returned by these user management commands.
Appendix C (page 125)
Related Documentation
This manual is part of the HP Neoview customer library.
Neoview Customer Library
The manuals in the Neoview customer library are listed here for your convenience.
• Administration
Information for database administrators and end users of the Neoview
Character Sets product, including rules for defining and managing character
data using SQL language elements, capabilities and limitations of Neoview
client applications, troubleshooting character set-related problems, and enabling
Pass-Through mode in the ISO88591 configuration.
Neoview Character Sets
Administrator's Guide
Information about how to load and manage the Neoview database by using
the Neoview DB Admin and other tools.
Neoview Database
Administrator’s Guide
Information about how to use stored procedures that are written in Java within
a Neoview database.
Neoview Guide to Stored
Procedures in Java
Information about reviewing query execution plans and investigating query
performance of Neoview databases.
Neoview Query Guide
Who Should Use This Manual 9