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