Dostats returning SQLCODE = -312, ISAM = -107

Posted in 2007

Topics: Error Codes & Troubleshooting, Connectivity: ESQL/C, 4GL & Embedded SQL, Versions, Editions & End-of-Life

RoB — Mon, 22 Oct 2007 03:30:08 -0700 — source: Usenet: comp.databases.informix

Hi all, We're frequently getting SQLCODE = -312, ISAM = -107 when running "dostats -d <dbname> -e" during quiet hours. I'm wondering if there's a nicer workaround than adding "SET LOCK MODE TO WAIT 30" in the esql code and recompile. I couldn't find any such statement in there. Is there perhaps a newer version of dostats that already addresses this issue? I'd guess that running dostats using shm-connection could avoid this problem (as it runs only on concurrent thread) but we wouldn't want to remove the parallelism as the complete run already takes longer than we want it to. dostats -V dostats: Features Version 4.6, Source Revision: 1.43 ! IDS 10.00.FC5 Linux RHEL AS 4 Any help appreciated! /RoB

↪ replying to RoB

Art S. Kagel — Mon, 22 Oct 2007 15:18:38 -0000 — source: Usenet: comp.databases.informix

On Oct 22, 6:30 am, RoB <pluma...@gmail.com> wrote: > Hi all, > > We're frequently getting SQLCODE = -312, ISAM = -107 when running > "dostats -d <dbname> -e" during quiet hours. I'm wondering if there's > a nicer workaround than adding "SET LOCK MODE TO WAIT 30" in the esql > code and recompile. I couldn't find any such statement in there. Is > there perhaps a newer version of dostats that already addresses this > issue? > > I'd guess that running dostats using shm-connection could avoid this > problem (as it runs only on concurrent thread) but we wouldn't want to > remove the parallelism as the complete run already takes longer than > we want it to. > > dostats -V > dostats: Features Version 4.6, Source Revision: 1.43 ! > > IDS 10.00.FC5 > Linux RHEL AS 4 > > Any help appreciated! > > /RoB In the next release of utils2_ak dostats will support a new option, - w, as will dbdelete, to specify the wait behavior. Currently dostats includes SET LOCK MODE TO WAIT 10; you can easily change it to WAIT 30 or wait for the next release. -- soon! Art S. Kagel

↪ replying to Art S. Kagel

RoB — Mon, 22 Oct 2007 08:30:22 -0700 — source: Usenet: comp.databases.informix

On Oct 22, 4:18 pm, "Art S. Kagel" <art.ka...@gmail.com> wrote: > On Oct 22, 6:30 am, RoB <pluma...@gmail.com> wrote: > > > > > > > Hi all, > > > We're frequently getting SQLCODE = -312, ISAM = -107 when running > > "dostats -d <dbname> -e" during quiet hours. I'm wondering if there's > > a nicer workaround than adding "SET LOCK MODE TO WAIT 30" in the esql > > code and recompile. I couldn't find any such statement in there. Is > > there perhaps a newer version of dostats that already addresses this > > issue? > > > I'd guess that running dostats using shm-connection could avoid this > > problem (as it runs only on concurrent thread) but we wouldn't want to > > remove the parallelism as the complete run already takes longer than > > we want it to. > > > dostats -V > > dostats: Features Version 4.6, Source Revision: 1.43 ! > > > IDS 10.00.FC5 > > Linux RHEL AS 4 > > > Any help appreciated! > > > /RoB > > In the next release of utils2_ak dostats will support a new option, - > w, as will dbdelete, to specify the wait behavior. > > Currently dostats includes SET LOCK MODE TO WAIT 10; you can easily > change it to WAIT 30 or wait for the next release. -- soon! > > Art S. Kagel- Hide quoted text - > > - Show quoted text - Great! I'll eagerly await the new release. Thanks! /RoB

Glossary

ESQL/C