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

Create a database with multiple categories of logging turned on.

nuodb [domain] > create database
Database Name: test
DBA User: dba
DBA Password: dba
Template Name (Single Host, Minimally Redundant, Multi Host, Region distributed): Single Host
Template Variables (optional): 
Database Options (optional): verbose sql-statements,sql-params,client-msgs,msgs,atoms
Timeout (ms/s/m/h/d/w) (optional): 
Template Variable HOST (default: localhost): 
Database Options for SMs (optional): 
Tag Constraints for SMs (optional): 
Database Options for TEs (optional): 
Tag Constraints for TEs (optional):

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