Hi, Thanks for answer
So here all collection I can do to find the problem : The redhat is a Redhat Enterprise 5 with 2.6.18-53.el5 kernel version Here the firmware part : # # Firmware Drivers # CONFIG_EDD=m CONFIG_EFI_VARS=y CONFIG_DELL_RBU=m CONFIG_DCDBAS=m # CONFIG_NOHIGHMEM is not set CONFIG_HIGHMEM4G=y # CONFIG_HIGHMEM64G is not set CONFIG_PAGE_OFFSET=0xC0000000 CONFIG_HIGHMEM=y CONFIG_SELECT_MEMORY_MODEL=y CONFIG_FLATMEM_MANUAL=y # CONFIG_DISCONTIGMEM_MANUAL is not set # CONFIG_SPARSEMEM_MANUAL is not set CONFIG_FLATMEM=y CONFIG_FLAT_NODE_MEM_MAP=y # CONFIG_SPARSEMEM_STATIC is not set CONFIG_SPLIT_PTLOCK_CPUS=4096 CONFIG_RESOURCES_64BIT=y CONFIG_HIGHPTE=y # CONFIG_MATH_EMULATION is not set CONFIG_MTRR=y CONFIG_EFI=y # CONFIG_IRQBALANCE is not set CONFIG_BOOT_IOREMAP=y CONFIG_REGPARM=y # CONFIG_SECCOMP is not set # CONFIG_VGA_NOPROBE is not set # CONFIG_HZ_100 is not set # CONFIG_HZ_250 is not set CONFIG_HZ_1000=y CONFIG_HZ=1000 CONFIG_KEXEC=y CONFIG_CRASH_DUMP=y CONFIG_RELOCATABLE=y CONFIG_PHYSICAL_ALIGN=0x400000 CONFIG_HOTPLUG_CPU=y # CONFIG_COMPAT_VDSO is not set CONFIG_ARCH_ENABLE_MEMORY_HOTPLUG=y The 64 bits resources appear, but I don't think it's the problem So now the debian: It's a debian etch with 2.6.18-6-686 kernel Here the firmware part : # # Firmware Drivers # CONFIG_EDD=m CONFIG_EFI_VARS=m CONFIG_DELL_RBU=m CONFIG_DCDBAS=m # CONFIG_NOHIGHMEM is not set CONFIG_HIGHMEM4G=y # CONFIG_HIGHMEM64G is not set CONFIG_PAGE_OFFSET=0xC0000000 CONFIG_HIGHMEM=y CONFIG_ARCH_FLATMEM_ENABLE=y CONFIG_ARCH_SPARSEMEM_ENABLE=y CONFIG_ARCH_SELECT_MEMORY_MODEL=y CONFIG_SELECT_MEMORY_MODEL=y CONFIG_FLATMEM_MANUAL=y # CONFIG_DISCONTIGMEM_MANUAL is not set # CONFIG_SPARSEMEM_MANUAL is not set CONFIG_FLATMEM=y CONFIG_FLAT_NODE_MEM_MAP=y CONFIG_SPARSEMEM_STATIC=y CONFIG_SPLIT_PTLOCK_CPUS=4 # CONFIG_RESOURCES_64BIT is not set # CONFIG_HIGHPTE is not set # CONFIG_MATH_EMULATION is not set CONFIG_MTRR=y CONFIG_EFI=y CONFIG_IRQBALANCE=y CONFIG_BOOT_IOREMAP=y CONFIG_REGPARM=y # CONFIG_SECCOMP is not set # CONFIG_HZ_100 is not set CONFIG_HZ_250=y # CONFIG_HZ_1000 is not set CONFIG_HZ=250 CONFIG_KEXEC=y # CONFIG_CRASH_DUMP is not set CONFIG_PHYSICAL_START=0x100000 CONFIG_HOTPLUG_CPU=y CONFIG_COMPAT_VDSO=y CONFIG_ARCH_ENABLE_MEMORY_HOTPLUG=y Yeah there is some difference ... perhaps I could try to copy the kernel config of redhat on a debian with the same version of kernel and see ... I will try that So here the DB2 log 2008-03-21-15.56.01.630547+060 E9166G1188 LEVEL: Event PID : 32282 TID : 2986575552 PROC : db2star2 INSTANCE: db2inst1 NODE : 000 FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911 MESSAGE : ADM7513W Database manager has started. START : DB2 DBM DATA #1 : Build Level, 128 bytes Instance "db2inst1" uses "32" bits and DB2 code release "SQL09050" with level identifier "03010107". Informational tokens are "DB2 v9.5.0.0", "s071001", "LINUXIA3295", Fix Pack "0". DATA #2 : System Info, 436 bytes System: Linux test 6 2 i686 CPU: total:2 online:2 Cores per socket:1 Threading degree per core:2 Physical Memory(MB): total:2029 free:702 Virtual Memory(MB): total:6125 free:4798 Swap Memory(MB): total:4096 free:4096 Kernel Params: msgMaxMessageSize:65535 msgMsgMap:65536 msgMaxQueueIDs:1024 msgNumberOfHeaders:65536 msgMaxQueueSize:65536 msgMaxSegmentSize:16 shmMax:268435456 shmMin:1 shmIDs:4096 shmSegments:4096 semMap:32000 semIDs:1024 semNum:32000 semUndo:32000 semNumPerID:250 semOps:32 semUndoSize:20 semMaxVal:32767 semAdjustOnExit:32767 2008-03-21-15.56.03.475024+060 I10355G477 LEVEL: Event PID : 32295 TID : 2977950624 PROC : db2sysc INSTANCE: db2inst1 NODE : 000 APPHDL : 0-7 APPID: *LOCAL.db2inst1.080321145603 AUTHID : DB2INST1 EDUID : 18 EDUNAME: db2agent (instance) FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20 CHANGE : CFG DB TOOLSDB : "Database_memory" From: "20" <automatic> To: "20416" <automatic> 2008-03-21-15.56.47.131581+060 E10833G462 LEVEL: Event PID : 32295 TID : 2967464864 PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : TOOLSDB APPHDL : 0-10 APPID: *LOCAL.DB2.080321145647 AUTHID : DB2INST1 EDUID : 41 EDUNAME: db2stmm (TOOLSDB) FUNCTION: DB2 UDB, Self tuning memory manager, stmmLog, probe:1008 DATA #1 : <preformatted> Starting STMM log from file number 0 2008-03-21-15.56.47.132190+060 E11296G528 LEVEL: Event PID : 32295 TID : 2967464864 PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : TOOLSDB APPHDL : 0-10 APPID: *LOCAL.DB2.080321145647 AUTHID : DB2INST1 EDUID : 41 EDUNAME: db2stmm (TOOLSDB) FUNCTION: DB2 UDB, Self tuning memory manager, stmmLogGetFileStats, probe:565 DATA #1 : <preformatted> New STMM log file (/home/db2inst1/sqllib/db2dump/stmmlog/stmm.0.log) created automatically. 2008-03-21-15.56.48.082845+060 I11825G472 LEVEL: Event PID : 32295 TID : 2974804896 PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : TOOLSDB APPHDL : 0-9 APPID: *LOCAL.db2inst1.080321145646 AUTHID : DB2INST1 EDUID : 25 EDUNAME: db2agent (TOOLSDB) FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20 CHANGE : CFG DB TOOLSDB: "Catalogcache_sz" From: "-1" To: "260" 2008-03-21-15.56.48.083097+060 I12298G470 LEVEL: Event PID : 32295 TID : 2974804896 PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : TOOLSDB APPHDL : 0-9 APPID: *LOCAL.db2inst1.080321145646 AUTHID : DB2INST1 EDUID : 25 EDUNAME: db2agent (TOOLSDB) FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20 CHANGE : CFG DB TOOLSDB: "Chngpgs_thresh" From: "60" To: "80" 2008-03-21-15.56.48.083239+060 I12769G490 LEVEL: Event PID : 32295 TID : 2974804896 PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : TOOLSDB APPHDL : 0-9 APPID: *LOCAL.db2inst1.080321145646 AUTHID : DB2INST1 EDUID : 25 EDUNAME: db2agent (TOOLSDB) FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20 CHANGE : CFG DB TOOLSDB: "Dbheap" From: "1200" <automatic> To: "2442" <automatic> 2008-03-21-15.56.48.083385+060 I13260G479 LEVEL: Event PID : 32295 TID : 2974804896 PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : TOOLSDB APPHDL : 0-9 APPID: *LOCAL.db2inst1.080321145646 AUTHID : DB2INST1 EDUID : 25 EDUNAME: db2agent (TOOLSDB) FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20 CHANGE : CFG DB TOOLSDB: "Locklist" From: "100" To: "2450" <automatic> 2008-03-21-15.56.48.083519+060 I13740G463 LEVEL: Event PID : 32295 TID : 2974804896 PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : TOOLSDB APPHDL : 0-9 APPID: *LOCAL.db2inst1.080321145646 AUTHID : DB2INST1 EDUID : 25 EDUNAME: db2agent (TOOLSDB) FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20 CHANGE : CFG DB TOOLSDB: "Logbufsz" From: "8" To: "98" 2008-03-21-15.56.48.083652+060 I14204G469 LEVEL: Event PID : 32295 TID : 2974804896 PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : TOOLSDB APPHDL : 0-9 APPID: *LOCAL.db2inst1.080321145646 AUTHID : DB2INST1 EDUID : 25 EDUNAME: db2agent (TOOLSDB) FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20 CHANGE : CFG DB TOOLSDB: "Logfilsiz" From: "1000" To: "1024" 2008-03-21-15.56.48.083785+060 I14674G465 LEVEL: Event PID : 32295 TID : 2974804896 PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : TOOLSDB APPHDL : 0-9 APPID: *LOCAL.db2inst1.080321145646 AUTHID : DB2INST1 EDUID : 25 EDUNAME: db2agent (TOOLSDB) FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20 CHANGE : CFG DB TOOLSDB: "Logprimary" From: "3" To: "13" 2008-03-21-15.56.48.083918+060 I15140G463 LEVEL: Event PID : 32295 TID : 2974804896 PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : TOOLSDB APPHDL : 0-9 APPID: *LOCAL.db2inst1.080321145646 AUTHID : DB2INST1 EDUID : 25 EDUNAME: db2agent (TOOLSDB) FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20 CHANGE : CFG DB TOOLSDB: "Logsecond" From: "2" To: "4" 2008-03-21-15.56.48.084052+060 I15604G488 LEVEL: Event PID : 32295 TID : 2974804896 PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : TOOLSDB APPHDL : 0-9 APPID: *LOCAL.db2inst1.080321145646 AUTHID : DB2INST1 EDUID : 25 EDUNAME: db2agent (TOOLSDB) FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20 CHANGE : CFG DB TOOLSDB: "Maxlocks" From: "10" <automatic> To: "60" <automatic> 2008-03-21-15.56.48.084186+060 I16093G491 LEVEL: Event PID : 32295 TID : 2974804896 PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : TOOLSDB APPHDL : 0-9 APPID: *LOCAL.db2inst1.080321145646 AUTHID : DB2INST1 EDUID : 25 EDUNAME: db2agent (TOOLSDB) FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20 CHANGE : CFG DB TOOLSDB: "Num_ioservers" From: "3" <automatic> To: "4" <automatic> 2008-03-21-15.56.48.084338+060 I16585G480 LEVEL: Event PID : 32295 TID : 2974804896 PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : TOOLSDB APPHDL : 0-9 APPID: *LOCAL.db2inst1.080321145646 AUTHID : DB2INST1 EDUID : 25 EDUNAME: db2agent (TOOLSDB) FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20 CHANGE : CFG DB TOOLSDB: "Pckcachesz" From: "-1" To: "1533" <automatic> 2008-03-21-15.56.48.084475+060 I17066G465 LEVEL: Event PID : 32295 TID : 2974804896 PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : TOOLSDB APPHDL : 0-9 APPID: *LOCAL.db2inst1.080321145646 AUTHID : DB2INST1 EDUID : 25 EDUNAME: db2agent (TOOLSDB) FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20 CHANGE : CFG DB TOOLSDB: "Softmax" From: "100" To: "520" 2008-03-21-15.56.48.084609+060 I17532G478 LEVEL: Event PID : 32295 TID : 2974804896 PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : TOOLSDB APPHDL : 0-9 APPID: *LOCAL.db2inst1.080321145646 AUTHID : DB2INST1 EDUID : 25 EDUNAME: db2agent (TOOLSDB) FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20 CHANGE : CFG DB TOOLSDB: "Sortheap" From: "256" To: "630" <automatic> 2008-03-21-15.56.48.084745+060 I18011G473 LEVEL: Event PID : 32295 TID : 2974804896 PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : TOOLSDB APPHDL : 0-9 APPID: *LOCAL.db2inst1.080321145646 AUTHID : DB2INST1 EDUID : 25 EDUNAME: db2agent (TOOLSDB) FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20 CHANGE : CFG DB TOOLSDB: "Util_heap_sz" From: "5000" To: "22240" 2008-03-21-15.56.48.084878+060 I18485G469 LEVEL: Event PID : 32295 TID : 2974804896 PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : TOOLSDB APPHDL : 0-9 APPID: *LOCAL.db2inst1.080321145646 AUTHID : DB2INST1 EDUID : 25 EDUNAME: db2agent (TOOLSDB) FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20 CHANGE : CFG DB TOOLSDB: "Self_tuning_mem" From: "0" To: "1" 2008-03-21-15.56.48.085012+060 I18955G487 LEVEL: Event PID : 32295 TID : 2974804896 PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : TOOLSDB APPHDL : 0-9 APPID: *LOCAL.db2inst1.080321145646 AUTHID : DB2INST1 EDUID : 25 EDUNAME: db2agent (TOOLSDB) FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20 CHANGE : CFG DB TOOLSDB: "Sheapthres_shr" From: "5000" To: "12612" <automatic> 2008-03-21-15.56.48.099365+060 I19443G504 LEVEL: Info PID : 32295 TID : 2974804896 PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : TOOLSDB APPHDL : 0-9 APPID: *LOCAL.db2inst1.080321145646 AUTHID : DB2INST1 EDUID : 25 EDUNAME: db2agent (TOOLSDB) FUNCTION: DB2 UDB, buffer pool services, sqlbAlterBufferPoolAct, probe:90 MESSAGE : Altering bufferpool "IBMDEFAULTBP" From: "1000" To: "66721" <automatic> 2008-03-21-15.56.49.929010+060 E19948G767 LEVEL: Warning PID : 32295 TID : 2974804896 PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : TOOLSDB APPHDL : 0-15 APPID: *LOCAL.db2inst1.080321145652 AUTHID : DB2INST1 EDUID : 25 EDUNAME: db2agent (TOOLSDB) FUNCTION: DB2 UDB, SQO Memory Management, sqloGetSharedMemoryFromOs, probe:2028 MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG "No Storage Available for allocation" DIA8305C Memory allocation failure occurred. DATA #1 : <preformatted> Unable to attach 3 segments totalling 566165504 bytes starting at address 0x00000000. One possible cause may be an improper setting for the shmmax Linux kernel tuneable. 2008-03-21-15.56.49.929656+060 I20716G934 LEVEL: Warning PID : 32295 TID : 2974804896 PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : TOOLSDB APPHDL : 0-15 APPID: *LOCAL.db2inst1.080321145652 AUTHID : DB2INST1 EDUID : 25 EDUNAME: db2agent (TOOLSDB) FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:1516 MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG "No Storage Available for allocation" DIA8305C Memory allocation failure occurred. DATA #1 : String, 286 bytes Failed to allocate the desired database shared memory set. Check to make sure the configured DATABASE_MEMORY + overflow does not exceed the maximum shared memory on the system. Attempting to start up with only the system buffer pools. Desired database shared memory set size is (bytes): DATA #2 : unsigned integer, 4 bytes 566099968 2008-03-21-15.56.49.932224+060 I21651G502 LEVEL: Event PID : 32295 TID : 2974804896 PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : TOOLSDB APPHDL : 0-15 APPID: *LOCAL.db2inst1.080321145652 AUTHID : DB2INST1 EDUID : 25 EDUNAME: db2agent (TOOLSDB) FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20 CHANGE : CFG DB TOOLSDB : "Database_memory" From: "20416" <automatic> To: "55616" <automatic> 2008-03-21-15.56.51.678915+060 E22154G784 LEVEL: Warning PID : 32295 TID : 2974804896 PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : TOOLSDB APPHDL : 0-15 APPID: *LOCAL.db2inst1.080321145652 AUTHID : DB2INST1 EDUID : 25 EDUNAME: db2agent (TOOLSDB) FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2 MESSAGE : ADM6073W The table space "SYSCATSPACE" (ID "0") is configured to use buffer pool ID "1", but this buffer pool is not active at this time. In the interim the table space will use buffer pool ID "4096". The inactive buffer pool should become available at next database startup provided that the required memory is available. ... So the problem appear during the installation process ... I have never see that on the redhat system But when I try to create my db, I have a Cannot allocate share memory just when I try to connect I do a reset config for db, after I can connect, but all buffer are disabled in log file, and so everything run really slowly and crash when I ask too much think So any idea ? Thanks 2008/3/23, Douglas A. Tutty <[EMAIL PROTECTED]>: > > On Mon, Mar 24, 2008 at 12:30:28AM +1300, Chris Bannister wrote: > > On Fri, Mar 21, 2008 at 10:16:52AM +0100, Vincent Bachelier wrote: > > > > Can you explain: > > > > "all main think like HIMEM4G and 64BITS RESOURCE, is sets ..." > > > > Whats this "64BITS RESOURCE"? > > > > Is "uname -a" for redhat == "uname -a" for Debian? > > > > > Or uname -a for AIX? > > Doug. > > > > -- > To UNSUBSCRIBE, email to [EMAIL PROTECTED] > with a subject of "unsubscribe". Trouble? Contact > [EMAIL PROTECTED] > >