Neoview Database Administrator's Guide (R2.2)

named pipes, extract output, 127
named pipes, transaction size limit, 99
overview, 93
recovery, 116
stopping a data load task, 97
stopping an extract task, 123
Loading data
commands for, 108
configuring task, 94
confirming completion, 95
performance, 93, 99
starting task, 94
stopping, 97
Logon help link, 21
Logs
extract task, 130
input.bad, 116
jms, 116, 146
loader, 115
recovery, 117
rejected data, 116
sql.bad, 116
M
Manage super ID operation, 87
Management tools
DB Admin, overview, 19
list of, 19
loader, overview, 19
ODBC Database Administrator, overview, 19
Materialized view groups
changing, 71
creating, 69
displaying, 70
displaying DDL, 71
dropping, 71
dropping (deleting), 71
refresh operation, 79
Materialized views
changing, 68
creating, 63
defragmenting, 79
defragmenting indexes, 79
displaying, 67
displaying DDL, 68
dropping, 69
refresh operation, 78
Messages, system, 88
N
Named pipes
and transaction size limit, 99
description of, 108
extract output, 127
input to loader, 112
NDCS (Neoview Database Connectivity Services), 135
Neoview DB Admin tool, overview, 19
Neoview loader (see Loader)
Neoview platform, description of, 15
Neoview VTS, 84
O
ODBC client data sources
reconfiguring , 135
removing, 135
ODBC Programmer’s Reference, 15
Operations
age table, 80
defragment indexes, 78
defragment materialized views, 79
defragment tables, 78
deleting, 83
displaying schedule, 82
manage super ID, 87
modifying schedule, 83
refresh materialized view groups, 79
refresh materialized views, 78
update statistics, 78
P
Passwords, changing
expiration, 25, 27
roles, 25
security considerations, 17
security policies, 29
super ID, 87
users, 27
Passwords, resetting, Linux accounts, 30
Performance
extract task, 125
load task, transaction size, 99, 113
loader, overview, 93
log inserts only, 43
Populate index, 59
Privileges, granting/revoking access to tables, 47
R
Reconfiguring client data sources, 135
Recovery
data, 85
loader, 116
Recovery logs, Loader, 117
Refresh materialized view groups operation, 79
Refresh materialized views operation, 78
Rejected data logs, 116
Removing client data sources, 135
Removing Linux accounts, 31
Renaming
views, 62
Roles
changing passwords and expiration dates, 25
creating, 25
deleting, 26
preconfigured, 23
relationship to user IDs, 23
typical usage, 24
153