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

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

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

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

database requirements

IMS/DB, 2-3

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

distributed transactions

IMS/DB, 5-16

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

PC disk space, 2-4

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

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

IMS/DB

requirements, 2-3

setting up, 3-2

IMS/DB driver, 5-16

distributed transactions, 5-16

IMS/TM

requirements, 2-3

index cache

dsmMidBufferSize parameter, 7-11

INSERT statement

disabling parameterization of constants, 7-10

installation

IBM S/390, 2-7

installing

Windows, 2-21

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

L

language parameter, 7-8

locking

optimistic as default, 7-11

log files

daemon options, D-4

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

IMS/DB, 2-3

IMS/TM, 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-14

tokenSize parameter, 7-11

TP Monitor requirements

CICS, 2-3

IMS/TM, 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

W

Windows

installing, 2-21

X

XML documents, 7-7

maximum size, 7-7

Y

Y2K

year2000Policy parameter, 7-8