OM query dfm perf data

[martin_pauke]

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

[rbalaji]

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.

[bipulm]

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.

[martin_pauke]

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

[rbalaji]

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

[martin_pauke]

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

[bipulm]

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

[martin_pauke]

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

[martin_pauke]

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

[bipulm]

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