Perform mask crashes Online 7.1!
Posted in 1995
Dear Informix experts, a colleague of mine is experiencing a nightmare after upgrading from Online 6.0 to 7.1 A perform mask which is running without problems under 6.0 is crashing the whole 7.1 engine. Apparently, more and more shared memory is allocated until none is left, resulting in Online aborting and leaving a huge core file. The machine is a Siemens-Nixdorf RM400 running SINIX 5.42, and the crash could even be reproduced by SNI support on a multiprocessor RM600. There seems to be an option in SQL like "set optimizer=low" which eliminates the problem, but this option doesn't affect ISQL/Perform (Version 6.00.UE1) Is this problem known on any other systems? Are there any workarounds? Following is the Perform sourcecode for the mask: ------------------------ CUT HERE ------------------------------------------ database quadra screen size 24 by 80 { ------------------------------------------------------------------------------- QUADRA - Quality Data Review Analysis Zusammenstellung der Daten Seite 1 ------------------------------------------------------------------------------- Fall-Nr.: [f00 ] Dateinr.: [f100 ] Kliniknr.: [f199 ] Name: [f01 ] Vorname: [f02 ] Anamnese-Nr.: [f03 ] Herzkathather-Nr.: [f04 ] OP-Nr.: [f05 ] Koronar-Nr.: [f06 ] Aortenklappen-Nr.: [f07 ] Mitralklappen-Nr.: [f08 ] Tricuspidalklappen-Nr.: [f09 ] Aneurysma-Nr.: [f10 ] Kongenitale-Nr.: [a1 ] Intensiv-Nr.: [f11 ] Verlegungs-Nr.: [f12 ] Entlassungs-Nr.: [f13 ] Nachuntersuchungs-Nr.: [f14 ] Schrittmacher-Nr.: [f15 ] Biopsie-Nr.: [f16 ] } end tables kvbasis anamnese aoklchir miklchir trklchir verleg opproto entlassung intensiv kaimpl smimpl kongen hkath nachunter aneuchir korochir end attributes f100 = kvbasis.k5dateinummer, required, lookup f03 = anamnese.a1annummer, joining anamnese.a1dateinummer, lookup f04 = hkath.h2hkanummer, joining hkath.h2dateinummer, lookup f05 = opproto.o1oppnummer, joining opproto.o1dateinummer, lookup f06 = korochir.k4kornummer, joining korochir.k4dateinummer, lookup f07 = aoklchir.a3aoknummer, joining aoklchir.a3dateinummer, lookup f08 = miklchir.m1miknummer, joining miklchir.m1dateinummer, lookup f09 = trklchir.t3trknummer, joining trklchir.t3dateinummer, lookup f10 = aneuchir.a2anenummer, joining aneuchir.a2dateinummer, lookup a1 = kongen.k3konnummer, joining kongen.k3dateinummer, lookup f11 = intensiv.i2intnummer, joining intensiv.i2dateinummer, lookup f12 = verleg.v1verlegnummer, joining verleg.v1dateinummer, lookup f13 = entlassung.e1entnummer, joining entlassung.e1dateinummer, lookup f14 = nachunter.n1nanummer, joining nachunter.n1dateinummer, lookup f15 = smimpl.s2smnummer, joining smimpl.s2dateinummer, lookup f16 = kaimpl.k1kanummer, joining kaimpl.k1dateinummer; f00 = kvbasis.k5fall_nr; f199 = kvbasis.k5kliniknummer; f01 = kvbasis.k5name; f02 = kvbasis.k5vorname; ---------------------------------- CUT HERE --------------------------------- Any help appreciated, Richard -- +----------------------------+-------------------------------------------+ | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3421 | | Klinikum Grosshadern | FAX : +49-89-7095-8886 | | 81366 Munich, Germany | | +----------------------------+-------------------------------------------+