Neoview Database Administrator's Guide (R2.2)

Displaying
columns in a table, 47
DDL for indexes, 60
DDL for materialized view groups, 71
DDL for materialized views, 68
DDL for schemas, 39
DDL for synonyms, 73
DDL for tables, 51
DDL for views, 62
indexes, 59
materialized view groups, 70
materialized views, 67
scheduled operations, 82
schemas, 38
stored procedures, 74
synonyms, 73
views, 61
Documents, related information, 11
Dropping
indexes, 60
materialized view groups, 71
materialized views, 69
schemas, 40
tables, 56
views, 62
E
Events
viewing database, 90
viewing dial out, 90
viewing history, 89
viewing in real time, 89
viewing summary, 90
viewing with OSM Event Viewer, 88
Extract task logs, 130
Extracting data
configuring task, 121
confirming completion, 122
starting task, 122
stopping task, 123
F
Files
.rcvy, 117
extract task output files, 125
input format, 105
input.bad, 116
jsm.log, 116, 146
sql.bad, 116
Format file, input data, 105
G
gcmd
commands, 108
logs, 115, 130
starting, 108
GEL JMS Consumer
data flow, 143
JMS logs, 146
security, 144
Gelserver
configuring a JMS task, 145
JMS data flow, 143
JMS installation considerations, 144
JMS logs, 146
reading data from a JMS Queue, 143
Getting started, 17
Granting and revoking access privileges, 47
Groups, materialized views, displaying, 70
H
Help, where to find information in this guide, 15
I
Identity column, loading, 107
Importing DDL to create tables, 45
Indexes
creating, 57
defragmenting, 78
displaying, 59
displaying DDL, 60
dropping (deleting), 60
limits, 35
populating, 33, 59
input.bad file, 116
J
Java Runtime Environment, supported versions, 18
JBOSS
components used to support JMS, 143
entries that support JMS, 145
JMS log, 116, 146
JMS Queue
configuring a JMS task, 145
message handling, 143
reading data from, 143
JRE, supported versions, 18
L
Limits, 35
Linux accounts
adding, 18, 31
creating, 31
deleting, 31
description of, 18
freezing, 30
resetting passwords, 30
thawing, 31
Loader
extract task logs, 130
extracting data, 121
gcmd commands for extract tasks, 127
gcmd commands for load tasks, 108
identity column support, 107
loading data, 94
logs, 115
named pipes, as input, 112
named pipes, description of, 108
152 Index