Re: IBM DB2 V9.5 32 bits failed to allocate share memory
Ok with the same kernel option set in a debian kernel like this :
apt-get source linux-image-`uname -r`
cp -r linux-`uname -r` linux-`echo $REDHAT_VERSION`
ln -s linux-`echo $REDHAT_VERSION` linux
cd linux
cp ~/config-`echo $REDHAT_VERSION` .config
echo "" | make oldconfig
make -kpkg --initrd kernel_image
So nothing change
I have disabled completly selinux (it was in alert mode only), nothing
change
See anything else ?
Strong Cypher a écrit :
> 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 <dtutty@porchlight.ca>:
>
>> 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 debian-user-REQUEST@lists.debian.org
>> with a subject of "unsubscribe". Trouble? Contact
>> listmaster@lists.debian.org
>>
>>
>>
>
>
Reply to: