Server Activity Logs

Using commands appropriate for your platform, you can direct Sybase IQ to capture server activity in a log file.

Server Startup Messages

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 example is from an AIX system:

Starting server myserver_iqdemo on myserver at port 3658 (09/06 17:25:23)

Run Directory       : /myserver/users/sybase/iqdemo_154_sep05
Server Executable   : /myserver/users/sybase/154_sep05/IQ-15_4/bin64/iqsrv15
Server Output Log   : /myserver/users/sybase/154_sep05/IQ-15_4/logfiles/iqdemo_3658.0001.srvlog
Server Version      : 15.4.0.6556/Mainline
Open Client Version : N/A
User Parameters     : '@iqdemo.cfg' 'iqdemo.db'
Default Parameters  : -ti 4400 -gn 25

I. 09/06 17:25:26. Sybase IQ
I. 09/06 17:25:26. Version 15.4
I. 09/06 17:25:26. (64bit mode)
I. 09/06 17:25:26. Copyright 1992-2011 by Sybase, Inc. All rights reserved
I. 09/06 17:25:26. Copyright (c) 2001-2011, Sybase, Inc.
I. 09/06 17:25:26. Portions copyright (c) 1988-2011, iAnywhere Solutions, Inc. All rights reserved.
I. 09/06 17:25:26. Use of this software is governed by the Sybase License Agreement.
I. 09/06 17:25:26. Refer to http://www.sybase.com/softwarelicenses.
I. 09/06 17:25:26. 
I. 09/06 17:25:26. Processors detected: 4 (containing 16 logical processors)
I. 09/06 17:25:26. Maximum number of physical processors the server will use: 4
I. 09/06 17:25:26. Running SunOS 5.10 Generic_144489-12 on X86_64
I. 09/06 17:25:26. Server built for X86_64 processor architecture
I. 09/06 17:25:26. 49152K of memory used for caching
I. 09/06 17:25:26. Minimum cache size: 49152K, maximum cache size: 262144K
I. 09/06 17:25:26. Using a maximum page size of 4096 bytes
I. 09/06 17:25:27. Starting database "iqdemo" (/myserver/users/sybase/iqdemo_154_sep05/iqdemo.db) at Tue Sep 06 2011 17:25
I. 09/06 17:25:27. Transaction log: iqdemo.log
I. 09/06 17:25:27. Starting checkpoint of "iqdemo" (iqdemo.db) at Tue Sep 06 2011 17:25
I. 09/06 17:25:27. Finished checkpoint of "iqdemo" (iqdemo.db) at Tue Sep 06 2011 17:25
I. 09/06 17:25:28. Database "iqdemo" (iqdemo.db) started at Tue Sep 06 2011 17:25
I. 09/06 17:25:28. IQ Server iqdemo_3658.
I. 09/06 17:25:28. Database server started at Tue Sep 06 2011 17:25
I. 09/06 17:25:28. Trying to start SharedMemory link ...
I. 09/06 17:25:28.     SharedMemory link started successfully
I. 09/06 17:25:28. Trying to start TCPIP link ...
I. 09/06 17:25:28. Starting on port 3658
I. 09/06 17:25:33.     TCPIP link started successfully
I. 09/06 17:25:33. Now accepting requests
I. 09/06 17:25:45. Database server shutdown due to HUP signal
I. 09/06 17:25:45. TCPIP listener on IP address (::):3658 is exiting
I. 09/06 17:25:45. TCPIP listener on IP address 0.0.0.0:3658 is exiting
I. 09/06 17:25:45. Starting checkpoint of "iqdemo" (iqdemo.db) at Tue Sep 06 2011 17:25
I. 09/06 17:25:45. Finished checkpoint of "iqdemo" (iqdemo.db) at Tue Sep 06 2011 17:25
I. 09/06 17:25:46. Database server stopped at Tue Sep 06 2011 17:25

The start_iq Log File

When you start a server with the start_iq utility, server activity is logged in an ASCII text file placed in the directory defined by $IQLOGDIR15.This file contains the standard output from the server and the server status.

The log file name has this format:

your_server_name.nnnn.srvlog

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

demo.0001.srvlog   demo.0002.srvlog
testdemo.0001.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.0002.srvlog

If you don’t define $IQLOGDIR15 directory, then on UNIX, the log is written to $IQDIR15/logfiles/ directory, and on Windows to the$IQLOGDIR15 directory defined by the Sybase IQ installation.

When you run start_iq, 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 iqsrv

This output differs slightly across UNIX platforms. For IBM AIX, the columns are:

UID   PID  PPID   C    STIME TTY         TIME CMD

For example:

jones  422034      1   0 17:47:36      -  0:04
/ibm64srv/users/sybase/iq152/IQ-15_4/bin64/
iqsrv15
@iqdemo.cfg iqdemo.db -ti 4400 -gn 25 -o
/ibm64srv/users/sybase/iq154/IQ-
15_4/logfiles/ibm64srv_iqdemo.0003.srvlog -hn 7

Use the stop_iq 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.