Release 10.1A: OpenEdge Deployment:
Startup Command and Parameter Reference

> ## OpenEdge SQL Broker parameters (SQL)

> Use the parameters listed in Table 3–15 to control spawned OpenEdge SQL processes when connecting to a OpenEdge SQL server. The parameters are organized alphabetically by syntax.

> Table 3–15: SQL Server parameters
> Syntax | Parameter | Purpose
> --- | --- | ---
>     -classpath
> | SQL Server Java Classpath | Identify the Java classpath to use when starting an SQL server.
>     -ServerType
> | Type of Server to Start | Limit the type of server the broker can start.
>     -SQLCursors
> | SQL Open Cursors | Define the maximum number of cursors open at any one time.
>     -SQLStack
> | SQL Stack Size | Change the size of the SQL stack.
>     -SQLStmtCache
> | SQL Statement Cache | Set the number of statements that can be stored in the SQL cache.
>     -SQLTempBuff
> | SQL Sorting Memory | Define the size in K-bytes of the temporary table buffers in main memory cache.
>     -SQLTempDisk
> | SQL Sorting on Disk | Define the size in K-bytes of the temporary table for backup storage on disk.
>     -SQLTempPgSize
> | SQL Temp Table Data Page | Define the size in K-bytes of the temporary table data page, which is the upper limit of temporary table record size.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095