| Data Columns | Computed Columns |
| Adapter | IBM AS400 |
|---|---|
| IBM OS/400 Collection Services. System and job-related information for AS400 systems. | |
| Domain Category | AS400 |
| ITRM Table Name | XQAJOBS |
| MXG Table Name | QAPMJOBS |
| Table Description | AS400 - job data |
Data Columns
ITRM Column Name  | MXG Column Name | Description |
|---|---|---|
| ASLEVEL | ASLEVEL | As400OperatingLevel |
| DATETIME | DTETIM | Datetime |
| DURATION | INTSEC | Duration |
| INTNUM | INTNUM | IntervalNumber |
| JB2CUD | JB2CUD | SecondaryControllerDescription |
| JB2LND | JB2LND | SecondaryLineDescription |
| JBACCO | JBACCO | JobAccountingCode |
| JBADBR | JBADBR | AsynchronousDatabaseReads |
| JBADBW | JBADBW | AsynchronousDatabaseWrites |
| JBAI | JBAI | TransitionsActiveToIneligibleState |
| JBAIQT | JBAIQT | ApplicationQueueingTime |
| JBANDR | JBANDR | AsynchronousNondatabaseReads |
| JBANDW | JBANDW | AsynchronousNondatabaseWrites |
| JBAPT | JBAPT | JbaptReservedForIbm |
| JBAW | JBAW | TransitionsActiveToWaitState |
| JBBCO | JBBCO | LogicalDbCommits |
| JBBDL | JBBDL | LogicalDbDeletes |
| JBBFE | JBBFE | LogicalDbFeods |
| JBBRG | JBBRG | TimesPagWasBroughtIn |
| JBBRO | JBBRO | LogicalDbRollbacks |
| JBBUP | JBBUP | LogicalDbUpdates |
| JBCDR | JBCDR | JbcdrReservedForIbm |
| JBCDS | JBCDS | JbcdsReservedForIbm |
| JBCGT | JBCGT | CommunicationReads |
| JBCPT | JBCPT | CommunicationWrites |
| JBCPU | JBCPU | CpuTimeUsed |
| JBCS | JBCS | ChecksumI/o-s |
| JBCUD | JBCUD | ControllerDescription |
| JBDBR | JBDBR | SynchronousDatabaseReads |
| JBDBU | JBDBU | MiscellaneousDatabaseOperations |
| JBDBW | JBDBW | SynchronousDatabaseWrites |
| JBDDMF | JBDDMF | TargetDdmJobFlag |
| JBDLCH | JBDLCH | DirectoryLookUpHits |
| JBDLCM | JBDLCM | DirectoryLookUpMisses |
| JBDQR | JBDQR | LogicalNonDbDataQueueReceives |
| JBDQS | JBDQS | LogicalNonDbDataQueueSends |
| JBDRN | JBDRN | DeviceResourceName |
| JBEAF | JBEAF | EmulationActiveFlag |
| JBEAO | JBEAO | EffectiveAddressOverflowException |
| JBEDBC | JBEDBC | Jbedbc |
| JBETRN | JBETRN | JbetrnNowReserved |
| JBFLAG | JBFLAG | JobFlag |
| JBGETA | JBGETA | AmountOfDataReceivedByUsersProg |
| JBGETN | JBGETN | CallsToAcgetToReceiveData |
| JBGGIL | JBGGIL | DurationGetChainTo1stGet |
| JBIOA | JBIOA | IoaNumber |
| JBIPF | JBIPF | PageFaultsPartOfAuxstoreOperation |
| JBIRN | JBIRN | IopResourceName |
| JBLBC | JBLBC | LongRunningDbCloses |
| JBLBI | JBLBI | LongRunningDbIndexBuilds |
| JBLBO | JBLBO | LongRunningDbOpens |
| JBLBS | JBLBS | LongRunningDbSorts |
| JBLND | JBLND | LineDescription |
| JBLRD | JBLRD | LogicalDatabaseReads |
| JBLWT | JBLWT | LogicalDatabaseWrites |
| JBMMT | JBMMT | TimeSpentAtMrtmax |
| JBMRTF | JBMRTF | MrtFlag |
| JBMTXT | JBMTXT | MutexWaitTime |
| JBNAIQ | JBNAIQ | ApplicationQueueingTrans |
| JBNAME | JBNAME | JobNameOrWorkStationName |
| JBNBRR | JBNBRR | JobNumber |
| JBNDA | JBNDA | LogicalNonDbDataAreas |
| JBNDB | JBNDB | SynchronousNondatabaseReads |
| JBNDW | JBNDW | SynchronousNondatabaseWrites |
| JBNETQ | JBNETQ | EntriesIntoTheMrt |
| JBNRU | JBNRU | ResourceUsageTrans |
| JBNSW | JBNSW | JbnswReservedForIbm |
| JBNTR | JBNTR | NumberOfTrans |
| JBNUS | JBNUS | LogicalNonDbUserSpaceOrIndex |
| JBOBIN | JBOBIN | BinaryOverflows |
| JBODEC | JBODEC | DecimalOverflows |
| JBOFLP | JBOFLP | FloatingPointOverflows |
| JBPAGF | JBPAGF | PagFaults |
| JBPCSF | JBPCSF | PcSupportApplicationFlag |
| JBPFL | JBPFL | NumberOfPrintFiles |
| JBPGIL | JBPGIL | DurationPutChainToCdReturn |
| JBPGIN | JBPGIN | PutChainToCdReturnIntervals |
| JBPLN | JBPLN | NumberOfPrintLinesSpooled |
| JBPOOL | JBPOOL | JobPool |
| JBPORT | JBPORT | WorkStationPortNumber |
| JBPPG | JBPPG | NumberOfPrintPages |
| JBPRG | JBPRG | TimesPagWasPurged |
| JBPTSF | JBPTSF | Pass-thruSourceFlag |
| JBPTTF | JBPTTF | Pass-thruTargetFlag |
| JBPTY | JBPTY | JobPriority |
| JBPUTA | JBPUTA | AmountOfDataSentByUsersProgram |
| JBPUTN | JBPUTN | CallsToAcputToSendData |
| JBPW | JBPW | SynchronousPermanentWrites |
| JBQT | JBQT | QueueingTimeToEnterTheMrt |
| JBQT2 | JBQT2 | Jbqt2ReservedForIbm |
| JBROUT | JBROUT | RoutingEntryIndex |
| JBRRI | JBRRI | ReqiosIssuedToReceiveData |
| JBRRT | JBRRT | JobWaitDuringReroutes |
| JBRSP | JBRSP | TotalTransTime |
| JBRTI | JBRTI | ReqiosIssuedToTrabnsmitData |
| JBRUT | JBRUT | ResourceUsageTime |
| JBS36E | JBS36E | JobRunningInS/36Environment? |
| JBSIT1 | JBSIT1 | SituationCounterOne |
| JBSIT2 | JBSIT2 | SituationCounterTwo |
| JBSIT3 | JBSIT3 | SituationCounterThree |
| JBSJNB | JBSJNB | SubmittorsJobNumber |
| JBSJNM | JBSJNM | SubmittorsJobName |
| JBSJUS | JBSJUS | SubmittorsJobUser |
| JBSKBR | JBSKBR | SocketBytesReceived |
| JBSKBS | JBSKBS | SocketBytesSent |
| JBSKRC | JBSKRC | SocketReceives |
| JBSKSC | JBSKSC | SocketSends |
| JBSLC | JBSLC | TimeSliceValue |
| JBSLIB | JBSLIB | LibraryTheSubsystemIsIn |
| JBSPD | JBSPD | SuspendedTime |
| JBSST | JBSST | JbsstReservedForIbm |
| JBSSYS | JBSSYS | SubsystemJobIsRunningIn |
| JBSTN | JBSTN | WorkStationNumber |
| JBSTRN | JBSTRN | JbstrnNowReserved |
| JBSTSF | JBSTSF | StatusFlag |
| JBSTYP | JBSTYP | JobSubtype |
| JBSVIF | JBSVIF | ServerInteractiveFlag? |
| JBSZWT | JBSZWT | Seize/waitTime |
| JBTCPU | JBTCPU | TotalJobCpu |
| JBTDBC | JBTDBC | Jbtdbc |
| JBTFLT | JBTFLT | TotalPageFaults |
| JBTHAC | JBTHAC | ActiveThreads |
| JBTHCT | JBTHCT | ThreadCreated |
| JBTHDF | JBTHDF | Secondary=0Primary=1ThreadFlag |
| JBTHID | JBTHID | ThreadIdentifier |
| JBTTYE | JBTTYE | TaskTypeExtender |
| JBTTYP | JBTTYP | TaskType |
| JBTYPE | JBTYPE | JobType |
| JBUSER | JBUSER | JobUser |
| JBWI | JBWI | TransitionsWaitToIneligibleState |
| JBWIO | JBWIO | WaitsForAsyncIoToComplete |
| JBWRT | JBWRT | NumberOfWrites |
| JBWSID | JBWSID | WorkStationAddress |
| JBXDYR | JBXDYR | DirectoryReads |
| JBXRFR | JBXRFR | RegularFileReads |
| JBXRFW | JBXRFW | RegularFileWrites |
| JBXSLR | JBXSLR | SymbolicLinkReads |
| JIOPB | JIOPB | IopBusNumber |
| JIOPBN | JIOPBN | IopBusAddress |
| LSTPDATE | LSTPDATE | LastProcessDate |
| MACHINE | AS400SYN | Machine |
| SYSNAME | AS400SYS | As400SystemName |
| ZDATE | ZDATE | DateObservationCreated |
Note: Differences between MXG and ITRM column names are highlighted in yellow
Top of PageComputed Columns
| ITRM Column Name | Description | Expression |
|---|---|---|
| DATETIMEFIFTEENMIN | DatetimeFifteenMinute | Formula:DatetimeFifteenMinute |
| DATETIMEFIVEMIN | DatetimeFiveMinute | Formula:DatetimeFiveMinute |
| DATETIMEONEMIN | DatetimeOneMinute | Formula:DatetimeOneMinute |
| DATETIMETENMIN | DatetimeTenMinute | Formula:DatetimeTenMinute |
| DATETIMETHIRTYMIN | DatetimeThirtyMinute | Formula:DatetimeThirtyMinute |
| DATETIMETWENTYMIN | DatetimeTwentyMinute | Formula:DatetimeTwentyMinute |
| DAYDATE | DayDate | Formula:DayDate |
| DAYOFMONTH | DayOfMonth | Formula:DayOfMonth |
| DAYOFWEEK | DayOfWeek | Formula:DayOfWeek |
| HOUR | Hour | Formula:Hour |
| MONTHDATE | MonthDate | Formula:MonthDate |
| SHIFT | Shift | Formula:Shift |
| TIME | Time | Formula:Time |
| WEEKDATE | WeekDate | Formula:WeekDate |
| YEARDATE | YearDate | Formula:YearDate |
v3.3_1 09MAY2012