Kbase P23229: What are the new SQL-92 Startup parameters for Progress 9.1D?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/22/2008 |
|
Status: Verified
GOAL:
Which are the new startup parameters for SQL-92?
GOAL:
What are the new SQL parameters for Progress 9.1D?
GOAL:
Where can I find documentation on -SQLStack?
GOAL:
Where can I find documentation on -SQLStmtCache?
GOAL:
Where can I find documentation on -SQLCursor?
FACT(s) (Environment):
Progress 9.1D
Progress 9.1E
OpenEdge 10.x
FIX:
In order to better manage Progress SQL-92 temp table resources, Progress 9.1D06 introduced new startup parameters.
Parameter form
Meaning
Range of values
Default
-SQLCursors
Max number of cursors open at any one time.
10 - 512
50
-SQLTempBuff
Size in K bytes of temp table buffers in main memory (cache)
100 - 200000
1000
-SQLTempDisk
Size in K bytes of temp table backing store on disk.
5000 - 100000000
500000
-SQLTempPgSize
Size in K bytes of a temp table data page (upper limit of temp table record size).
4 - 256
7
-SQLStmtCache
Number of Statements that can be stored in the SQL cache
16 - 1024
100
-SQLStack
Size in KB of the SQL stack
100 - 2000
1000