Добрый день!
Имеется SLES11 (x64), DB 9.5
Раньше базы работали под управлением DB2 8.2. Экскалаций блокировок не было.
Переехали на 9.5.
Стали появляться эскалации.
Конфигурация нашей БД
Database Configuration for Database

Self tuning memory (SELF_TUNING_MEM) = OFF
Size of database shared memory (4KB) (DATABASE_MEMORY) = AUTOMATIC(192928)
Database memory threshold (DB_MEM_THRESH) = 10
Max storage for lock list (4KB) (LOCKLIST) = AUTOMATIC(10240)
Percent. of lock lists per application (MAXLOCKS) = AUTOMATIC(20)
Package cache size (4KB) (PCKCACHESZ) = AUTOMATIC(6144)
Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = AUTOMATIC(5000)
Sort list heap (4KB) (SORTHEAP) = AUTOMATIC(1024)
Database heap (4KB) (DBHEAP) = AUTOMATIC(1200)
Catalog cache size (4KB) (CATALOGCACHE_SZ) = 260
Log buffer size (4KB) (LOGBUFSZ) = 98
Utilities heap size (4KB) (UTIL_HEAP_SZ) = 47272
Buffer pool size (pages) (BUFFPAGE) = 1000
SQL statement heap (4KB) (STMTHEAP) = AUTOMATIC(6144)
Default application heap (4KB) (APPLHEAPSZ) = AUTOMATIC(512)
Application Memory Size (4KB) (APPL_MEMORY) = AUTOMATIC(40016)
Statistics heap size (4KB) (STAT_HEAP_SZ) = AUTOMATIC(4384)
Interval for checking deadlock (ms) (DLCHKTIME) = 10000
Lock timeout (sec) (LOCKTIMEOUT) = -1
Changed pages threshold (CHNGPGS_THRESH) = 60
Number of asynchronous page cleaners (NUM_IOCLEANERS) = AUTOMATIC(3)
Number of I/O servers (NUM_IOSERVERS) = AUTOMATIC(3)
Index sort flag (INDEXSORT) = YES
Sequential detect flag (SEQDETECT) = YES
Default prefetch size (pages) (DFT_PREFETCH_SZ) = 32
Track modified pages (TRACKMOD) = OFF
Default number of containers = 1
Default tablespace extentsize (pages) (DFT_EXTENT_SZ) = 32
Max number of active applications (MAXAPPLS) = AUTOMATIC(60)
Average number of active applications (AVG_APPLS) = AUTOMATIC(1)
Max DB files open per application (MAXFILOP) = 61440
Automatic maintenance (AUTO_MAINT) = ON
Automatic database backup (AUTO_DB_BACKUP) = OFF
Automatic table maintenance (AUTO_TBL_MAINT) = ON
Automatic runstats (AUTO_RUNSTATS) = ON
Automatic statement statistics (AUTO_STMT_STATS) = ON
Automatic statistics profiling (AUTO_STATS_PROF) = OFF
Automatic profile updates (AUTO_PROF_UPD) = OFF
Automatic reorganization (AUTO_REORG) = OFF
Enable XML Character operations (ENABLE_XMLCHAR) = YES
WLM Collection Interval (minutes) (WLM_COLLECT_INT) = 0
Вроде все параметры отвечающие за распределение памяти установили в AUTOMATIC:)
Может быть что-нибудь упустили?

А разве эти параметры не расчитывает сама DB2?
Мы просто пишим using LOCKLISTAUTOMATIC? Т.е надо написать using LOCKLISTAUTOMATIC(20480)?
И это будет значит, что больше этого DB2 не даст, а уменьшить может?

Т.е. правильно будет SELF_TUNNING_MEM=2?

Огромное спасибо!