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
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