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, 6.2.2

analyzerQueryPlan parameter, 6.2.2

application language

parameter, 6.2.3

arithmetic operators, C.2

arrays

flattening hierarchical data, C.4.3

B

buffer size

comCacheBufferSize parameter, 6.2.1

Business Objects

qualifying catalog and tables names, 6.2.6.1

C

cache

max queries in, 6.2.6.1

cache memory

dsmMaxBufferSize parameter, 6.2.8

CD-ROM drive requirements

IBM S/390, 2.1.1.1

PC, 2.1.2.1

codepage parameter, 6.2.3

comCacheBufferSize, 6.2.1

comCacheBufferSize parameter, 6.2.1

comm parameters

comCacheBufferSize, 6.2.1

comMaxSocketSize, 6.2.1

comMaxXmlSize, 6.2.1, 6.2.1

comMaxSocketSize parameter, 6.2.1

comMaxXmlSize parameter, 6.2.1, 6.2.1

comparison operators, C.2

compileAfterLoad parameter, 6.2.6.1

compiling procedures and views, 6.2.6.1

CREATE PROCEDURE statement

maximum procedures in cache memory, 6.2.6.1

cvtSeverityLevel parameter, 6.2.3

D

daemon

logging, D.2

security, D.3

server modes, 6.1.3

shutting down, 5.1.2

starting, 5.1.1

timeout, 5.2

daemon configuration

logging section, D.2

security section, D.3

data source properties

disabling caching, 6.2.6.1

data type conversions

cvtSeverityLevel parameter, 6.2.3

data types

cvtSeverityLevel, 6.2.3

nlsString, 6.2.3

datatypes

metadata atomic datatypes, B.1

debug environment parameters, 6.2.2

debug parameters

acxTrace, 6.2.2

analyzerqueryPlan, 6.2.2

generalTrace, 6.2.2

logFile, 6.2.2

oledbTrace, 6.2.2

optimizerTrace, 6.2.2

queryWarnings, 6.2.2

traceDir, 6.2.2

disk space requirements

IBM S/390, 2.1.1.1

PC, 2.1.2.1

dsmMaxBufferSize parameter, 6.2.8

dsmMaxSortBufferSize parameter, 6.2.8

dsmMidBufferSize parameter, 6.2.8

dsoThreadingBoth parameter, 6.2.6.1

E

edit parameter, 6.2.3

emptyStringIsNull parameter

queryProcessor parameters

emptyStringIsNull, 6.2.6.1

environment parameters

acxTrace, 6.2.2

analyzerQueryPlan, 6.2.2

codepage, 6.2.3

comCacheBufferSize parameter, 6.2.1

comMaxSocketSize, 6.2.1

comMaxXmlSize, 6.2.1, 6.2.1

cvtSeverityLevel, 6.2.3

debug, 6.2.2

dsmMaxBufferSize, 6.2.8

dsmMaxSortBufferSize, 6.2.8

dsmMidBufferSize, 6.2.8

dsoThreadingBoth, 6.2.6.1

edit, 6.2.3

emptyStringIsNull, 6.2.6.1

firstTreeExtensions, 6.2.6.1

forceQualifiedNames, 6.2.6.1

generalTrace, 6.2.2

goal, 6.2.6

hashBufferSize, 6.2.8

hashEnableParallelism, 6.2.8

hashMaxDiskSpace, 6.2.8

hashMaxOpenFiles, 6.2.8

ignoreSegmentBindFailure, 6.2.6.1

language, 6.2.3

logFile, 6.2.2

maxColumnsInParsing, 6.2.6.1

maxSqlCache, 6.2.6.1

miscellaneous, 6.2.3

nlsString, 6.2.3

noCommandReuse, 6.2.6.1

noCompilationCache, 6.2.6.1

noDSPropertyCache, 6.2.6.1

noInsertParameterization, 6.2.6.1

noMarkRowFailedFetch, 6.2.6.1

noMetadataCaching, 6.2.6.1

noParallelExecution, 6.2.6.1

noQueryParametrization, 6.2.6.1

noQueryReadAhead, 6.2.6.1

noSessionPooling, 6.2.6.1

noSQSCache, 6.2.6.1

noThreadedReadAhead, 6.2.6.1

noThreads, 6.2.6.1

noTreeAutoExtend, 6.2.6.1

odbc, 6.2.4

oledb, 6.2.5

oledbTrace, 6.2.2

optimisticForUpdate, 6.2.6.1

optimizer, 6.2.6

optimizerTrace, 6.2.2

parserDepth, 6.2.6.1

proceduresCacheSize, 6.2.6.1

promptDbUserPassword, 6.2.6.1

queryProcessor, 6.2.6.1

queryWarnings, 6.2.2

tempDir, 6.2.3

tokenSize, 6.2.6.1

traceDir, 6.2.2

transactions, 6.2.7

tuning, 6.2.8

useAlternatequalifier, 6.2.6.1

useTableFilterExpressions, 6.2.6.1

year2000Policy, 6.2.3

error log

logFile parameter, 6.2.2

F

first row optimization

goal parameter, 6.2.6

firstTreeExtensions parameter, 6.2.6.1

forceQualifiedNames parameter, 6.2.6.1, 6.2.6.1

G

generalTrace parameter, 6.2.2

goal parameter, 6.2.6

Group functions, C.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

hashMaxDiskSpace parameter, 6.2.8

hash joins

hashMaxOpenFiles parameter, 6.2.8

hash memory

hashBufferSize parameter, 6.2.8

hashEnableParallelism parameter, 6.2.8

hashing

hashEnableParallelism parameter, 6.2.8

hashMaxDiskSpace parameter, 6.2.8

hashMaxOpenFiles parameter, 6.2.8

hierarchical queries

flattening hierarchical data, C.4.3

I

IBM S/390

installation, 2.2.4

postinstallation, 2.2.5

preinstallation, 2.2.2

ignoreSegmentBindFailure parameter, 6.2.6.1

Importing the Installation Kit, 2.2.3

index cache

dsmMidBufferSize parameter, 6.2.8

INSERT statement

disabling parameterization of constants, 6.2.6.1

installation

IBM S/390, 2.2.4

installing

Windows, 2.4.1

Integration Flow from Oracle Application Server to the Legacy Application, 1.2.1

Interaction Advanced Tab, A.2.3

J

joins

hashBufferSize parameter, 6.2.8

hashEnableParallelism parameter, 6.2.8

hashMaxDiskSpace parameter, 6.2.8

hashMaxOpenFiles parameter, 6.2.8

L

language parameter, 6.2.3

locking

optimistic as default, 6.2.6.1

log files

daemon options, D.2

logFile parameter, 6.2.2

logging

optimizer strategy, 6.2.2

trace information, 6.2.2

M

maxColumnsInParsing parameter, 6.2.6.1

maximum size, 6.2.1

maxSqlCache parameter, 6.2.6.1

memory

dsmMaxBufferSize parameter, 6.2.8

dsmMaxSortBufferSize parameter, 6.2.8

memory for index cache

dsmMidBufferSize parameter, 6.2.8

memory requirements

IBM S/390, 2.1.1.1

PC, 2.1.2.1

metadata

atomic datatypes, B.1

disabling retrieval from cache, 6.2.6.1

Microsoft software requirements, 2.1.2.2

miscellaneous environment parameters, 6.2.3

miscellaneous parameters

codepage, 6.2.3

cvtSeverityLevel, 6.2.3

edit, 6.2.3

language, 6.2.3

nlsString, 6.2.3

tempDir, 6.2.3

year2000Policy, 6.2.3

multithreading

disabling, 6.2.6.1

N

NAV_UTIL

text editor, 6.2.3

nlsString parameter, 6.2.3

noCommandReuse parameter, 6.2.6.1

noCompilationCache parameter, 6.2.6.1

noDSPropertyCache parameter, 6.2.6.1

noInsertParameterization parameter, 6.2.6.1

noMarkRowFailedFetch parameter, 6.2.6.1

noMetadataCaching parameter, 6.2.6.1

noParallelExecution parameter, 6.2.6.1

noQueryParametrization parameter, 6.2.6.1

noQueryReadAhead parameter, 6.2.6.1

noSessionPooling parameter, 6.2.6.1

noSQSCache parameter, 6.2.6.1

noThreadedReadAhead parameter, 6.2.6.1

noThreads parameter, 6.2.6.1

noTreeAutoExtend parameter, 6.2.6.1

O

odbc environment parameters, 6.2.4

oledb environment parameters, 6.2.5

oledbTrace parameter, 6.2.2

operating system requirements

PC, 2.1.2.2

UNIX, 2.1.1.2

optimisticForUpdate parameter, 6.2.6.1

optimizer environment parameters, 6.2.6

optimizer files

traceDir parameter, 6.2.2

optimizer parameters

goal, 6.2.6

optimizer plan

writing to file, 6.2.2

optimizerTrace parameter, 6.2.2

Oracle Application Server requirements, 2.1.1.2

P

parallel processing

disabling, 6.2.6.1

parserDepth parameter, 6.2.6.1

password

setting automatic prompt for, 6.2.6.1

pooling

disabling, 6.2.6.1

postinstallation

IBM S/390, 2.2.5

preinstallation

IBM S/390, 2.2.2

procedures

columns

maximum referenced in query, 6.2.6.1

maximum in cache memory, 6.2.6.1

reading from disk, 6.2.6.1

setting to compile, 6.2.6.1

proceduresCacheSize parameter, 6.2.6.1

processor requirements

PC, 2.1.2.1

UNIX, 2.1.1.1

promptDbUserPassword parameter, 6.2.6.1

Q

queries

disabling parallel processing, 6.2.6.1

disabling parameterization of constants, 6.2.6.1

disabling read-ahead functionality, 6.2.6.1

disabling reuse, 6.2.6.1

disabling saved compilation, 6.2.6.1

enabling retrieval after failure, 6.2.6.1

maximum cached in memory, 6.2.6.1

maximum length of string, 6.2.6.1

maximum size after compilation, 6.2.6.1

query optimization

goal parameter, 6.2.6

query optimizer

logging strategy, 6.2.2

writing plan to file, 6.2.2

query optimizer files

traceDir parameter, 6.2.2

queryProcessor environment parameters, 6.2.6.1

queryProcessor parameters

compileAfterLoad

environment parameters, 6.2.6.1

dsoThreadingBoth, 6.2.6.1

firstTreeExtensions, 6.2.6.1

forceQualifiedNames, 6.2.6.1

ignoreSegmentBindFailure, 6.2.6.1

maxColumnsInParsing, 6.2.6.1

maxSqlCache, 6.2.6.1

noCommandReuse, 6.2.6.1

noCompilationCache, 6.2.6.1

noDSPropertyCache, 6.2.6.1

noInsertParameterization, 6.2.6.1

noMarkRowFailedFetch, 6.2.6.1

noMetadataCaching, 6.2.6.1

noParallelExecution, 6.2.6.1

noQueryParametrization, 6.2.6.1

noQueryReadAhead, 6.2.6.1

noSessionPooling, 6.2.6.1

noSQSCache, 6.2.6.1

noThreadedReadAhead, 6.2.6.1

noThreads, 6.2.6.1

noTreeAutoExtend, 6.2.6.1

optimisticForUpdate, 6.2.6.1

parserDepth, 6.2.6.1

proceduresCacheSize, 6.2.6.1

promptDbUserPassword, 6.2.6.1

tokenSize, 6.2.6.1

useAlternatequalifier, 6.2.6.1

useTableFilterExpressions, 6.2.6.1

queryWarnings parameter, 6.2.2

R

read-ahead functionality

disabling, 6.2.6.1

reading from disk, 6.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, 6.2.6

S

security information

setting automatic prompt for, 6.2.6.1

segmented data sources

response upon failure, 6.2.6.1

server modes

configuring, 6.1.3

servers

reusable, 6.1.3

Reuse limit daemon parameter, D.4.2

ReuseLimit daemon parameter, 6.1.3

sessions

disabling pooling, 6.2.6.1

SMS

system managed storage, 2.2.2

sockets

comMaxSocketSize parameter, 6.2.1

software

Microsoft products, 2.1.2.2

software requirements

Microsoft, 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, 6.2.8

SQL

flattening hierarchical data, C.4.3

stored queries

maximum in cache memory, 6.2.6.1

string functions, C.3

system managed storage

SMS, 2.2.2

T

tempDir parameter, 6.2.3

temporary files

tempDir parameter, 6.2.3

threading model, 6.2.6.1

timeout

client idle, 5.2

tokenSize parameter, 6.2.6.1

trace information

logging, 6.2.2

traceDir parameter, 6.2.2

transactions environment parameters, 6.2.7

tuning environment parameters, 6.2.8

tuning parameters

dsmMaxBufferSize, 6.2.8

dsmMaxSortBufferSize, 6.2.8

dsmMidBufferSize, 6.2.8

hashBufferSize, 6.2.8

hashenableParallelism, 6.2.8

hashMaxDiskSpace, 6.2.8

hashMaxOpenFiles, 6.2.8

U

useAlternatequalifier parameter, 6.2.6.1

useTableFilterExpressions parameter, 6.2.6.1

V

views, 6.2.6.1

setting to compile, 6.2.6.1

VSAM

setting up, 2.5.3.1

W

Windows

installing, 2.4.1

Workspace server mode, D.4.2

X

XML documents, 6.2.1

maximum size, 6.2.1

Y

Y2K

year2000Policy parameter, 6.2.3