Privileges required for execution
[Windows]
The privileges of a user belonging to the "Administrators" group are required to execute this command.
[UNIX]
The privileges of a system administrator (superuser) are required to execute this command.
Execution environment
This command can be executed on Enterprise Managers, Managers, Proxy Managers and Agents.
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 |
Function
This command saves user data in the PDB.
This command should be executed after performing the definitions described in "Managing User Data" in the User's Guide.
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 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" for details on the format of created records.
Specifies the data type. The data types listed below are available. The display functions and retention period of each data type are different. Decide which data type to use by referring to "Product Architecture" of the Technical Guide.
- 0: Monitor 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" (or to "udndata5" if the Record ID is "UDATA_1", "UDATA_2", "UDATA_3", "UDATA_6", "UDATA_7", "UDATA_8", "UDATA_11", "UDATA_12", "UDATA _13", "UDATA_16", "UDATA_17", or "UDATA_18").
Specifies the field number of the user data file data (text) to be stored in field "smudntxt1" or "udntxt1" to "udntxt7" (or to "udndata5" if the Record ID is "UDATA_1", "UDATA_2", "UDATA_3", "UDATA_6", "UDATA_7", "UDATA_8", "UDATA_11", "UDATA_12", "UDATA _13", "UDATA_16", "UDATA_17", or "UDATA_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". |
Return values
0: Normal termination
1: Abnormal termination
Note
User data will not be stored in a PDB in the following cases:
The data in the field number specified by col_resource_id is empty.
The data in the field number specified by col_start_date_time is in the wrong format.
The format of the collection start time does not match the format used by the PDB.
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 |
