ITRM Aggregation - MonthSystem

Intrinsic Columns | Class Columns | ID Columns | Statistic Columns | Rank Columns

Adapter	SAR
Adapter	System Activity Reporter. System activity counters from most UNIX and Linux variants.
Domain Category	System
Input Staging Table	SAR
Adapter Setup Wizard Configuration Level	Minimal, Typical, Full
Perform Aging	True
Aging Column	MONTHDATE
Age Limit in Days	397
Perform Duplicate Checking	True
Cutoff Time	.
Purge Input Table	False
Purge on Reload	False

Name	Label	Format
CompletedDay	CompletedDay
ContribCount	ContribCount	NLNUM32.
LastUpdated	LastUpdated	NLDATM.
TimePeriod	TimePeriod	NLDATE10.

Top of Page

Name	Label	Format	Input Column	Adapter Setup Wizard Configuration Level
MACHINE	Machine		MACHINE	Minimal, Typical, Full
MONTHDATE	StartOfMonth	NLDATE10.	MONTHDATE	Minimal, Typical, Full

Top of Page

Name	Label	Format	Input Column	Adapter Setup Wizard Configuration Level
OS	OpSys		OS	Minimal, Typical, Full

Top of Page

Input Column	Weight Column	Name	Label	Format	Statistic	Adapter Setup Wizard Configuration Level
ATCH		ATCHMAX	MinorPageFaultRateMax	NLNUM16.2	Max	Full
ATCH	DURATION	ATCHWMEAN	MinorPageFaultRateWMean	NLNUM16.2	WMean	Full
AVLSMEM		AVLSMEMMEAN	SwapSpaceAvailablePagesMean	NLNUM16.2	Mean	Full
AVLSMEM		AVLSMEMMIN	SwapSpaceAvailablePagesMin	NLNUM16.2	Min	Full
BPGIN		BPGINMAX	PagingInputBlockRateMax	NLNUM16.2	Max	Typical, Full
BPGIN	DURATION	BPGINWMEAN	PagingInputBlockRateWMean	NLNUM16.2	WMean	Typical, Full
BPGOUT		BPGOUTMAX	PagingOutputBlockRateMax	NLNUM16.2	Max	Typical, Full
BPGOUT	DURATION	BPGOUTWMEAN	PagingOutputBlockRateWMean	NLNUM16.2	WMean	Typical, Full
BPGTOT		BPGTOTMAX	PagingBlockRateMax	NLNUM16.2	Max	Typical, Full
	DURATION	BPGTOTWMEAN	PagingBlockRateWMean	NLNUM16.2	WMean	Typical, Full
	DURATION	BPGTOTWPSTD	PagingBlockRateWPStd	NLNUM16.2	WPStd	Typical, Full
BRDWR		BRDWRMAX	DiskPhysicalIoRateMax	NLNUM16.2	Max	Typical, Full
	DURATION	BRDWRWMEAN	DiskPhysicalIoRateWMean	NLNUM16.2	WMean	Typical, Full
	DURATION	BRDWRWPSTD	DiskPhysicalIoRateWPStd	NLNUM16.2	WPStd	Typical, Full
BREAD		BREADMAX	DiskPhysicalReadRateMax	NLNUM16.2	Max	Full
BREAD	DURATION	BREADWMEAN	DiskPhysicalReadRateWMean	NLNUM16.2	WMean	Full
BSWIN		BSWINMAX	SwapInBlockRateMax	NLNUM16.2	Max	Full
BSWIN	DURATION	BSWINWMEAN	SwapInBlockRateWMean	NLNUM16.2	WMean	Full
BSWOT		BSWOTMAX	SwapOutBlockRateMax	NLNUM16.2	Max	Full
BSWOT	DURATION	BSWOTWMEAN	SwapOutBlockRateWMean	NLNUM16.2	WMean	Full
BSWTOT		BSWTOTMAX	SwapBlockRateMax	NLNUM16.2	Max	Full
BSWTOT	DURATION	BSWTOTWMEAN	SwapBlockRateWMean	NLNUM16.2	WMean	Full
BWRIT		BWRITMAX	DiskPhysicalWriteRateMax	NLNUM16.2	Max	Full
BWRIT	DURATION	BWRITWMEAN	DiskPhysicalWriteRateWMean	NLNUM16.2	WMean	Full
CPUBUSY		CPUBUSYMAX	CpuBusyPctMax	NLNUM6.2	Max	Minimal, Typical, Full
	DURATION	CPUBUSYWMEAN	CpuBusyPctWMean	NLNUM6.2	WMean	Minimal, Typical, Full
	DURATION	CPUBUSYWPSTD	CpuBusyPctWPStd	NLNUM6.2	WPStd	Minimal, Typical, Full
DIRBLK		DIRBLKMAX	DirectoryBlockReadRateMax	NLNUM16.2	Max	Full
DIRBLK	DURATION	DIRBLKWMEAN	DirectoryBlockReadRateWMean	NLNUM16.2	WMean	Full
DURATION		DURATIONSUM	DurationSum	TIME8.	Sum	Minimal, Typical, Full
EXEC		EXECMAX	SystemExecutionCallRateMax	NLNUM16.2	Max	Full
EXEC	DURATION	EXECWMEAN	SystemExecutionCallRateWMean	NLNUM16.2	WMean	Full
FAULT		FAULTMAX	TotalPageFaultRateMax	NLNUM16.2	Max	Full
FAULT	DURATION	FAULTWMEAN	TotalPageFaultRateWMean	NLNUM16.2	WMean	Full
FORK		FORKMAX	SystemForkCallRateMax	NLNUM16.2	Max	Full
FORK	DURATION	FORKWMEAN	SystemForkCallRateWMean	NLNUM16.2	WMean	Full
FREEMEM		FREEMEMMIN	MemoryPagesAvailableSunScoMin	NLNUM16.2	Min	Typical, Full
	DURATION	FREEMEMWMEAN	MemoryPagesAvailableSunScoWMean	NLNUM16.2	WMean	Typical, Full
	DURATION	FREEMEMWPSTD	MemoryPagesAvailableSunScoWPStd	NLNUM16.2	WPStd	Typical, Full
FREESWP		FREESWPMEAN	DiskAvailableSwapSpaceMean	NLNUM16.2	Mean	Full
FREESWP		FREESWPMIN	DiskAvailableSwapSpaceMin	NLNUM16.2	Min	Full
FRMPG		FRMPGMAX	MemoryPageFreeRateLinuxMax	NLNUM16.2	Max	Full
FRMPG	DURATION	FRMPGWMEAN	MemoryPageFreeRateLinuxWMean	NLNUM16.2	WMean	Full
IDLE2		IDLE2MIN	CpuIdlePctMin	NLNUM6.2	Min	Full
IDLE2	DURATION	IDLE2WMEAN	CpuIdlePctWMean	NLNUM6.2	WMean	Full
IGET		IGETMAX	InodeCallRateMax	NLNUM16.2	Max	Full
IGET	DURATION	IGETWMEAN	InodeCallRateWMean	NLNUM16.2	WMean	Full
INTRSEC		INTRSECMAX	CpuIoInterruptRateMax	NLNUM16.2	Max	Typical, Full
	DURATION	INTRSECWMEAN	CpuIoInterruptRateWMean	NLNUM16.2	WMean	Typical, Full
	DURATION	INTRSECWPSTD	CpuIoInterruptRateWPStd	NLNUM16.2	WPStd	Typical, Full
KMEMFRE2		KMEMFRE2MEAN	MemoryAvailableMBMean	NLNUM16.2	Mean	Typical, Full
		KMEMFRE2MIN	MemoryAvailableMBMin	NLNUM16.2	Min	Typical, Full
		KMEMFRE2PSTD	MemoryAvailableMBPStd	NLNUM16.2	PStd	Typical, Full
KSWPFRE2		KSWPFRE2MEAN	SwapSpaceAvailableMBMean	NLNUM16.2	Mean	Full
KSWPFRE2		KSWPFRE2MIN	SwapSpaceAvailableMBMin	NLNUM16.2	Min	Full
LALLOC2		LALLOC2MAX	MemoryAllocatedLargePoolMBMax	NLNUM16.2	Max	Full
LALLOC2		LALLOC2MEAN	MemoryAllocatedLargePoolMBMean	NLNUM16.2	Mean	Full
LDAVG1		LDAVG1MAX	CpuLoadAvgMax	NLNUM16.2	Max	Typical, Full
	DURATION	LDAVG1WMEAN	CpuLoadAvgWMean	NLNUM16.2	WMean	Typical, Full
	DURATION	LDAVG1WPSTD	CpuLoadAvgWPStd	NLNUM16.2	WPStd	Typical, Full
LGMPCT		LGMPCTMAX	MemoryUsageLargePoolPctMax	NLNUM6.2	Max	Full
LGMPCT	DURATION	LGMPCTWMEAN	MemoryUsageLargePoolPctWMean	NLNUM6.2	WMean	Full
LKUPPN		LKUPPNMAX	FilesystemPathLookupRateMax	NLNUM16.2	Max	Full
LKUPPN	DURATION	LKUPPNWMEAN	FilesystemPathLookupRateWMean	NLNUM16.2	WMean	Full
LRDWR		LRDWRMAX	CacheLogicalIoRateMax	NLNUM16.2	Max	Full
LRDWR	DURATION	LRDWRWMEAN	CacheLogicalIoRateWMean	NLNUM16.2	WMean	Full
LREAD		LREADMAX	CacheLogicalReadRateMax	NLNUM16.2	Max	Full
LREAD	DURATION	LREADWMEAN	CacheLogicalReadRateWMean	NLNUM16.2	WMean	Full
LWRIT		LWRITMAX	CacheLogicalWriteRateMax	NLNUM16.2	Max	Full
LWRIT	DURATION	LWRITWMEAN	CacheLogicalWriteRateWMean	NLNUM16.2	WMean	Full
MAJFLT		MAJFLTMAX	MajorPageFaultRateMax	NLNUM16.2	Max	Full
MAJFLT	DURATION	MAJFLTWMEAN	MajorPageFaultRateWMean	NLNUM16.2	WMean	Full
NCEBUSY		NCEBUSYMAX	CpuNiceBusyPctMax	NLNUM6.2	Max	Full
NCEBUSY	DURATION	NCEBUSYWMEAN	CpuNiceBusyPctWMean	NLNUM6.2	WMean	Full
OVSZAL2		OVSZAL2MAX	MemoryAllocatedOversizeDynamicMBMax	NLNUM16.2	Max	Full
OVSZAL2		OVSZAL2MEAN	MemoryAllocatedOversizeDynamicMBMean	NLNUM16.2	Mean	Full
PCTMEMU		PCTMEMUMAX	MemoryUsagePctMax	NLNUM6.2	Max	Typical, Full
	DURATION	PCTMEMUWMEAN	MemoryUsagePctWMean	NLNUM6.2	WMean	Typical, Full
	DURATION	PCTMEMUWPSTD	MemoryUsagePctWPStd	NLNUM6.2	WPStd	Typical, Full
PCTSWPU		PCTSWPUMAX	SwapSpaceUsagePctMax	NLNUM6.2	Max	Typical, Full
	DURATION	PCTSWPUWMEAN	SwapSpaceUsagePctWMean	NLNUM6.2	WMean	Typical, Full
	DURATION	PCTSWPUWPSTD	SwapSpaceUsagePctWPStd	NLNUM6.2	WPStd	Typical, Full
PFLT		PFLTMAX	ProtectionPageFaultRateMax	NLNUM16.2	Max	Full
PFLT	DURATION	PFLTWMEAN	ProtectionPageFaultRateWMean	NLNUM16.2	WMean	Full
PGFREE		PGFREEMAX	MemoryPageFreeRateSunMax	NLNUM16.2	Max	Full
PGFREE	DURATION	PGFREEWMEAN	MemoryPageFreeRateSunWMean	NLNUM16.2	WMean	Full
PGIN		PGINMAX	PagingInputRequestRateMax	NLNUM16.2	Max	Full
PGIN	DURATION	PGINWMEAN	PagingInputRequestRateWMean	NLNUM16.2	WMean	Full
PGOUT		PGOUTMAX	PagingOutputRequestRateMax	NLNUM16.2	Max	Full
PGOUT	DURATION	PGOUTWMEAN	PagingOutputRequestRateWMean	NLNUM16.2	WMean	Full
PGSCAN		PGSCANMAX	MemoryPageScanRateMax	NLNUM16.2	Max	Full
PGSCAN	DURATION	PGSCANWMEAN	MemoryPageScanRateWMean	NLNUM16.2	WMean	Full
PPGIN		PPGINMAX	PagingInputRateMax	NLNUM16.2	Max	Typical, Full
PPGIN	DURATION	PPGINWMEAN	PagingInputRateWMean	NLNUM16.2	WMean	Typical, Full
PPGOUT		PPGOUTMAX	PagingOutputRateMax	NLNUM16.2	Max	Typical, Full
PPGOUT	DURATION	PPGOUTWMEAN	PagingOutputRateWMean	NLNUM16.2	WMean	Typical, Full
PPGTOT		PPGTOTMAX	PagingRateMax	NLNUM16.2	Max	Typical, Full
	DURATION	PPGTOTWMEAN	PagingRateWMean	NLNUM16.2	WMean	Typical, Full
	DURATION	PPGTOTWPSTD	PagingRateWPStd	NLNUM16.2	WPStd	Typical, Full
PRDWR		PRDWRMAX	DiskRawIoRateMax	NLNUM16.2	Max	Full
PRDWR	DURATION	PRDWRWMEAN	DiskRawIoRateWMean	NLNUM16.2	WMean	Full
PREAD		PREADMAX	DiskRawReadRateMax	NLNUM16.2	Max	Full
PREAD	DURATION	PREADWMEAN	DiskRawReadRateWMean	NLNUM16.2	WMean	Full
PSWCH		PSWCHMAX	CpuContextSwitchRateMax	NLNUM16.2	Max	Full
PSWCH	DURATION	PSWCHWMEAN	CpuContextSwitchRateWMean	NLNUM16.2	WMean	Full
PSWPIN		PSWPINMAX	SwapInPageRateMax	NLNUM16.2	Max	Full
PSWPIN	DURATION	PSWPINWMEAN	SwapInPageRateWMean	NLNUM16.2	WMean	Full
PWRIT		PWRITMAX	DiskRawWriteRateMax	NLNUM16.2	Max	Full
PWRIT	DURATION	PWRITWMEAN	DiskRawWriteRateWMean	NLNUM16.2	WMean	Full
RCACHE		RCACHEMIN	CacheReadHitPctMin	NLNUM6.2	Min	Full
RCACHE	DURATION	RCACHEWMEAN	CacheReadHitPctWMean	NLNUM6.2	WMean	Full
RCHAR		RCHARMAX	SystemCharacterReadRateMax	NLNUM16.2	Max	Full
RCHAR	DURATION	RCHARWMEAN	SystemCharacterReadRateWMean	NLNUM16.2	WMean	Full
RUNOCC		RUNOCCMAX	RunQueuePctMax	NLNUM6.2	Max	Full
RUNOCC	DURATION	RUNOCCWMEAN	RunQueuePctWMean	NLNUM6.2	WMean	Full
RUNQSZ		RUNQSZMAX	RunQueueLengthMax	NLNUM16.2	Max	Minimal, Typical, Full
	DURATION	RUNQSZWMEAN	RunQueueLengthWMean	NLNUM16.2	WMean	Minimal, Typical, Full
	DURATION	RUNQSZWPSTD	RunQueueLengthWPStd	NLNUM16.2	WPStd	Minimal, Typical, Full
SALLOC2		SALLOC2MAX	MemoryAllocatedSmallPoolMBMax	NLNUM16.2	Max	Full
SALLOC2		SALLOC2MEAN	MemoryAllocatedSmallPoolMBMean	NLNUM16.2	Mean	Full
SCALL		SCALLMAX	SystemCallRateMax	NLNUM16.2	Max	Full
SCALL	DURATION	SCALLWMEAN	SystemCallRateWMean	NLNUM16.2	WMean	Full
SLOTS		SLOTSMEAN	MemoryPagesAvailableAixMean	NLNUM16.2	Mean	Typical, Full
		SLOTSMIN	MemoryPagesAvailableAixMin	NLNUM16.2	Min	Typical, Full
		SLOTSPSTD	MemoryPagesAvailableAixPStd	NLNUM16.2	PStd	Typical, Full
SMLMPCT		SMLMPCTMAX	MemoryUsageSmallPoolPctMax	NLNUM6.2	Max	Full
SMLMPCT	DURATION	SMLMPCTWMEAN	MemoryUsageSmallPoolPctWMean	NLNUM6.2	WMean	Full
SREAD		SREADMAX	SystemReadCallRateMax	NLNUM16.2	Max	Full
SREAD	DURATION	SREADWMEAN	SystemReadCallRateWMean	NLNUM16.2	WMean	Full
SWPIN		SWPINMAX	SwapInRequestRateMax	NLNUM16.2	Max	Full
SWPIN	DURATION	SWPINWMEAN	SwapInRequestRateWMean	NLNUM16.2	WMean	Full
SWPOCC		SWPOCCMAX	SwapQueuePctMax	NLNUM6.2	Max	Full
SWPOCC	DURATION	SWPOCCWMEAN	SwapQueuePctWMean	NLNUM6.2	WMean	Full
SWPOT		SWPOTMAX	SwapOutRequestRateMax	NLNUM16.2	Max	Full
SWPOT	DURATION	SWPOTWMEAN	SwapOutRequestRateWMean	NLNUM16.2	WMean	Full
SWPQSZ		SWPQSZMAX	SwapQueueLengthMax	NLNUM16.2	Max	Full
SWPQSZ	DURATION	SWPQSZWMEAN	SwapQueueLengthWMean	NLNUM16.2	WMean	Full
SWRIT		SWRITMAX	SystemWriteCallRateMax	NLNUM16.2	Max	Full
SWRIT	DURATION	SWRITWMEAN	SystemWriteCallRateWMean	NLNUM16.2	WMean	Full
SYSBUSY		SYSBUSYMAX	CpuSystemBusyPctMax	NLNUM6.2	Max	Minimal, Typical, Full
SYSBUSY	DURATION	SYSBUSYWMEAN	CpuSystemBusyPctWMean	NLNUM6.2	WMean	Minimal, Typical, Full
USRBUSY		USRBUSYMAX	CpuUserBusyPctMax	NLNUM6.2	Max	Minimal, Typical, Full
USRBUSY	DURATION	USRBUSYWMEAN	CpuUserBusyPctWMean	NLNUM6.2	WMean	Minimal, Typical, Full
VFLT		VFLTMAX	TranslationPageFaultRateMax	NLNUM16.2	Max	Full
VFLT	DURATION	VFLTWMEAN	TranslationPageFaultRateWMean	NLNUM16.2	WMean	Full
WCACHE		WCACHEMIN	CacheWriteHitPctMin	NLNUM6.2	Min	Full
WCACHE	DURATION	WCACHEWMEAN	CacheWriteHitPctWMean	NLNUM6.2	WMean	Full
WCHAR		WCHARMAX	SystemCharacterWriteRateMax	NLNUM16.2	Max	Full
WCHAR	DURATION	WCHARWMEAN	SystemCharacterWriteRateWMean	NLNUM16.2	WMean	Full
WIO		WIOMAX	CpuWaitIoBusyPctMax	NLNUM6.2	Max	Typical, Full
	DURATION	WIOWMEAN	CpuWaitIoBusyPctWMean	NLNUM6.2	WMean	Typical, Full
	DURATION	WIOWPSTD	CpuWaitIoBusyPctWPStd	NLNUM6.2	WPStd	Typical, Full

Top of Page

Name	Label	Input Column	Rank Order	Rank Over	Completed Periods Only	Adapter Setup Wizard Configuration Level
MONTHDATERANK01	MonthDateDescRank	MonthDate	Descending		True	Minimal, Typical, Full
BPGTOTRANK01	PagingBlockRateWMeanDescRank	BPGTOTWMEAN	Descending	MONTHDATE	True	Typical, Full
BRDWRRANK01	DiskPhysicalIoRateWMeanDescRank	BRDWRWMEAN	Descending	MONTHDATE	True	Typical, Full
CPUBUSYRANK01	CpuBusyPctWMeanDescRank	CPUBUSYWMEAN	Descending	MONTHDATE	True	Minimal, Typical, Full
FREEMEMRANK01	MemoryPagesAvailableSunScoMinAscRank	FREEMEMMIN	Ascending	MONTHDATE	True	Typical, Full
INTRSECRANK01	CpuIoInterruptRateWMeanDescRank	INTRSECWMEAN	Descending	MONTHDATE	True	Typical, Full
KMEMFRE2RANK01	MemoryAvailableMBMinAscRank	KMEMFRE2MIN	Ascending	MONTHDATE	True	Typical, Full
LDAVG1RANK01	CpuLoadAvgWMeanDescRank	LDAVG1WMEAN	Descending	MONTHDATE	True	Typical, Full
PCTMEMURANK01	MemoryUsagePctWMeanDescRank	PCTMEMUWMEAN	Descending	MONTHDATE	True	Typical, Full
PPGTOTRANK01	PagingRateWMeanDescRank	PPGTOTWMEAN	Descending	MONTHDATE	True	Typical, Full
RCACHERANK01	CacheReadHitPctMinAscRank	RCACHEMIN	Ascending	MONTHDATE	True	Full
RUNQSZRANK01	RunQueueLengthWMeanDescRank	RUNQSZWMEAN	Descending	MONTHDATE	True	Minimal, Typical, Full
SLOTSRANK01	MemoryPagesAvailableAixMinAscRank	SLOTSMIN	Ascending	MONTHDATE	True	Typical, Full
WIORANK01	CpuWaitIoBusyPctWMeanDescRank	WIOWMEAN	Descending	MONTHDATE	True	Typical, Full

Top of Page

v304000 26SEP2013