Very Computer

by **al-jouha** » Wed, 01 Feb 1995 18:29:37

Hi INFORMIX'ers,

how would U define :
user process
database server process
application process

when a user access online thru fglgo
in UNIX ps -u user-id it shows sqlturbo as a process running
for that user-id, and also 4 anonther user running isql,
what would be (i.e. user process, application process, or
database server process)

many thanks in advance.......

by **Richard Spi** » Sat, 04 Feb 1995 18:26:38

: how would U define :
: user process
: database server process
: application process

I don't know exactly what you mean by "user process" and "application
process". In my understanding, when a user starts an application that
accesses the Informix database, two processes are started: The application
(frontend) process and the database server (backend) process, which is
either "sqlexec" or "sqlturbo" (SE or Online, respectively).

Since both processes are started by the user, they show up in the
process table under the user's id.

Regards, Richard
--
+----------------------------+-------------------------------------------+

| EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3421 |
| Klinikum Grosshadern | FAX : +49-89-7095-8886 |
| 81366 Munich, Germany | |
+----------------------------+-------------------------------------------+

by **Malcolm Weallan** » Tue, 07 Feb 1995 05:58:37

Quote:> Hi INFORMIX'ers,
> > how would U define :

Basically each INFORMIX end-user uses two processes to access the data in
the database. A user process and a database server process. These are
also often referred to as the front-end and the back-end, and by some as
the client and the server. Spme people also refer to them as application
and engine processes.

Quote:> user process

Any process providing the interface between the user and the computer.
e.g. ISQL, a 4GL application, an ESQL application
> database server process

A process providing access to the database data. This would include
SQLEXEC, and SQLTURBO. (N.B. Many of the utilities - tblog, tbcheck,
etc., would also count as database server processes as they access the
database data directly)

Quote:> application process

The definition of this is as per user process and the two are synonymous.

Quote:> > when a user access online thru fglgo
> in UNIX ps -u user-id it shows sqlturbo as a process running
> for that user-id, and also 4 anonther user running isql,
> what would be (i.e. user process, application process, or
> database server process)
> > many thanks in advance.......

Malcolm Weallans
Online Database Consultancy
2 Arkley Court
Maidenhead
Berks
SL6 2YR
Phone 0628-72154
Fax 0628-37463
CIX - onlinedbc

Very Computer

user process,server process,application process

user process,server process,application process

user process,server process,application process

user process,server process,application process