Hi;
I'm getting an error in db2diag.log saying "DIA3601C No memory available in
the application heap."
accourding to my db cfg for <db_name> have this :
Database heap (4KB) (DBHEAP) = 10000
Catalog cache size (4KB) (CATALOGCACHE_SZ) = 5000
Log buffer size (4KB) (LOGBUFSZ) = 1024
Utilities heap size (4KB) (UTIL_HEAP_SZ) = 5000
Buffer pool size (pages) (BUFFPAGE) = 1000
Extended storage segments size (4KB) (ESTORE_SEG_SZ) = 16000
Number of extended storage segments (NUM_ESTORE_SEGS) = 0
Max storage for lock list (4KB) (LOCKLIST) = 1000
Max appl. control heap size (4KB) (APP_CTL_HEAP_SZ) = 5000
Sort list heap (4KB) (SORTHEAP) = 3000
SQL statement heap (4KB) (STMTHEAP) = 10000
Default application heap (4KB) (APPLHEAPSZ) = 20000
Package cache size (4KB) (PCKCACHESZ) = 6000
Statistics heap size (4KB) (STAT_HEAP_SZ) = 5000
Also in my DBM cfg file I don't have intra_parallelism is turn on. Should
truning this on will be a good idea. My system is EE.
Farah Shire
Database Administration - IBM Global Services
[EMAIL PROTECTED]
(704) 594-8241 or T/L 794-8241
Pager 1-800-759-8352 PIN 1875048#
(NONE OF US IS GOOD AS ALL OF US!!!)
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
