Oninit cdi / Archive
Talk to an expert →

Suspended sessions problem

Posted in 2001

Topics: Error Codes & Troubleshooting, Connectivity: ESQL/C, 4GL & Embedded SQL, Logging & Checkpoints

Leonid Belov — — source: Informix-list mailing list archive (1991-1998)

Hello all, I have a problem with sessions suspended by server. When logical logs are full and server is wating for backup media, any query from client to server will be suspended by default. I need to obtain some error code instead of it and continue client execution. Is it possible on ESQL-C (Client SDK) Any help would be appreciated. Leonid

↪ replying to Leonid Belov
Jonathan Leffler — — source: Informix-list mailing list archive (1991-1998)

Leonid Belov wrote: > I have a problem with sessions suspended by server. > When logical logs are full and server is wating for backup media, > any query from client to server will be suspended by default. > I need to obtain some error code instead of it and continue > client execution. Is it possible on ESQL-C (Client SDK) > > Any help would be appreciated. Read up on sqlbreakcallback(), and the related functions sqlbreak() and sqldone(). Also, why is your system so misconfigured that you can have the logical logs full and the system hanging waiting for backup media? What are you going to do instead of accessing the database? Tell the client that the database is temporarily unavailable? -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"

Glossary