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 AIX:
Starting server myserver_iqdemo on myserver at port 2638 (05/22 16:18:58) Run Directory : /myserver/users/sybase/iq153/IQ-15_3/demo Server Executable : /myserver/users/sybase/iq153/IQ-15_3/bin64/iqsrv15 Server Output Log : /myserver/users/sybase/iq153/IQ 15_3/logfiles/myserver_iqdemo.0001.srvlog Server Version : 15.3.0.5027/GA Open Client Version : 15.0/P-EBF16070 ESD #15 User Parameters : '@iqdemo.cfg' 'iqdemo.db' Default Parameters : -ti 4400 -gn 25 I. 05/22 16:19:05. Sybase IQ I. 05/22 16:19:05. Version 15.3 I. 05/22 16:19:05. (64bit mode) I. 05/22 16:19:05. Copyright 1992-2010 by Sybase, Inc. All rights reserved I. 05/22 16:19:05. I. 05/22 16:19:05. 4 physical processor(s) detected. I. 05/22 16:19:05. Maximum number of physical processors the server will use: 4 I. 05/22 16:19:05. Running AIX 5 3 on PPC I. 05/22 16:19:05. Server built for PPC processor architecture I. 05/22 16:19:05. 49152K of memory used for caching I. 05/22 16:19:05. Minimum cache size: 49152K, maximum cache size: 262144K I. 05/22 16:19:05. Using a maximum page size of 4096 bytes I. 05/22 16:19:05. Starting database "iqdemo" (/myserver/users/sybase/iq151/IQ-15_3/demo/iqdemo.db) at Fri May 22 2009 16:19 ============================================================= IQ server starting with: 10 connections ( -gm ) 18 cmd resources ( -iqgovern ) 267 threads ( -iqmt ) 512 Kb thread stack size ( -iqtss ) 136704 Kb thread memory size ( -iqmt * -iqtss ) 4 IQ number of cpus ( -iqnumbercpus ) 0 MB maximum size of IQMSG file ( -iqmsgsz ) 0 copies of IQMSG file archives ( -iqmsgnum )============================================================= I. 05/22 16:19:07. Transaction log: iqdemo.log I. 05/22 16:19:08. Starting checkpoint of "iqdemo" (iqdemo.db) at Fri May 22 2009 16:19 I. 05/22 16:19:08. Finished checkpoint of "iqdemo" (iqdemo.db) at Fri May 22 2009 16:19 ============================================================= IQ server starting with: 10 connections ( -gm ) 18 cmd resources ( -iqgovern ) 267 threads ( -iqmt ) 512 Kb thread stack size ( -iqtss ) 136704 Kb thread memory size ( -iqmt * -iqtss ) 4 IQ number of cpus ( -iqnumbercpus ) 0 MB maximum size of IQMSG file ( -iqmsgsz ) 0 copies of IQMSG file archives ( -iqmsgnum ) ============================================================= I. 05/22 16:19:07. Transaction log: iqdemo.log I. 05/22 16:19:08. Starting checkpoint of "iqdemo" (iqdemo.db) at Fri May 22 2009 16:19 I. 05/22 16:19:08. Finished checkpoint of "iqdemo" (iqdemo.db) at Fri May 22 2009 16:19I. 05/22 16:19:10. Database "iqdemo" (iqdemo.db) started at Fri May 22 2009 16:19 I. 05/22 16:19:10. IQ Server myserver_iqdemo. I. 05/22 16:19:10. Database server started at Fri May 22 2009 16:19 I. 05/22 16:19:10. Trying to start SharedMemory link ... I. 05/22 16:19:10. SharedMemory link started successfully I. 05/22 16:19:10. Trying to start TCPIP link ... I. 05/22 16:19:15. TCPIP link started successfully I. 05/22 16:19:15. Now accepting requests
New process id is 397436 Server started successfully
I. 05/20 22:11:26. Starting database "iqdemo" (/testproduction/users/miller/setup_main/iqdemo.db) at Wed May 20 2009 22:11 I. 05/20 22:11:27. Transaction log: iqdemo.log I. 05/20 22:11:27. Starting checkpoint of "iqdemo" (iqdemo.db) at Wed May 20 2009 22:11 I. 05/20 22:11:27. Finished checkpoint of "iqdemo" (iqdemo.db) at Wed May 20 2009 22:11 I. 05/20 22:11:28. Database "iqdemo" (iqdemo.db) started at Wed May 20 2009 22:11 I. 05/20 22:11:28. IQ Server iqdemo1. I. 05/20 22:11:28. Database server started at Wed May 20 2009 22:11 I. 05/20 22:11:28. Trying to start SharedMemory link ... I. 05/20 22:11:28. SharedMemory link started successfully I. 05/20 22:11:28. Trying to start TCPIP link ... I. 05/20 22:11:28. Starting on port 2638 I. 05/20 22:11:33. TCPIP link started successfully I. 05/20 22:11:33. Now accepting requests I. 05/20 22:11:33. Press 'q' to shut down the database server I. 05/20 22:11:35. Database server shutdown requested by pressing Q I. 05/20 22:11:35. Starting checkpoint of "iqdemo" (iqdemo.db) at Wed May 20 2009 22:11 I. 05/20 22:11:35. Finished checkpoint of "iqdemo" (iqdemo.db) at Wed May 20 2009 22:11 I. 05/20 22:11:35. Database server stopped at Wed May 20 2009 22:11
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.
your_server_name.nnnn.srvlogEach 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
% 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.
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_3/bin64/ iqsrv15 @iqdemo.cfg iqdemo.db -ti 4400 -gn 25 -o /ibm64srv/users/sybase/iq152/IQ- 15_3/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.