© Copyright IBM Corp. 2004. All rights reserved. 495
Index
Symbols
(Application Group) / Application Shared Memory
38
Numerics
64-bit 357
A
active log 210, 213–214
administration notification log 79, 209, 243
Agent / Application Shared Memory
aslheapsz 44
rqrioblk 45
agent pool 27, 233
Agent private memory 40, 104
agent_stack_sz 43
applheapsz 42
java_heap_sz 43
query_heap_sz 42
rqrioblk 43
stat_heap_sz 42
stmtheap 42
Agent/Application Shared Memory 43, 104
Agent/Local Application Shared Memory 31
agent_stack_sz 43, 48
agentpri 59, 298
aio 334
AIX Logical Volume Manager 355
AIX platform 332
DB2 process segment register use 340
DB2 specific recommendations 362
Disk and filesystem considerations 346
Disk subsystem recommendations 358
Disk subsystem review 346
Disk technology fundamentals 348
filemon 366
Filesystem recommendations 359
General file system performance 358
iostat 369
lsps 369
Memory considerations 335
nmon 372
Operating system considerations 332
Paging space 339
ps 373
sar 376
svmon 377
system view of memory 337
virtual memory architecture review 335
vmstat 378
vmtune 379
appgroup_mem_sz 38, 40, 53
appl_ctl_heap_sz 39–40, 53, 342
applheapsz 42, 48, 285
application control block 21
Application design considerations 111
index design 137
Table design 111
Table space design 141
Application global memory 104
application group 19, 22, 48
Application Group Shared Memory 38
appgroup_mem_sz 40
appl_ctl_heap_sz 40
groupheap_ratio 40
Application Shared Memory 38
archive logging 209, 211, 215
aslheapsz 31, 43–44, 59, 184, 288, 291, 342
audit_buf_sz 33, 35, 59
autoconfigure 54, 57
admin_priority 58
bp_resizeable 58
is_populated 58
isolation 58
mem_percent 58
num_local_apps 58
num_remote_apps 58
num_stmts 58
tpm 58
workload_type 58
avg_appls 61
AWE 242, 245, 383
B
backup 35, 304
496 DB2 UDB ESE V8 Performance Guide for High Performance OLTP and BI
best practices guidelines 9
BI 109–110, 114–115, 117–118, 125, 140, 147,
150, 159, 198, 202, 211, 218, 226, 234, 251, 253,
258, 279, 284
characteristics 109
blk_log_dsk_full 209, 221
block index 125
block-based buffer pools 22, 244, 248, 476
block-based I/O 245
blocking cursors 183
BLOCKSIZE 23, 244, 249
BPM 15, 48
BSU 15
buffer pools 22, 35, 74, 145, 238
Block-based buffer pools 244, 248
Buffer pool assignment with multiple buffer pools
248
Buffer pool hit ratios 251
chngpgs_thresh and num_iocleaners consider-
ations 249
Clean pages 240
Dirty pages 239
Dynamic buffer pools 242
flow 238
Hidden buffer pools 243
IBMDEFAULTBP 243
In use pages 239
Main characteristics 242
Memory allocation 242
num_ioservers considerations 250
overhead 246
Single or multiple buffer pools? 247
Size of the buffer pool? 247
C
catalog_cache_sz 53
catalogcache_sz 36–37, 47, 61, 237, 272
cell density 123, 125
cell utilization 125, 128
chngpgs_thresh 48, 53, 61, 241, 249, 253
circular logging 209, 211
CLI/ODBC 185
CLI/ODBC/JDBC trace 67
clustering index 139
commit grouping 219
communication buffer 181–182
compound SQL 184
Atomic 184
Non-atomic 184
COMPRESS SYSTEM DEFAULT 116, 475
concurrency 186
Configuration Advisor 54
connection concentrator 19–20, 45, 49, 233, 477
dispatcher 21
logical agent scheduler 22
Connection considerations 226
container 145
Device containers 145
Directory containers 145
File containers 145
How many containers 147
multiple containers 153
Single or multiple 148
Size of containers 149
striped containers 152
striping 147
coordinator agent 47–48
counter 69
Creating an Event Monitor 75
D
data placement 25
Data SARGable predicates 162
data type conversions 183
data types 115
database configuration parameter
applheapsz 286
aslheapsz 184, 288
avg_appls 61
blk_log_dsk_full 209
catalogcache_sz 61, 273, 284
chngpgs_thresh 61, 241
database_memory 36
dbheap 35, 273, 284
dlchktime 24, 198
estore_seg_sz 36, 343
java_heap_sz 61
locklist 35, 61, 198, 262
logbufsz 35, 61, 210, 284, 321
logfilsz 209
logpath 210
logprimary 209, 213
logretain 208
logsecond 213
maxappls 62, 229, 236, 273
maxfilop 300
Index 497
maxlocks 198, 260
mincommit 24, 210, 221
mirrorlogpath 208
multipage_alloc 141
num_estore_segs 36, 343
num_iocleaners 23, 62, 241
num_ioservers 23, 62
pckcachesz 35, 62, 273, 284
rqrioblk 184
seqdetect 62, 240
sheapthres 60
sheapthres_shr 36, 62, 276
softmax 63, 242
sortheap 62, 275, 313
stmtheap 289
userexit 208
util_heap_sz 35, 273, 313, 321
Database global memory 104
database manager configuration parameter
agentpri 59, 299
aslheapsz 31, 43, 59, 291
audit_buf_sz 33, 59
chngpgs_thresh 249
diaglevel 85
instance_memory 34
intra_parallel 27, 36, 38, 229, 297
java_heap_sz 288
max_connections 18, 20, 38, 227
max_coordagents 18, 20, 38, 231
max_querydegree 298
maxagents 18, 229
maxappls 18
maxcagents 18, 232
maxtotfilop 301
mon_heap_sz 33
num_initagents 19, 236
num_poolagents 18, 60, 233
query_heap_sz 288
rqrioblk 293
sheapthres 275
database manager configuration parameters
max_connections 36
max_coordagents 36
Database manager shared memory 33, 104
audit_buf_sz 35
instance_memory 34
mon_heap_sz 34
Database shared memory 35–36
catalogcache_sz 37
database_memory 37
dbheap 37
estore_seg_sz 38
locklist 38
num_estore_segs 38
pckcachesz 38
sheapthres_shr 38
util_heap_sz 37
Database System Monitor 68, 224
database_memory 36–37
DB2 agents 17–18
coordinator 18
subagents 18
DB2 hypotheses hierarchy 397, 399
DB2 resource constraints 400
Buffer pool constraints 408
Cache size constraints 409
Connection constraints 401
DB2 application design-related 411
Locking constraints 406
Miscellaneous constraints 410
Sorting constraints 404
DB2 system resource constraints 400
DB2 objects 198
placement 201
DB2 objects placement 200
DB2 optimizer 113, 117, 129–130, 161, 181, 475
DB2 PE
Environment structure 92
Main components 90
Performance Expert Agent 91
Server 92
DB2 PE Client 92
DB2 Performance Expert 88
DB2 processes 28
DB2 registry/environment variables 63
DB2_AVOID_PREFETCH 64
DB2_AWE 66
DB2_ENABLE_BUFPD 64
DB2_MMAP_READ 65
DB2_MMAP_WRITE 65
DB2_OVERRIDE_BPF 64
DB2_PARALLEL_IO 65
DB2MAXFSCRSEARCH 64
DB2MEMDISCLAIM 65
DB2MEMMAXFREE 65
DB2NTMEMSIZE 66
DB2NTNOCACHE 66
DB2 stripe 353
Get DB2 UDB ESE V8 non-DPF Performance Guide for High Performance OLTP and BI now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
