Re: IBM DB2 V9.5 32 bits failed to allocate share memory
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: