In some cases the utility_db cannot be started due to the following error:
I. 04/20 02:18:25. Adaptive Server IQ
I. 04/20 02:18:25. Version 12.7
I. 04/20 02:18:25. (64bit mode)
I. 04/20 02:18:25. Copyright 1992-2008 by Sybase, Inc. All rights reserved
I. 04/20 [...]
The system stored procedure sp_iqaddlogin is different in IQ 12.7 and IQ 15.1
The main difference ist the syntax and it seems that the 15-version might have a bug.
Neither sp_iqaddlogin, nor sp_iqpassword will accept symbols in passwords, such as “=”, “%”, “!”, “+”. Strangely the dollar symbol is accepted. The following error message is generated; [...]
Tables on a remote IQ Server can be made available to another IQ Server using Proxy Tables.
1. Configure the remote IQ Server for proxy access on the local IQ Server.
(DBA)> create server REMOTE_IQ class ‘asajdbc’ using ‘remote_iq.my_domain.com:4000/REMOTE_IQ’
This SQL statement puts an entry into the SYSSERVERS table.
2. Configure EXTERNLOGIN for users and/or “table owners”.
For example, on [...]
It is possible for up to 1000 users to connect to an IQ Server, but the Server may not have enough resources to support 1000 users, so the switches –gm and –iqgovern should be used.
-gm limits the number of users, who can connect at one time. If –gm is set to 100, then the 101st [...]
-zr [ ALL | NONE ]
ALL logs all SQL statements and other requests to the server.
NONE turns off SQL statement logging. This is the default.
The -zr option can be used with IQ 12.6 and later to collect SQL statements into the .srvlog file in $SYBASE/logfiles. The option must be written into the config file with [...]
SELECT t1.user_id,
t1.user_name,
t3.proc_id,
t3.proc_name AS ‘Function or Procedure’
FROM sysuserperm t1, sysprocperm t2, sysprocedure t3
WHERE t1.user_id = t2.grantee
AND t2.proc_id = t3.proc_id
AND user_group = ‘Y’
AND t1.user_id >=101 — fading out system users