This task describes how to add querylogging channels.
You must enable querylogging prior to adding a querylogging
channel.
When you create a querylogging channel, you must specify the mandatory parameters:
- a channel name
- a name for the channel log file
- the maximum number of versions of the file to create
- a file size (in MB)
- a severity level
- a message category
Note: Log files are stored on the
/replicated disk partition. Ensure that the
size and version parameters are configured
appropriately to avoid filling the disk partition.You must also specify whether the logging system should mark each entry with its time, severity level, and category.
To add a querylogging channel:
Adonis> configure querylogging
Adonis:configure:querylogging> add channel view1
Adonis:configure:querylogging:view1>add category database
Adonis:configure:querylogging:view1>add category config
Adonis:configure:querylogging:view1>set file db_log.txt
Adonis:configure:querylogging:view1>set version 2
Adonis:configure:querylogging:view1>set size 2
Adonis:configure:querylogging:view1>set severity critical
Adonis:configure:querylogging:view1>set printtime yes
Adonis:configure:querylogging:view1>set printseverity yes
Adonis:configure:querylogging:view1>set printcategory yes
Adonis:configure:querylogging:view1>save
Save channel details for view1