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

18.1 sqcPDBcout (CSV Output Command)

Function

This command outputs data stored in a PDB (Monitor information or Drill Down/Report information) to CSV format. The command is executed with parameters that specify the conditions to use when extracting information.

Execution environment

This command can be executed on Managers and operation management clients.

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

Syntax

For Managers

Installation directory\bin\sqcPDBcout.exe	-R record-id [-sys system] [-rid resource-id] [-tmbin time] [-tmfin time] [-intval interval] [-h on|off]
Installation directory\bin\sqcPDBcout.exe	-f sql-file [-h on|off]

/opt/FJSVssqc/bin/sqcPDBcout.sh	-R record-id [-sys system] [-rid resource-id] [-tmbin time] [-tmfin time] [-intval interval] [-h on|off]
/opt/FJSVssqc/bin/sqcPDBcout.sh	-f sql-file [-h on|off]

For operation management clients

Installation directory\bin\sqcPDBcout.exe	-R record-id -name manager [-sys system] [-rid resource-id] [-tmbin time] [-tmfin time] [-intval interval] [-h on|off]
Installation directory\bin\sqcPDBcout.exe	-f sql-file -name manager [-h on|off]

Options

-R record-id

This mode specifies data extraction conditions as options. Specify the record ID in "record-id". Refer to Chapter 19, "Data Formats" for details on record IDs.

-f sql-file

This mode specifies data extraction conditions in SQL. Specify the path to a file containing SQL in "sql-file".

Refer to the following usage example for details on the syntax for SQL statements. Also, refer to Chapter 19, "Data Formats" for details on table names specified with the FROM clause.

Refer to the following output results for details on field names specified with the SELECT and WHERE clauses.

-name manager

This mode specifies a Manager. Specify in "manager" the host name of a Manager that has the PDB data to be output.

-sys system

Specify the name of the system for which data is to be extracted. If this option is omitted, the data of all systems will be targeted.

-rid resource-id

Specify the ID of the resource for which data is to be extracted. If this option is omitted, the data of all resources will be targeted.

-tmbin time

Specify the extraction start time using GMT (Greenwich Mean Time). If this option is omitted, all the data in the PDB, from the oldest to the newest, will be extracted.

The following format is used to specify the time:

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

-tmfin time

Specify the extraction end time using GMT (Greenwich Mean Time). If this option is omitted, all the data in the PDB, from the newest to the oldest, will be extracted.

The following format is used to specify the time:

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

-intval interval (can be specified only for Drill Down/Report information)

Specify the interval data type of the data that is to be extracted. If this option is omitted, all the interval data will be targeted.

There are three interval data types: 600, 3600 and 86400

-h on|off

Specify whether to display header information at the beginning of the output result. If this option is omitted, header information is not displayed.

Output results

When header information is attached to the beginning of output results, information such as the following will be displayed.

For Monitor information:

system_name,record_id,resource_id,start_date_time,end_date_time,end_time,data_num1,data_num2,data_num3,data_num4,data_num5,data_num6,data_num7,data_text1

For Drill Down/Report information:

system_name,record_id,resource_id,start_date_time,end_date_time,consol_flag,consol_interval,coverage,data_num1,data_num2,data_num3,data_num4,data_num5,data_num6,data_num7,data_text1,data_text2,data_text3,data_text4,data_text5

The items that appear in header information are explained below.

system_name

The system name

record_id

The record ID. Refer to Chapter 19, "Data Formats" for details.

resource_id

The resource ID

start_date_time

The collection start time using GMT (Greenwich Mean Time)

end_date_time

The collection end time using GMT (Greenwich Mean Time)

end_time (for Monitor information only)

The time component of the collection end time

time_flag (only if the -f option is specified)

Internal control information

time_zone (only if the -f option is specified)

Internal control information

daylight_saving (only if the -f option is specified)

Internal control information

cycle_nr (only if the -f option is specified, and for Monitor information only)

Internal control information

consol_flag (for Drill Down/Report information only)

The interval type

consol_interval (for Drill Down/Report information only)

The interval time

coverage (for Drill Down/Report information only)

The data coverage rate. For example, a coverage rate of 1 indicates no lost data. A coverage rate of 0.9 indicates that 10% of data has been lost.

data_num1 to data_num7

The numerical value of each field. Refer to Chapter 19, "Data Formats" for details.

data_text1 to data_text5

The text of each field. Refer to Chapter 19, "Data Formats" for details.

Return values

0: Normal termination

1: Abnormal termination

Usage example 1

The following execution example uses the option specification (-R) as an extraction condition.

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

C:\Program Files\DiskSpaceMonitor\bin>sqcPDBcout -R WIN_DISKSPACE -sys server1 -rid C:\ -tmbin "2004-07-01 10:00:00" -intval 3600 -h off

server1,WIN_DISKSPACE,C:\,2004-07-01 11:00:00,2004-07-01 12:00:00,2,3600,1,74857984,2113864192,,,,,,,,,,

server1,WIN_DISKSPACE,C:\,2004-07-01 12:00:00,2004-07-01 13:00:00,2,3600,1,105043456,2113864192,,,,,,,,,,

# cd /opt/FJSVssqc/bin/

# ./sqcPDBcout.sh -R WIN_DISKSPACE -sys server1 -rid C:\ -tmbin "2004-07-01 10:00:00" -intval 3600 -h off

server1,WIN_DISKSPACE,C:\,2004-07-01 11:00:00,2004-07-01 12:00:00,2,3600,1,74857984,2113864192,,,,,,,,,,

server1,WIN_DISKSPACE,C:\,2004-07-01 12:00:00,2004-07-01 13:00:00,2,3600,1,105043456,2113864192,,,,,,,,,,LABRET,WIN_DISKSPACE,C:\,2004-07-01 12:00:00,2004-07-01 13:00:00,2,3600,1,105043456,2113864192,,,,,,,,,,

Usage example 2

The following execution example uses the SQL file specification (-f) as an extraction condition.

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

C:\Program Files\DiskSpaceMonitor\bin>sqcPDBcout -f C:\sql.txt

server1,WIN_DISKSPACE,C:\,2004-07-01 11:00:00,2004-07-01 12:00:00,2,3600,1,74857984,2113864192,,,,,,,,,,

server1,WIN_DISKSPACE,C:\,2004-07-01 12:00:00,2004-07-01 13:00:00,2,3600,1,105043456,2113864192,,,,,,,,,,

# cd /opt/FJSVssqc/bin/

# ./sqcPDBcout.sh -f /tmp/sql.txt

server1,WIN_DISKSPACE,C:\,2004-07-01 11:00:00,2004-07-01 12:00:00,2,3600,1,74857984,2113864192,,,,,,,,,,

server1,WIN_DISKSPACE,C:\,2004-07-01 12:00:00,2004-07-01 13:00:00,2,3600,1,105043456,2113864192,,,,,,,,,,

In this case, the content of sql.txt is as follows:

select * from resource_data where record_id='WIN_DISKSPACE' AND system_name='LABRET' AND consol_interval=3600;