Re: dbexport error 208 (mem. alloc error)

Jan Blok writes: |> When we try to use dbexport on an Informix-Online 5.0 database with a few |> hundred tables ( running on Unix system-V release 3.1 ) we get after about |> 45-60 min. ERROR 208 with the message : |> |> "MEMORY ALLOCATION FAILURE DURING QUERY PROCESSING". |> |> ( BTW: we get the same error when we try to create a dbschema ) |> |> We already tried without success to increase the following parameter in |> the UNIX kernel : SHMMNI increased from 100 to 200 . |> SHMMAX is at 0x7fffff |> SHMSEG is at 40 |> ( which, I believe, makes SHMMAX * SHMSEG = 320 Mb per process ). |> ( SHMMIN is set to 1 ) |> |> In tbmonitor we have about 24 Mb shared memory allocated. Your changes won't affect your problem, as the -208 does not refer to shared memory but rather to conventional process memory. You might look for a kernel tuneable like MAXUMEM or the like. You can also monitor the process growth using ps. Look for both dbexport and the corresponding sqlturbo. Dave Disclaimer: The opinions expressed in this message are not those of Informix Software, its partners or lackeys. Anyone who says otherwise is itching for a fight. **************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney