![Truncating the transaction log on a running server [CR 404902]](arrow-left.gif){kind=icon}
![Requirement for Interactive SQL [CR 375382]](arrow-right.gif){kind=icon}
The Sybase IQ Utility Guide Chapter 1 specified incorrect values for default thread stack size and number of threads. The thread stack size default (-iqtss) for 64-bit systems is 350KB. The total number of threads (-iqmt plus -gn) must not exceed 4096 on 64-bit platforms or 2048 on 32-bit platforms.
The calculation for the number of threads IQ creates is 60 per CPU for the first four CPUs and 50 per CPU for the rest, plus connection threads.
For example, on a system with 12 CPUs and 10 connections:
60*4 + 50*(numCPUs - 4) + 2*(numConnections + 2) + 1 = 655
