Oninit cdi / Archive
Talk to an expert →

Error allocating temporary clob file on Innovator

Posted in 2017

Topics: Licensing & Editions

FLAVIO — — source: IIUG Forums & Mailing Lists

Hello! We're getting Error: 8359: Function (extractvalueclob) Error allocating temporary clob file. trying to use SELECT EXTRACTVALUE(xml,'/doc/number') FROM TABLE_WITH_A_XML_COLUMN. In the online.log we got the message: Warning: The IBM IDS Innovator-C Edition license restriction limits the total shared memory size for this server to 2097152 KB. Size of resident + virtual segments 120212 KB + 1985132 KB > 2097152 KB. Size of resident + virtual segments 120212KB + 1985132KB > 2097152KB total allowed by configuration parameter SHMTOTAL Even restarting the instance. Onstat -g seg shows: Segment Summary: id key addr size ovhd class blkused blkfree 655360 52564801 44000000 123097088 1875896 R 30051 2 688129 52564802 4b565000 2024386560 23725080 V 16412 477823 Total: - - 2147483648 - - 46463 477825 I've also tryied export LOBCACHE=0 Could anybody help me, plz?

↪ replying to FLAVIO
Fernando — — source: IIUG Forums & Mailing Lists

The "Warning: The IBM IDS Innovator-C Edition license restriction limits" message will be printed out in online.log everytime the engine starts, if you're exceeding those IE limits. The engine will fix that for you, lowering whatever SHMVIRTSIZE+BUFFERPOOLs you set to its boundaries (2GB). Pls, send the complete Informix server version/release and OS specifics. I can see this is an Innovator-C Edition but whatelse? Regards, Fernando F Oliveira Chief Technology Officer ffo@digicorpsystems.com<mailto:ffo@digicorpsystems.com> DIGICORP SYSTEMS +55 (11) 30990477 | +55 (11) 994082607 Avenida Paulista, 777 15o. Andar 01311-100 Sao Paulo - Brasil ________________________________ De: ids-bounces@iiug.org <ids-bounces@iiug.org> em nome de FLAVIO CARDOSO <flavio@null.net.br> Enviado: quarta-feira, 30 de agosto de 2017 11:28:52 Para: ids@iiug.org Assunto: Error allocating temporary clob file on Innovator [39792] Hello! We're getting Error: 8359: Function (extractvalueclob) Error allocating temporary clob file. trying to use SELECT EXTRACTVALUE(xml,'/doc/number') FROM TABLE_WITH_A_XML_COLUMN. In the online.log we got the message: Warning: The IBM IDS Innovator-C Edition license restriction limits the total shared memory size for this server to 2097152 KB. Size of resident + virtual segments 120212 KB + 1985132 KB > 2097152 KB. Size of resident + virtual segments 120212KB + 1985132KB > 2097152KB total allowed by configuration parameter SHMTOTAL Even restarting the instance. Onstat -g seg shows: Segment Summary: id key addr size ovhd class blkused blkfree 655360 52564801 44000000 123097088 1875896 R 30051 2 688129 52564802 4b565000 2024386560 23725080 V 16412 477823 Total: - - 2147483648 - - 46463 477825 I've also tryied export LOBCACHE=0 Could anybody help me, plz? ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to FLAVIO
Andreas — — source: IIUG Forums & Mailing Lists

This error indicates a problem with creating a (temporary) file in file system. On Unix/Linux this would be /tmp/blobfile. -> check whether such file might be in your way. From: "FLAVIO CARDOSO" <flavio@null.net.br> To: ids@iiug.org Date: 08/30/2017 04:29 PM Subject: Error allocating temporary clob file on Innovator [39792] Sent by: ids-bounces@iiug.org Hello! We're getting Error: 8359: Function (extractvalueclob) Error allocating temporary clob file. trying to use SELECT EXTRACTVALUE(xml,'/doc/number') FROM TABLE_WITH_A_XML_COLUMN. In the online.log we got the message: Warning: The IBM IDS Innovator-C Edition license restriction limits the total shared memory size for this server to 2097152 KB. Size of resident + virtual segments 120212 KB + 1985132 KB > 2097152 KB. Size of resident + virtual segments 120212KB + 1985132KB > 2097152KB total allowed by configuration parameter SHMTOTAL Even restarting the instance. Onstat -g seg shows: Segment Summary: id key addr size ovhd class blkused blkfree 655360 52564801 44000000 123097088 1875896 R 30051 2 688129 52564802 4b565000 2024386560 23725080 V 16412 477823 Total: - - 2147483648 - - 46463 477825 I've also tryied export LOBCACHE=0 Could anybody help me, plz? ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary