Neoview Database Administrator's Guide (R2.2)

NDCS data source status, 137
NDCS server status, 138
NDCS status, 137
objects, displaying, 39
operations
age table, 80
manage super ID, 87
Rename Table Wizard, 53
Rename View Wizard, 62
renaming
tables, 53
views, 62
roles
adding, 25
changing password, 25
deleting, 26
Schedule Age Table Wizard
failure, 81
predicate, 80
schedule, 81
UID, 81
Schedule Maintain Wizard
defining schedule, 80
select operation, 77
Schedule Populate Index Wizard, 59
schema objects, 39
schemas
creating, 39
displaying, 38
displaying DDL, 40
dropping, 40
security policies, managing, 30
stored procedures
displaying , 74, 75
super ID status, 87
synonyms
changing, 73
creating, 72
displaying, 73
system name display, 21
tables
adding columns, 51
aging data, 80
aging predicate, 80
attributes, 43
creating, 40
creating triggers:action, 55
creating triggers:granularity, 54
creating triggers:name, 54
creating triggers:search, 55
displaying , 47
displaying attributes, 49
displaying columns, 49
displaying DDL, 50, 51
displaying hash key, 49
displaying primary keys, 49
displaying privileges, 50
displaying space, 50
dropping, 56
renaming, 53
user IDs
adding, 27
changing password, 27
deleting, 28
user status
viewing all, 29
viewing by role, 29
view events, 90
viewing user status, 29
viewing user status by role, 29
views
creating, 61
displaying, 62
entering DDL to create, 61
renaming, 62
virtual tape status, 84
VST system status page, 84
Scripting, 21
Security
considerations, 17
managing policies, 30
sql.bad file, 116
Stopping a data load task, 97
Stopping an extract task, 123
Stored procedures, 21, 74
Sun Java Plug-in, supported versions, 18
Super ID, managing, 87
Support, contacting, 16, 85
Synonyms
changing, 73
creating, 72
displaying, 73
displaying DDL, 73
dropping (deleting), 74
Sysadmin account
description of, 18
performing tasks, 92
System messages, viewing, 88
System name display, 21
System status page (Neoview VTS), 84
T
Tables
adding columns to, 51, 52
ageing operation, 80
changing, 51, 52
adding columns, 51
attributes, 52
renaming, 52
changing materialized view groups for, 71
creating, 40
creating from existing tables, 44
creating index for, 57
creating materialized view groups for, 69
creating materialized views for, 63, 65
creating multiple, 45
creating synonyms for, 72
creating triggers on, 53
155