DB2 Performance Expert for Multiplatforms V2.2, 2nd Edition

© 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,