Re: ALLBASE/SQL shared memory lock allocation failed in DBCore (149 Views)
Reply
Occasional Advisor
miramardesign
Posts: 10
Registered: ‎07-03-2008
Message 1 of 3 (149 Views)

ALLBASE/SQL shared memory lock allocation failed in DBCore

I am trying to setup a dbe for the odbc driver. It worked for the smaller databases such as macusr and macweb. But when I try macord or macitm, it gives me this error.

>>set sqldbe macitm
>>set turbodb macitm.macsdata.sgaii
>>attach
Split 71 compound s ALLBASE/SQL shared memory lock allocation failed in DBCore.
(DBERR 4008) table/source field name(s) (ATCWARN 32062).
Mapped 1394 incompatible/imprecise source type(s) (ATCWARN 32061).
ALLBASE/SQL shared memory lock allocation failed in DBCore. (DBERR 4008)


I imagine this is a traffic / locked situation or simply because of the large size of the db's in question.
Should I try this again at a really slow hour?
Is there someway I can unlock the db??
Please use plain text.
Honored Contributor
Kwan Fong, Emile
Posts: 1,162
Registered: ‎07-10-2000
Message 2 of 3 (149 Views)

Re: ALLBASE/SQL shared memory lock allocation failed in DBCore

Hi Miramardesign,

The ITRC technical Knowledge base has a document providing some options to fix the DBERR 4008. The document ID is KBRC00003408 (SHARED MEMORY LOCK ALLOCATION FAILED IN DBCORE).

The ALLBASE/SQL is running out of run-time control block space. You may want to increase the runtime control block by using the sqlutil>>altdbe command.
King is the customer!
Please use plain text.
Occasional Advisor
miramardesign
Posts: 10
Registered: ‎07-03-2008
Message 3 of 3 (149 Views)

Re: ALLBASE/SQL shared memory lock allocation failed in DBCore

thanks emile,
So what commands would I call after I start
sqlutil to create a dbe called macitm?
Is this dangerous?
//clueless

SGAII:sqlutil
TUE, JUL 22, 2008, 1:56 PM
HP36216-02A.G3.02 DBE Utility/3000 ALLBASE/SQL
(C)COPYRIGHT HEWLETT-PACKARD CO. 1982,1983,1984,1985,1986,1987,1988,
1989,1990,1991,1992,1993,1994. ALL RIGHTS RESERVED.

>>
Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation