The Trend Viewer can output Usage DB data to a file in CSV format depending on the data type when the dbprt command is used.
The following explains how to use the dbprt commands.
Format
Windows]
dbprt [/f][/h] target server start day end day data type output file |
UNIX]
dbprt [-f][-h] target server start day end day data type output file |
Function
The CSV output fetches data from the Usage DB to output it in the CSV format.
Options
Windows]
Options | Meaning |
|---|---|
/f | Suppresses the overwrite confirmation of the output file.
|
/h | Displays the command help. For details, refer to "Command help". |
UNIX]
Options | Meaning |
|---|---|
-f | Suppresses the overwrite confirmation of the output file.
|
-h | Displays the command help. For details, refer to "Command help". |
Operands
Operands | Meaning |
|---|---|
Target server | Specify the symbol of the analysis target server set in the Usage DB Environment Definition File. (For information on the Usage DB Environment Definition File, refer to "15.2.1 Usage DB Environment Definition File".) |
Start day | Specify the start day of the extraction period. Its format is as follows:
|
End day | Specify the end day of the extraction period. Its format is the same as that of the start day. |
Data type | Specify the type of data to be extracted. Specify either of the following data types:
|
Output file | Specify the path of the file in which extracted data is stored. If the path string contains any blank character, specify the path by enclosing it in double quotation marks. |
Termination status
The return value and display message when the command finishes are as listed below:
End state | Return value | Display message |
|---|---|---|
Normal end | 0 | The output file name was output. |
Abnormal end | Greater than 0 | Error message |
If the command ends normally, the file displayed in the output file name is created.
If the command ends abnormally, an error message is displayed and no file is created.
An error message corresponding to each error is displayed. For details, refer to "17.2 Usage Analysis Function".
Execution Example
An execution example of the command is as follows. In this example, session information of January 2001 of the analysis target server whose symbol is "PUBLIC" is output to a file whose name is "session-2001-01.csv".
Windows]
C:\temp> "C:\Program Files\SystemwalkerSQC\bin\dbprt" PUBLIC 20010101 20010131 session session-2001-01.csv C:\Program Files\SystemwalkerSQC\bin\dbprt: Output to session-2001-01.csv C:\temp> |
UNIX]
# /opt/FJSVssqc/bin/dbprt PUBLIC 20010101 20010131 session session-2001-01.csv /opt/FJSVssqc/bin/dbprt:Output to session-2001-01.csv # |
Command help
When using the dbprt command, help messages are output in the following cases:
When an incorrect operand is specified
When a required operand is not specified
"/h" is specified in the operand.
Contents of a help message are as follows:
Windows]
dbprt outputs data in WWW Service Analyze Function Database to a file formed CSV according to a data kind. dbprt [/f][/h] server start-date end-date data-kind output-file /f Not confirm to overwrite the output file. /h Display help message. server A symbol of the server in database environment definition file. start-date Start date of an output period. Form like 20010101. end-date End date of an output period. Form like 20010131. data-kind A kind of output data. output-file A file name to store the data. Using dbprt, it required to be started the Database Register Engine in advance. |
UNIX]
dbprt outputs data in WWW Service Analyze Function Database to a file formed CSV according to a data kind. dbprt [-f][-h] server start-date end-date data-kind output-file -f Not confirm to overwrite the output file. -h Display help message. server A symbol of the server in database environment definition file. start-date Start date of an output period. Form like 20010101. end-date End date of an output period. Form like 20010131. data-kind A kind of output data. output-file A file name to store the data. Using dbprt, it required to be started the Database Register Engine in advance. |
