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
adapter inbound configuration, 3.1
add timestamp to traced events parameter, 7.2.1
Artithmetic fixed precision parameter, 7.2.9

B

binary XML log level parameter, 7.2.1
binding file
configuration, 3.2.2

C

cache
maximum queries, 7.2.9
cache buffer size parameter, 7.2.2
CDC
stream positions table, 3.1.1
CDC adapter
connection factory, 3.1.2
CDC stream positions table, 3.1.1
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
configuring the binding file, 3.2.2
connection factory, 3.1.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
creating JCA configuration files
JCA configuration files
creating, 3.2.1

D

daemon
logging, B.2
security, B.3
server modes, 7.1.3
shutting down, 6.5.2
starting, 6.5.1
timeout, 6.6
data sources, disabling caching, 7.2.9
data types
atomic metadata, D.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
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, 7.2.2
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, 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
modeling, 7.2.4
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
parallel processing, 7.2.8
parser depth, 7.2.9
procedures cache size, 7.2.9
prompt database user pasword, 7.2.9
query processor, 7.2.9
query processor trace, 7.2.1
query warnings, 7.2.1
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

G

GDB trace parameter, 7.2.1
general parameters
cache buffer size, 7.2.2
environment, 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

H

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

I

ignore segment bind failure parameter, 7.2.9
index cache
dsm middle buffer size parameter, 7.2.11
insert from select commit rate parameter, 7.2.9

J

JCA configuration files, 3.2
configuration, 3.2
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, 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, B.2
log file parameter, 7.2.1
logging
daemon configurations, B.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
metadata
atomic data types, D.1
disabling retrieval from cache, 7.2.9
minimum number of parameters allocated parameter, 7.2.9
modeling environment parameters, 7.2.4

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
optimistic for updates parameter, 7.2.9
optimizer
optimizer goal parameter, 7.2.7
trace directory parameter, 7.2.1
optimizer environment parameters, 7.2.7
optimizer goal parameter, 7.2.7
optimizer trace parameter, 7.2.1

P

parallel processing environment parameters, 7.2.8
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
procedures cache size parameter, 7.2.9
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
environment parameters, 7.2.9
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

R

recovery delay, 7.2.10
Replace invalid XML characters parameter, 7.2.12
rollback loops
troubleshooting, 3.4
row optimization, optimizer goal parameter, 7.2.7

S

security
daemon configurations, B.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, B.4.2
setting up VSAM, 2.3.1
sort buffer, dsm maximum sort buffer size parameter, 7.2.11
staging area, 1.2.1
stored queries, maximum in cache memory, 7.2.9
stream positions table, 3.1.1

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.6
daemon, 6.6
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 parameters
dsm maximum buffer size, 7.2.11
dsm maximum sort buffer Size, 7.2.11
dsm middle buffer size, 7.2.11
environment, 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.3.1

W

Weblogic
deployment, 3
WebLogic deployment, 3
Workspace server mode, B.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