How to check the running state for all of DBMaker's background processes on Linux? (DBMR2777)

~ 0 min
2016-06-17 04:40

DBMaker has 3 base processes on Linux: BACKUP_SERVER, SERVICE_SERVER and IO_SERVER. Users can use the following SQL statement to confirm the process id (the process id is same with value of the connection_id in table SYSUSER).

dmSQL> select connection_id,user_name from sysuser;

CONNECTION_ID          USER_NAME

================== ================

32433                    SYSADM

32322                    BACKUP_SERVER

32321                    SERVICE_SERVER

32320                    IO_SERVER

4 rows selected

Next time, users can use the following command to conform whether the database is active.

[dbmaker@RD-Redhat62 bin]$ ps -A|grep dmserver

32319 ? 00:00:00 dmserver.bin

32320 pts/0 00:00:00 dmserver.bin

32321 pts/0 00:00:00 dmserver.bin

32322 pts/0 00:00:00 dmserver.bin

32433 ? 00:00:00 dmserver.bin

If a connection is added, the number of processes will has an increase of 1; if a connection is disconnected, the number of processes will reduce by 1. For example, the above 32319 process is an added one.

In addition, if more users connect to db, more daemon processes will be added.

 

Version: All

Product: Normal/Bundle

Platform: Linux

Average rating 0 (0 Votes)

You cannot comment on this entry

Tags