QAPMPOOL
 
Data Columns | Computed Columns

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

Data Columns
NameLabelTypeLengthFormatInformatExternal NameRecommended
AS400SYNMachine Character8     MACHINE Yes
AS400SYSAs400SystemName Character8     SYSNAME Yes
ASLEVELAs400OperatingLevel Character6     ASLEVEL Yes
DATETIMEDatetime Numeric 8 NLDATM.   DTETIM Yes
DTETIMDatetime Numeric 8 NLDATM.   DATETIME Yes
DURATIONDuration Numeric 8 TIME8.   INTSEC Yes
INTNUMIntervalNumber Numeric 6 NLNUM16.0   INTNUM Yes
INTSECDuration Numeric 8 TIME8.   DURATION Yes
LSTPDATELastProcessDate Numeric 8 NLDATM.   LSTPDATE Yes
MACHINEMachine Character8     AS400SYN Yes
POACTLPoolActivityLevelSetting Numeric 6 NLNUM16.0   POACTL Yes
POAITransitionsActiveToIneligible Numeric 6 NLNUM16.0   POAI Yes
POAWTransitionsActiveToWait Numeric 6 NLNUM16.0   POAW Yes
PODBFPoolDatabaseFaults Numeric 6 NLNUM16.0   PODBF Yes
PODBPGPoolDatabasePagesRead Numeric 6 NLNUM16.0   PODBPG Yes
PONBRPoolNumber Character2     PONBR Yes
PONDBFPoolNondatabaseFaults Numeric 6 NLNUM16.0   PONDBF Yes
PONDPGPoolNondatabasePagesRead Numeric 6 NLNUM16.0   PONDPG Yes
PORESPoolReservedSize Numeric 6 MGBYTES.   PORES Yes
POSIZPoolSize Numeric 6 MGBYTES.   POSIZ Yes
POWITransitionsWaitToIneligible Numeric 6 NLNUM16.0   POWI Yes
PTDBF1Class1DatabaseBlockingFactor Numeric 6 NLNUM16.0   PTDBF1 Yes
PTDBF2Class2DatabaseBlockingFactor Numeric 6 NLNUM16.0   PTDBF2 Yes
PTDBF3Class3DatabaseBlockingFactor Numeric 6 NLNUM16.0   PTDBF3 Yes
PTDBF4Class4DatabaseBlockingFactor Numeric 6 NLNUM16.0   PTDBF4 Yes
PTDEX1Class1DbChangeOperationType Character1     PTDEX1 Yes
PTDEX2Class2DbChangeOperationType Character1     PTDEX2 Yes
PTDEX3Class3DbChangeOperationType Character1     PTDEX3 Yes
PTDEX4Class4DbChangeOperationType Character1     PTDEX4 Yes
PTDTS1Class1DatabaseTypeOfTransfer Character1     PTDTS1 Yes
PTDTS2Class2DatabaseTypeOfTransfer Character1     PTDTS2 Yes
PTDTS3Class3DatabaseTypeOfTransfer Character1     PTDTS3 Yes
PTDTS4Class4DatabaseTypeOfTransfer Character1     PTDTS4 Yes
PTNDBFNon-databaseBlockingFactor Numeric 6 NLNUM16.0   PTNDBF Yes
PTPAGEChangePageHandling Character1     PTPAGE Yes
PTTYPETypeOfTuning Character1     PTTYPE Yes
SHIFT_MXGMXG Shift Character1 $CHAR1.   SHIFT_MXG Yes
ZDATEDateObservationCreated 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