Use the sqcPDBcload command to store user data in the PDB.
Refer to Section 1.7.2, "sqcPDBcload (User Data Input Command)" in the Reference Guide for more information about the sqcPDBcload command.
Note
When monitoring the threshold of user data, an alarm occurs when the defined value is exceeded by the value of the monitored item at the time that the user data is loaded into the PDB by the sqcPDBcload command.
Syntax
[Windows]
Installation directory\bin\sqcPDBcload.exe | -u udata-file -i conv-file |
[UNIX]
/opt/FJSVssqc/bin/sqcPDBcload.sh | -u udata-file -i conv-file |
Options
Specifies the user data file (CSV file) to be stored in a PDB.
Specifies the data conversion definition file (as an ini file). A data conversion definition file specifies rules for converting user data to the record format used in a PDB. The following is an example:
[USERDATA] consol_flag=2 record_id=1 col_resource_id=2,5 col_start_date_time=6 col_data_num1=10 col_data_num2=9 col_data_text1=4 |
Refer to Chapter 4, "Data Formats" in the Reference Guide for information about the formats of the records that are generated.
Specify the data type. There are four data types, as shown below. Each of these data types has different display functions and storage periods. Decide which data type to use by referring to Section 3.2.2, "Manager" in the Technical Guide.
0: Summary data
1: Resource data (10 minutes)
2: Resource data (1 hour)
3: Resource data (24 hours)
If 0 is specified, record "SUM_UDATA_n" is created.
If 1, 2 or 3 is specified, record "UDATA_n" is created.
Specifies which record between "SUM_DATA_1" and "SUM_DATA_20" or between "U_DATA_1" and "U_DATA_20" is to be created.
Specifies the field number of the user data file that will be set as a resource ID. A resource ID is a unique identifier for identifying a record.
In the case of process information, for example, the process name is used as the resource ID.
It is also possible to connect multiple fields and use these together as a resource ID. If "col_resource_id=2,5" is specified, fields 2 and 5 are used in combination as the resource ID.
Specifies the field number that will be set as the collection start time.
Note that data is stored in the following format:
'YYYY-MM-DD [hh[:mm[:ss]]]'
'MM-DD-YYYY [hh[:mm[:ss]]]'
(YYYY: year; MM: month; DD: day; hh: hour; mm: minute; ss: second)
Specifies the field number of the user data file data (numerical) to be stored in field "smudndata1" to "smudndata7" or "udndata1" to "udndata7" (up to udndata5 when Record ID is UDATA_1, 2, 3, 6, 7, 8, 11, 12, 13, 16, 17, and 18).
Specifies the field number of the user data file data (text) to be stored in field "smudntxt1" or "udntxt1" to "udntxt7" (up to udntxt5 when Record ID is UDATA_1, 2, 3, 6, 7, 8, 11, 12, 13, 16, 17, and 18.).
Data conversion definition file specification | Created record | Remarks | |
|---|---|---|---|
Record ID | Field Name | ||
consol_flag=0 record_id=1 col_data_num3=9 | SUM_UDATA_1 | smud1data3 | If "0" is specified for consol_flag, record "SUM_DATA_n" is created. If "1" is specified for record_id, record "SUM_DATA_1" is created. If "9" is specified for col_data_num3, the 9th field of the CSV file is stored in field "sumud1data3". |
consol_flag=1 record_id=1 col_data_num3=9 | UDATA_1 | ud1data3 | If 1, 2 or 3 is specified for console_flag, record "UDATA_n" is created. If "1" is specified for record_id, record "UDATA_1" is created. If "9" is specified for col_data_num3, the 9th field of the CSV file is stored in field "ud1data3". |
consol_flag=3 record_id=2 col_data_num3=9 | UDATA_2 | ud2data3 | If 1, 2 or 3 is specified for console_flag, record "UDATA_n" is created. If "2" is specified for record_id, record "UDATA_2" is created. If "9" is specified for col_data_num3, the 9th field of the CSV file is stored in field "ud2data3". |
Example
[Windows]
C:\>cd C:\Program Files\SystemwalkerSQC\bin C:\Program Files\SystemwalkerSQC\bin>sqcPDBcload -u C:\temp\udata.csv -i C:\temp\conv.ini sqcPDBcload succeeded |
[UNIX]
# cd /opt/FJSVssqc/bin/ # ./sqcPDBcload.sh -u /tmp/udata.csv -i /tmp/conv.ini sqcPDBcload succeeded. |
In this case, the content of udata.csv is as follows:
2004-09-09 10:00:00,kaminaka,2,octets,data,767872,28856,22400 |
The content of conv.ini is as follows:
[USERDATA] consol_flag=2 record_id=1 col_resource_id=2,3 col_start_date_time=1 col_data_num1=6 col_data_num2=7 col_data_text1=4 |
