Neoview Database Administrator's Guide (R2.2)

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

This manual is based on (and a revision of) the Neoview Database Administrator’s Guide for Release

2.0, part number 54758-001. Major changes are listed below:

New and Changed InformationChapters

Added description of “Stored Procedures” (page 21)Chapter 2 (page 17)

Updated description of “User IDs” (page 23) with the limit on the number of user IDsChapter 3 (page 23)

• Updated “Creating Tables ” (page 40) with changed screens

• Updated “Granting and Revoking Access (Privileges) to a Table” (page 47) with

changed screen

• Updated “Displaying Tables and Their Properties” (page 47) with more details

• Added “Enabling or Disabling Reorganize and Update Statistics on Tables” (page 56)

• Updated “Creating Indexes” (page 57) to describe unique index creation

• Update “Displaying Indexes and Their Properties” (page 59) with changed screens

• Updated “Creating Views” (page 60) with changed screens

• Updated “Creating Materialized Views” (page 63) with procedures for creating two

kinds of materialized views

• Added “Stored Procedures in Java (SPJs)” (page 74)

Chapter 5 (page 37)

Updated “Displaying the System Status Page” (page 84) with revised screen shot.Chapter 6 (page 77)

• Updated “Data Formats” under “Input Data Considerations For Load Tasks” (page 100).

• Updated description of rightTrim(-tm) and transactionSize(-ts)arguments

Chapter 8 (page 93)

Updated “NDCS Services” (page 136) with updated screen shotChapter 9 (page 135)