topic Re: Extract command in Operating System - HP-UX

Extract command

zsujith — Wed, 06 Aug 2008 04:17:53 GMT

Hello,

We have sar data run through cron in /usr/adm/sa directory. Now we need to create report of disk utilization using extract command.
Please let us know what option to use with extract command to generate disk utilization report etc.

Regards

Re: Extract command

Kapil Jha — Wed, 06 Aug 2008 04:46:27 GMT

Hello,
you will have to use
erxtract -b -e -xt -l

Read man extract for more info.
------------
extract -xt [d|w|m|y -offset] [-v][-gapkdzcntuy]
[-l ] [-f ]
[-b ] [-e ]
[-s - noweekends]
------------
BR,
Kapil+

Re: Extract command

zsujith — Wed, 06 Aug 2008 05:25:53 GMT

Dear Kapil,

Do i need to provide beginning and end date as i already have the sar data.

Regards

Re: Extract command

Rasheed Tamton — Wed, 06 Aug 2008 05:57:30 GMT

Hi,

extract reads the contents of OV Performance Agent (OVPA) scopeux log files. You can use the sar command as below to get the disk (or tape) output:

sar -d -f /var/adm/sa/sa06

or
just grep for Average

sar -d -f /var/adm/sa/sa06|grep Average

-f is the filename

Regards.

Re: Extract command

zsujith — Wed, 06 Aug 2008 07:26:22 GMT

Hello Rasheed,

Thanks for your reply.

I need to create a graphical report from that sar disk utilization data. Any idea how to go forward or just create a Statiscal report to show it to end customer.

Regards

Re: Extract command

Emil Velez — Wed, 06 Aug 2008 13:14:42 GMT

the extract command is part of the measureware product not sar. Measurware now called the performance agent collects data separately from sar

extract -xp -d -f /tmp/rxlog_disks.txt

This is how you would extract disk data. Extract has many other clases of data: Global, process, application (group of processes you define), disk, logical volumen, netif, cpu and configuration.

look into it. Measureware is collecting over 400 metrics constantly and is on most of the HPUX systems given the way people purchase their OE bundle.

Re: Extract command

Rasheed Tamton — Wed, 06 Aug 2008 13:23:35 GMT

Hello Sujith,

You have to export to excel (csv) format and do the reporting from there.

Otherwise, if scopeux is on the system, you can use the extract command and send to output file, move to PC, and use excel.

This is the template (you can modify the items as per your needs) file for extract:

cat /home/sujith/disktemplate
REPORT "MWA Export on !SYSTEM_ID"
FORMAT ASCII
HEADINGS ON
SEPARATOR="|"
SUMMARY=60
MISSING=0
DATA TYPE GLOBAL
YEAR
DATE
TIME
GBL_DISK_UTIL_PEAK
GBL_DISK_SUBSYSTEM_QUEUE

use the below command to extract today's data using the above template file and output to a file called extractfile

/opt/perf/bin/extract -xp -r /home/sujith/disktemplate -g -b today 00:00 -e today 16:59 -f extractfile

(from 05th Aug to 06th Aug below; -d for disk - man extract for details)

/opt/perf/bin/extract -xp -d -g -b 08/05/08 -e 08/06/08 -f extract.out

send the output file as attachment by mail or you can sftp to pc

uuencode extractfile extractfile |mailx -m -s "extract as attach" sujith@domain.com

and put it to excel.

May be someone would come with a better idea.

Regards.

Re: Extract command

zsujith — Tue, 26 Aug 2008 06:44:07 GMT

Thank U