DB2 Server for VSE & VM: Performance Tuning Handbook

Index

Special Characters
Numerics
A B C D E F G H I J K L M N O P Q R S T U V W X

Special Characters

*IDENT (3942)

Numerics

16MB line

storage above (4100)

storage queue (4084)

virtual addressability extension (4486)

31 bit addressing

advantages (4101)

storage queue (4085)

virtual addressability extension (4485)

31-bit addressing (3934)

5697F42 MEMO (5209)

loading (5210)

absolute share (4454)

access path

choosing (5062)

dbspace scan (5001)

disadvantages of indexes (5022)

index-only access (5011)

index scan (5005)

influencing (4996)

locking (4736)

types (4998), (5010)

unique index with key matching predicate (5017)

with unclustered index (5006)

ACCESSLIST directory statement (5232)

accounting

measurement tool (3737)

ACQUIRE DBSPACE

allocating dbspace storage (4312)

minimum lock level (4721)

ADD (4129)

address space

size (4087)

virtual addressability extension (4479)

virtual disk (4118), (4168)

addressability extension

virtual (4477)

addressing (4054)

ADDRSPACE directory statement (5233)

adhoc query

isolation level (4941)

temporary table (4950)

view (4954)

agent

checkpoint (4590)

deprived (4679)

dispatching (4670)

operator (4591)

pseudo (4643)

real (4593)

structure

virtual addressability extension (4480)

user (4592)

allocating users to agents (4600)

ALTER DBSPACE

free space in a data page (4258)

lock escalation (4772)

AMXT/MXT

CICS (4494)

analyzing

SQL statements (5087)

application program

adhoc query (4931)

DBS utility considerations (4958)

deadlock (4798)

distributed database (4524)

ISQL considerations (4930)

response time (3626)

application requester

configuring (4537)

DRDA (4518)

PROTOCOL parameter (4878)

application server

configuring (4536)

DRDA (4517)

PROTOCOL parameter (4877)

response time (3622)

archive (5241)

checkpoint (4832)

database (4127), (4164), (4177), (4189)

log (4853), (4855)

selective (4851)

archiving

as overhead (3761)

ARCHPCT

tuning parameter (4865)

ARIS41DB (3856)

ARISDBMA EXEC (5246)

ARISQLDS (3855)

arithmetic operator

in syntax diagrams (3561)

asynchronous

communication (4924)

page fault processing (5305)

writes (5317)

auditing

fair share (4676)

AUTO PROTOCOL option (4890)

AUTOCOMMIT

command (4940)

ISQL (4935)

automatic statistics collection (4963)

suppressing (4969)

auxiliary storage

CICS temporary (4507)

expanded storage (4059)

system paging DASD (4058)

availability (3577), (3632)

average row length (3975)

AVGROWLEN (3973)

back-up

file (4139)

virtual disk (4157)

VSAM (4415)

balancing

DASD (4406)

batch user, VSE (4606)

BEGINLUW counter (3873)

BLOCK

initialization parameter (4900)

blocking (5295), (5312)

disadvantages (4918)

DRDA protocol (4901)

fetch and insert (4895)

ISQL (4919)

maximum row length (4909)

single user mode (SUM) (4914)

suppressed (4912)

bootstrap module, contents (5260)

bootstrap package

contents (5259), (5261)

copied to A-disk (5262)

creating (5258)

buffer pool (5298)

checkpoint (4839)

data page (4544)

NCUSERS (4570), (4617)

size (4567)

build the database manager (5247)

caching

minidisk (4435)

package (4575)

NCUSERS (4621)

CANCEL

ISQL (4938)

synchronous communication (4926)

catalog

procedure

virtual disk (4149)

table (3966)

catalog table

automatic statistics collection (4967)

column information (3990)

dbspace information (4005)

description (3722)

index information (4030)

locking (4755), (4949)

placement (4428)

statement (5068)

statistics (5066)

influencing data access (5072)

updating (5075)

SYSTEM.SYSCATALOG (3970), (4271), (4275)

SYSTEM.SYSCOLUMNS (3988)

SYSTEM.SYSDBSPACES (4003), (4254), (4268)

SYSTEM.SYSINDEXES (4028)

table information (3971)

UPDATE STATISTICS (5067)

CCSID

CHARNAME (5051)

column (4000)

conversion

PROTOCOL (4887)

DRDA handshaking (4885)

impact on sargability (5048)

CCW

fast translation (4469)

channel (4410)

CHARNAME

CCSID (5050)

checklist

enable (5228)

pre-enable (5226)

checkpoint

agent (4594)

as overhead (3759)

forcing (4296), (4843)

interval (4840)

choosing (5342)

default value (5347)

invalid index (4388)

load measurement (3896)

managing (5334)

occurrence (4823)

overview (4816)

performance implication (4837)

process (4292)

save interval (5346)

shadow page (4284), (4817)

short on storage (4223)

storage queue (4081)

checkpoint interval

understanding (5150)

CHKINTVL

checkpoint (4825)

choosing a value (4841)

CHKPOINT counter (3875)

choose

in syntax diagrams (3564)

CICSPARS (3700), (3834)

CIRB

initiated CICS connections

concurrency (4657)

transaction (4633)

CIRD transaction (3705), (3865)

CIRT transaction (4634)

CISQ

transaction name (4500)

cluster ratio

catalog table (4039)

evaluating (4344)

clustered

catalog table (4035)

index (4324)

access path (5007)

unclustered index (4336)

clustering index (4326)

catalog table (4034)

changing

while reorganizing a dbspace (4363)

while reorganizing a table (4355)

without dropping indexes (4370)

data (4321)

PCTFREE (4264)

reorganize index (4382)

unclustered (4339)

view (4347)

CLUSTERTYPE

clustering (4333)

column

> 254 (4917)

catalog information (3989)

length (3994)

null type (3998)

type (3993)

COMMIT WORK

checkpoint (4828)

ISQL (4936)

lock escalation (4776)

log cushion (4868)

statement (4813)

COMMITCOUNT

locking (4982)

communication

blocking (4897)

DRDA protocol (4871)

synchronous (4921)

compatibility

lock (4709)

compile partition size (4491)

concurrency

agent (4589)

allocating agent structure (4599)

as overhead (3755)

CICS (4629)

CICSPARS (4638)

CIRB transaction (4631)

concurrent ISQL users (4502)

cost of additional real agents (4614)

description (4588)

differences between real and pseudo agents (4645)

dispatching agents (4668)

DISPBIAS (4680)

fair share auditing (4677)

guest sharing (4646)

long versus short LUW (4683)

MAXCONN (4651)

NCUSERS (4611)

operator SHOW commands (3939)

prioritization (4673)

privileged remote DRDA user (4659)

pseudo-agents (4642)

RMTUSERS (4652)

SHOW CONNECT (4623)

SHOW USERS (4625), (4665)

startup mode (4685)

VM user (4610)

VSE batch user (4603)

VSE interactive user (4604)

VSE remote DRDA user (4605)

conditional JCL

startup for virtual disk (4161)

configuration

consideration, distributed (4510)

console log (3861)

constraint

removing (3763)

controller (4411)

conventions

example (3572)

syntax diagram notation (3556)

Conversational Monitor System (CMS)

work unit (4814)

corrective service (5216)

cost

estimating

obtaining (5108)

explain table (5093)

of monitoring (3645)

cost-benefit ratio (3578)

counter

CP indicate user

I/O (3819)

READS (3806)

RES (3803)

WRITES (3808)

CP query time

CTIME (3810)

TOTCPU (3816)

VTIME (3813)

directory (5157)

example (3869)

operator command (3728), (3867)

storage pool performance

understanding (5156)

COUNTER

COUNTER POOL

DB2 Server DSS (3744)

monitor (3660)

time (3818)

CP directory

maximum (5372)

statement

ACCESSLIST (5236)

ADDRSPACE (5237)

MACHINE (5234)

XCONFIG (5235)

update (5240)

CP QUERY TIME (3678)

CPU

as a resource (3747)

load measurement (3782), (3827)

time used (3946)

CREATE INDEX

reorganize a single table (4360)

CREATE PROGRAM

blocking (4904)

creating

bootstrap package (5257)

CSTT transaction (3840)

CTIME counter (3811)

cursor

fetch (4906)

insert (4905)

stability (CS)

isolation level (4745)

ISQL (4945)

minimum lock level (4723)

suppressed blocking (4915)

cushion

log (4867)

Customer Information Control System (CICS)

AMXT/MXT (4493)

CICS partition

31 bit addressing (4487)

CCW translation (4466)

connection (4608)

dispatching priority (4464)

system paging DASD (4069)

virtual addressability extension (4474)

CICS statistics (3709)

CICSPARS (3701), (3835), (4639)

CIRB transaction (4632)

CIRD transaction (3704), (3864)

CMXT parameter (4504)

concurrent ISQL users (4503)

CSTT transaction (3841)

DFHMCT ID keywords and clocks (3844)

DFHMCT macro (3846)

DFHSIT macro (3843)

link to database partition (4630)

measurement tools (3695)

online resource adapter (4647)

pseudo agent (4656)

temporary storage (4508)

transaction time usage (3836), (3838)

DASD

cache (5299)

DASD I/O

*BLOCKIO (4072)

as a resource (3751)

balancing (4405)

channel (4408)

checkpoint (4838)

controller (4409)

DASD I/O system (4541)

general consideration (4426)

load measurement (3792), (3833)

NCUSERS (4616)

package cache (4577)

page format (4204)

VSAM (4073)

DASD storage

as a resource (3753)

CMS reserved minidisk (4201)

cost of monitoring (3646)

dbextent placement in a volume (4443)

distributing (4196)

dividing (4192)

failure (4850)

running out (4198), (4300)

VSAM entry sequenced data sets (ESDS) (4199)

wasting (4194)

DASDIO counter (3890)

DASDREAD counter (3888)

DASDWRIT counter (3889)

data clustering (4322)

data location

physical (3850)

data page

description (4238)

free space (4257)

proportion to other pages (4245)

data set placement (VSE) (3854)

data space

virtual disk (4120), (4170)

data spaces

directory (5139)

internal dbspace (5132)

removing (5221)

storage pool (5128)

turning on and off (5282)

understanding (5125)

database

archive (4854), (5242)

creating new (5296)

design

using EXPLAIN (5114)

generation

MAXPOOLS keyword (4216)

machine

31 bit addressing (4108)

address space size (4089)

auxiliary storage (4063)

buffer pool (4547)

CPU load (3831)

DASD I/O load (3790)

fair share scheduling (4448)

load on (3893)

overall performance (3801)

SHOW STORAGE (3932)

virtual storage load (3786)

manager

storage (4538)

database machine

DASD requirement (5200)

logoff (5239)

logon (5229)

modes of operation (5181)

overview (5177)

virtual storage (5190)

database manager

building (5249)

verifying (5250)

database partition

31 bit addressing (4109), (4489)

address space size (4090)

auxiliary storage (4064)

balancing pool (4462)

batch (4461)

buffer pool (4548)

CICS

dispatching priority (4460)

fast CCW translation (4465)

virtual addressability extension (4475)

compile size (4490)

DASD I/O load (3791)

deactivation (4074)

load on (3894)

overall performance (3802)

SHOW STORAGE (3933)

DATALOAD

automatic statistics collection (4962)

clustering index (4328)

free page space (4019)

locking (4980)

PCTFREE (4262)

DATAUNLOAD

locking (4988)

date

ever increasing index (4319)

DB2 for VM Control Center Operations Guide, IBM (3732)

DB2 for VM directory

data spaces support (5138)

performance counter (5158)

understanding (5137)

DB2 Server DSS

checkpoint (4845)

counters (3913)

DB2 Server for VM directory

reblocking (5293)

using (5292)

dbextent

adding (4304)

allocation to dbspace (4421)

caching (4438)

consecutive placement (4442)

mapping to dbspace (4205)

moving (4413)

number (5351), (5357)

number per device (5353)

restructuring (4424)

size (5355)

splitting (4425)

storage (3924)

virtual disk (4146), (4186)

DBNAME directory (4663)

DBS utility (Database Services utility)

automatic statistics collection (4966)

lock escalation (4978)

performance considerations (4959)

reorganize (4378)

REORGANIZE INDEX (4380)

tape blocking (4972)

unload and reload package (4995)

UNLOAD block size (4974)

dbspace

active pages (4010)

adding (4307)

available pages (4007)

catalog information (4004)

DROP

checkpoint (4831)

dropping (4213)

dropping for force a checkpoint (4298)

extending (4311)

forcing checkpoint (4844)

full (4301), (4310)

over allocating (4313)

shadow page (4315)

LOCK DBSPACE statement (4976)

lockmode (4022)

mapping to dbextent (4206)

move (4422)

pages for indexes (4013)

PCTFREE (4266)

percentage of page free (4017)

private

lock (4711)

reassign (4418)

releasing empty pages (4214)

reorganize (4306), (4362)

scan (5000)

minimum lock level (4724)

reorganize index (4404)

row level locking (4747)

storage pool (4025)

table placement (5026)

DBSSCALL counter (3872)

DDR (4416)

deactivation of partition (4075)

DEADLCK counter (3879)

deadlock

application design (4797)

COUNTER (4808)

example (4792)

hit ratio (3900)

lock contention (4800)

lock escalation (4802)

NCUSERS (4619), (4794)

overview (4791)

performance indicator (3898), (4807)

reschedule applications (4799)

rollback (4809)

time required to detect (4793)

DEDICATE parameter (4143)

default

in syntax diagrams (3566)

deprived agent (4678)

design

data (5081)

database (5116)

evaluation (5080)

modifying tables (5119)

device utilization

load measurement (3795)

DFHMCT CICS macro (3845)

DFHSIT

macro instruction for CICS

AMXT/MXT (4495)

CICSPARS (3842)

diminishing returns, law of (3583)

directory

buffer

DASD I/O system (4545)

NDIRBUF (4568)

performance indicator (3911)

caching (4437)

checkpoint (4822)

page map table (4208)

placement (4439)

solutions (3716)

DIRREAD counter (3884)

DIRWRITE counter (3885)

disabling VMDSS (5277)

disk locations, VM (3852)

dispatching

agents (4669)

fair share auditing (4674)

prioritization (4671)

priority (VSE) (4459)

SET QUICKDSP (4458)

DISPBIAS

agent dispatching (4681)

distributed configuration

application planning (4523)

performance implication (4521)

VM (4511)

VSE (4519)

distributing

DASD (4195)

distribution tape (5243)

dividing

DASD (4191)

processor time (4449), (4452)

DRDA protocol

blocking (4902)

distributed consideration (4513)

DRDA option (4892)

fetch and insert blocking (4529)

handshaking (4883)

performance considerations (4872)

PROTOCOL parameter (4880)

DRDA user

privileged remote (4661)

RMTUSERS (4654)

VSE pseudo agent (4609)

DROP DBSPACE

checkpoint (4830)

command (5025)

dual log (4858)

duration

lock (4705)

dynamic

page allocation (4211)

dynamic storage size management (5314)

effective use measurement

description (3768)

elapsed time (3619), (3812)

elements of performance (3573)

empty log

invalid index (4390)

enable (5224)

enable checklist (5227)

enable code (5244), (5245)

engineering change (EC) (3587)

ESCALATE (3877)

counter (3964), (4780)

estimating

size of response (5110)

evaluating

logical data design (5079)

example

conventions (3571)

exclusive lock

description (4697)

EXEC

SQLGENLD (5265)

SQLSTART (5270), (5274)

existing data

striping (5359)

expanded storage (5141)

auxiliary storage (4061)

buffer pool (4556)

EXPLAIN

cost table (5094)

database design (5115)

explicit and implicit (5088)

plan table (5096)

reference table (5098)

referential constraint (5101)

statement (5085)

structure table (5103)

explanation table

general description (5084)

using (5083), (5091)

extension

virtual addressability (4478)

fair share

auditing (4675)

scheduling (4445)

fallback procedures (3592)

fast CCW translation (4467)

FASTTR

job control option (4470)

fault

page (4071)

FB-512 storage devices (5195)

fetch blocking (4893)

distributed database (4525)

filter factor (5046)

fold file

distributed database (4532)

forcing

a checkpoint (4297)

fragment of syntax

in syntax diagrams (3569)

fragmentation

index (4371)

guest sharing

concurrency (4648)

distributed database (4520)

guidelines

tuning (3581)

handshaking

DRDA (4884)

hardware

problems (3585)

upgrading (3590)

header page

description (4236)

number (4243)

proportion to other pages (4246)

hierarchy of locks (4694)

HIGHSTOR (3938)

hit ratio

deadlock (3899)

description (3654), (3769)

directory buffer (3912)

local buffer (3909)

waitlock (3903)

hold file

distributed database (4531)

host variable

in syntax diagrams (3558)

I/O

cost (5077)

counter (3820)

DASD balancing (4407)

DASD I/O as a resource (3752)

DASD I/O system (4542)

fast CCW translation (4473)

general consideration (4427)

IBM DB2 for VM Control Center (3731)

IDCAMS

backup (4140)

dataset location (3859)

improvement process

performance (3594)

index

access path (4999)

catalog information (4029)

causes of invalid (4400)

cluster ratio (4038)

clustered (4037), (4323)

clustering (4036), (4327)

default versus clustering (4330)

unclustered (4349)

clustering strategy (4332)

creating (5013)

default strategy (4331)

disadvantages (5021)

ever increasing (4316)

foreign key (5029)

fragmentation (4372)

free space

catalog table (4044)

fragmentation (4373)

fully matched (5037)

index-only access (5012)

invalid (4383)

lock contention (4729)

lockmode (4042)

page

description (4240)

free space (4278)

proportion to other pages (4244)

reserved in a dbspace (4014)

running out (4318)

PCTFREE (4374)

recommendation (5020)

release level (4047)

reorganize (4376)

invalid (4401)

scan (5003)

minimum lock level (4722)

sorting (5018)

transient (4395)

unclustered

identifying (4338)

unique

access path type (5015)

row level locking (4730)

with key matching predicate (5016)

INDICATE USER

command (3799)

description (3679)

example (3821)

indicators

performance (3597)

indicators, performance (3613)

individual device utilization

load measurement (3794)

influencing data access

with catalog statistics (5073)

initialization parameter

BLOCK (4899), (4903)

CHKINTVL (4824)

LOGMODE (4821)

NCUSERS (4581), (4612)

NDIRBUF (4550)

NLRBS (4762), (4768)

NLRBU (4763), (4769)

NPACKAGE (4582)

NPACKPCT (4583)

NPAGBUF (4549)

PCTFREE (4280), (4367)

PROTOCOL (4873)

retrieval (3719), (3860)

inner table (5059)

insert

blocking (4526), (4894)

distributed database (4527)

multiple row (4898)

INSERT logic (4325)

installation option

overview (5218)

production system (5219)

removing VMDSS (5220)

saved segment (5222)

installation requirement

CP directory (5371)

DASD (5193)

database disk (5201)

database machine (5175), (5191)

database machine DASD (5198)

dbextent (5203)

directory (5202)

FBA (5194)

hardware (5205)

log (5204)

MAINT machine (5171), (5187)

operating system (5164), (5168)

real storage (5192)

software (5183)

virtual storage (5185)

VM paging DASD (5196)

intent

exclusive lock

description (4700)

none lock

description (4701)

share lock

description (4699)

interactive

interface

VSE (3688)

user

VSE (4607)

Interactive Structured Query Language (ISQL)

asynchronous communication (4928)

AUTOCOMMIT (4933), (4939)

blocking (4920)

CANCEL (4934)

CICS (4496)

concurrent users (4501)

isolation level (4943)

performance considerations (4932)

temporary table (4951)

transaction name (4497)

view (4956)

internal dbspace

adding to a virtual disk pool (4159)

data spaces (4432)

mapped

choosing (5324)

understanding (5133)

using (5291)

placement (4430)

unmapped

choosing (5323)

understanding (5135)

using (5289)

virtual disk (4125), (4175), (4433)

interval

sampling (3771)

interval, monitoring (3643)

invalid index (4384)

package (4392)

SHOW INVALID (4393)

IPL procedure (4128)

isolation level

considerations for adhoc users (4948)

description (4742)

ISQL (4944)

lock duration (4751)

lock escalation (4777)

selecting (4753)

user defined (4749)

ISQ2

transaction name (4499)

IUCV *BLOCKIO

DASD I/O system (4553)

page format (4203)

IUCV conversations (4689)

join

merge scan (5060)

multiple (5063)

performance considerations (5054)

predicate (5044)

stored (4953), (5121)

key-matching (5035)

keyword

in syntax diagrams (3557)

law of diminishing returns (3582)

LDIRBUFF counter (3883)

length, column (3995)

limits

system tuning (3605)

link-edit (5251)

LISTCAT (3692), (3858)

load

leveling (4076)

workload (3606)

load measurement

checkpoint (3895)

CPU (3779), (3828)

DASD I/O (3832)

database machine or partition DASD I/O load (3789)

description (3652), (3767)

I/O (5078)

individual device utilization (3793)

logical unit of work (3891)

main storage (3823)

operating system (3775)

processor (3780), (3830)

real and virtual storage (3783)

system paging DASD (3787), (3825)

tools (3776)

saved segments (5253)

local

buffer

DASD I/O system (4546)

new page (4291)

NPAGBUF (4569)

performance indicator (3908)

virtual addressability extension (4481)

copy

distributed database (4533)

LOCALAXE entry

privileged remote DRDA user (4664)

locations

physical data (3851)

LOCK

lock escalation (4773)

lock contention

access path (4735)

catalog table (4754)

deadlock (4801)

index (4728)

isolation level (4743)

lock compatibility (4710)

logical unit of work (4739)

measurement (3953)

minimum lock level (4717)

NCUSERS (4715)

operator SHOW command (3954)

row level locking (4733)

lock escalation

ALTER DBSPACE (4774)

COUNTER operator command (4782)

DBS utility (4975)

deadlock (4803)

isolation level (4778)

LOCK (4775)

measurement (3960)

NCUSERS (4620)

operator SHOW command (3961)

overview (4759)

SHOW LOCK MATRIX (4785)

trading lock level (4765)

lock request block

determining number required (4779)

insufficient (4786)

NLRBS (4761)

NLRBU (4760)

number in use (3963)

performance indicator (3906), (4783)

locking

as overhead (3756)

compatibility (4708)

considerations

reducing lock escalation (4983)

contention

overview (4692)

performance indicator (4757)

cost of (3757)

DBS utility

DATALOAD and RELOAD (4979)

deadlock (4986)

UNLOAD PACKAGE and RELOAD PACKAGE (4985)

duration (4706)

isolation level (4752)

hierarchy (4693)

lock level (4719)

lockmode

dbspace (4023)

index (4041)

minimum lock level (5027)

mode (4695)

NCUSERS (4618)

operator SHOW commands (3952)

overview (4691)

private dbspace (4712)

SHARE lock

DBS utility (4989)

virtual addressability extension (4482)

LOCKLMT

counter (3965)

example (3876)

log (5338)

archive (4856)

caching (4436)

checkpoint (4826)

cushion (4866)

dual (4857)

file (4847)

full

checkpoint (4834)

invalid index (4389)

placement (4440)

SHOW LOG (4870)

log buffer (5336)

log disk (5337)

logging

as overhead (3760)

logical data design

evaluation of (5082)

logical unit of work

load measurement (3892)

lock duration (4707)

locking (4738)

long versus short (4684)

recovery (4811)

storage queue (4083)

logmode

changing (4861)

initialization parameter (4820)

selecting (4859)

short on storage (4224)

LOGMODE

LOGMODE startup parameter (5339)

LOGREAD counter (3886)

LOGWRITE counter (3887)

LPAGBUFF counter (3880)

LU 6.2 LUWID

DRDA handshaking (4886)

MACHINE directory statement (5230)

main storage (5142)

buffer pool (4564)

dedicating (4055)

load measurement (3824)

page count (3805)

temporary CICS (4506)

virtual addressability extension (4484)

virtual disk (4121), (4171)

MAINT machine

installation (5173)

overview (5172)

virtual storage (5188)

maintenance

statistics (5065)

manual

organization (3552)

prerequisite (3553)

who should use (3551)

mapping

choosing (5333), (5361)

understanding (5134)

matched index (5038)

MAXCONN (3943)

increasing virtual storage (4092)

pseudo agent (4650)

MAXPOOLS

keyword (4217)

measurement

production system (3649)

relative nature (3647)

test system (3648)

to indicators (3798)

tools (3657), (3714)

catalog table (3721)

CICS (3694)

CICS monitoring facility (3697)

CICS statistics (3708)

CICSPARS (3699)

CIRD transaction (3703)

COUNTER operator command (3727)

CP INDICATE USER (3674)

CP monitor (3663)

CP QUERY TIME (3676)

database manager (3848)

DB2 Server DSS COUNTER POOL (3743)

DB2 Server DSS SHOW TARGETWS (3740)

DB2 Server for VSE & VM (3712)

DB2 Server for VSE & VM accounting (3734)

DB2 Server for VSE & VM trace (3736)

IBM DB2 for VM Control Center (3730)

initialization parameter (3718)

operating system (3778)

RTM VM/ESA (3681)

SHOW operator command (3724)

VM (3659)

VM/PRF (3665)

VMMAP (3669)

VSAM LISTCAT (3690)

VSE (3684)

VSE interactive interface (3686)

measuring performance (3764)

memo-to-users (5211)

merge scan join (5061)

message traffic

fetch and insert blocking (4528)

microcode assists (3589)

minidisk

caching (4434)

minimum lock level (4718)

modifying table designs (5118)

monitor, CP (3661)

Monitor Analysis Program (VMMAP) (3671)

monitoring

cost (3644)

interval (3642)

master schedule (3641)

plan (3637)

performance (3601), (3639)

real time (3633)

statistical (3634)

most recently used pages (4067)

multiple join (5064)

multiple user mode

starting DB2 Server for VM (5269), (5273)

multiple user mode (MUM)

allocating user to agents (4602)

blocking (4896)

running (4688)

NCUSERS

buffer pool (4572)

deadlock (4795)

determining number of real agents (4613)

example (3944)

increasing virtual storage (4091)

lock contention (4714)

number of real agents (4598)

package cache (4579)

RMTUSERS (4658)

NDIRBUF

directory buffer (4565)

directory buffer pool (4552)

increasing virtual storage (4094)

nested loop join (5057)

network

distributed (4522)

response time (3624)

SNA (4516)

NLRBS

increasing virtual storage (4096)

initialization parameter (4770)

NLRBU

increasing virtual storage (4095)

initialization parameter (4771)

NOFASTTR

job control option (4471)

non-XC mode

database machine (5182)

hardware (5208)

SQL/DS directory (5327)

verify (5267)

nonrecoverable storage pool

checkpoint (4835)

nonselective index scan (5008)

NOVERFLOW (3981)

NPACKAGE

increasing virtual storage (4097)

package cache (4578)

NPACKPCT

package cache (4580)

NPAGBUF

increasing virtual storage (4093)

local buffer (4566)

local buffer pool (4551)

null (3997)

objectives

performance (3599), (3615)

obtaining costs for statements (5107)

operating

mode

XA (4106)

XC (4107)

system measurements (3772)

operating system

non-XC mode (5170)

requirement (5166)

operator

command (3915), (3950)

operator agent (4595)

storage queue (4080)

optimizer (4997)

optional

default parameter

in syntax diagrams (3568)

installation steps (5276)

item

in syntax diagrams (3563)

keyword

in syntax diagrams (3567)

options file, start up (3863)

outer table (5058)

overflow

catalog table (4277)

reorganization (4350)

row expansion (4260)

overhead (3754)

overview

checkpoint interval (5149)

data space (5126)

database machine (5178)

directory (5140)

internal dbspace (5131)

logical mapping (5162)

MAINT machine (5174)

operating system (5165), (5169)

performance counter (5155)

physical mapping (5163)

save interval (5151)

storage management (5144)

storage pool (5129)

storage pool structure (5161)

striping (5154)

target working storage size parameter (5145)

working storage residence priority (5148)

package

cache (4574)

NCUSERS (4622)

threshold (4587)

virtual addressability extension (4483)

invalid (4391)

unload and reload (4994)

page

active in a dbspace (4011)

allocating from storage pool (4220)

available in a dbspace (4008)

DASD I/O system (4543)

data

description (4237)

free space (4256)

dbspace

running out (4299)

dynamic allocation (4210)

fault

system paging DASD (4070)

free percentage (4018)

header (4235)

index (4239)

reserved in a dbspace (4015)

running out (4317)

jumps (4345)

logical and physical (4212)

map table (4207), (4209)

shadow page (4287)

modified (4557)

most recently used (4066)

number used by a table (3986)

releasing (4558)

shadow

checkpoint (4283)

description (4241)

number in use (4293)

size (4200), (4202)

stealing (4559)

storage (4056)

type (4234)

update (4290)

page fault processing, asynchronous (5306)

PAGEREAD counter (3881)

PAGWRITE counter (3882)

parentheses

in syntax diagrams (3560)

path length (5303)

PCTFREE

initialization parameter (4259)

reorganize a dbspace (4365), (4368)

reorganize a single table (4357)

PCTINDEX

proportion of page types (4250)

PCTINDX

proportion of page types (4253)

performance

elements of (3574)

improvement process (3593)

improving (5124)

indicator (3612)

measurement

description (3653)

translating to indicators (3797)

monitoring plan (3600), (3638)

objectives (3598), (3614)

trade-off (3603)

performance indicator

AVGROWLEN (4270)

CICSPARS (4640)

CIRD transaction (4641)

COUNTER (4573)

deadlock (3897), (4806)

directory buffer (3910)

FREEPCT (4267)

IPCTFREE (4281)

local buffer (3907)

lock contention (4758)

lock request block (3905), (4784)

lockmode (4725)

NOVERFLOW (4274)

operating system (3773)

PCTINDX (4251)

performance improvement process (3596)

SHOW POOL (4231)

SHOW USERS (4666)

tools (3774)

waitlock (3901)

Performance Reporting Facility, VM (3667)

performance tuning

asynchronous processing (5307)

blocking (5313)

buffer pool (5300)

checkpoint (5340), (5345)

checkpoint interval (5341)

DASD cache (5301)

data space (5297)

dynamic storage management (5316)

internal dbspace (5322)

mapping (5360)

more asynchronous writes (5319)

path length (5304)

prefetching (5311)

save interval (5343)

SQL/DS directory (5326)

storage pool (5321)

storage size (5329)

striping (5309), (5348)

target working storage size (5330)

permanent dbspace

shadow page (4286)

physical data locations (3849)

placement in dbspace (5023)

plan, performance monitoring (3602), (3640)

plan explain table (5095)

planning

storage pool structure (5160)

post installation (5275)

pre-enable checklist (5225)

predicate

CCSID (4001)

column attribute (5033)

filter factors (5045)

join (5043)

key-matching (5034)

processing (5030)

examples (5047)

residual (5040)

sargable (5039)

suitable indexes for (5036)

prefetch

improving performance (5310)

preprocessing

compile partition size (4492)

prerequisite manual (3554)

preventive service (5213)

priority

agent prioritization (4672)

dispatching (VSE) (4463)

private dbspace

cursor stability (4746)

privileged remote DRDA user, VSE (4660)

procedures

stored (4535)

process

performance improvement (3595)

processing cost (5076)

processor

as a resource (3746)

load measurement (3781), (3829)

time used (3947)

processor requirement (5206)

production workload (3610), (3650)

PROFILE EXEC, modifying (4187)

program directory

loading (5212)

program temporary fix (PTF) (3588)

proportion

of available pages (3921)

of index to data and header pages (4247)

proportion of index to data and header pages

PCTINDEX (4249)

PCTINDX (4252)

PROTOCOL

AUTO option (4889)

CCSID conversion (4888)

DRDA

communications (4874)

option (4882), (4891)

SQLDS option (4881)

pseudo agent

description (4644)

number waiting (4627)

PTF tape (5215)

punctuation mark

in syntax diagrams (3559)

QRYBLKSIZE

blocking (4908)

query

adhoc

isolation level (4942)

performance considerations (4929)

temporary table (4952)

view (4955)

separating into subquery structures (5106)

several tables (5053)

query set (5268), (5272)

QUERY TIME

command (3800)

description (3677)

example (3822)

queue, storage (3930)

quick dispatch

SET QUICKDSP (4457)

ratio

cost-benefit (3579)

hit (3655)

RDSCALL counter (3871)

READS counter (3807)

real agent

description (4597)

number available (4628)

storage queue (4079)

real storage

as a resource (3749)

description (4049)

increasing virtual storage (4088)

load measurement (3784)

Real Time Monitor VM/ESA program, (RTM VM/ESA) (3682)

real time monitoring (3635)

reblocking directory (5294)

recovery

archive (4849)

as overhead (3758)

checkpoint (4815)

log (4848)

logical unit of work (4810)

shadow page (4289)

storage queue (4082)

reducing

lock escalation (4984)

redundant data (5122)

reentrant code (4112)

reference explain table (5097)

referential structure

EXPLAIN (5099)

organization (5028)

relative performance measurement (3765)

relative share (4453)

release level (4046)

releasing, page (4561)

RELOAD

automatic statistics collection (4961)

clustering index (4329)

free page space (4020)

locking (4981)

NEW (4366)

PCTFREE (4263)

PURGE (4353)

single table (4359)

RELOAD PACKAGE

DBS utility (4992)

usage considerations (4993)

remote, privileged DRDA user (4662)

reorganize

all the tables in a dbspace (4361)

clustering index (4381)

dbspace (4305)

index (4375)

invalid index (4399)

PCTFREE (4356), (4364)

reasons to reorganize data (4348)

selecting a method (4351)

single table (4352)

REORGANIZE INDEX

advantages (4379)

DBS utility command (4377)

invalid index (4402)

repeat symbol

in syntax diagrams (3565)

repeatable read (RR)

isolation level (4744)

ISQL (4946)

required item

in syntax diagrams (3562)

requirements

real storage (5362)

RES counter (3804)

resave the saved segment (5252)

reserved words

SQL (3570)

RESET

example (3870)

operator command (3868)

residual predicate (5032), (5042)

resources (3745)

response size

estimating (5111)

response time

application program (3627)

application server (3623)

components (3620)

network (3625)

performance (3575), (3616)

restarting

the application server (5266)

restore virtual disk backup (4163)

RINO

EXPLAIN (5100)

RMTUSERS

concurrency (4653)

ROLLBACK (3874)

ROLLBACK WORK

checkpoint (4827)

invalid index (4385)

ISQL (4937)

locking (4740)

statement (4812)

row

expansion (4261)

length

blocking (4910)

level locking

unique index (4732)

overflow (3983)

total number (3980)

ROWCOUNT

catalog table (3978)

estimating response size (5113)

running out of

DASD (4197)

sampling interval (3770)

sargable

affect of CCSID (5049)

predicate (5031), (5041)

save interval

choosing (5344)

understanding (5152)

saved segment

resaving (5223)

saved segments (4110)

loading (5256)

SAVEINTV

DB2 Server DSS (4846)

saving

segments (5254)

scan

dbspace (5002)

index (5004)

scheduling

fair share (4446)

second level guest (4509)

segment saving (5255)

segments, saved (4111)

selective

archive (4852)

index

scan (5009)

separating queries into subquery structures (5104)

SEPINTDB

unmapped internal dbspaces (5290)

service

corrective (5217)

preventive (5214)

SET POOL (5288)

SET QUICKDSP

fair share scheduling (4455)

SET SHARE

fair share scheduling (4450)

shadow page (5335)

accumulating (4230)

checkpoint (4842)

checkpoint process (4818)

dbspace full (4314)

description (4242), (4285), (4819)

number in use (4294)

page map table (4288)

short on storage (4225)

description (4703)

lock

description (4696)

with intent exclusive lock (4702)

SHARE lock (4990)

short on storage

checkpoint (4829)

example (3926)

initialization parameter (4229)

managing pool space (4222)

SHOW POOL (4232)

SOSLEVEL (4228)

shorter path length (5302)

SHOW

operator command (3725), (3914)

SHOW ACTIVE

operator command (3940)

SHOW CONNECT

concurrency (4624)

operator command (3945), (3949), (3951)

SHOW DBEXTENT

available storage pool space (4308)

operator command (3919)

SHOW DBSPACE

operator command (3922)

SHOW INVALID

invalid index (4394)

transient index (4397)

SHOW LOCK

operator command (3955)

SHOW LOCK ACTIVE

operator command (3956)

SHOW LOCK GRAPH

operator command (3958)

SHOW LOCK MATRIX

lock escalation (4781)

operator command (3957), (3962)

SHOW LOCK USER

operator command (3959)

SHOW LOG

log cushion (4869)

SHOW POOL

available dbextent space (4309)

operator command (3925)

shadow page (4295)

short on storage (4233)

SHOW STORAGE

operator command (3931)

SHOW TARGETWS

DB2 Server DSS (3741)

SHOW USERS

concurrency (4626)

operator command (3941)

pseudo-agents (4667)

shutdown

checkpoint (4833)

single user mode (SUM)

allocating users to agents (4601)

blocking (4913)

fetch and insert blocking (4530)

logmode (4860)

running (4687)

size of responses, estimating (5112)

SLOGCUSH

tuning parameter (4864)

SNA network

distributed database (4515)

software problems (3586)

software requirement (5184)

Solutions Directory (3715)

sorting

index (5019)

specification file

storage pool

changing (5279)

format (5364), (5366), (5370)

identifying (5281)

writing (5368)

SQL statements, analyzing (5086)

SQLCODE

-649 (5089)

-911 (4804)

-912 (4787)

-915 (4788)

SQLDS protocol (4879)

SQLGENLD EXEC (5263), (5264)

SQLHX

synchronous communication (4925)

SQLINIT

PROTOCOL parameter (4875)

QRYBLKSIZE (4907)

SYNCHRONOUS (4922)

SQLMACH machine

DASD requirement (5199)

modes of operation (5180)

overview (5176)

virtual storage (5189)

SQLQRY

synchronous communication (4927)

SQLSTART (3853)

SQLSTATE

40001 (4805)

42704 (5090)

57028 (4789)

57029 (4790)

start up

mode (4686)

options file (3862)

statements

obtaining costs (5109)

statistics

automatic collection (4960)

catalog table (3968)

CICS (3710)

influencing data access (5074)

maintenance (5069)

monitoring (3636)

update all (5071)

stealing, page (4560)

storage

16MB line (3936)

31-bit addressing (3935)

address space size (4086)

allocation above 16MB (3937)

as a resource (3748)

auxiliary (4062)

available dbextent storage (3923)

available storage pool space (3917)

DASD (4190)

DASD I/O system (4540)

database manager (4539)

main and expanded (5143)

operator SHOW commands (3916)

package cache (4576)

page (4057)

paging system (4065)

proportion of available pages (3920)

queue (3929), (4078)

real and virtual (4048)

saved segments (4114)

short on storage (4226)

temporary CICS (4505)

virtual (3927)

virtual disk (4116), (4166)

virtual machine (4051)

virtual partition (4052)

storage pool

allocating page from (4219)

assign DASD (4417)

assigning dbextent (4218)

available space (3918)

catalog placement (4429)

Data Spaces Support (5283)

dbspace (4026)

description (4215)

directory and log placement (4441)

existing pool and virtual disk (4153)

free allocated pages (4302)

full (4303)

internal dbspace placement (4431)

managing space (4221)

nonrecoverable

checkpoint (4836)

performance (5320)

reassign dbspace (4419)

specification

checking (5286)

dynamically changing (5287)

specification file

changing (5278)

example (5369)

format (5363), (5365)

identifying (5280)

writing (5367)

virtual disk (4151), (4184)

storage pool

planning structure (5159)

understanding (5127)

stored procedure

executing (3948)

stored procedures program (3628)

storing

joins of tables (5120)

logical table as two tables (5123)

striping

choosing (5349)

dbextent size (5354)

existing data (5358)

number of dbextents (5356)

one dbextent (5350)

performance (5308)

physical device (5352)

turning on an off (5285)

understanding (5153)

structure explain table (5102)

subquery structures, determining (5105)

super exclusive lock

description (4698)

supervisor mode

ESA (4104)

VMESA (4105)

suppressed blocking (4911)

suppressing

automatic statistics collection (4970)

SYNCHRONOUS

communication (4923)

syntax diagram

notation conventions (3555)

SYSDEF (4137)

system paging DASD

auxiliary storage (4060)

buffer pool (4555)

hidden cost (4068)

increasing virtual storage (4099)

load measurement (3788), (3826)

monitoring load (4098)

NCUSERS (4615)

saved segments (4113)

virtual disk (4119), (4169)

SYSTEM.SYSCATALOG

average row length (3972), (4272)

catalog table (3969)

clustering (4334)

number of page used by a table (3984)

overflow rows (3977), (4273), (4276)

total number of rows (3976)

SYSTEM.SYSCOLUMNS

catalog table (3987)

CCSID (3999)

column length (3991)

column type (3992)

null (3996)

SYSTEM.SYSDBSPACES

active pages (4009)

available pages (4006)

catalog table (4002)

ever increasing index (4320)

free space in a data page (4016), (4269)

lockmode (4021), (4726)

percentage of reserved index pages (4012), (4255)

storage pool number (4024)

SYSTEM.SYSINDEXES

catalog table (4027)

changing clustering index (4335)

cluster ratio (4033), (4341)

cluster value (4346)

clustered (4031)

clustering (4032)

free index space (4043), (4282)

lockmode (4040)

page jumps (4342)

release level (4045)

row count (4343)

table

allocation to dbspace (4420)

average row length (3974)

catalog

automatic statistics collection (4968)

information (3967)

locking (4756)

design modification (5117)

explanation (5092)

LOCK TABLE statement (4977)

methods of joining (5055)

moving (4423)

nested loop join (5056)

number of pages (3985)

overflow rows (3982)

placement in dbspace (5024)

reorganize (4354)

total number of rows (3979)

tape blocking

DBS utility (4971)

target working storage size (5373)

choosing (5331)

understanding (5146)

temporary storage

local copy (4534)

virtual disk (4122), (4172)

test workload (3608), (3651)

thrashing (4077)

throughput (3576), (3629)

time

components (3621)

elapsed (3618)

response (3617)

tools

measurement (3656), (3713)

catalog table (3720)

CICS (3693)

CICS monitoring facility (3696)

CICS statistics (3707)

CICSPARS (3698)

CIRD transaction (3702)

COUNTER operator command (3726)

CP INDICATE USER (3673)

CP monitor (3662)

CP QUERY TIME (3675)

database manager (3847)

DB2 Server DSS COUNTER POOL (3742)

DB2 Server DSS SHOW TARGETWS (3739)

DB2 Server for VSE & VM (3711)

DB2 Server for VSE & VM accounting (3733)

DB2 Server for VSE & VM trace (3735)

IBM DB2 for VM Control Center (3729)

initialization parameter (3717)

operating system (3777)

RTM VM/ESA (3680)

SHOW operator command (3723)

VM (3658)

VM/PRF (3664)

VMMAP (3668)

VSAM LISTCAT (3689)

VSE (3683)

VSE interactive interface (3685)

TOTCPU counter (3817)

trace

measurement tool (3738)

trade-off, performance (3604)

trading

lock level (4764)

transaction

CIRB (4635)

CIRD (3706), (3866)

CIRT (4636)

CSTT (3839)

name

ISQL (4498)

per second (3631)

time, CICS (3837)

transient index (4396)

SHOW INVALID (4398)

translation

fast CCW (4468)

of performance measurements to indicators (3796)

TSAF collection

distributed database (4514)

tuning

by levels (3584)

guidelines (3580)

queries (5052)

trade-off (3762)

tuning parameter

access path, lock contention (4734)

ARCHPCT (4863)

CIRB transaction (4637)

deadlock (4796)

DISPBIAS (4682)

index lock contention (4727)

isolation level (4741)

lock level (4720)

logical unit of work, lock contention (4737)

MAXCONN (4649)

minimum lock level (4716)

NCUSERS (4571), (4584), (4713)

NDIRBUF (4562)

NLRBS (4767)

NLRBU (4766)

NPACKAGE (4585)

NPACKPCT (4586)

NPAGBUF (4563)

PCTFREE (4265), (4279)

PCTINDEX (4248)

PROTOCOL (4876)

RMTUSERS (4655)

SLOGCUSH (4862)

SOSLEVEL (4227)

unclustered index (4337)

uncommitted read (UR)

isolation level (4748)

ISQL (4947)

UNDO

invalid index (4386)

unique constraint

invalid index (4403)

unique index

invalid index (4387)

row level locking (4731)

with key matching predicate (5014)

UNLOAD

block size (4973)

locking (4987)

UNLOAD PACKAGE

DBS utility (4991)

update lock

description (4704)

UPDATE STATISTICS

ALL (5070)

automatic statistics collection (4964)

clustered index (4340)

DBS utility (4965)

reorganize a dbspace (4369)

reorganize a single table (4358)

upgrading hardware (3591)

user agent (4596)

USER isolation level (4750)

VDISK (4136)

verify the database manager (5248)

view (4957)

virtual

addressability extension (4476)

dbextent

virtual disk (4181)

virtual disk

ADD (4131)

adding internal dbspace (4158)

backing up (4156)

backup file (4138)

cataloged procedure (4148)

conditional startup JCL (4160)

define (4133), (4178)

existing pools (4152)

increasing virtual storage (4115), (4165)

internal dbspace (4124), (4174)

MDISK (4179)

number of dbextents (4154)

procedure to create (4126), (4176)

PROFILE EXEC (4188)

restore backup (4162)

storage pool (4150), (4182), (4183)

storage pools (5130)

SYSDEF (4134)

temporary storage (4123), (4173)

VDISK (4135)

virtual and real dbextents (4155)

virtual dbextent (4145), (4180), (4185)

virtual VSAM cluster (4144)

VSAM user catalog (4141)

VSIZE (4132)

virtual machine

fair share scheduling (4447)

time (3815)

virtual storage (3928), (4050)

as a resource (3750)

blocking (4916)

load measurement (3785)

requirement (5186)

virtual addressing (4053)

VM/ESA

31 bit addressing (4102)

distributed database (4512)

requirement (5167)

SET QUICKDSP (4456)

SET SHARE (4451)

virtual disk (4167)

VM Monitor Analysis Program (VMMAP) (3672)

VM/Performance Reporting Facility (VM/PRF) (3666)

VM system paging DASD

internal dbspace (5136)

requirement (5197)

VMMAP (3670)

VSAM

backup (4444)

backup and restore (4414)

cluster

virtual disk (4147)

DASD I/O system (4554)

I/O buffer address (4472)

LISTCAT (3691), (3857)

user catalog

virtual disk (4142)

VSE/ESA

31 bit addressing (4103)

virtual addressability extension (4488)

virtual disk (4117)

VSE interactive interface (3687)

VSIZE (4130)

VTIME counter (3814)

waitlock

example (3878)

performance indicator (3902)

WAITLOCK

waitlock hit ratio (3904)

wasting

DASD (4193)

working storage residence priority

changing (5284)

choosing (5332)

understanding (5147)

working storage size (5374)

improving performance (5315)

management (5328)

workload (3766)

considerations (3607)

distributing (4412)

production (3611)

test (3609)

throughput (3630)

WRITES counter (3809)

writing asynchronously (5318)

XC mode

CP directory statement (5238)

database machine (5179)

hardware (5207)

SQL/DS directory (5325)

verify (5271)

XCONFIG directory statement (5231)

XPCC conversations (4690)

[ Top of Page | Previous Page | Table of Contents | Index ]