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 to drop DBSPACEs on an IQ Server, if there is enough space to move all data to other DBSPACEs.
1. Check DBSPACEs
The sp_iqdbspace command should be used to list all DBSPACEs and their status.
(DBA)> sp_iqdbspace
Execution time: 0.053 seconds
Name Path [...]
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 [...]