I've always thought if the system was a Data Warehouse system you want it on other wise turn it off. Paul
-----Original Message----- From: Farah Shire [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 3:17 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [DB2EUG] DIA3601C No memory available in the application heap. 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 - ::: 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
