Subscribe

OM query dfm perf data

Hi,

is it possible to get more than one measurepoint with one query (-C aggregate:user_writes,user_reads...) (this example didn,t work).?

i use this :

dfm perf retrieve -o file:aggrname -C aggregate:user_writes -M Month -s 3600

but i need all existig information like user_writes user_reads total_transfers.

Regards Martin

OM query dfm perf data

You should specify the counters in comma separated format as (-C aggregate:user_reads,aggregate:user_writes,aggregate:total_transfers).

Object name was missing before user_reads in you example.

OM query dfm perf data

One more thing is your command is wrong. It should be like dfm perf data retrieve -o <object_name> -C <counter_name> ...

You can see the usage details by using the command like

$dfm perf data retrieve help

NAME
    retrieve -- This command allows you to extract the counter data
                with supported statistical calculations on them.

SYNOPSIS
    dfm perf data retrieve { [ -o object-name-or-id ... ] [ -C perf-counter ... ]
                        [ -V view-name ] }
                [ -d duration ] [ -b start-time ] [ -e end-time ]
                [ -M month ... ] [ -D weekday ... ] [ -T time-range ... ]
                [ -m statistical-method [ -P percentile-value ]
                        [ -S data-advance-method ] ]
                [ -s sample-rate ] [ -x output-format ] [ -R ]

Here it clearly specifies the object name need to be there in the dfm perf data retrieve command.

OM query dfm perf data

This is the output of my problem:

This worked

smc-vm-025:~ # dfm perf data retrieve -o smc-na001-pb.smc.xxx.net:f1_aggr0_mir_15k  -C aggregate:user_reads  -M Sep -s 3600

Timestamp       smc-na001-pb.smc.xxx.net:f1_aggr0_mir_15k:user_reads

-------------------------------------------------------------------------------

2011-09-09 14:04:43     277.800

2011-09-09 15:04:43     175.867

.

.

This not:

smc-vm-025:~ # dfm perf data retrieve -o smc-na001-pb.smc.xxx.net:f1_aggr0_mir_15k  -C aggregate:user_reads,aggregate:user_writes -M Sep -s 3600

Error: Expected object:counter; found aggregate:user_reads,aggregate:user_writes.

And this Tables exists:

smc-vm-025:~ # dfm perf data retrieve -o smc-na001-pb.smc.xxx.net:f1_aggr0_mir_15k  -V "Aggregate Summary View" -M Aug -s 3600

Timestamp       smc-na001-pb.smc.xxx.net:f1_aggr0_mir_15k:user_reads

-------------------------------------------------------------------------------

No data available

Timestamp       smc-na001-pb.smc.xxx.net:f1_aggr0_mir_15k:user_writes

-------------------------------------------------------------------------------

No data available

Timestamp       smc-na001-pb.smc.xxx.net:f1_aggr0_mir_15k:cp_reads

-------------------------------------------------------------------------------

No data available

Timestamp       smc-na001-pb.smc.xxx.net:f1_aggr0_mir_15k:total_transfers

-------------------------------------------------------------------------------

No data available

So, the problem still exists.

Regards Martin

OM query dfm perf data

The 'No data available' error could be because you are asking for Aug month data and the perf data for 'Aggregate Summary View' by default stores 1 week data.

Can you please verify against Sep month ? Also, post the sampling rate and sampling duration for the 'aggregate' object of this host using 'dfm perf data describe' CLI

OM query dfm perf data

This should only a example for the existing tables.

This is the main problem:

smc-vm-025:~ # dfm perf data retrieve -o smc-na001-pb.smc.xxx.net:f1_aggr0_mir_15k  -C aggregate:user_reads,aggregate:user_writes -M Sep -s 3600

Error: Expected object:counter; found aggregate:user_reads,aggregate:user_writes.

All other things are only to explain.

Regards Martin

OM query dfm perf data

Hello,

when you specify the comma in between the counter name on the cli, still -C need to be there. Otherwise it will give you error

Correct syntax would be either

$ dfm perf data retrieve -o <object name>  -C aggregate:user_reads, -C aggregate:user_writes -M Sep -s 3600

or

without comma separated cli,

$ dfm perf data retrieve -o <object -name>   -C aggregate:user_reads   -C  aggregate:user_writes -M Sep -s 3600

Now try again.

Thanks,

Bipul

Re: OM query dfm perf data

Ok. It works now  - but --- now the next question . Is it possible tho put the output in two collums. Actual  the output was generated sequentialy.

smc-vm-025:~ # dfm perf data retrieve -o smc-na001-pb.smc.xxx.net:f1_aggr0_mir_15k  -C aggregate:user_reads -C aggregate:user_writes  -M Sep -s 3600

Timestamp       smc-na001-pb.smc.xxx.net:f1_aggr0_mir_15k:user_reads

-------------------------------------------------------------------------------

2011-09-09 14:31:44     507.900

2011-09-09 15:31:44     220.283

.

.

Timestamp       smc-na001-pb.smc.xxx.net:f1_aggr0_mir_15k:user_writes

-------------------------------------------------------------------------------

2011-09-09 14:31:44     507.900

2011-09-09 15:31:44     220.283

.

.

Regards Martin

OM query dfm perf data

OK. I found the solution.

dfm perf data retrieve -o smc-na001-pb.smc.xxx.net:f1_aggr0_mir_15k  -C aggregate:user_reads -C aggregate:user_writes  -M Sep -s 3600 -x TimeIndexed

is what i need.

Thanks for your great support

Martin

Re: OM query dfm perf data

Hello,

"-x TimeIndexed" will give you the column by column output, but it ignores the second information on the time column of the CLI output.

Thanks,

Bipul