![IDENTITY_INSERT option setting corrections [CR 418760, CR 439496, CR 456339]](arrow-left.gif){kind=icon}
![ALTER TABLE and modifying columns [CR 408589]](arrow-right.gif){kind=icon}
The following new feature for Sybase IQ 12.6 was omitted from Chapter 1, section “Environment Variables,” in the Sybase IQ Reference Manual.
ASIQTIMEOUT=nnn
Optional but recommended in multiplex environments.
The IQ Agent waits indefinitely for a process to complete. Setting a wait time is recommended when creating or synchronizing query servers for a multiplex with a very large catalog store. Large catalog stores extend the time needed for the dbbackup part of synchronization, and increasing the wait time accommodates a larger synchronize.
This variable overrides the default wait time (zero, no timeout). The argument nnn is the number of minutes for the IQ Agent to wait. For example:
To wait 45 minutes (Korn or Bourne shell):
ASIQTIMEOUT=45 export ASIQTIMEOUT
To wait an hour (C shell):
setenv ASIQTIMEOUT 60
To overwrite the current setting, use the following server start-up option, where nnn is the number of minutes to wait:
-Dasiqtimeout=nnn
