It may be helpful, especially for new users, to monitor server activity. Using commands appropriate for your platform, you can direct Sybase IQ to capture server activity in a log file.
When you start an IQ server, a series of messages appears in the server log window. The exact set of messages you see depends on your platform and licensed options. The following is an example of what you see on Solaris:
Starting server iq_8888 on iqsun at port 8888 Run Directory : /iqsun1/sybase_127/ASIQ-12_7/demo Server Executable : /iqsun1/sybase_127/ASIQ-12_7/bin/asiqsrv12 Server Output Log : /iqsun1/sybase_127/ASIQ-12_7/logfiles/iq_8888.001.srvlog Server Version : 12.7.0/Mainline Open Client Version : 12.5.1/P User Parameters : @asiqdemo.cfg asiqdemo.db Default Parameters : -c 48m -gc 20 -gd all -gl all -gm 10 -gp 4096 -ti 4400 -gn 25 I. 08/05 18:39:32. Adaptive Server IQ I. 08/05 18:39:32. Version 12.7 I. 08/05 18:39:32. (64bit mode) I. 08/05 18:39:32. Copyright 1992-2006 by Sybase, Inc. All rights reserved I. 08/05 18:39:32. I. 08/05 18:39:32. Running on SunOS 5.8 Generic_117000-03 I. 08/05 18:39:32. 49152K of memory used for caching I. 08/05 18:39:32. Minimum cache size: 49152K, maximum cache size: 262008K I. 08/05 18:39:32. Using a maximum page size of 4096 bytes I. 08/05 18:39:34. Starting database "asiqdemo" (/iqsun1/sybase_126/ASIQ-12_7/demo/asiqdemo.db) at Thu Aug 05 2004 18:39 I. 08/05 18:39:35. Transaction log: asiqdemo.log I. 08/05 18:39:45. TCPIP link started successfully I. 08/05 18:39:45. Now accepting requests New process id is 124Server started successfully
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.This file contains the standard output from the server and the server status.
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 –f command to view the log contents. For example:
% tail -f demo.002.srvlog
If you don’t specify a log file name or IQ cannot find the server name, the log is written to $ASLOGDIR/start_asiq.log. If $ASLOGDIR is not defined, the log is written to $ASDIR/logfiles/start_asiq.log.
When you run start_asiq, specify the -z option to enhance the log file with additional information about connections. This will help new users or those troubleshooting connection problems.
On UNIX systems, there are two ways to check if a particular server is running:
Log into the machine where the server was started, and issue the command:
ps -eaf | grep start_asiq
This command returns the commands used to start the various servers, as follows:
maryc 24836 25554 0 Feb 09 - 17:36 start_asiq -c 48m -gd all -gl all -gm 10 -gp 4096 -ti 4400 -tl 300 -iqmt 450 @fnma.cfg asiqdemo.db janed 28932 38122 0 11:39:24 - 2:10 start_asiq -c 48m -gl all -gm 10 -gp 4096 -ti 4400 -tl 300 -n janedemo -gd all -iqmt 256 -x tcpip(port=1872)
Use the stop_asiq utility, described in the following section, which displays all Sybase IQ processes running.
On Windows systems, look in the system tray for one or more Sybase IQ icons. Place the cursor over each icon and read the server name.
Use the -o parameter on the start_asiq startup command to name the server log file, rather than using the default name of server.###.srvlog. For example, to save output to a file named results, start the server as follows:
start_asiq -n imyserver -o results
On UNIX platforms, an additional log file captures operating system output, including stdout and stderr output.
The file name has this format:
your_server_name.###.stderr
On UNIX systems, the name of the file that contains stack trace information has this format:
stktrc-YYYYMMDD-HHNNSS_#.iq
