sqlturbo processes don't go away
Posted in 1996
Topics: Installation, Setup & Upgrades, Stored Procedures & SPL, Connectivity: ESQL/C, 4GL & Embedded SQL
I have a question..... It appears that I have many sqlturbo process running which should not be. I was reading about how when running INFORMIX-OnLine, an sqlturbo process will be spawned to work with my application process. I understand this, but something doesn't seem right. I read the following in the "INFORMIX-NET/INFORMIX-STAR User Guide" "The database engine process is active for the duration of the connection. You terminate the sqlexec or sqlturbo process when you finish running your application or when you issue a CLOSE DATABASE statement. Each request from a client receives its own database engine process." If I have a simple program like the following, I get no sqlturbo. MAIN WHILE TRUE DISPLAY "HELLO WORLD" SLEEP 1 END WHILE END MAIN If I add a database to this, I get the sqlturbo until the program stops. DATABASE TEST MAIN WHILE TRUE DISPLAY "HELLO WORLD" SLEEP 1 END WHILE CLOSE DATABASE END MAIN With the following I would expect the sqlturbo to start and end when I issue the CLOSE DATABASE - but it doesn't. The sqlturbo stays until the application program is terminated. DATABASE TEST MAIN CLOSE DATABASE WHILE TRUE DISPLAY "HELLO WORLD" SLEEP 1 END WHILE END MAIN Does anyone know what would cause this? Do I really have a problem or am I missing something? Thanks in advance Rob Scott .........installed software...................................... INFORMIX EMBEDDED SQL Run Time Facility Version 4.12.UC1 INFORMIX-4GL Run Time Facility Version 4.11.UC2 INFORMIX-SQL Run Time Facility Version 4.11.UC1 INFOMRIX-OnLine Version 5.02.UC7 INFOMRIX-STAR Version 5.02.UC7 SYSTEM: UNIX R40V4.2 m88k mc88110 -- Robert Scott Robert_Scott@csg.mot.com Motorola Inc. Phone: (847) 523-8106 600 N. U.S. RTE 45 Fax: (847) 523-8163 Libertyville, IL 60048 Pager: 7094