The database server
28
To control access to the file system using these statements, the
–gl
command-line option allows you to control the level of database permission
that is required to use these statements.
The allowed values are as follows:
♦
dba Only users with DBA authority can load or unload data from the
database.
♦
all All users can load or unload data from the database.
♦
none Data cannot be unloaded or loaded.
Both uppercase and lower case syntax is acceptable.
The default settings are all for personal database servers on non-Unix
operating systems, and dba for the network database server and the Unix
personal server. These settings reflect the fact that, on non-UNIX platforms,
the personal database server is running on the current machine, and so the
user already has access to the file system.
–gm command-line option
Limit the number of concurrent connections to the server.
[ dbsrv7 | dbeng7 ] -gm
integer
...
All operating systems and servers.
If this number is greater than the number that is allowed under licensing and
memory constraints, it has no effect.
–gn command-line option
Set the number of execution threads.
[ dbsrv7 | dbeng7 ] -gn
integer
...
All operating systems and servers.
Set the number of execution threads to be used in the database server. Each
connection uses a thread for each request, and when the request is completed
the thread is returned to the pool for use by other connections. As no
connection can have more than one request in progress at one time, no
connection uses more than one thread at a time.
An exception to this rule is if a Java application uses threads. Each thread in
the Java application is a database server execution thread.
Function
Syntax
Applies to
Description
Function
Syntax
Applies to
Description
To Next Page
Loading...