Online Documentation for SQL Manager for DB2

Performance

The Performance branch of the Database variables section of the Database Properties dialog allows you to view/edit the following DB2 database performance-related variables:

STMTHEAP, APP_CTL_HEAP_SZ, APPGROUP_MEM_SZ, APPLHEAPSZ, CATALOGCACHE_SZ, CHNGPGS_THRESH, MULTIPAGE_ALLOC, DATABASE_MEMORY, DB_HEAP, DFT_EXTENT_SZ, DFT_PREFETCH_SZ, GROUPHEAP_RATIO, LOCK_LIST, LOGBUFSZ, NUM_ESTORE_SEGS, NUM_IOCLEANERS, NUM_IOSERVERS, NUMSEGS, PCKCACHESZ, SEQDETECT, SHEAPTHRES_SHR, SORT_HEAP, STAT_HEAP_SZ, UTIL_HEAP_SZ.