CGE provides a number of advanced options that can be used to change the behavior of the database server for a specific request. Some of these options impact the server, whereas others impact individual requests. To access this interface, select Edit Database Configuration from the Data Access drop down. The user interface for configuring advanced options is shown in the following figure:Figure: Server Name Value Pairs
Note: Options provided in this section of the user interface are relevant only for the processing of the request under consideration and should be updated for each individual request. If it is desired to change the options for the database server as a whole, it will be required to use the interface described in the 'Edit Server Configurations Using the CGE UI' topic of this publication.
Server NVPs (Name Value Pairs)
In the Server NVPs section, NVPs can be specified to pass to the database server. These can be used to control behavior or enable additional debugging information.
Important: In most cases, it will not be required to enter anything in the Server NVPs field, unless specifically instructed to do so by a Cray representative for gathering information to aid in diagnosing encountered issues.
Server Logging Configuration
The Server Logging Options section provides options that allow configuring the amount of logging the database server will produce in the server side logs during the processing of a request. The desired logging level (i.e. log verbosity) can be selected from the Server Log Level drop down, which is followed by the Server Log String field, in which a log string can be entered. The log string can be up to 128 characters and will be included on each log line pertaining to the request. This is often useful for extracting all the log lines pertaining to a specific request.
Messages of types INFO, WARNING, and ERROR can be logged in the system, INFO being the default log level.
This interface also provides the option to disable logging for the request entirely, though it is generally recommended to avoid this option as it makes it difficult to monitor the status of the server while it processes queries.
