Neoview Database Administrator's Guide (R2.3)

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 “Changing the Password and Expiration Date of a Role” (page 23), “Creating
a New User ID” (page 25), and “Changing the Password and Expiration Date of a User”
(page 26) to reflect 64 character passwords.
Chapter 3 (page 21)
Added “Granting and Revoking Access (Privileges) to a Schema” (page 41)Chapter 5 (page 35)
Updated “Schedule Table Row Deletion” (page 88) to reflect change in DB Admin.
Updated screen display in “Neoview VTS System Status Page” (page 91).
Chapter 6 (page 85)
Added a new chapter to describe automated UPDATE STATISTICS and REORG
operations.
Chapter 8 (page 103)
Added Mode_Special_2 features (must be enabled upon request).“ Special Neoview
Features—Enabled Upon Request” (page 121).
Appendix B (page 121)
Related Documentation
This manual is part of the HP Neoview customer library.
Neoview Customer Library
• 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 using the HP Neoview Command Interface to run SQL
statements interactively or from script files.
Neoview Command Interface
(NCI) Guide
Command-line help that describes the commands supported in the current
operating mode of Neoview Command Interface.
Neoview Command Interface
(NCI) Online Help
Information about how to load and manage the Neoview database by using
the Neoview DB Admin and other tools.
Neoview Database
Administrator’s Guide
Context-sensitive help topics that describe how to use the HP Neoview DB
Admin management interface.
Neoview DB Admin Online
Help
Information about how to use stored procedures that are written in Java within
a Neoview database.
Neoview Guide to Stored
Procedures in Java
Who Should Use This Manual 9