Neoview Database Administrator's Guide (R2.3)

DDL for tables, 54
DDL for views, 69
indexes, 62
materialized view groups, 78
materialized views, 75
scheduled operations, 88
schemas, 36
stored procedures, 82
synonyms, 81
triggers, 66
views, 68
Documents, related information, 9
Dropping
indexes, 62
materialized view groups, 79
materialized views, 77
schemas, 42
tables, 58
views, 70
E
Events
viewing database, 99
viewing dial out, 99
viewing history, 98
viewing in real time, 98
viewing summary, 99
viewing with OSM Event Viewer, 96
G
Getting started, 15
Granting and revoking access privileges, 41, 50
Groups, materialized views, displaying, 78
H
Help, where to find information in this guide, 13
HP_USTAT.CHG_AUTO_LIST() stored procedure, 103
HP_USTAT.STOP_AUTOMATED_STATS() stored
procedure, 107
HP_USTAT.USTAT_AUTO_LIST view, 106
HP_USTAT.USTAT_AUTO_LIST_DETAIL view, 106
I
Importing DDL to create tables, 48
Indexes
creating, 58
defragmenting, 87
displaying, 62
displaying DDL, 62
dropping (deleting), 62
limits, 33
populating, 31, 61
J
Java Runtime Environment, supported versions, 16
JRE, supported versions, 16
L
Limits, 33
Logon help link, 18
M
Manage super ID operation, 95
Management tools
DB Admin, overview, 17
list of, 17
ODBC Database Administrator, overview, 17
Materialized view groups
changing, 79
creating, 77
displaying, 78
displaying DDL, 78
dropping, 79
dropping (deleting), 79
refresh operation, 87
Materialized views
changing, 76
creating, 70
defragmenting, 87
defragmenting indexes, 87
displaying, 75
displaying DDL, 76
dropping, 77
refresh operation, 87
MAXREORGSLICE, 108
MAXRUNTIME, 108
Messages, system, 96
mode_special_2, 121
N
NDCS (Neoview Database Connectivity Services), 111
Neoview DB Admin tool, overview, 17
Neoview platform, description of, 13
Neoview VTS, 91
O
ODBC client data sources
reconfiguring , 111
removing, 111
ODBC Programmer’s Reference, 13
Operations
age table, 88
defragment indexes, 87
defragment materialized views, 87
defragment tables, 87
deleting, 91
displaying schedule, 88
manage super ID, 95
modifying schedule, 91
refresh materialized view groups, 87
refresh materialized views, 87
update statistics, 87
P
Passwords, changing
expiration, 23, 26
roles, 23
security considerations, 15
128 Index