Log

This is a NuoDB Manager command. See NuoDB Manager.

Description

Generates a log for a domain, a database, or a process. You must specify the categories of logging information that you require. Output is directed to stdout.

This command does not turn on logging for the database process. You must specify this via database options (see Database Options). This command simply lets you specify which logging information will be displayed by nuodbmgr and directed to stdout.

Syntax

log domain categories log_categories
log database database_name categories log_categories
log process host host_name pid process_id categories log_categories

Parameters

Interactive Example

Currently logging is only supported via the nuodbmgr --command parameter.

Scripting Example

Log only SQL statements and their parameters to a log file using nuodbmgr.

$ nuodbmgr --broker host --password password \ 
    --command "log database test categories sql-statements,sql-params" > sqlstatement.log

Log all SQL statements and their explain plans and parameter data types and values to a log file using nuodbmgr.

$ nuodbmgr --broker host --password password \ 
    --command "log domain categories sql-statements,sql-statement-explain-plans,sql-statement-metrics" > sqlstatement.log

The logging of SQL statement performance metrics and Explain plan information is controlled by the system property SQL_STATEMENT_LOG_MIN_TIME. Any statement that runs longer than this property (in seconds) is logged, if either of the following two log categories are set:

To set SQL_STATEMENT_LOG_MIN_TIME, see SQL System Properties.