ETERNUS SF Disk Space Monitor User's Guide - Microsoft(R) Windows Server(TM) 2003/Solaris(TM) Operating System/Linux - 13.0

18.2 sqcPDBcload (User Data Input Command)

Function

This command saves user data in the PDB.

Execution environment

This command can be executed on Managers and Agents.

Note that only the users with system administrator (superuser or Administrator) privileges are permitted to execute this command.

Syntax

Installation directory\bin\sqcPDBcload.exe

-u udata-file -i conv-file

/opt/FJSVssqc/bin/sqcPDBcload.sh

-u udata-file -i conv-file

Options

-u udata-file

Specifies the user data file (CSV file) to be stored in a PDB.

-i conv-file

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

Data conversion definition file (conv-file)

Refer to Chapter 19, "Data Formats" for details on the format of created records.

consol_flag

Specifies the data type. The data types listed below are available. The display functions and retention periods of each data type are different. Refer to Chapter 2, "Product Architecture" and specify an appropriate data type for storing data.

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

record_id

Specifies which record between "SUM_DATA_1" and "SUM_DATA_5" or between "U_DATA_1" and "U_DATA_5" is to be created.

col_resource_id

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.

col_start_date_time

Specifies the field number that will be set as the collection start time.

Note that data is stored in the following format:

'MM-DD-YYYY [hh[:mm[:ss]]]'

(YYYY: year; MM: month; DD: day; hh: hour; mm: minute; ss: second)

"col_data_num1" to "col_data_num7" (or to "col_data_num14" if the Record ID is "UDATA_4" or "UDATA_5")

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 "udndata14" if the Record ID is "UDATA_4" or "UDATA_5").

"col_data_text1" to "col_data_text5"

Specifies the field number of the user data file data (text) to be stored in field "smudntxt1" or "udntxt1" to "udntxt5".

Examples of data conversion definition files and the records that are created

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

Notes

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

C:\>cd C:\Program Files\DiskSpaceMonitor\bin

C:\Program Files\DiskSpaceMonitor\bin>sqcPDBcload -u C:\temp\udata.csv -i C:\temp\conv.ini

sqcPDBcload succeeded

# 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