Index

A B C D E F G H I J L M N O P Q R S T U V W X Y

A

acxTrace parameter, 5.2.2

advanced interaction parameters, A.2.3

analyzerQueryPlan parameter, 5.2.2

application language parameter, 5.2.3

arithmetic operators, D.2

arrays, flattening hierarchical data, D.4.3

B

buffer size, comCacheBufferSize parameter, 5.2.1

Business Objects, qualifying catalog and tables names, 5.2.6.1

C

cache

dsmMaxBufferSize parameter, 5.2.8

maximum queries, 5.2.6.1

CD-ROM drive requirements

IBM S/390, 2.1.1.1

PC, 2.1.2.1

codepage parameter, 5.2.3

comCacheBufferSize parameter, 5.2.1

comm parameters

comCacheBufferSize, 5.2.1

comMaxSocketSize, 5.2.1

comMaxXmlSize, 5.2.1, 5.2.1

comMaxSocketSize parameter, 5.2.1

comMaxXmlSize parameter, 5.2.1, 5.2.1

comparison operators, D.2

compileAfterLoad parameter, 5.2.6.1

compiling

procedures, 5.2.6.1

views, 5.2.6.1

cvtSeverityLevel parameter, 5.2.3

D

daemon

logging, C.2

security, C.3

server modes, 5.1.3

shutting down, 4.1.2

starting, 4.1.1

timeout, 4.2

data sources, disabling caching, 5.2.6.1

data types

atomic metadata, B.1

cvtSeverityLevel, 5.2.3

nlsString, 5.2.3

debug parameters

acxTrace, 5.2.2

analyzerqueryPlan, 5.2.2

environment, 5.2.2

generalTrace, 5.2.2

logFile, 5.2.2

oledbTrace, 5.2.2

optimizerTrace, 5.2.2

queryWarnings, 5.2.2

traceDir, 5.2.2

disabling

parallel processing, 5.2.6.1

parameterization of constants, 5.2.6.1

pooling, 5.2.6.1

read-ahead functionality, 5.2.6.1

disk space requirements

IBM S/390, 2.1.1.1

PC, 2.1.2.1

dsmMaxBufferSize parameter, 5.2.8

dsmMaxSortBufferSize parameter, 5.2.8

dsmMidBufferSize parameter, 5.2.8

dsoThreadingBoth parameter, 5.2.6.1

E

edit parameter, 5.2.3

emptyStringIsNull parameter, 5.2.6.1, 5.2.6.1

environment parameters

acxTrace, 5.2.2

analyzerQueryPlan, 5.2.2

codepage, 5.2.3

comCacheBufferSize, 5.2.1

comMaxSocketSize, 5.2.1

comMaxXmlSize, 5.2.1, 5.2.1

compileAfterLoad, 5.2.6.1

cvtSeverityLevel, 5.2.3

debug, 5.2.2

dsmMaxBufferSize, 5.2.8

dsmMaxSortBufferSize, 5.2.8

dsmMidBufferSize, 5.2.8

dsoThreadingBoth, 5.2.6.1

edit, 5.2.3

emptyStringIsNull, 5.2.6.1

firstTreeExtensions, 5.2.6.1

forceQualifiedNames, 5.2.6.1

generalTrace, 5.2.2

goal, 5.2.6

hashBufferSize, 5.2.8

hashEnableParallelism, 5.2.8

hashMaxDiskSpace, 5.2.8

hashMaxOpenFiles, 5.2.8

ignoreSegmentBindFailure, 5.2.6.1

language, 5.2.3

logFile, 5.2.2

maxColumnsInParsing, 5.2.6.1

maxSqlCache, 5.2.6.1

miscellaneous, 5.2.3

nlsString, 5.2.3

noCommandReuse, 5.2.6.1

noCompilationCache, 5.2.6.1

noDSPropertyCache, 5.2.6.1

noInsertParameterization, 5.2.6.1

noMarkRowFailedFetch, 5.2.6.1

noMetadataCaching, 5.2.6.1

noParallelExecution, 5.2.6.1

noQueryParametrization, 5.2.6.1

noQueryReadAhead, 5.2.6.1

noSessionPooling, 5.2.6.1

noSQSCache, 5.2.6.1

noThreadedReadAhead, 5.2.6.1

noThreads, 5.2.6.1

noTreeAutoExtend, 5.2.6.1

odbc, 5.2.4

oledb, 5.2.5

oledbTrace, 5.2.2

optimisticForUpdate, 5.2.6.1

optimizer, 5.2.6

optimizerTrace, 5.2.2

parserDepth, 5.2.6.1

proceduresCacheSize, 5.2.6.1

promptDbUserPassword, 5.2.6.1

queryProcessor, 5.2.6.1

queryWarnings, 5.2.2

tempDir, 5.2.3

tokenSize, 5.2.6.1

traceDir, 5.2.2

transactions, 5.2.7

tuning, 5.2.8

useAlternatequalifier, 5.2.6.1

useTableFilterExpressions, 5.2.6.1

year2000Policy, 5.2.3

error log

logFile parameter, 5.2.2

F

first row optimization, goal parameter, 5.2.6

firstTreeExtensions parameter, 5.2.6.1

forceQualifiedNames parameter, 5.2.6.1, 5.2.6.1

functions

group, D.3

string, D.3

G

generalTrace parameter, 5.2.2

goal parameter, 5.2.6

group functions, D.3

H

hardware requirements

IBM S/390 CD-ROM drive, 2.1.1.1

IBM S/390 disk space, 2.1.1.1

IBM S/390 memory, 2.1.1.1

PC CD-ROM drive, 2.1.2.1

PC disk space, 2.1.2.1

PC memory, 2.1.2.1

PC processor, 2.1.2.1

UNIX, 2.1.1.1

hash disk space, 5.2.8

hash joins, 5.2.8

hash memory, 5.2.8

hashBufferSize parameter, 5.2.8

hashEnableParallelism parameter, 5.2.8

hashMaxDiskSpace parameter, 5.2.8

hashMaxOpenFiles parameter, 5.2.8

hierarchical queries, D.4.3

I

IBM S/390

installing, 2.2.4

postinstallation, 2.2.5

preinstallation, 2.2.2

ignoreSegmentBindFailure parameter, 5.2.6.1

importing installation kit, 2.2.3

index cache

dsmMidBufferSize parameter, 5.2.8

installation kit, importing, 2.2.3

installing

IBM S/390, 2.2.4

Windows, 2.4.1

integration flow, Oracle Application Server to legacy application, 1.2.1

interaction parameters, advanced, A.2.3

J

joins

hashBufferSize parameter, 5.2.8

hashEnableParallelism parameter, 5.2.8

hashMaxDiskSpace parameter, 5.2.8

hashMaxOpenFiles parameter, 5.2.8

L

language parameter, 5.2.3

locking, optimistic, 5.2.6.1

log files

daemon options, C.2

logFile parameter, 5.2.2

logging

daemon configurations, C.2

optimizer strategy, 5.2.2

trace information, 5.2.2

M

maxColumnsInParsing parameter, 5.2.6.1

maximum size, XML documents, 5.2.1

maxSqlCache parameter, 5.2.6.1

memory

dsmMaxBufferSize parameter, 5.2.8

dsmMaxSortBufferSize parameter, 5.2.8

dsmMidBufferSize parameter, 5.2.8

PC requirements, 2.1.2.1

memory requirements

IBM S/390 requirements, 2.1.1.1

metadata

atomic data types, B.1

disabling retrieval from cache, 5.2.6.1

Microsoft software requirements, 2.1.2.2

miscellaneous parameters

codepage, 5.2.3

cvtSeverityLevel, 5.2.3

edit, 5.2.3

environment, 5.2.3

language, 5.2.3

nlsString, 5.2.3

tempDir, 5.2.3

year2000Policy, 5.2.3

multithreading, disabling, 5.2.6.1

N

NAV_UTIL, text editor, 5.2.3

nlsString parameter, 5.2.3

noCommandReuse parameter, 5.2.6.1

noCompilationCache parameter, 5.2.6.1

noDSPropertyCache parameter, 5.2.6.1

noInsertParameterization parameter, 5.2.6.1

noMarkRowFailedFetch parameter, 5.2.6.1

noMetadataCaching parameter, 5.2.6.1

noParallelExecution parameter, 5.2.6.1

noQueryParametrization parameter, 5.2.6.1

noQueryReadAhead parameter, 5.2.6.1

noSessionPooling parameter, 5.2.6.1

noSQSCache parameter, 5.2.6.1

noThreadedReadAhead parameter, 5.2.6.1

noThreads parameter, 5.2.6.1

noTreeAutoExtend parameter, 5.2.6.1

O

odbc environment parameters, 5.2.4

oledb environment parameters, 5.2.5

oledbTrace parameter, 5.2.2

operating system requirements

PC, 2.1.2.2

UNIX, 2.1.1.2

optimisticForUpdate parameter, 5.2.6.1

optimizer

goal parameter, 5.2.6

traceDir parameter, 5.2.2

writing plan to file, 5.2.2

optimizer environment parameters, 5.2.6

optimizerTrace parameter, 5.2.2

Oracle Application Server requirements, 2.1.1.2

P

parallel processing, disabling, 5.2.6.1

parameterization of constants, disabling, 5.2.6.1

parserDepth parameter, 5.2.6.1

password, setting automatic prompt, 5.2.6.1

pooling, disabling, 5.2.6.1

postinstallation, IBM S/390, 2.2.5

preinstallation, IBM S/390, 2.2.2

proceduresCacheSize parameter, 5.2.6.1

processor requirements

PC, 2.1.2.1

UNIX, 2.1.1.1

promptDbUserPassword parameter, 5.2.6.1

Q

queries

disabling parallel processing, 5.2.6.1

disabling parameterization of constants, 5.2.6.1

disabling read-ahead functionality, 5.2.6.1

disabling reuse, 5.2.6.1

disabling saved compilation, 5.2.6.1

enabling retrieval after failure, 5.2.6.1

maximum cached in memory, 5.2.6.1

maximum length of string, 5.2.6.1

maximum size after compilation, 5.2.6.1

query optimizer

goal parameter, 5.2.6

logging strategy, 5.2.2

traceDir parameter, 5.2.2

writing plan to file, 5.2.2

query processor

compileAfterLoad parameter, 5.2.6.1

dsoThreadingBoth parameter, 5.2.6.1

emptyStringISNull parameter, 5.2.6.1

environment parameters, 5.2.6.1

queryWarnings parameter, 5.2.2

queryProcessor parameters

firstTreeExtensions, 5.2.6.1

forceQualifiedNames, 5.2.6.1

ignoreSegmentBindFailure, 5.2.6.1

maxColumnsInParsing, 5.2.6.1

maxSqlCache, 5.2.6.1

noCommandReuse, 5.2.6.1

noCompilationCache, 5.2.6.1

noDSPropertyCache, 5.2.6.1

noInsertParameterization, 5.2.6.1

noMarkRowFailedFetch, 5.2.6.1

noMetadataCaching, 5.2.6.1

noParallelExecution, 5.2.6.1

noQueryParametrization, 5.2.6.1

noQueryReadAhead, 5.2.6.1

noSessionPooling, 5.2.6.1

noSQSCache, 5.2.6.1

noThreadedReadAhead, 5.2.6.1

noThreads, 5.2.6.1

noTreeAutoExtend, 5.2.6.1

optimisticForUpdate, 5.2.6.1

parserDepth, 5.2.6.1

proceduresCacheSize, 5.2.6.1

promptDbUserPassword, 5.2.6.1

tokenSize, 5.2.6.1

useAlternatequalifier, 5.2.6.1

useTableFilterExpressions, 5.2.6.1

queryWarnings parameter, 5.2.2

R

read-ahead functionality, disabling, 5.2.6.1

reading from disk, 5.2.6.1

requirements

PC hardware requirements, 2.1.2.1

PC software requirements, 2.1.2.2

UNIX hardware requirements, 2.1.1.1

UNIX software requirements, 2.1.1.2

row optimization, goal parameter, 5.2.6

S

security

daemon configurations, C.3

setting automatic prompt, 5.2.6.1

segmented data sources, response upon failure, 5.2.6.1

servers

configuring modes, 5.1.3

reusable, 5.1.3

Reuse limit daemon parameter, C.4.2

ReuseLimit daemon parameter, 5.1.3

sessions, disabling pooling, 5.2.6.1

setting up VSAM, 2.5.3.1

SMS

See system managed storage

sockets, comMaxSocketSize parameter, 5.2.1

software requirements

Microsoft, 2.1.2.2, 2.1.2.2

Oracle Application Server, 2.1.1.2

PC operating system, 2.1.2.2

UNIX operating system, 2.1.1.2

sort buffer, dsmMaxSortBufferSize parameter, 5.2.8

SQL, flattening hierarchical data, D.4.3

stored queries, maximum in cache memory, 5.2.6.1

string functions, D.3

system managed storage, 2.2.2

T

tempDir parameter, 5.2.3

temporary files, 5.2.3

threading model, 5.2.6.1

timeout

client idle, 4.2

daemon, 4.2

tokenSize parameter, 5.2.6.1

trace information, logging, 5.2.2

traceDir parameter, 5.2.2

transactions environment parameters, 5.2.7

tuning parameters

dsmMaxBufferSize, 5.2.8

dsmMaxSortBufferSize, 5.2.8

dsmMidBufferSize, 5.2.8

environment, 5.2.8

hashBufferSize, 5.2.8

hashenableParallelism, 5.2.8

hashMaxDiskSpace, 5.2.8

hashMaxOpenFiles, 5.2.8

U

useAlternatequalifier parameter, 5.2.6.1

useTableFilterExpressions parameter, 5.2.6.1

V

views, 5.2.6.1

views, setting to compile, 5.2.6.1

VSAM, setting up, 2.5.3.1

W

Windows, installing, 2.4.1

Workspace server mode, C.4.2

X

XML documents, maximum size, 5.2.1

Y

Y2K

See year2000Policy parameter

year2000Policy parameter, 5.2.3