SHEET2PCP(1) General Commands Manual SHEET2PCP(1) (NAME) sheet2pcp - PCP (SYNOPSIS) sheet2pcp [-h host] [-V version] [-Z timezone] infile mapfile outfile (DESCRIPTION) sheet2pcp (infile) Performance Co-Pilot (PCP) outfile . Perl ( (CAVEATS) ). <<>> . PCP PCP pmchart(1) PCP pmie(1) . mapfile PCP . XML (MAPPING CONFIGURATION) . outfile . : outfile.0 ( ) outfile.meta ( ) outfile.index ( ). sheet2pcp . -h hostname mapfile . mapfile . -V PCP . $PCP_ARCHIVE_VERSION ( PCP ) version . -Z timezone mapfile . mapfile . sheet2pcp Perl PCP::LogImport libpcp_import PCP PCP . (MAPPING CONFIGURATION) mapfile XML . ... . sheet : heading . : heading="1". hostname PCP ( ). : hostname="some.where.com". timezone PCP ( UTC ). +HHMM ( UTC) -HHMM ( UTC) . zoneinfo ( Olson) Europe/Paris TZ EST+5 . : timezone="+1100". datefmt (Y) (M) (D) . DMY () MDY YMD. : datefmt="YMD". metricname . metric : pmid (PMID) (.) domain cluster item PMID PMID PMNS(5) . PMID pmiAddMetric(3) . PM_ID_NULL . : pmid="60.0.2" pmid="PM_ID_NULL". indom . (Instance Domain) PM_INDOM_NULL . indom (.) domain ordinal . : indom="PM_INDOM_NULL" indom="60.3" indom="PMI_DOMAIN.4". . domain pmid indom pmid domain indom PMI_DOMAIN . indom PM_INDOM_NULL . units ( ) - (6-tuple) . pmiUnits(3) pmUnits . pmLookupDesc(3) . units="0,0,0,0,0,0". : units="0,1,0,0,PM_TIME_MSEC,0" () units="1,-1,0,PM_SPACE_MBYTE,PM_TIME_SEC,0" ( ) units="0,1,-1,0,PM_TIME_USEC,PM_COUNT_ONE" ( ). type . pmLookupDesc(3) PM_TYPE_FLOAT . : type="PM_TYPE_32" type="PM_TYPE_U64" type="PM_TYPE_STRING". sem (semantics) . pmLookupDesc(3) PM_SEM_INSTANT . : sem="PM_SEM_COUNTER" type="PM_SEM_DISCRETE". metricspec . PCP PCP . metricspec ( ) hinv.ncpu kernel.all.load[1 minute]. skip PCP . . . (EXAMPLE) mapfile ... kernel.percpu.cpu.sys kernel.percpu.cpu.sys[cpu0] kernel.percpu.cpu.sys[cpu1] : Date;"Status";"SysTime - 0";"SysTime - 1"; 26/01/2001 14:05:22;"Some Busy";0.750;0.133 26/01/2001 14:05:37;"OK";0.150;0.273 26/01/2001 14:05:52;"All Busy";0.733;0.653 (CAVEATS) infile . Perl : *.csv (CSV) Text::CSV_XS(3pm) . *.sxc *.ods OpenOffice Spreadsheet::ReadSXC(3pm) Archive::Zip(3pm) . *.xls Microsoft Office Spreadsheet::ParseExcel(3pm) OLE::Storage_Lite(3pm) . *.xlsx Microsoft OpenXML Spreadsheet::XLSX(3pm) . sheet2pcp OpenXML OpenOffice . PCP (PCP ENVIRONMENT) PCP_ PCP . /etc/pcp.conf . $PCP_CONF pcp.conf(5) . PCP pmGetOptions(3) . (SEE ALSO) pmchart(1), pmie(1), pmlogger(1), sed(1), pmiAddMetric(3), pmLookupDesc(3), pmiUnits(3), Archive::Zip(3pm), Date::Format(3pm), Date::Parse(3pm), PCP::LogImport(3pm), OLE::Storage_Lite(3pm), Spreadsheet::ParseExcel(3pm), Spreadsheet::ReadSXC(3pm), Spreadsheet::XLSX(3pm), Text::CSV_XS(3pm), XML::TokeParser(3pm) LOGIMPORT(3). Performance Co-Pilot PCP SHEET2PCP(1)