time frame in global_cpumem.rept file

[NDO]

Hi all

I am using the extract command in a hp-ux server to get peformance data as per the following syntax:

extract -v -g -xp -r /tmp/fr/global_cpumem.rept -f /tmp/fr/dbnode1_Mar19_v1.txt,purge -b "/3/01/2019 0:00" -e "/3/31/2019

But its giving me values of every 5 minutes. How to change that to only give values every hour?

my global_cpumem.rept file is as follows:

REPORT "OVPA Export !DATE !TIME Logfile: !LOGFILE !COLLECTOR !SYSTEM_ID"
FORMAT ASCII
HEADINGS ON
SUMMARY=60
MISSING=0
DATA TYPE GLOBAL
DATE
TIME
GBL_ACTIVE_CPU
GBL_CPU_TOTAL_UTIL
GBL_DISK_PHYS_IO_RATE
GBL_DISK_PHYS_IO
GBL_MEM_FREE
GBL_MEM_UTIL
GBL_MEM_USER_UTIL
GBL_SWAP_SPACE_UTIL
GBL_MEM_PAGEOUT_BYTE
GBL_MEM_PAGEOUT_BYTE_RATE
GBL_MEM_PAGEOUT_RATE
GBL_MEM_SWAPOUT_RATE
GBL_MEM_PG_SCAN_RATE

Thanks in advance

[Mani_Np]

Hello,

There is no option in man page for tuning interval for extract command.. So, I think we need to edit the output of the extract command by text level (for e.g., grep, perl, shell or even by excel).

[Duncan Edmonstone]

Yes you can do this - you just need to use summary data rather than detail data - so in this case just replace the "-g" argument with "-G" - then the extract command will pay attention to the "SUMMARY=60" option in the report configuration file and summarise up to 60 minutes.

[NDO]

It worked, but with the "summary" value of 86400 (for daily values) did not work, any ideas?

[Duncan Edmonstone]

Minutes not seconds... there are 24 x 60 = 1,440 minutes in a day. Your value is for 60 days!