© Copyright IBM Corp. 2005, 2006. All rights reserved. 609
Index
Symbols
# 77
$ 55
$$ 55
$$CIM 58
** 55
.db2pev2 16
Numerics
32-bit 400
64-bit 400, 404, 413
A
active application 537
ADDALLDBS 49
ADDDB 49
ADDLOCINST 48
ADDREMINST 48
Administrator 5, 11, 16, 18, 23, 27, 30, 32, 316
Administrator rights 56, 70–71
aged in 542
agent 5, 9, 119, 151, 156, 165, 184–185, 340–341,
344, 347–348, 352–354, 408, 448
AGENT_STACK_SZ 475
AIX 9, 11, 17, 20–23, 36, 70, 94, 123–124, 129,
343, 404, 413, 441
alert 5
alter table 451
analysis tool 472
APP_CTL_HEAP_SZ 475
APPLHEAPSZ 475
application x, 20, 133, 166, 180, 203, 263, 268,
300, 342, 465
Application Details 149, 154, 157, 180, 183, 199,
202, 298, 383, 388, 394, 410–412, 419, 430
Application Handle 149
Application heap 455
Application Status 150
Application Summary 3, 120–121, 142, 147, 149,
152, 154, 157, 160, 194, 224, 238, 246, 265, 268,
298, 382, 394, 410, 415, 429, 433–434, 439
Applications in Lock Conflicts 4, 120, 181, 183
ASC 331, 393, 403
asynchronous 531
attribute 140
audio 472
Auth id 150
Auth level 150
authentication 61
authorizations 61
autorefresh 244
availability 1, 162
AVG_APPLS 362, 475
B
Backup 54, 170, 186
backup
offline 54
BI 5, 525
block queue length 546
Blocking Cursor 161
bottleneck 368
buffer pool ix, 4, 9, 147, 156, 162, 166, 168, 170,
195–196, 200, 203–204, 206, 221, 240, 244, 254,
263, 272–273, 296–301, 307, 309–311, 313–318,
320, 327–328, 331, 335, 338, 340, 368, 385, 404,
441–442, 444–445, 457–458, 460–463, 469, 529
Buffer Pool Analysis 5, 16, 121, 239, 252–253, 263,
292, 298, 302, 304, 306, 308–309, 311–312, 323,
329, 338, 445
Buffer pool trace reports 253
Bufferpools 264, 286
Business Intelligence 525
by percentage 206
C
cache 4, 156, 167, 200, 332, 368, 379, 418–419,
432, 442
catalog 55, 58, 68–69, 75, 94, 97, 102–103,
108–109, 111–112, 141, 167, 286, 398
Catalog cache 170, 264
CATALOGCACHE_SZ 463–464, 482
certified x
CHANGE 49
CIMOM 8, 43, 474
610 DB2 Performance Expert for Multiplatforms V2.2
cimserver 60
circular logging 14
classic design 92
client
Administration Client 18, 423
client/server 141, 184
cluster 272–274, 276, 280, 318–319, 322, 324,
336, 445, 457–458, 463, 466, 469
CM 471–480, 482, 485, 490–502, 504, 506–508,
512, 514–515, 517, 519–520
Collect Report Data 266
Command Line Processor 111
Command Window 53, 301, 423
comment 77
commit 206
common information model 8
compile time 537
components 12, 17, 21, 48, 114, 118–119, 121,
132, 137, 166, 193, 240–241, 248, 252–253, 285,
331, 422, 429, 471–472, 474
configuration 11–13, 19, 21–23, 29, 32–33, 35
Configuration Advisor 440
configuration file 52, 184–185
container 56, 169, 296, 459
configuration 459
Content Management 471–472
Control Center 51, 90–91, 425
Coordinator pid/ 150
counter 146, 245
CPU usage 4
CPU-bound 546
CRD 266
CREATE INDEX 393, 403
create table 332, 372
cursor 161
cursor stability 451
D
data partitioning 6
data skew 549
data view 544
Data Views 116, 172–173, 300, 375
database 35, 59, 63, 119, 405, 407
Database activity trace report 254
Database Alias 182
database cluster 272, 463
Database configuration 180, 185–186, 246, 296,
344–345, 349, 351, 366–367, 384, 400, 422, 425,
440–441, 447–448, 450, 454, 464
database configuration parameter
MINCOMMIT 447
database design x, 366–367, 369, 454
Database manager 51–52, 56, 94, 131, 141, 149,
151, 165, 180, 184–185, 246, 298, 344, 346–348,
351, 400, 422, 442, 448, 451, 461–463
database manager configuration parameters
184–185, 344
Database parameters 349, 368, 402, 448
database partition 69, 75, 102–103
Database shared memory 184–185, 301, 448
database size 366
Database, LOCKLIST 450
DATE() 284
DB Path 150
db_name 285
DB2 Administration Server 186
DB2 configuration 113, 297, 440
DB2 PE 20, 274, 346, 356, 388, 440
DB2 performance information 4
DB2 registry 52
DB2 UDB configuration 441
DB2_PARALLEL_IO 459
DB2_SKIPINSERTED 592
db2advis 393
db2agent 341
db2agntp 341
DB2COMM 52
DB2DETAILDEADLOCK 238
db2diag.log 421, 424, 426, 429, 431, 433
db2pe.prop 140
db2pesrv.log 30, 123
db2pesrv.prop 124, 134
db2pesrv.trc 123–124
DB2PM 13
DB2PM database 7, 15, 307
db2set 52, 373
db2start 373, 403
db2stop 133, 373, 403
db2syscs.exe 424
DBHEAP 447–448, 475
DCS 9
deadlock 5, 180
Deadlock event exception 193
Delta processing 163
deployment 441, 455
describe table 425
design x, 5, 92, 148, 355, 366–367, 369, 391, 393,

Get DB2 Performance Expert for Multiplatforms V2.2, 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.