Re: Informix 4.0 and 4.1 questions (std engine)

In article <19930126.100713.257@almaden.ibm.com> pbenton@vnet.ibm.com writes: >Can anyone help with the following questions ? > >Occasionally, its sqlexec child process terminates. The parent >process traps the SIGCLD (UNIX) signal and executes a siglongjmp() >(UNIX system call) to recovery code (set up with the sigsetjmp() >UNIX system call). The recovery code includes calling sqlexit() >and sqlstart() to clean up and start up a new sqlexec process. >The database is then opened again. However, when the process >again PREPAREs all the SQL statements, Informix returns the error >code -258 "System error--invalid statement ID received by the >sqlexec process". The process tries periodically to PREPARE the >SQL statements until it's successful, but Informix continues to >return the same error code. Only in a few cases did Informix >successfully PREPARE some (but not all) of the SQL statements >after several attempts by the process. You need to issue a CLOSE DATABASE statement to clean up all the structs in the client program. The sqlexit() only terminates the server process - it has no effect on the structures previously allocated in the application. Dave -- Disclaimer: These opinions are not those of Informix Software, Inc. ************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney