out of memory error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David Greenberg - 13 Apr 2008 15:34 GMT

Hi
I'm getting the error message ....

E_SC0204 Error allocating memory

Anyone know which memory parameter I need to update in CBF ?

Thanks 1

David Greenberg

Reply to this Message

jpzuate@gmail.com - 16 Apr 2008 14:37 GMT

Hello,

Depend on your Ingres version & OS but, on HP boxes, it come because
you need to run Ingres with Internal threads (vs system threads).

Doing this by :
- ingstop
- ingsetenv II_THREAD_TYPE internal
- ingsetenv II_NUM_SLAVER number
- ingstart

number of slaves depend on your activity. 4 to 6 can be a good start.
After a period (day, week, etc), see how many iislaves processes are
not using system (ps -ef) and adjust II_NUM_SLAVES

Hope this help
Jean-Pierre

David Greenberg a écrit :

> Hi
> I'm getting the error message ....
[quoted text clipped - 6 lines]
>
> David Greenberg

Reply to this Message

OldSchool - 16 Apr 2008 16:42 GMT

On Apr 16, 9:37 am, "jpzu...@gmail.com" <jpzu...@gmail.com> wrote:

> Hello,
>
> Depend on your Ingres version & OS but, on HP boxes, it come because
> you need to run Ingres with Internal threads (vs system threads).

Not so....it depends on the which version of HP-UX. I've successfully
run IngresII 2.0/2.5/2.6 in HP-UX 11.0 and up. It does take some
careful tuning of logging, write-behinds and such to get it to run
reliably in that config. I tried running internal threads on the same
box / os and the performance was abysmal

Reply to this Message