Kbase P27124: Running larger SQL queries produces error (7631) on 9.1D
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/04/2005 |
|
Status: Unverified
FACT(s) (Environment):
UNIX
Windows
Progress 9.1D
SYMPTOM(s):
Running large SQL queries produces error (7631)
FIX:
Larger SQL queries may require that the SQL server processes be tuned in order to handle the result set being returned by the SQL server process. This normally occurs when the SQL query is swapping data in/out to disk using temp files (i.e. tables) located in $WRKDIR directory. To resolve the problem, use the following (new to 9.1D06) DB broker startup parameter:
-SQLTempPgSize
Valid range: 4 - 256K
Default: 8K
Example: -SQLTempPgSize 128