Index
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
A
- acxTrace parameter, 7-7
- analyzerQueryPlan parameter, 7-7
- application language
- parameter, 7-8
- arithmetic operators, C-2
- array updates, 5-12
- arrays
- flattening hierarchical data, 5-3, C-5
- autocommit
- setting using setAutoCommit verb, E-5
B
- buffer size
- comCacheBufferSize parameter, 7-7
- Business Objects
- qualifying catalog and tables names, 7-10
C
- cache
- max queries in, 7-10
- cache memory
- dsmMaxBufferSize parameter, 7-11
- CD-ROM drive requirements
- IBM S/390, 2-2
- PC, 2-3
- CICS
- requirements, 2-3
- COBOL, E-6
- execute function, E-6
- COBOL API
- connect verb, E-2
- disconnect verb, E-4
- setAutoCommit verb, E-5
- transaction verbs, E-4
- transactionCommit verb, E-5
- transactionRollback, E-6
- codepage parameter, 7-8
- comCacheBufferSize parameter, 7-7
- comm parameters
- comCacheBufferSize, 7-7
- comMaxSocketSize, 7-7
- comMaxXmlSize, 7-7
- comMaxSocketSize parameter, 7-7
- comMaxXmlSize parameter, 7-7
- committing a transaction, E-5
- comparison operators, C-2
- compileAfterLoad parameter, 7-10
- compiling procedures and views, 7-10
- connect verb, E-2
- connecting
- connect verb, E-2
- using COBOL, E-2
- connection
- destroying with disconnect, E-4
- CREATE PROCEDURE statement
- maximum procedures in cache memory, 7-11
- cvtSeverityLevel parameter, 7-8
D
- daemon
- logging, D-4
- security, D-7
- server modes, 7-3
- shutting down, 6-6
- starting, 6-5
- timeout, 6-13
- workspaces, 6-5
- daemon configuration
- logging section, D-4
- security section, D-7
- data source properties
- disabling caching, 7-10
- data type conversions
- cvtSeverityLevel parameter, 7-8
- data types
- cvtSeverityLevel, 7-8
- nlsString, 7-8
- datatypes
- metadata atomic datatypes, B-2, B-11
- debug environment parameters, 7-7
- debug parameters
- acxTrace, 7-7
- analyzerqueryPlan, 7-7
- generalTrace, 7-7
- logFile, 7-7
- oledbTrace, 7-7
- optimizerTrace, 7-7
- queryWarnings, 7-7
- traceDir, 7-7
- disconnect verb, E-4
- disk space requirements
- IBM S/390, 2-2
- PC, 2-3
- distributed transactions
- VSAM, 5-11
- dsmMaxBufferSize parameter, 7-11
- dsmMaxSortBufferSize parameter, 7-11
- dsmMidBufferSize parameter, 7-11
- dsoThreadingBoth parameter, 7-10
E
- edit parameter, 7-8
- emptyStringIsNull parameter
- queryProcessor parameters
- emptyStringIsNull, 7-10
- environment parameters
- acxTrace, 7-7
- analyzerQueryPlan, 7-7
- codepage, 7-8
- comCacheBufferSize parameter, 7-7
- comMaxSocketSize, 7-7
- comMaxXmlSize, 7-7
- cvtSeverityLevel, 7-8
- debug, 7-7
- dsmMaxBufferSize, 7-11
- dsmMaxSortBufferSize, 7-11
- dsmMidBufferSize, 7-11
- dsoThreadingBoth, 7-10
- edit, 7-8
- emptyStringIsNull, 7-10
- firstTreeExtensions, 7-10
- forceQualifiedNames, 7-10
- generalTrace, 7-7
- goal, 7-9
- hashBufferSize, 7-11
- hashEnableParallelism, 7-11
- hashMaxDiskSpace, 7-11
- hashMaxOpenFiles, 7-12
- ignoreSegmentBindFailure, 7-10
- language, 7-8
- logFile, 7-7
- maxColumnsInParsing, 7-10
- maxSqlCache, 7-10
- miscellaneous, 7-7
- nlsString, 7-8
- noCommandReuse, 7-10
- noCompilationCache, 7-10
- noDSPropertyCache, 7-10
- noHashJoin, 7-9
- noInsertParameterization, 7-10
- noMarkRowFailedFetch, 7-10
- noMetadataCaching, 7-10
- noParallelExecution, 7-10
- noQueryParametrization, 7-10
- noQueryReadAhead, 7-10
- noSemiJoin, 7-9
- noSessionPooling, 7-10
- noSQSCache, 7-10
- noThreadedReadAhead, 7-10
- noThreads, 7-11
- noTreeAutoExtend, 7-11
- odbc, 7-9
- oledb, 7-9
- oledbTrace, 7-7
- optimisticForUpdate, 7-11
- optimizer, 7-9
- optimizerTrace, 7-7
- parserDepth, 7-11
- preferredSite, 7-9
- proceduresCacheSize, 7-11
- promptDbUserPassword, 7-11
- queryProcessor, 7-10
- queryWarnings, 7-7
- semiJoinInValuesFactor, 7-9
- tempDir, 7-8
- tokenSize, 7-11
- traceDir, 7-7
- transactions, 7-11
- tuning, 7-11
- useAlternatequalifier, 7-11
- useTableFilterExpressions, 7-11
- year2000Policy, 7-8
- error log
- logFile parameter, 7-7
- execute function, E-6
F
- first row optimization
- goal parameter, 7-9
- firstTreeExtensions parameter, 7-10
- forceQualifiedNames parameter, 7-10
G
- generalTrace parameter, 7-7
- goal parameter, 7-9
- Group functions, C-3
H
- hardware requirements
- IBM S/390 CD-ROM drive, 2-2
- IBM S/390 disk space, 2-2
- IBM S/390 memory, 2-2
- IBM S/390 processor, 2-2
- PC CD-ROM drive, 2-3
- PC disk space, 2-3
- PC memory, 2-3
- PC processor, 2-3
- hash disk space
- hashMaxDiskSpace parameter, 7-11
- hash joins
- disabling, 7-9
- hashMaxOpenFiles parameter, 7-12
- hash memory
- hashBufferSize parameter, 7-11
- hashBufferSize parameter, 7-11
- hashEnableParallelism parameter, 7-11
- hashing
- hashEnableParallelism parameter, 7-11
- hashMaxDiskSpace parameter, 7-11
- hashMaxOpenFiles parameter, 7-12
- hierarchical queries
- flattening hierarchical data, 5-3, C-5
I
- IBM S/390
- installation, 2-7
- postinstallation, 2-12
- preinstallation, 2-6
- ignoreSegmentBindFailure parameter, 7-10
- index cache
- dsmMidBufferSize parameter, 7-11
- INSERT statement
- disabling parameterization of constants, 7-10
- installation
- IBM S/390, 2-7
- installing
- Windows, 2-19
J
- joins
- disabling hash joins, 7-9
- hashBufferSize parameter, 7-11
- hashEnableParallelism parameter, 7-11
- hashMaxDiskSpace parameter, 7-11
- hashMaxOpenFiles parameter, 7-12
K
- known restrictions, 5-11
L
- language parameter, 7-8
- locking
- optimistic as default, 7-11
- log files
- daemon options, D-4
- logFile parameter, 7-7
- logFile parameter, 7-7
- logging
- optimizer strategy, 7-7
- trace information, 7-7
M
- maxColumnsInParsing parameter, 7-10
- maximum size, 7-7
- maxSqlCache parameter, 7-10
- memory
- dsmMaxBufferSize parameter, 7-11
- dsmMaxSortBufferSize parameter, 7-11
- memory for index cache
- dsmMidBufferSize parameter, 7-11
- memory requirements
- IBM S/390, 2-2
- PC, 2-3
- metadata
- atomic datatypes, B-2, B-11
- disabling retrieval from cache, 7-10
- Microsoft software requirements, 2-4
- miscellaneous environment parameters, 7-7
- miscellaneous parameters
- codepage, 7-8
- cvtSeverityLevel, 7-8
- edit, 7-8
- language, 7-8
- nlsString, 7-8
- tempDir, 7-8
- year2000Policy, 7-8
- multithreading
- disabling, 7-11
N
- NAV_UTIL
- text editor, 7-8
- nlsString parameter, 7-8
- noCommandReuse parameter, 7-10
- noCompilationCache parameter, 7-10
- noDSPropertyCache parameter, 7-10
- noHashJoin parameter, 7-9
- noInsertParameterization parameter, 7-10
- noMarkRowFailedFetch parameter, 7-10
- noMetadataCaching parameter, 7-10
- noParallelExecution parameter, 7-10
- noQueryParametrization parameter, 7-10
- noQueryReadAhead parameter, 7-10
- noSemiJoin parameter, 7-9
- noSessionPooling parameter, 7-10
- noSQSCache parameter, 7-10
- noThreadedReadAhead parameter, 7-10
- noThreads parameter, 7-11
- noTreeAutoExtend parameter, 7-11
O
- odbc environment parameters, 7-9
- oledb environment parameters, 7-9
- oledbTrace parameter, 7-7
- operating system requirements
- IBM S/390, 2-3
- PC, 2-4
- optimisticForUpdate parameter, 7-11
- optimizer environment parameters, 7-9
- optimizer files
- traceDir parameter, 7-7
- optimizer parameters
- goal, 7-9
- noHashJoin, 7-9
- noSemiJoin, 7-9
- preferredSite, 7-9
- semiJoinInValuesFactor, 7-9
- optimizer plan
- writing to file, 7-7
- optimizerTrace parameter, 7-7
- Oracle Application Server ProcessConnect requirements, 2-3
P
- parallel processing
- disabling, 7-10
- parserDepth parameter, 7-11
- password
- setting automatic prompt for, 7-11
- pooling
- disabling, 7-10
- postinstallation
- IBM S/390, 2-12
- preferredSite parameter, 7-9
- preinstallation
- IBM S/390, 2-6
- procedures
- columns
- maximum referenced in query, 7-10
- maximum in cache memory, 7-11
- reading from disk, 7-10
- setting to compile, 7-10
- proceduresCacheSize parameter, 7-11
- processor requirements
- IBM S/390, 2-2
- PC, 2-3
- promptDbUserPassword parameter, 7-11
Q
- queries
- disabling parallel processing, 7-10
- disabling parameterization of constants, 7-10
- disabling read-ahead functionality, 7-10
- disabling reuse, 7-10
- disabling saved compilation, 7-10
- enabling retrieval after failure, 7-10
- maximum cached in memory, 7-10
- maximum length of string, 7-11
- maximum size after compilation, 7-10
- query optimization
- goal parameter, 7-9
- query optimizer
- logging strategy, 7-7
- writing plan to file, 7-7
- query optimizer files
- traceDir parameter, 7-7
- queryProcessor environment parameters, 7-10
- queryProcessor parameters
- compileAfterLoad
- environment parameters
compileAfterLoad
, 7-10
- dsoThreadingBoth, 7-10
- firstTreeExtensions, 7-10
- forceQualifiedNames, 7-10
- ignoreSegmentBindFailure, 7-10
- maxColumnsInParsing, 7-10
- maxSqlCache, 7-10
- noCommandReuse, 7-10
- noCompilationCache, 7-10
- noDSPropertyCache, 7-10
- noInsertParameterization, 7-10
- noMarkRowFailedFetch, 7-10
- noMetadataCaching, 7-10
- noParallelExecution, 7-10
- noQueryParametrization, 7-10
- noQueryReadAhead, 7-10
- noSessionPooling, 7-10
- noSQSCache, 7-10
- noThreadedReadAhead, 7-10
- noThreads, 7-11
- noTreeAutoExtend, 7-11
- optimisticForUpdate, 7-11
- parserDepth, 7-11
- proceduresCacheSize, 7-11
- promptDbUserPassword, 7-11
- tokenSize, 7-11
- useAlternatequalifier, 7-11
- useTableFilterExpressions, 7-11
- queryWarnings parameter, 7-7
R
- read-ahead functionality
- disabling, 7-10
- reading from disk, 7-10
- requirements
- IBM S/390 hardware requirements, 2-2
- IBM S/390 software requirements, 2-2
- PC hardware requirements, 2-3
- PC software requirements, 2-4
- rolling back transactions, E-6
- row optimization
- goal parameter, 7-9
S
- security information
- setting automatic prompt for, 7-11
- segmented data sources
- response upon failure, 7-10
- semiJoinInValuesFactor parameter, 7-9
- server modes
- configuring, 7-3
- servers
- reusable, 7-4
- Reuse limit daemon parameter, D-14
- ReuseLimit daemon parameter, 7-4
- sessions
- disabling pooling, 7-10
- setAutoCommit verb, E-5
- SMS
- system managed storage, 2-6
- sockets
- comMaxSocketSize parameter, 7-7
- software
- Microsoft products, 2-4
- software requirements
- CICS, 2-3
- IBM S/390 operating system, 2-3
- Microsoft, 2-4
- Oracle Application Server ProcessConnect, 2-3
- PC operating system, 2-4
- sort buffer
- dsmMaxSortBufferSize parameter, 7-11
- SQL
- flattening hierarchical data, 5-3, C-5
- stored queries
- maximum in cache memory, 7-11
- string functions, C-3
- system managed storage
- SMS, 2-6
T
- tempDir parameter, 7-8
- temporary files
- tempDir parameter, 7-8
- threading model, 7-10
- timeout
- client idle, 6-13
- tokenSize parameter, 7-11
- TP Monitor requirements
- CICS, 2-3
- trace information
- logging, 7-7
- traceDir parameter, 7-7
- transaction verbs, E-4
- transactionCommit verb, E-5
- transactionRollback verb, E-6
- transactions
- committing with transactionCommit, E-5
- rolling back with transactionRollback, E-6
- transactions environment parameters, 7-11
- tuning
- preferredSite parameter, 7-9
- tuning environment parameters, 7-11
- tuning parameters
- dsmMaxBufferSize, 7-11
- dsmMaxSortBufferSize, 7-11
- dsmMidBufferSize, 7-11
- hashBufferSize, 7-11
- hashenableParallelism, 7-11
- hashMaxDiskSpace, 7-11
- hashMaxOpenFiles, 7-12
U
- useAlternatequalifier parameter, 7-11
- useTableFilterExpressions parameter, 7-11
V
- verbs
- connection, E-2
- views, 7-10
- setting to compile, 7-10
- VSAM
- setting up, 3-2
- VSAM driver, 5-11
- distributed transactions, 5-11
W
- Windows
- installing, 2-19
X
- XML documents, 7-7
- maximum size, 7-7
Y
- Y2K
- year2000Policy parameter, 7-8