Salesforce

What are the new SQL-92 Startup parameters for Progress 9.1D?

« Go Back

Information

 
TitleWhat are the new SQL-92 Startup parameters for Progress 9.1D?
URL NameP23229
Article Number000140770
EnvironmentAll Supported Operating Systems
Progress 9.1D
Progress 9.1E
OpenEdge 10.x
SQL92
Question/Problem Description
Which are the new startup parameters for SQL-92?
What are the new SQL parameters for Progress 9.1D?
What are the new SQL parameters for Progress 9.1D or higher?
Where can I find documentation on -SQLStack?
Where can I find documentation on -SQLStmtCache?
Where can I find documentation on -SQLCursor?
Steps to Reproduce
Clarifying Information
Error Message
Defect Number
Enhancement Number
Cause
Resolution
In order to better manage Progress SQL-92 temp table resources, Progress 9.1D06 introduced new startup parameters.    
Parameter formMeaningRange of  values  Default
-SQLCursorsMax number of cursors  open at any one time.10 - 51250
-SQLTempBuffSize in K bytes of temp table buffers in  main memory (cache)100 - 2000001000
-SQLTempDiskSize in K bytes of  temp table backing store on disk.5000 - 100000000500000
-SQLTempPgSizeSize in K bytes of a temp table data page (upper limit of temp table record size).4 - 2567
-SQLStmtCacheNumber of Statements that can be stored in the SQL cache16 - 1024100
-SQLStackSize in KB of the SQL stack100 - 20001000

 

Workaround
Notes
NOTE:
On LINUX/UNIX Operating Systems you need to specify the -H parameter in order for these -SQL* parameters to take effect. This has been fixed in Progress 9.1E.

The parameter SQLTempBuff can be made larger to lessen the amount of IO for temp tables, or made smaller to free memory for other uses. One temp table buffer is allocated per connection.

The parameter SQLTempDisk can be made larger to sort very large amounts of data. Disk space is actually allocated on demand, so this parameter is an upper bound.

The parameter SQLTempPgSize can be made larger to sort data with a large number of values per row. For example, this might be useful if sorting a query with 20 output columns, each 600 chars long.

The parameters are documented in the Progress Startup Command and Parameter Reference manual as well as the Progress 9.1D Product Update Bulletin.

There is a documentation error where these parameters appear in the book as -SQLStackSize and -SQLStmtCacheSize. The correct spelling is the one that appears here.

The naming changes were made at the last minute and the changes will appear in the next documentation release.

These values can be added to the command line of the startup of the dbase (when using Proserve) or in the Other Arguments area in the Progress Explorer.

References to Written Documenation

Progress Solution:

"Changes in SQL startup parameters used in OpenEdge 10.1A or later"
Keyword Phrase
Last Modified Date11/20/2020 7:37 AM

Powered by