Dear Informixers,

yesterday I installed Informix SE for Windows 7.25TC3 Personal Edition
(downloaded from the IIUG website) on my Laptop with XP SP2.

After some trial and error, I am now able to create and access databases
both via the seipcip and the sesoctcp protocols. However, "dbaccess"
hangs whenever I try to process more than around 250 records in a
single statement.

For example, I can load a file containing 250 records with the "load"
statement just fine. It hangs if the file contains 254 records or more,
so the number that works is somewhere in between. Same for "delete"
statements. The database is non-ANSI with logging, it makes no difference
which protocol I am using for connecting to the database.

Any ideas what might cause this, and a remedy?

Regards, Richard

If this was unix i would say the number of locks you have configured
is not sufficient.... dono windowze that well, however you may
give it a go. so try and set that bigger????

maybe someone else has a better answer....

Guy B???

Superboer.

Richard Spitz schreef:
> Dear Informixers,
>
> yesterday I installed Informix SE for Windows 7.25TC3 Personal Edition
> (downloaded from the IIUG website) on my Laptop with XP SP2.
>
> After some trial and error, I am now able to create and access databases
> both via the seipcip and the sesoctcp protocols. However, "dbaccess"
> hangs whenever I try to process more than around 250 records in a
> single statement.
>
> For example, I can load a file containing 250 records with the "load"
> statement just fine. It hangs if the file contains 254 records or more,
> so the number that works is somewhere in between. Same for "delete"
> statements. The database is non-ANSI with logging, it makes no difference
> which protocol I am using for connecting to the database.
>
> Any ideas what might cause this, and a remedy?
>
> Regards, Richard

"Superboer" <superboer7@planet.nl> schrieb:

>If this was unix i would say the number of locks you have configured
>is not sufficient.... dono windowze that well, however you may
>give it a go. so try and set that bigger????

This was my first thought, too, but this is WinXP, and the software
was written for Win2000, so no "AUTOEXEC.BAT" or "CONFIG.SYS" where
I could tweak the FILES and LOCKS Parameters. Besides, there is
nothing in the release notes or the manuals about locks.

Is nobody using SE 7.25TC3 PE on Windows XP?

Regards, Richard

From the keyboard of Richard Spitz
<Richard.Spitz@med.uni-muenchen.de>:

> "Superboer" <superboer7@planet.nl> schrieb:
>
>>If this was unix i would say the number of locks you have
>>configured is not sufficient.... dono windowze that well,
>>however you may give it a go. so try and set that bigger????
>
> This was my first thought, too, but this is WinXP, and the
> software was written for Win2000, so no "AUTOEXEC.BAT" or
> "CONFIG.SYS" where I could tweak the FILES and LOCKS Parameters.

It's *not* the OS parameters, but those of the Informix.
Please read the manuals for the parameter "LOCKS" and check if you
have only 250-something defined in SE's config file.

HTH

Christian
--
#include <std_disclaimer.h>
/* The opinions stated above are my own and not
necessarily those of my employer. */

Christian Knappke <chknews@gmx.net> schrieb:

>It's *not* the OS parameters, but those of the Informix.
>Please read the manuals for the parameter "LOCKS" and check if you
>have only 250-something defined in SE's config file.

Which config file? We are talking about SE and NOT about Dynamic Server.
There is not a single occurence of the word "lock" in the "IBM Informix
SE Installation and Configuration Guide for Microsoft Windows Environ-
ments". The "Setnet32" configuration program also has no parameters that
influence locks, at least AFAIK.

It's been over 10 years since I last worked with SE, and this was in
a Unix environment.

Regards, Richard