Sybase IQ 12.4.0 installation instructions Monitoring server activity

ipcrm -m mid1 -m mid2 ... -s sid1 -s sid2 ...

For example:

%ipcrm -m 40965 -s 5130 -s36682

9.5.16Monitoring server activity

It may be helpful, especially for new users, to monitor server activity. When you start a server with the start_asiq utility, server activity is logged in an ASCII text file placed in the directory defined by $ASLOGDIR. (If $ASLOGDIR is not defined, it defaults to $ASDIR/logfiles.)

The log file name has this format:

your_server_name.###.srvlog

Each time you start the server, the number is incremented. For example, your directory may look like this:

demo.001.srvlog demo.002.srvlog janedemo.001.srvlog

For information about your most recent session, choose the log with the largest number for the desired server. Issue a tail –fcommand to view the log contents. For example:

%tail -f demo.002.srvlog

When you run start_asiq, specify the –Zoption to enhance the log file with additional information about connections. This will help new users or those troubleshooting connection problems.

To check if a particular server is running, log into the machine where it was started, and issue the command:

%ps -eaf grep asiqsrv12

maryc 24836 25554			0	Feb 09	- 17:36
asiqsrv12 -c	16m -gc			6000 -gd all
-gr 6000 -gm	10	-gp 4096 -ti 4400
-tl 300 -iqmt 450			-iqsmem 2560
@fnma.cfg asiqdemo.db
janed 28932 38122			0 11:39:24		- 2:10
asiqsrv12 -c	16m -gc			6000 -gr 6000
-gm 10 -gp 4096		-ti 4400
-tl 300 -iqsmem		2560		-n janedemo -gd all
-iqmt 256 -x tcpip(port=1872)

In addition, the command % stop_asiq will display all Adaptive Server IQ processes running.

47