SAP Sybase IQ 16.0 includes option changes for the isql and start_iq utilities.
| Option | Description |
|---|---|
| --URP |
New option for the Interactive SQL utility (isql). Allows you to specify a remote password and provides TDS login redirection for logical servers. See Utility Guide > isql Interactive SQL Utility.. |
| Utility | Description |
|---|---|
| -al | New option for the start_iq utility,
-al allows you to extend authentication to select
users using standard authentication. This may be necessary when the
login_mode database options are restricted to
SAP Sybase IQ LDAP user authentication
(LDAPUA) only, but no user or login policy exists that permits LDAPUA
authentication. See start_iq > -al iqsrv16 Server Option or start_iq > -al iqsrv16 Database Option under start_iq Database Server Startup Utility in the Utility Guide . |
| -iqlm |
New option. The –iqlm startup option specifies the maximum amount of memory that SAP Sybase IQ can dynamically request from OS for temporary use. Set –iqlm as a switch as part of the command or configuration file that starts the server. Default large memory is 2048MB. Large memory requirements represent one third of the total available physical memory. To ensure adequate memory for the main and temporary IQ stores, set the –iqlm, –iqtc, and –iqmc startup parameters so that each parameter receives one third of all available memory. See Utility Guide > start_iq Database Server Startup Utility > start_iq Server Options > -iqlm iqsrv16 Server Option. |
| –iqmc |
Behavior change. Default memory for –iqmc is 64MB. Large memory requirements are one third of all available physical memory. To ensure adequate memory for the main store, set the –iqmc startup parameter to one third of available physical memory. See Utility Guide > start_iq Database Server Startup Utility > start_iq Server Options > -iqmc iqsrv16 Server Option. |
| -iqrlvmem |
New option. Server startup argument to govern the RLV store memory usage. Only used if RLV storage is enabled. The default is 2GB. |
| –iqtc |
Behavior change. Default memory for –iqtc is 64MB. Large memory requirements are one third of all available physical memory. To ensure adequate memory for the IQ temporary store cache, set the –iqtc startup parameter to one third of available physical memory. See Utility Guide > start_iq Database Server Startup Utility > start_iq Server Options > -iqtc iqsrv16 Server Option. |
| -sf | New feature set. manage_keys added to the manage_security feature set for the start_iq -sf option. Allows you to specify which features you want to secure for databases running on the database server. |