Previous Topic: Ways to Improve PerformanceNext Topic: Tablespaces and Indexspaces


DB2 Parameters

The following table lists DSNZPARM value recommendations:

Value

Recommendation

DSMAX

Set DSMAX to the same value as the z/OS maximum number of datasets open.

EDMPOOL

Set the size to a minimum of 7 megabytes.

BUFFER

Define BP1 and BP2 to DB2 even if you do not allocate space for them. Defining them helps the RID list processing.

The RID pool is increased as needed until it reaches the lower of two values:

50% of the sum of the buffer pools' sizes (BP0 + BP1 + BP2 + BP32)

200 megabytes

NUMLKTS

Set the size to 2000.

NUMLKUS

Set the size to 10000.

BLKSIZE

Set the size to 28K

LOGLOAD

Set the size large enough to hold enough records for about 15 minutes of processing at peak times. Also consider archiving the log to DASD.

DSN07

Set the DSN07 to be multiple tablespaces. Allocate the tablespaces large enough so that the datasets do not use secondary extents.