QAPMSYST
 
Data Columns | Computed Columns

AdapterIBM AS400
IBM OS/400 Collection Services. System and job-related information for AS400 systems.
Domain CategoryAS400
DescriptionAS400 - system performance data
External TableQAPMSYST
Table TypeINTERVAL
RecommendedNo

Data Columns
NameLabelTypeLengthFormatInformatExternal NameRecommended
AS400SYNInternalSystemName Character8     MACHINE No
AS400SYSAs400SystemName Character8     SYSNAME No
ASLEVELAs400OperatingLevel Character6     ASLEVEL No
DATETIMEIntervalEndEvent Numeric 8 NLDATM.   DTETIM No
DTETIMIntervalEndEvent Numeric 8 NLDATM.   DATETIME No
DURATIONIntervalDuration Numeric 8 TIME8.   INTSEC No
INTNUMIntervalNumber Numeric 5 NLNUM16.0   INTNUM No
INTSECIntervalDuration Numeric 8 TIME8.   DURATION No
LSTPDATELastProcessDate Numeric 8 NLDATM.   LSTPDATE Yes
MACHINEInternalSystemName Character8     AS400SYN No
PCTCPDBYPctDatabaseCpuBusy Numeric 5 NLNUM6.2   PCCPDBY No
PCTCPSBYPctSecondaryWorkloadCpuBusy Numeric 5 NLNUM6.2   PCCPSBY No
PCTCPTBYPctSystaskCpuBusy Numeric 5 NLNUM6.2   PCTCPTB No
PCTCPUBYPctCpuWasBusy Numeric 5 NLNUM6.2   PCCPUBY No
SHCPUCpuTimeUsedBySystasksAndJobs Numeric 5 TIME12.2   SHCPU No
SHIFT_MXGMXG Shift Character1 $CHAR1.   SHIFT_MXG Yes
SMMERequestorsThatRoutedToAMrt Numeric 5 NLNUM16.0   SMME No
SMMMTTimeAtMrtmaxByAllMrtRequestors Numeric 5 TIME12.2   SMMMT No
SMPLPMachinePoolPaging Numeric 5 NLNUM16.0   SMPLP No
SMUPLHighestUserPoolPaging Numeric 5 NLNUM16.2   SMUPL No
SMXDUPeakDiskUsage Numeric 5 NLNUM6.2   SMXDU No
SMXDUIArmWithPeakUsage Character4     SMXDUI No
SUPLIPoolWithHighestPaging Character2     SUPLI No
SYAPGFAccessGroupMemberPageFaults Numeric 5 NLNUM16.0   SYAPGF No
SYASYLAsyncLockConflicts Numeric 5 NLNUM16.0   SYASYL No
SYAUTHAuthorityLookupCount Numeric 5 NLNUM16.0   SYAUTH No
SYBTACAsyncClearOperations Numeric 5 NLNUM16.0   SYBTAC No
SYBTAPAsyncPrebringOperations Numeric 5 NLNUM16.0   SYBTAP No
SYBTAPCAsyncCreateOperations Numeric 5 NLNUM16.0   SYBTAPC No
SYBTAPDAsyncDeleteOperations Numeric 5 NLNUM16.0   SYBTAPD No
SYBTAPPParallelPrebringOperations Numeric 5 NLNUM16.0   SYBTAPP No
SYCTAConfiguredCpuTimeAvailable Numeric 5 TIME13.3   SYCTA No
SYDECDDecimalDataCount Numeric 5 NLNUM16.0   SYDECD No
SYDPCHTotalDispatchTime Numeric 5 TIME13.3   SYDPCH No
SYDPGFDirectoryPageFaults Numeric 5 NLNUM16.0   SYDPGF No
SYEXPNTotalExceptions Numeric 5 NLNUM16.0   SYEXPN No
SYFOPNFullOpensSystemWide Numeric 5 NLNUM16.0   SYFOPN No
SYHEAOTeraspaceEaoExceptions Numeric 5 NLNUM16.0   SYHEAO No
SYHFTHFalseTrapsTeraspaceAddress Numeric 5 NLNUM16.0   SYHFTH No
SYHFTSFalseTrapsSpaceAddress Numeric 5 NLNUM16.0   SYHFTS No
SYIFTATimeAvailableInteractiveFeature Numeric 5 TIME13.3   SYIFTA No
SYIFTETimeUsedExeedingThreshold Numeric 5 TIME13.3   SYIFTE No
SYIFUSTimeUsedInteractiveFeature Numeric 5 TIME13.3   SYIFUS No
SYIXRBIndexRebuildsSystemWide Numeric 5 NLNUM16.0   SYIXRB No
SYJOBDBundleWritesToDefaultJournalPorts Numeric 5 NLNUM16.0   SYJOBD No
SYJOBJBundleWritesToUserJournalPorts Numeric 5 NLNUM16.0   SYJOBJ No
SYJOC11stBundlesForced Numeric 5 NLNUM16.0   SYJOC1 No
SYJOC22ndBundlesForced Numeric 5 NLNUM16.0   SYJOC2 No
SYJOC33rdBundlesForced Numeric 5 NLNUM16.0   SYJOC3 No
SYJOERSmappEvaluationsRequested Numeric 5 NLNUM16.0   SYJOER No
SYJOESSmappEvaluationsServices Numeric 5 NLNUM16.0   SYJOES No
SYJOIBSmappIndexBuildTimeEstimate Numeric 5 TIME12.2   SYJOIB No
SYJOIDJournalImplicitDepositsTotal Numeric 5 NLNUM16.0   SYJOID No
SYJOIPImplicitStopJournalOperations Numeric 5 NLNUM16.0   SYJOIP No
SYJOIRImplicitStartJournalOperations Numeric 5 NLNUM16.0   SYJOIR No
SYJOJNExposedIndexesNotBeingJournaled Numeric 5 NLNUM16.0   SYJOJN No
SYJOJPJournalImplicitDepositsUser Numeric 5 NLNUM16.0   SYJOJP No
SYJOJYExposedIndexesImplicitlyJournaled Numeric 5 NLNUM16.0   SYJOJY No
SYJONDEstimatedExposureNoSmapp Numeric 5 NLNUM16.0   SYJOND No
SYJORTRe-tunes Numeric 5 NLNUM16.0   SYJORT No
SYJOS11stFrequentJournalEntryType Character2     SYJOS1 No
SYJOS22ndFrequentJournalEntryType Character2     SYJOS2 No
SYJOS33rdFrequentJournalEntryType Character2     SYJOS3 No
SYJOSEEstimatedSystemExposure Numeric 5 NLNUM16.0   SYJOSE No
SYJOXDJournalExplicitDeposits Numeric 5 NLNUM16.0   SYJOXD No
SYJOXPExplicitStopJournalOperations Numeric 5 NLNUM16.0   SYJOXP No
SYJOXRExplicitStartJournalOperations Numeric 5 NLNUM16.0   SYJOXR No
SYJPASSyjpas Character3     SYJPAS No
SYJS6ESyjs6e Character3     SYJS6E No
SYJSPLSyjspl Character3     SYJSPL No
SYLPTBLparTimeBase Numeric 5 TIME12.2   SYLPTB No
SYLRT1TransInRtmBracket1 Numeric 5 NLNUM16.0   SYLRT1 No
SYLRT2TransInRtmBracket2 Numeric 5 NLNUM16.0   SYLRT2 No
SYLRT3TransInRtmBracket3 Numeric 5 NLNUM16.0   SYLRT3 No
SYLRT4TransInRtmBracket4 Numeric 5 NLNUM16.0   SYLRT4 No
SYLRT5TransInRtmBracket5 Numeric 5 NLNUM16.0   SYLRT5 No
SYMCTRMicrotaskReadOperations Numeric 5 NLNUM16.0   SYMCTR No
SYMCTWMicrotaskWriteOperations Numeric 5 NLNUM16.0   SYMCTW No
SYMPGFMicrocodePageFaults Numeric 5 NLNUM16.0   SYMPGF No
SYNPLASharedPoolCpuTimeAvailable Numeric 5 TIME13.3   SYNPLA No
SYNPLUSharedPoolCpuTimeUsed Numeric 5 TIME13.3   SYNPLU No
SYNUALNoncachedUserAuthorityLookups Numeric 5 NLNUM16.0   SYNUAL No
SYNUTCUncappedCpuTimeConfigured Numeric 5 TIME13.3   SYNUTC No
SYPRMWPermanentDataTransferred Numeric 5 MGBYTES.   SYPRMW No
SYSASPSystemAspSpaceAvailable Numeric 5 MGBYTES.   SYSASP No
SYSCIUUserAuthorizationsNeeded Numeric 5 TIME13.3   SYSCIU Yes
SYSDBCDatabaseCpuTime Numeric 5 TIME12.2   SYSDBC No
SYSDFALUnforcedStreamFiles Numeric 5 NLNUM16.0   SYSDFAL No
SYSDFRLForcedStreamFiles Numeric 5 NLNUM16.0   SYSDFRL No
SYSDNFEStreamFilesExposed Numeric 5 NLNUM16.0   SYSDNFE No
SYSDNFOStreamFilesOverdue Numeric 5 NLNUM16.0   SYSDNFO No
SYSDNSTForceTasks Numeric 5 NLNUM16.0   SYSDNST No
SYSDPFDForcedStreamFilePages Numeric 5 NLNUM16.0   SYSDPFD No
SYSDPFFPagesForcedByFsync Numeric 5 NLNUM16.0   SYSDPFF No
SYSDTETExposureTime Numeric 5 TIME13.3   SYSDTET No
SYSEZCSeizeCount Numeric 5 NLNUM16.0   SYSEZC No
SYSHRFSharedProcessorFlag0=no1=yes Character1     SYSHRF No
SYSIULUserAuthorizationsAvailable Numeric 5 NLNUM16.0   SYSIUL Yes
SYSIZCSizeCount Numeric 5 NLNUM16.2   SYSIZC No
SYSPTUTotalCpuTimeUsed Numeric 5 TIME13.3   SYSPTU No
SYSSWCSecondaryWorkloadCpuTime Numeric 5 TIME12.2   SYSSWC No
SYSYNLSyncLockConflicts Numeric 5 NLNUM16.0   SYSYNL No
SYSZWTSeize/waitTime Numeric 5 TIME12.2   SYSZWT No
SYUTAUncappedCpuTimeAvailable Numeric 5 TIME13.3   SYUTA No
SYVCPUVirtualProcessorTimeConfigured Numeric 5 TIME13.3   SYVCPU No
SYVFYCVerifyCount Numeric 5 NLNUM16.0   SYVFYC No
ZDATEZeeDateZeeObsWasCreated Numeric 4 NLDATE10.   ZDATE No
Top of Page

Computed Columns
NameLabelTypeLengthFormatInformatExpressionRecommended
DATETIMEFIFTEENMINDatetimeFifteenMinute Numeric 8 NLDATM.   Formula:DatetimeFifteenMinute Yes
DATETIMEFIVEMINDatetimeFiveMinute Numeric 8 NLDATM.   Formula:DatetimeFiveMinute Yes
DATETIMEONEMINDatetimeOneMinute Numeric 8 NLDATM.   Formula:DatetimeOneMinute Yes
DATETIMETENMINDatetimeTenMinute Numeric 8 NLDATM.   Formula:DatetimeTenMinute Yes
DATETIMETHIRTYMINDatetimeThirtyMinute Numeric 8 NLDATM.   Formula:DatetimeThirtyMinute Yes
DATETIMETWENTYMINDatetimeTwentyMinute Numeric 8 NLDATM.   Formula:DatetimeTwentyMinute Yes
DAYDATEDate Numeric 8 NLDATE10.   Formula:DayDate Yes
DAYOFMONTHDayOfMonth Numeric 8 2.   Formula:DayOfMonth Yes
DAYOFWEEKDayOfWeek Numeric 8 WKD.   Formula:DayOfWeek Yes
HOURHour Numeric 8 2.   Formula:Hour Yes
MONTHDATEStartOfMonth Numeric 8 NLDATE10.   Formula:MonthDate Yes
SHIFTShift Character1 $CHAR1.   Formula:Shift Yes
TIMETime Numeric 8 TOD5.   Formula:Time Yes
WEEKDATEStartOfWeek Numeric 8 NLDATE10.   Formula:WeekDate Yes
YEARDATEStartOfYear Numeric 8 NLDATE10.   Formula:YearDate Yes
Top of Page
v304000  27SEP2013