Problem with SE 7.25TC3 for Windows
Richard Spitz installed SE 7.25TC3 Personal Edition on Windows XP SP2; dbaccess hangs when a single statement processes more than about 250 records. Superboer suggested the configured locks might be too low, but Richard found no way to set them on XP and nothing in the docs. The last reply was empty, so it was unresolved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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
\