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

SAP SQL Anywhere, on-demand edition 1.0 SP 6 » Troubleshooting and additional resources » Viewing diagnostic information for the cloud (dbmanageetd)

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

Generates a diagnostic log that allows the user to examine information for events occurring in the cloud.

dbmanageetd [ options ] [ filtering-options ] [ information-options ] [ output-format-options ] [ output-redirection-options ]
Option Description
@data Reads in options from the specified environment variable or configuration file. To protect passwords or other information in the configuration file, you can use the File Hiding utility (dbfhide) to encrypt the contents of the configuration file.
-m Merges diagnostic files from multiple hosts.
-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 CRITICAL, ERROR, WARNING, INFORMATION, or DEBUG.
-fr offset,count Filters by record range. Offset is a 0 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.
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.

Generate the diagnostic log using the GenerateDiagnosticLog task from the Cloud Command utility (dbcloudcmd).


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

By default, output is displayed on the screen unless the -o option is specified.

If the output format for your file is ASCII or XML, ensure that your editor can interpret the file as UTF-8.

Configure logging options using the SetServerLoggingOption task.


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

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