Kill a Backend

Informix OnLine versions earlier than 6.0 maintain a two-process architecture. Whenever a tool such as I-SQL or ESQL/C or I-4GL makes a request of the database, the tool is considered a client process. This client process spawns a server process that does the actual access to the database. This server process is called a "backend" process.

OnLine takes great pains to ensure the consistency of the data in the database. Whenever something occurs that could potentially destroy this consistency, OnLine will immediately abort. When the database is restarted, the fast recovery process will roll back any processes that are not completed and would therefore cause the inconsistency.

One of the major actions that can cause the database to ...

Get Informix DBA Survival Guide, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.