Sets the maximum number of physical processors that can be used (up to the licensed maximum). This option is only useful on multiprocessor systems.

Syntax

{ dbsrv11 | dbeng11 } -gt integer ...

Applies to

Windows (except Windows Mobile), Linux, and Solaris.

Remarks

With per-seat licensing, the network database server uses all CPUs available on the computer (the default). With CPU-based licensing, the network database server uses only the number of processors you are licensed for. In addition, the personal database server and runtime database server are both limited to a single processor.

When you specify a value for the -gt option, the database server adjusts its affinity mask (if supported on that hardware platform) to restrict the database server to run on only that number of physical processors. If the database server is licensed for n processors, the server will, by default, run on all logical processors (hyperthreads and cores) of n physical processors. This can be further restricted with the -gtc option.

Valid values for the -gt option are between 1 and the minimum of:

• the number of physical processors on the computer
• the maximum number of CPUs that the server is licensed for if CPU-licensing is in effect

If the -gt value specified lies outside this range, the lower or upper limit is imposed. For the personal database server (dbeng11) the server uses a -gt value of 1.

See also

• -gn server option
• -gtc server option
• Threading in SQL Anywhere