Neoview Database Administrator's Guide (R2.4)

columns in a table, 53
DDL for indexes, 64
DDL for materialized view groups, 80
DDL for materialized views, 77, 78
DDL for schemas, 43
DDL for synonyms, 83
DDL for tables, 56
DDL for views, 71
indexes, 64
materialized view groups, 80
materialized views, 77
scheduled operations, 90
schemas, 38
stored procedures, 84
synonyms, 83
triggers, 68
views, 70
Documents, related information, 9
Dropping
indexes, 64
materialized view groups, 81
materialized views, 79
schemas, 44
tables, 60
views, 72
dropUser command
syntax of, 126
E
Events
viewing database, 101
viewing dial out, 101
viewing history, 100
viewing in real time, 100
viewing summary, 101
viewing with OSM Event Viewer, 98
G
Getting started, 15
Granting and revoking access privileges, 43, 52
grantRole command
syntax of, 127
Groups, materialized views, displaying, 80
H
Help, where to find information in this guide, 13
HP_USTAT.CHG_AUTO_LIST() stored procedure, 105
HP_USTAT.STOP_AUTOMATED_STATS() stored
procedure, 109
HP_USTAT.USTAT_AUTO_LIST view, 108
HP_USTAT.USTAT_AUTO_LIST_DETAIL view, 108
I
Importing DDL to create tables, 50
Indexes
creating, 61
defragmenting, 89
displaying, 64
displaying DDL, 64
dropping (deleting), 64
limits, 35
populating, 33, 63
J
Java Runtime Environment, supported versions, 16
JRE, supported versions, 16
L
Limits, 35
Logon help link, 19
M
Manage super ID operation, 97
Management tools
DB Admin, overview, 17
list of, 17
ODBC Database Administrator, overview, 17
Materialized view groups
changing, 81
creating, 79
displaying, 80
displaying DDL, 80
dropping, 81
dropping (deleting), 81
refresh operation, 89
Materialized views
changing, 78
creating, 72
defragmenting, 89
defragmenting indexes, 89
displaying, 77
displaying DDL, 78
dropping, 79
refresh operation, 89
MAXREORGSLICE, 110
MAXRUNTIME, 110
Messages, system, 98
N
NDCS (Neoview Database Connectivity Services), 113
Neoview DB Admin tool, overview, 17
Neoview platform, description of, 13
Neoview VTS, 93
O
ODBC client data sources
reconfiguring , 113
removing, 113
ODBC Programmer’s Reference, 13
Operations
defragment indexes, 89
defragment materialized views, 89
defragment tables, 89
deleting, 93
displaying schedule, 90
manage super ID, 97
modifying schedule, 93
refresh materialized view groups, 89
138 Index