|
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 |
|---|---|
| @data |
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.
None.
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