Collection Services data files: QAPMJOBS and QAPMJOBL
The QAPMJOBL file is provided for compatibility with the performance monitor and combines data from the QAPMJOBMI file and the QAPMJOBOS file.
The QAPMJOBS file is created when the performance monitor database files are migrated with the Convert Performance Collection (CVTPFRCOL) command to a newer release. Collection Services does not create the QAPMJOBS file.
The database files contain data for
each job, task or thread (one record per job, task, or thread). Collection
Services provides data only for jobs that consume CPU during an interval. Job
means
job, task, or thread. Data in this file comes from the *JOBMI and
*JOBOS categories.
| Field Name | Description | Attribute |
|---|---|---|
| INTNUM | Interval number: The nth sample database interval based on the start time specified in the Create Performance Data (CRTPFRDTA) command. | PD (5,0) |
| DTETIM | Interval date (yymmdd) for job interval entry and job completion date, and time (hhmmss) for job completion entry. | C (12) |
| INTSEC | Elapsed interval seconds. | PD (7,0) |
| JBSSYS | Name of the subsystem the job is running in. | C (10) |
| JBSLIB | Name of the library the subsystem description is in. | C (10) |
| JBNAME | Job name/workstation name. | C (16) |
| JBUSER | Job user. | C (10) |
| JBNBR | Job number. | C (6) |
| JBACCO | Job accounting code. Field cannot be displayed. | C (15) |
| JBTYPE | Job type (A:Autostart, B:Batch, I:Interactive, M:Subsystem monitor, R:Spool reader, S:System, V:SLIC task, W:Spool writer, X:SCPF job) | C (1) |
| JBSTYP | Job subtype. (T:MRT (System/36 environment only) E:Evoke (communications batch), P:Print driver job, J:Prestart job, F:M36 (Advanced/36 server job), D:Batch immediate job, U:Alternative spool user.) | C (1) |
| JBTTYP | Task type. (01:Resident task, 02:Supervisor task, 03:MI process task, 04:S36 emulation task). | C (2) |
| JBTTYE | Task type extender. See task type extender definitions for detailed information about a task type extender. (See note 1.) | C (2) |
| JBFLAG | Job flag. (Bit, 0:Pass-through source, 1:Pass-through target, 2:Emulation active, 3:IBM® i Access application, 4:Target DDM job, 5:MRT, 6-15: Not used) Field cannot be displayed. | C (2) |
| JBS36E | Is job running in System/36 environment? (Y/N) | C (1) |
| JBPOOL | Job pool. | C (2) |
| JBPRTY | Job priority. | C (3) |
| JBCPU | Thread unscaled interval CPU time charged. The amount of unscaled
processing time (in milliseconds) charged to this thread. It includes
unscaled processing time used by this thread and any unscaled processing
time charged to the thread by server tasks that worked on its behalf
within the interval. (See note 2.) For server tasks, this field will be zero. |
PD (15,3) |
| JBRSP | Total transaction time (in seconds.) Certain IBM i functions support the concept of a transaction. The definition of transaction and the characteristics of a transaction are different depending on the type of job or the specific function of the job. For interactive jobs, display I/O transactions are counted. The transaction starts on detection of enter from the workstation; the transaction ends when the keyboard is unlocked. For SNADS jobs, a transaction is the processing of a distribution. | PD (15,3) |
| JBSLC | Time-slice value (in milliseconds.) | PD (11,0) |
| JBNTR | Number of transactions. Certain IBM i functions support the concept of a transaction. The definition of transaction and the characteristics of a transaction are different depending on the type of job or the specific function of the job. For interactive jobs, display I/O transactions are counted. The transaction starts on detection of enter from the workstation; the transaction ends when the keyboard is unlocked. For SNADS jobs, a transaction is the processing of a distribution. | PD (11,0) |
| JBDBR | Number of synchronous database reads: Total number of physical synchronous database read operations for database functions. (See note 2.) | PD (11,0) |
| JBNDB | Number of synchronous nondatabase reads: Total number of physical synchronous nondatabase read operations for nondatabase functions. (See note 2.) | PD (11,0) |
| JBWRT | Number of writes: Total number of physical database and nondatabase write operations. (See note 2.) | PD (11,0) |
| JBAW | Total number of transitions from active state to wait state for this job. (See note 2.) | PD (11,0) |
| JBWI | Total number of transitions from wait state to ineligible state for this job. (See note 2.) | PD (11,0) |
| JBAI | Total number of transitions from active state to ineligible state for this job. (See note 2.) | PD (11,0) |
| JBPLN | Number of print lines: Number of lines written by the program. This does not reflect what is actually printed. Spooled files can be ended, or printed with multiple copies. (See note 3.) | PD (11,0) |
| JBPPG | Number of print pages. (See note 3.) | PD (11,0) |
| JBPFL | Number of print files. (See note 3.) | PD (11,0) |
| JBLWT | Number of database writes (logical): Number of times the internal database write function was called. This does not include I/O operations to readers/writers, or I/O operations caused by the CPYSPLF or DSPSPLF command. If SEQONLY(*YES) is specified, these numbers show each block of records written, not the number of individual records written. (See note 3.) | PD (11,0) |
| JBLRD | Number of database reads (logical): Number of times the database module was called. This does not include I/O operations to readers/writers, or I/O operations caused by the CPYSPLF or DSPSPLF command. If SEQONLY(*YES) is specified, these numbers show each block of records read, not the number of individual records read. (See note 3.) | PD (11,0) |
| JBDBU | Number of miscellaneous database operations: Updates, deletes, force-end-of-data, commits, rollbacks, and releases (logical). (See note 3.) | PD (11,0) |
| JBCPT | Number of communications writes: These do not include remote workstation activity. They include only activity related to intersystem communications function (ICF) files when the I/O is for an ICF device. (See note 3.) | PD (11,0) |
| JBCGT | Number of communications reads (logical): These do not include remote workstation activity. They include only activity related to intersystem communications function (ICF) files when the I/O is for an ICF device. (See note 3.) | PD (11,0) |
| JBSPD | Total suspended time (in milliseconds.) (See note 3.) | PD (11,0) |
| JBRRT | Total time job waited during reroutes (in milliseconds.) (See note 3.) | PD (11,0) |
| JBLND | Line description: Name of the communications line this workstation and its controller is attached to. This is only available for remote workstations. (See note 3.) | C (10) |
| JBCUD | Controller description: Name of the controller this workstation is attached to. (See note 3.) | C (10) |
| JB2LND | Secondary line description (pass-through and emulation only.) (See note 3.) | C (10) |
| JB2CUD | Secondary controller description (pass-through and emulation only.) (See note 3.) | C (10) |
| JBBRG | Reserved | PD (9,0) |
| JBPRG | Reserved | PD (9,0) |
| JBNDW | Number of synchronous nondatabase writes: Total number of synchronous physical nondatabase write operations for nondatabase functions. (See note 2.) | PD (11,0) |
| JBDBW | Number of synchronous database writes: Total number of synchronous physical database write operations for database functions. (See note 2.) | PD (11,0) |
| JBANDW | Number of asynchronous nondatabase writes: Total number of asynchronous physical nondatabase write operations for nondatabase functions. (See note 2.) | PD (11,0) |
| JBADBW | Number of asynchronous database writes: Total number of asynchronous physical database write operations for database functions. (See note 2.) | PD (11,0) |
| JBANDR | Number of asynchronous nondatabase reads: Total number of asynchronous physical nondatabase read operations for nondatabase functions. (See note 2.) | PD (11,0) |
| JBADBR | Number of asynchronous database reads: Total number of asynchronous physical database read operations for database functions. (See note 2.) | PD (11,0) |
| JBPW | Number of synchronous permanent writes. (See note 2.) | PD (11,0) |
| JBCS | Reserved | PD (11,0) |
| JBPAGF | Number of PAG faults. Total number of times the program access group (PAG) was referred to, but was not in main storage. The Licensed Internal Code no longer uses process access groups for caching data. Because of this implementation, this field will always be 0 for more current releases. (See note 2.) | PD (11,0) |
| JBEAO | Reserved | PD (11,0) |
| JBOBIN | Number of binary overflows. (See note 2.) | PD (11,0) |
| JBODEC | Number of decimal overflows. (See note 2.) | PD (11,0) |
| JBOFLP | Number of floating point overflows. (See note 2.) | PD (11,0) |
| JBIPF | Number of times a page fault occurred on an address that was currently part of an auxiliary storage I/O operation. (See note 2.) | PD (11,0) |
| JBWIO | Number of times the process explicitly waited for outstanding asynchronous I/O operations to complete. (See note 2.) | PD (11,0) |
| JBIRN | IOP resource name. (See note 3.) | C (10) |
| JBDRN | Device resource name. (See note 3.) | C (10) |
| JIOPB | Reserved | PD(3,0) |
| JIOPA | Reserved | PD(3,0) |
| JBPORT | Workstation port number. (See note 3.) | PD (3,0) |
| JBSTN | Workstation number. (See note 3.) | PD (3,0) |
| JBPTSF | Pass-through source flag. | PD (1,0) |
| JBPTTF | Pass-through target flag. | PD (1,0) |
| JBEAF | Emulation active flag. | PD (1,0) |
| JBPCSF | IBM i Access application flag. | PD (1,0) |
| JBDDMF | Target DDM job flag. | PD (1,0) |
| JBMRTF | MRT flag. | PD (1,0) |
| JBROUT | The routing entry index for the subsystem this job is in. | PD (5,0) |
| JBAPT | Reserved. | PD (11,0) |
| JBNSW | Reserved. | PD (11,0) |
| JBSST | Reserved. | PD (11,0) |
| JBQT2 | Reserved. | PD (11,0) |
| JBCDR | Reserved. | PD (11,0) |
| JBCDS | Reserved. | PD (11,0) |
| JBAIQT | Total application input queuing time (in hundredths of a second.) (See note 3.) | PD (15,1) |
| JBNAIQ | Number of application input queuing transactions. (See note 3.) | PD (11,0) |
| JBRUT | Total resource usage time (in seconds.) (See note 3.) | PD (15,3) |
| JBNRU | Number of resource usage transactions. (See note 3.) | PD (11,0) |
| JBQT | Total queuing time to enter the MRT (in hundredths of seconds.) (See note 3.) | PD (11,0) |
| JBMMT | Total time spent at MRTMAX (in seconds.) (See note 3.) | PD (11,0) |
| JBNEQT | Total number of entries into the MRT. (See note 3.) | PD (11,0) |
| JBPUTN | The number of times ACPUT was called to send user or control data. Calls that result in no data being sent are not counted. (See note 3.) | PD (11,0) |
| JBPUTA | The total amount of user and control data that was sent by the user's program. This value does not include the LLID, MAPNAME, or FMH-7 data lengths. (See note 3.) | PD (11,0) |
| JBGETN | The number of times ACGET was called to receive user or control data. Calls that result in no data being given to the user application will not be counted. (See note 3.) | PD (11,0) |
| JBGETA | The total amount of user and control data that was received by the user's program. This value does not include the LLID, MAPNAME, or FMH-7 data lengths. (See note 3.) | PD (11,0) |
| JBPGIN | The number of intervals that begin at the first put of a chain and end when CD is returned to the user. (See note 3.) | PD (11,0) |
| JBPGIL | The amount of time (in milliseconds) spent in intervals that begin at the first put of a chain and end when CD is returned to the user. (See note 3.) | PD (11,0) |
| JBGGIL | The amount of time (in milliseconds) spent in intervals that begin when the first get of a get chain completes and ends when the first get of a new chain is issued. (See note 3.) | PD (11,0) |
| JBRTI | This is the number of request I/O commands (REQIOs) issued to transmit data of any kind (including FMH-7s.) (See note 3.) | PD (11,0) |
| JBRRI | This is the number of REQIOs issued to receive data of any kind (including FMH-7s.) (See note 3.) | PD (11,0) |
| JBSZWT | Total seize wait time in milliseconds. (See note 2.) | PD (15,3) |
| JBSKSC | Number of socket sends. (See note 3.) | PD (11,0) |
| JBSKBS | Number of socket bytes sent. (See note 3.) | PD (11,0) |
| JBSKRC | Number of socket receives. (See note 3.) | PD (11,0) |
| JBSKBR | Number of socket bytes received. (See note 3.) | PD (11,0) |
| JBXRFR | Stream file reads. (See note 2.) | PD (11,0) |
| JBXRFW | Stream file writes. (See note 2.) | PD (11,0) |
| JBXSLR | File system symbolic link reads. (See note 3.) | PD (11,0) |
| JBXDYR | File system directory reads. (See note 3.) | PD (11,0) |
| JBDLCH | File system directory lookup cache hits. (See note 3.) | PD (11,0) |
| JBDLCM | File system lookup cache misses. | PD (11,0) |
| JBSJNM | Submitter's job name. (See note 3.) | C (10) |
| JBSJUS | Submitter's job user. File system directory lookup cache hits. (See note 3.) | C (10) |
| JBSJNB | Submitter's job number. (See note 3.) | C (6) |
| JBSJFG | Submitted job flag. This flag is designed to differentiate locally submitted jobs from jobs that are submitted from remote systems. Currently, this flag supports locally submitted jobs only. (See note 3.) | C (1) |
| JBRSYS | Reserved. | C (10) |
| JBDEVN | Reserved. | C (10) |
| JBRLNM | Reserved. | C (8) |
| JBLLNM | Reserved. | C (8) |
| JBMODE | Reserved. | C (8) |
| JBRMNT | Reserved. | C (8) |
| JBINSX | Reserved. | PD (11,0) |
| JBBUP | Reserved. | PD (11,0) |
| JBBDL | Reserved. | PD (11,0) |
| JBBFE | Reserved. | PD (11,0) |
| JBBCO | Database commit operations. | PD (11,0) |
| JBBRO | Database rollback operations. | PD (11,0) |
| JBLBO | The cumulative number of SQL cursors which have been full opened. | PD (11,0) |
| JBLBC | Reserved. | PD (11,0) |
| JBLBI | Reserved. | PD (11,0) |
| JBLBS | The cumulative number of SQL cursors which have been pseudo-opened. Pseudo-opens are also known as reused SQL cursors. | PD (11,0) |
| JBDQS | Reserved. | PD (11,0) |
| JBDQR | Reserved. | PD (11,0) |
| JBNDA | Reserved. | PD (11,0) |
| JBNUS |  Full opens. The number of Native database
(non-SQL) files and SQL cursors which have been full opened. Subtracting
the value within field JBLBO from JBNUS will yield the number of non-SQL
full opens. |
PD (11,0) |
| JBSIT1 | Reserved. | PD (11,0) |
| JBSIT2 | Reserved. | PD (11,0) |
| JBSIT3 | Reserved. | PD (11,0) |
| JBTCPU | Job unscaled interval CPU time charged. Thread unscaled interval
CPU time charged (in milliseconds) totaled for all threads of the
job within the interval. Note: This value may not equal the sum of
JBCPU for all threads due to timing differences in the collection
and reporting of these values. (See note 3.)
|
PD (15,3) |
| JBTHDF | Secondary thread flag. Identifies secondary threads of a multi-threaded job. The values are: 0 for tasks and primary threads; 1 for secondary threads. | PD (1,0) |
| JBTHID | Thread Identifier. A 4-byte displayable thread identifier. A hex string that is unique for threads within a process. It will be blank for tasks and prior release data. | C (8) |
| JBTHAC | Active threads. Current number of active threads in the process when the data was sampled. An active thread may be actively running, suspended, or waiting on a resource. Includes the primary thread. (See note 3.) | PD (11,0) |
| JBTHCT | Threads created. Number of threads initiated within this job. Includes both active and terminated threads. (See note 3.) | PD (11,0) |
| JBMTXT | Mutex wait time in milliseconds. Cumulative time the thread waited for a mutex. (See note 2.) | PD (15,3) |
| JBIBM1 | Reserved | PD (11,0) |
| JBSTSF | Status flag: indicates job status relative to this interval. The values are: 0 -- normal interval collection, 1 -- job started in interval, 2 -- job ended in interval, 3 -- job started and ended. Jobs that are rerouted or transferred will result in a termination record (JBSTSF = 2) and a new job record (JBSTSF = 1) | PD (1,0) |
| JBSVIF | Server interactive flag. Set to '1' if the resource consumed by the function is charged to the interactive capability of the system. | C (1) |
| JBTFLT | Total page faults. | PD (11,0) |
| JBEDBC | Reserved |
P (15,3) |
| JBTDBC | Reserved |
P (15,3) |
| JBSVRT | Server type. The type of server represented by the job. A value of blank (or blank space) indicates that the job is not part of a server. | C (30) |
| JBCOP | Number of primary commit operations performed under the task. | PD (11,0) |
| JBCOS | Number of secondary commit operations performed under the task. This includes application and system-provided referential integrity commits. | PD (11,0) |
| JBDOP | Number of primary decommit operations performed under the task. | PD (11,0) |
| JBDOS | Number of secondary decommit operations performed under the task. This includes application and system-provided referential integrity decommits. | PD (11,0) |
| JBPJE | Number of physical journal write operations to disk performed under the task. | PD (11,0) |
| JBNSJE | Number of journal entries not directly related to SMAPP. | PD (11,0) |
| JBUJD | Number of SMAPP-induced journal entries deposited in user-provided journals. | PD (11,0) |
| JBSJD | Number of SMAPP-induced journal entries deposited in system-provided (default) journals. | PD (11,0) |
| JBBFW | Number of journal bytes written to disk. Such entries are packaged within the permanent area of the journal receiver. These are traditional journal entries which can be retrieved and displayed. | PD (15,0) |
| JBBFA | Number of bytes deposited within the permanent area of the journal receiver. This count includes both those bytes already written to disk and those still cached in main memory. These are traditional journal entries which can be retrieved and displayed. | PD (15,0) |
| JBBTW | Number of transient area journal receiver bytes written to disk. The transient area contains hidden journal entries produced by the system, used during IPL, and routed to this transient area only if the customer specifies *RmvIntEnt on the CHGJRN command. This transient area is a separate area on the disk, distinct from the disk space used to store the normal journal entries. | PD (15,0) |
| JBBTA | Number of bytes generated for the journal receiver transient area. This count includes both transient bytes already written to disk and those still cached in main memory. The transient area contains hidden journal entries produced by the system, used during IPL, and routed to this transient area only if the customer specifies *RmvIntEnt on the CHGJRN command. This transient area is a separate area on the disk, distinct from the disk space used to store the normal journal entries. | PD (15,0) |
| JBTWT | Amount of time this task spent waiting for journal bundles to be written to disk (in milliseconds). This includes time spent waiting for physical disk write operations initiated by this task to be serviced, as well as time spent waiting for physical disk write operations initiated by other tasks whose journal entries reside in the same journal bundle. | PD (11,0) |
| JBTNW | Number of times this task waited for journal bundles to be written to disk. | PD (11,0) |
| JBXRRR | Number of random stream file read operations. This count includes files in the Root, QOpenSys, QDLS, QOPT (when the files are on a volume that is not formatted in Universal Disk Format (UDS)) and user-defined file systems. | PD (11,0) |
| JBXRRW | Number of random stream file write operations. This count includes files in the Root, QOpenSys, QDLS, QOPT (when the files are on a volume that is not formatted in Universal Disk Format (UDS)) and user-defined file systems. | PD (11,0) |
| JBXRFS | Number of fsync operations. This count includes files in the Root, QOpenSys, QDLS, QOPT (when the files are on a volume that is not formatted in Universal Disk Format (UDS)) and user-defined file systems. | PD (11,0) |
| JBXRBR | Stream file bytes read. This count includes files in the Root, QOpenSys, QDLS, QOPT (when the files are on a volume that is not formatted in Universal Disk Format (UDS)) and user-defined file systems. | PD (15,0) |
| JBXRBW | Stream file bytes written. This count includes files in the Root, QOpenSys, QDLS, QOPT (when the files are on a volume that is not formatted in Universal Disk Format (UDS)) and user-defined file systems. | PD (15,0) |
| JBFSH | Number of full secure sockets layer (SSL) handshakes that use server authentication. | PD (11,0) |
| JBASH | Number of abbreviated (or fast) secure sockets layer (SSL) handshakes that use server authentication. | PD (11,0) |
| JBFSHA | Number of full secure sockets layer (SSL) handshakes that use server and client authentication. | PD (11,0) |
| JBASHA | Number of abbreviated (or fast) secure sockets layer (SSL) handshakes that use server and client authentication. | PD (11,0) |
| JBPGA | Total number of 4096-byte units of temporary
and permanent storage that have been allocated by the thread since
the thread started. |
P (11,0) |
| JBPGD | Total number of 4096-byte units of temporary
and permanent storage that have been deallocated by the thread since
the thread started. |
P (11,0) |
| JBCUSR | The user profile that the job was running under at the time the data was sampled. | C (10) |
| JBFSOPN | File system opens. This count includes the following file systems: Root, QOpenSys, and user-defined files systems. | PD (11,0) |
| JBFSDC | File system directory creates. This count includes the following file systems: Root, QOpenSys, and user-defined files systems. | PD (11,0) |
| JBFSNDC | File system non-directory creates. Count of create operations for non-directory objects such as files or symbolic links. This count includes the following file systems: Root, QOpenSys, and user-defined files systems. | PD (11,0) |
| JBFSDD | File system directory deletes. This count includes the following file systems: Root, QOpenSys, and user-defined files systems. | PD (11,0) |
| JBFSNDD | File system non-directory deletes. Count of delete operations for non-directory objects such as files or symbolic links. This count includes the following file systems: Root, QOpenSys, and user-defined files systems. | PD (11,0) |
| JBACPU | Accumulated job unscaled CPU time charged in
milliseconds. The accumulated unscaled interval CPU time charged for
all threads of the job since the job started. Note: This field is
provided for primary threads only.
|
PD (15,3) |
| JBIPAF | The remote IP address family flag indicates
the type of IP address information provided in field JBIPAD. The
following are supported (see <sys/socket.h> and the API referenced
under JBIPAD for more information on these values):
Note: An address may not be available if there is no current
connection.
|
C (1) |
| JBIPAD | The binary form of IPv4 or IPv6 remote IP address most recently communicated with over sockets. If a sockets connection has not been established or has terminated (JBIPAF = X'00'), this field will be blank. An IPv4 address is 4 bytes long left justified in this field. An IPv6 address uses all 16 bytes. For examples and further explanation, refer to the Usage Notes section in the Convert IPv4 and IPv6 Addresses Between Text and Binary Form (inet_pton) API | C (16) |
| JBIPPT | Remote port number. This field displays the port number that is used in this connection. | Z (5,0) |
| JBUAUF | Reserved. | C (1) |
| JBPGRQ | Page frames requested. Number of new page frames required by thread to satisfy page fault, read or clear operation. | B (9,0) |
| JBPGRL | Page frames released. Number of page frames explicitly released by thread. | B (9,0) |
| JBMSLR | File system symbolic link reads. This count includes the following file systems: Root (/), QOpenSys, and user-defined file systems. | B (9,0) |
| JBMDYR | File system directory reads. This count includes the following file systems: Root (/), QOpenSys, and user-defined file systems. | B (9,0) |
| JBMLCH | File system directory lookup cache hits. This count includes the following file systems: Root (/), QOpenSys, and user-defined file systems. | B (9,0) |
| JBMLCM | File system lookup cache misses. This count includes the following file systems: Root (/), QOpenSys, and user-defined file systems. | B (9,0) |
| JBMOPN | File system opens. This count includes the following file systems: Root (/), QOpenSys, and user-defined file systems. | B (9,0) |
| JBMNDC | File system non-directory creates. Count of create operations for non-directory objects such as files or symbolic links. This count includes the following file systems: Root (/), QOpenSys, and user-defined file systems. | B (9,0) |
| JBMNDD | File system non-directory deletes. Count of delete operations for non-directory objects such as files or symbolic links. This count includes the following file systems: Root (/), QOpenSys, and user-defined file systems. | B (9,0) |
| JBSCPU | Thread scaled interval CPU
time used charged. The amount of scaled processing time (in microseconds)
charged to this thread. It includes scaled processing time used by
this thread and any scaled processing time charged to the thread by
server tasks that worked on its behalf within the interval. For server tasks, this field will be zero. Note: The ratio of JBSCPU
to JBCPU shows the current processor speed in relation to nominal
processor speed.
|
B (18,0) |
| JBSTCPU | Job scaled interval CPU time
charged. Thread scaled interval CPU time charged (in microseconds)
totaled for all threads of the job within the interval. Note: This
may not equal the sum of JBSCPU for all threads due to timing differences
in the collection and reporting of these values. This field is provided
for primary threads only.
|
B (18,0) |
| JBSQLCPU |
Thread unscaled SQL CPU time
used. The amount of unscaled processor time (in microseconds) this
thread has used performing work done on behalf of an SQL operation. |
B (18,0) |
Notes:
|
||