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

ACX trace parameter, 7.2.1

add timestamp to traced events parameter, 7.2.1

arithmetic operators, D.2

arrays, flattening hierarchical data, D.4.3

Artithmetic fixed precision parameter, 7.2.9

B

binary XML log level parameter, 7.2.1

C

cache

maximum queries, 7.2.9

cache buffer size parameter, 7.2.2

code page parameter, 7.2.3

COM maximum XML size in memory parameter, 7.2.12

COM maximum XML size parameter, 7.2.12

COM XML transport buffer parameter, 7.2.12

commit on destroy, 7.2.10

comparison operators, D.2

continuous query

prefix, 7.2.9

retry interval, 7.2.9

timeout, 7.2.9

continuous query prefix parameter, 7.2.9

continuous query retry interval parameter, 7.2.9

continuous query timeout parameter, 7.2.9

D

daemon

logging, C.2

security, C.3

server modes, 7.1.3

shutting down, 6.1.2

starting, 6.1.1

timeout, 6.2

data sources, disabling caching, 7.2.9

data types

atomic metadata, B.1

NLS string parameter, 7.2.3

debug parameters

ACX trace, 7.2.1

add timestamp to traced events, 7.2.1

environment, 7.2.1

GDB trace, 7.2.1

general trace, 7.2.1

lbinary XML log level, 7.2.1

log file, 7.2.1

optimizer trace, 7.2.1

query processor trace, 7.2.1

query warnings, 7.2.1

trace directory, 7.2.1

Transaction extended logging, 7.2.1

disable 2PC, 7.2.10

disable command reuse parameter, 7.2.9

disable compilation cache parameter, 7.2.9

disable DS property cache parameter, 7.2.9

disable insert parameterization parameter, 7.2.9

disable metadata caching parameter, 7.2.9

disable query parameterization parameter, 7.2.9

disable row mark fail fetch parameter, 7.2.9

disable SQS cache parameter, 7.2.9

disable threads parameter, 7.2.8

disabling

parameterization of constants, 7.2.9

parameterization of queries, 7.2.9

disk space requirements

IBMmainframe, 2.1.1.1

dsm maximum buffer size parameter, 7.2.11, 7.2.11

dsm middle buffer size parameter, 7.2.11

dsmMaxSortBufferSize parameter, 7.2.11

E

environment parameters

ACX trace, 7.2.1

add timestamp to traced events, 7.2.1

Artithmetic fixed precision, 7.2.9

cache buffer size, 7.2.2

code page, 7.2.3

COM maximum XML size, 7.2.12

COM maximum XML size in memory, 7.2.12

COM XML transport buffer, 7.2.12

commit on destroy, 7.2.10

continuous query prefix, 7.2.9

continuous query retry interval, 7.2.9

continuous query timeout, 7.2.9

debug, 7.2.1

disable 2PC, 7.2.10

disable command reuse, 7.2.9

disable compilation cache, 7.2.9

disable DS property cache, 7.2.9

disable insert parameterization, 7.2.9

disable metadata caching, 7.2.9

disable query parameterization, 7.2.9

disable row mark fail fetch, 7.2.9

disable SQS cache, 7.2.9

disable threads, 7.2.8

dsm maximum buffer size, 7.2.11

dsm maximum sort buffer Size, 7.2.11

dsm middle buffer size, 7.2.11

expose XML fields, 7.2.9

file close on transaction, 7.2.11

file pool size, 7.2.11

file pool size per file, 7.2.11

first tree extensions, 7.2.9

GDB trace, 7.2.1

general trace, 7.2.1

hash buffer size, 7.2.11, 7.2.11

hash enable RO, 7.2.11

hash max open files, 7.2.11

hash primary event size, 7.2.11

hash secondary event size, 7.2.11

ignore segment bind failure, 7.2.9

insert from select commit rate, 7.2.9

language, 7.2.3

log file, 7.2.1

maximum columns in parsing, 7.2.9

Maximum segmented database thread, 7.2.9

maximum SQL cache, 7.2.9

minimum number of parameters allocated, 7.2.9

miscellaneous, 7.2.2

nav utility editor, 7.2.2

NLS string, 7.2.3

odbc, 7.2.5

oledb, 7.2.6

optimistic for updates, 7.2.9

optimizer, 7.2.7

optimizer goal, 7.2.7

optimizer trace, 7.2.1

parser depth, 7.2.9

procedures cache size, 7.2.9

prompt database user pasword, 7.2.9

query processor trace, 7.2.1

query warnings, 7.2.1

queryProcessor, 7.2.9

recovery delay, 7.2.10

Replace invalid XML characters, 7.2.12

time limit, 7.2.10

token size, 7.2.9

trace directory, 7.2.1

transaction conversions parameters, 7.2.10

Transaction extended logging, 7.2.1

transaction extended logging, 7.2.10

transaction log file, 7.2.10

transactions, 7.2.10

ttemporary directory, 7.2.2

tuning, 7.2.11

use alternate qualifier, 7.2.9

use global file pool, 7.2.11

use table filter expression, 7.2.9

user commit confirm table, 7.2.10

write empty string as null, 7.2.9

XML, 7.2.12

XML date format parameter, 7.2.12

XML trim char column, 7.2.12

year 2000 policy, 7.2.2

error log, binary XML log level parameter, 7.2.1

error log, log file parameter, 7.2.1

exact arithmetic, 7.2.9

expose XML fields parameter, 7.2.9

F

file close on transaction, 7.2.11

file pool size, 7.2.11

file pool size per file, 7.2.11

first row optimization, optimizer goal parameter, 7.2.7

first tree extensions parameter, 7.2.9

floating point precision, 7.2.9

functions

group, D.3

string, D.3

G

GDB trace parameter, 7.2.1

general parameters

cache buffer size, 7.2.2

nav utility editor, 7.2.2

temporary directory, 7.2.2

year 2000 policy, 7.2.2

general trace parameter, 7.2.1, 7.2.1

group functions, D.3

H

hardware requirements

IBM mainframe disk space, 2.1.1.1

IBM mainframe memory, 2.1.1.1

UNIX, 2.1.1.1

hash buffer size, 7.2.11, 7.2.11

hash buffer size parameter, 7.2.11

hash enable RO parameter, 7.2.11

hash joins, 7.2.11

hash max open files parameter, 7.2.11

hash primary event size parameter, 7.2.11

hash secondary event size parameter, 7.2.11

hierarchical queries, D.4.3

I

IBM mainframe

installing, 2.2.4

post-installation, 2.2.5

preinstallation, 2.2.2

ignore segment bind failure parameter, 7.2.9

importing installation kit, 2.2.3

index cache

dsm middle buffer size parameter, 7.2.11

insert from select commit rate parameter, 7.2.9

installation kit, importing, 2.2.3

installing

IBM mainframe, 2.2.4

integration flow, Oracle Application Server to legacy application, 1.2.1

J

joins

hash buffer size parameter, 7.2.11

hash max open files parameter, 7.2.11

L

language parameter, 7.2.3

language parameters

code page, 7.2.3

environment, 7.2.3

language, 7.2.3

NLS string, 7.2.3

locking, optimistic, 7.2.9

log file parameter, 7.2.1

log files

binary XML log level parameter, 7.2.1

daemon options, C.2

log file parameter, 7.2.1

logging

daemon configurations, C.2

optimizer strategy, 7.2.1, 7.2.1

M

maximum columns in parsing parameter, 7.2.9

Maximum segmented database thread, 7.2.9

maximum SQL cache parameter, 7.2.9

memory

dsm maximum buffer size parameter, 7.2.11

dsm maximum sort buffer Size parameter, 7.2.11

dsm middle buffer size parameter, 7.2.11

memory requirements

mainframe requirements, 2.1.1.1

metadata

atomic data types, B.1

disabling retrieval from cache, 7.2.9

minimum number of parameters allocated parameter, 7.2.9

miscellaneous parameters

environment, 7.2.2

N

nav utility editor parameter, 7.2.2

nav utility editor, text editor, 7.2.2

NLS string parameter, 7.2.3

O

odbc environment parameters, 7.2.5

oledb environment parameters, 7.2.6

operating system requirements

UNIX, 2.1.1.2

optimistic for updates parameter, 7.2.9

optimizer

environment parameters, 7.2.7

optimizer goal parameter, 7.2.7

trace directory parameter, 7.2.1

optimizer goal parameter, 7.2.7

optimizer trace parameter, 7.2.1

Oracle Application Server requirements, 2.1.1.2

P

parallel processing parameters

disable threads, 7.2.8

parameterization of constants, disabling, 7.2.9

parameterization of queries, disabling, 7.2.9

parser depth parameter, 7.2.9

password, setting automatic prompt, 7.2.9

post-installation, IBM mainframe, 2.2.5

preinstallation, IBM mainframe, 2.2.2

procedures cache size parameter, 7.2.9

processor requirements

UNIX, 2.1.1.1

prompt database user pasword parameter, 7.2.9

Q

queries

disabling reuse, 7.2.9

disabling saved compilation, 7.2.9

enabling retrieval after failure, 7.2.9

maximum cached in memory, 7.2.9

maximum length of string, 7.2.9, 7.2.9

maximum size after compilation, 7.2.9

query optimizer

logging strategy, 7.2.1, 7.2.1

optimizer goal parameter, 7.2.7

trace directory parameter, 7.2.1

query processor parameters

Artithmetic fixed precision, 7.2.9

continuous query prefix, 7.2.9

continuous query retry interval, 7.2.9

continuous query timeout, 7.2.9

disable command reuse, 7.2.9

disable compilation cache, 7.2.9

disable DS property cache, 7.2.9

disable insert parameterization, 7.2.9

disable metadata caching, 7.2.9

disable query parameterization, 7.2.9

disable row mark fail fetch, 7.2.9

disable SQS cache, 7.2.9

emptyStringISNull parameter, 7.2.9

expose XML fields, 7.2.9

first tree extensions, 7.2.9

ignore segment bind failure, 7.2.9

insert from select commit rate, 7.2.9

maximum columns in parsing, 7.2.9

Maximum segmented database thread parameter, 7.2.9

maximum SQL cache, 7.2.9

minimum number of parameters allocated, 7.2.9

optimistic for updates, 7.2.9

parser depth, 7.2.9

procedures cache size, 7.2.9

prompt database user pasword, 7.2.9

token size, 7.2.9

use alternate qualifier, 7.2.9

use table filter expression, 7.2.9

query processor trace parameter, 7.2.1

query warnings parameter, 7.2.1

queryProcessor environment parameters, 7.2.9

R

recovery delay, 7.2.10

Replace invalid XML characters parameter, 7.2.12

requirements

UNIX hardware requirements, 2.1.1.1

UNIX software requirements, 2.1.1.2

row optimization, optimizer goal parameter, 7.2.7

S

security

daemon configurations, C.3

setting automatic prompt, 7.2.9

segmented data sources, response upon failure, 7.2.9

servers

configuring modes, 7.1.3

reusable, 7.1.3

Reuse limit daemon parameter, 7.1.3, C.4.2

setting up VSAM, 2.5.3.1

SMS

See system managed storage

software requirements

Oracle Application Server, 2.1.1.2

UNIX operating system, 2.1.1.2

sort buffer, dsm maximum sort buffer size parameter, 7.2.11

SQL, flattening hierarchical data, D.4.3

stored queries, maximum in cache memory, 7.2.9

string functions, D.3

system managed storage, 2.2.2

T

temporary directory parameter, 7.2.2

temporary files, 7.2.2

threading model, 7.2.9

time limit parameter, 7.2.10

timeout

client idle, 6.2

daemon, 6.2

token size parameter, 7.2.9

trace directory parameter, 7.2.1

trace information, logging, 7.2.1

transaction conversions parameters, 7.2.10

transaction extended logging, 7.2.10

Transaction extended logging parameter, 7.2.1

transaction log file, 7.2.10

transactions environment parameters, 7.2.10

transactions parameters

commit on destroy, 7.2.10

disable 2PC, 7.2.10

recovery delay, 7.2.10

time limit, 7.2.10

transaction conversions parameters, 7.2.10

transaction extended logging, 7.2.10

transaction log file, 7.2.10

user commit confirm table, 7.2.10

tuning environment parameters, 7.2.11

tuning parameters

dsm maximum buffer size, 7.2.11

dsm maximum sort buffer Size, 7.2.11

dsm middle buffer size, 7.2.11

file close on transaction, 7.2.11

file pool size, 7.2.11

file pool size per file, 7.2.11

hash buffer size, 7.2.11, 7.2.11

hash enable RO, 7.2.11

hash max open files, 7.2.11

hash primary event size, 7.2.11

hash secondary event size, 7.2.11

use global file pool, 7.2.11

U

use alternate qualifier parameter, 7.2.9

use global file pool, 7.2.11

use table filter expression parameter, 7.2.9

user commit confirm table, 7.2.10

V

VSAM, setting up, 2.5.3.1

W

Workspace server mode, C.4.2

write empty string as null parameter, 7.2.9

X

XML

environment parameters, 7.2.12

XML date format parameter, 7.2.12

XML parameters

COM maximum XML size, 7.2.12

COM maximum XML size in memory, 7.2.12

COM XML transport buffer, 7.2.12

Replace invalid XML characters, 7.2.12

XML date format parameter, 7.2.12

XML trim char column, 7.2.12

XML trim char column parameter, 7.2.12

Y

Y2K

See year 2000 policy parameter

year 2000 policy parameter, 7.2.2