Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database administration tools and utilities » Database administration utilities

Event Trace Data (ETD) File Management utility (dbmanageetd)

Generates a diagnostic log that allows the user to examine information for user-defined and system events. Use the sp_trace_events system procedure to see the descriptions of the events.

dbmanageetd [ options ] [ filtering-options ] [ information-options ] [ output-format-options ] [ output-redirection-options ] filename [ filename2 ... ]
Option Description

Reads options from the specified environment variable or configuration file.

To protect information in the configuration file, you can use the File Hiding utility (dbfhide) to encode the contents of the configuration file.

-m Merges multiple diagnostic files.
-s Shows a diagnostic summary. The -s option cannot be used with the -etd output format option.
-h Shows the usage help.
Filtering option Description
-fe event-name, ... Filters by event name.
-fh host, ... Filters by host name.
-fl severity-level Filters by severity level. Valid severity levels are ALWAYS, CRITICAL, ERROR, WARNING, INFORMATION, or DEBUG. For example, WARNING include ALWAYS, CRITICAL, and ERROR but not INFORMATION or DEBUG.
-fr offset, count Filters by record range. The offset is a zero-based offset. Count is the number of records returned.
-ft from, to

Filters by timestamp range.

The timestamp format should be YYYY-MM-DDThh:mm:ss.sssTZD where TZD is the time zone designator (Z or +hh:mm or -hh:mm).

Use Z for UTC offset or +hh:mm or -hh:mm to specify a time zone adjustment.

-fregex regex Filters for the regular expression in event data (Windows and Linux only).
Information option Description
-all Shows all information (process ID, thread ID, host name, host information, and the file name).
-epoch Shows the time in Epoch format, in milliseconds.
-filename Shows the file name.
-hostinfo Shows the host information. This information includes the operating system version and processor type.
-hostname Shows the host name field.
-pid Shows the process ID field.
-tid Shows the thread ID field.
-tzadj minutes Specifies the time zone adjustment value in minutes. The default is the local time of the computer running the utility.
-utc Shows the time in UTC format.
Output format option Description
-text Shows output in the operating system character set. This value is the default. The operating system character set is used unless an encoding is specified with the -te option.
-etd Shows output in ETD file format. Specify the -o option with this option. The -etd option cannot be used with the -s option.
-xml Shows output in XML format using UTF-8.
-le Lists available character set encodings. Specify + to view the expanded list.
-te encoding Specifies the character set encoding for the -text output format. By default, the operating system character set is used.
Output redirection option Description
-o filename Specifies the name of the file where the output is saved.

You must have already set up an event tracing session that logged information to an event trace data file.




The -fe and -fh filtering options accept comma-delimited lists of values.

Output appears on the screen unless the -o option is specified.


View a summary of the diagnostic information - Run the following command to view a summary of the diagnostic information:

dbmanageetd -s diagnostic-log.etd

View a list of events with a severity level of error and higher - Use the -fl option. For example:

dbmanageetd -fl error diagnostic-log

Convert an .etd file to an .xml file - Use the -xml and -o options. For example:

dbmanageetd -xml -o merged.xml diagnostic-log.etd

View only events on a specific host - To view only events from the host MyHost, use the -fh option. For example:

dbmanageetd -fh MyHost diagnostic-log.etd

Merge multiple .etd files from different hosts - Use the -m option. For example:

dbmanageetd -m -etd -o merged.etd machine1.etd machine2.etd machine3.etd machine4.etd

View events filtered by timestamp range - To view events that occurred between 1:30 AM to 2:00 AM in EST on 26th of Mar 2012, use the -ft option. For example:

dbmanageetd -ft 2012-03-26T01:30:00.000-04:00,2012-03-26T02:00:00.000-04:00 diagnostic-log.etd