IFS_JOB_INFO table function
The IFS_JOB_INFO table function returns a table that contains information about integrated file system references for a job.
This information is similar to what is returned by the Retrieve Referenced Objects (QP0LRRO) API.
The list of objects returned may be incomplete for objects residing in file systems other than the root (/), QOpenSys, and user-defined file systems. Objects in some of the other file systems can be locked with interfaces that do not use the integrated file system. Therefore, objects referenced by a job will only have references that were obtained as part of an integrated file system operation, or an operation that causes an integrated file system operation to occur.
Authorization: The caller must be running with the same user profile as the job being retrieved or have *JOBCTL special authority.
- job-name
- An expression that returns the qualified job name whose reference information is to be returned.
Can contain the following special value:
- *
- Return information for the current job.
- ignore-errors
-
A character or graphic string expression that identifies what to do when an error is encountered.
- NO
-
An error is returned.
- YES
- A warning is returned.
The result of the function is a table containing rows with the format shown in the following table. All the columns are nullable.
Column Name | Data Type | Description |
---|---|---|
PATH_NAME | DBCLOB(16M) CCSID 1200 | The path name of an integrated file system object that is
referenced by the job. Contains the null value if the object is not linked to a path. This can occur in the root (/) file system, the QOpenSys file system, or a user-defined file system. Can also contain the null value if the object is in a remote file system or the optical file system (QOPT). |
FILE_SYSTEM_TYPE | VARCHAR(15) | The file system for the object.
|
FILE_IDENTIFIER_NUMBER | BIGINT | The file identifier number of the object. This number uniquely
identifies the object with a file system. The file identifier number, generation identifier, and file system identifier used together uniquely identify the object on the system. |
GENERATION_IDENTIFIER | BIGINT | The generation identifier associated with the object. The file identifier number, generation identifier, and file system identifier used together uniquely identify the object on the system. |
FILE_SYSTEM_IDENTIFIER | BIGINT | The file system ID to which the object belongs. This number
uniquely identifies the file system to which the object belongs. The file identifier number, generation identifier, and file system identifier used together uniquely identify the object on the system. |
FILE_IDENTIFIER | BINARY(16) | An identifier associated with the referred to object. |
REFERENCE_COUNT | INTEGER | Current number of references on the object for the specified job. |
RO_SHARE_R_COUNT | INTEGER | Number of read only accesses for the job where the sharing mode allows sharing with read and execute access intents only. |
RO_SHARE_W_COUNT | INTEGER | Number of read only accesses for the job where the sharing mode allows sharing with write access intents only. |
RO_SHARE_RW_COUNT | INTEGER | Number of read only accesses for the job where the sharing mode allows sharing with read, execute, and write access intents. |
RO_SHARE_NONE_COUNT | INTEGER | Number of read only accesses for the job where the sharing mode allows sharing with no other access intents. |
WO_SHARE_R_COUNT | INTEGER | Number of write only accesses for the job where the sharing mode allows sharing with read and execute access intents only. |
WO_SHARE_W_COUNT | INTEGER | Number of write only accesses for the job where the sharing mode allows sharing with write access intents only. |
WO_SHARE_RW_COUNT | INTEGER | Number of write only accesses for the job where the sharing mode allows sharing with read, execute, and write access intents. |
WO_SHARE_NONE_COUNT | INTEGER | Number of write only accesses for the job where the sharing mode allows sharing with no other access intents. |
RW_SHARE_R_COUNT | INTEGER | Number of read and write accesses for the job where the sharing mode allows sharing with read and execute access intents only. |
RW_SHARE_W_COUNT | INTEGER | Number of read and write accesses for the job where the sharing mode allows sharing with write access intents only. |
RW_SHARE_RW_COUNT | INTEGER | Number of read and write accesses for the job where the sharing mode allows sharing with read, execute, and write access intents. |
RW_SHARE_NONE_COUNT | INTEGER | Number of read and write accesses for the job where the sharing mode allows sharing with no other access intents. |
XO_SHARE_R_COUNT | INTEGER | Number of execute only accesses for the job where the sharing mode allows sharing with read and execute access intents only. |
XO_SHARE_W_COUNT | INTEGER | Number of execute only accesses for the job where the sharing mode allows sharing with write access intents only. |
XO_SHARE_RW_COUNT | INTEGER | Number of execute only accesses for the job where the sharing mode allows sharing with read, execute, and write access intents. |
XO_SHARE_NONE_COUNT | INTEGER | Number of execute only accesses for the job where the sharing mode allows sharing with no other access intents. |
XR_SHARE_R_COUNT | INTEGER | Number of execute and read accesses for the job where the sharing mode allows sharing with read and execute access intents only. |
XR_SHARE_W_COUNT | INTEGER | Number of execute and read accesses for the job where the sharing mode allows sharing with write access intents only. |
XR_SHARE_RW_COUNT | INTEGER | Number of execute and read accesses for the job where the sharing mode allows sharing with read, execute, and write access intents. |
XR_SHARE_NONE_COUNT | INTEGER | Number of execute and read accesses for the job where the sharing mode allows sharing with no other access intents. |
CURRENT_DIRECTORY | VARCHAR(3) | The object is a directory that is being used as the current
directory of the job.
|
ROOT_DIRECTORY | VARCHAR(3) | The object is a directory that is being used as the root
directory of the job.
|
ATTRIBUTE_LOCK | VARCHAR(3) | Indicates whether attribute changes are prevented.
|
SAVE_LOCK | VARCHAR(3) | Indicates whether the object is being referenced by an object
save operation.
|
INTERNAL_SAVE_LOCK | VARCHAR(3) | Indicates whether the object is being referenced internally
during a save operation on a different object.
|
LINK_CHANGES_LOCK | VARCHAR(3) | Indicates whether changes to links in the directory are
prevented.
|
CHECKED_OUT | VARCHAR(3) | Indicates whether the object is currently checked out.
|
CHECKED_OUT_USER_NAME | VARCHAR(10) | The name of the user who has the object checked out. Contains the null value if CHECKED_OUT is NO. |
FILE_SERVER_REFERENCE | VARCHAR(3) | The File Server is holding a generic reference on the object on
behalf of a client.
|
FILE_SERVER_WORKING_DIRECTORY | VARCHAR(3) | The object is a directory, and the File Server is holding a
working directory reference on it on behalf of a client.
|
NFS_SERVER_REFERENCE | VARCHAR(3) | The Network File System (NFS) Version 4 server job is holding a
generic reference on the object on behalf of a client.
|
Example
- List all the integrated file system references for the current
job.
SELECT * FROM TABLE(QSYS2.IFS_JOB_INFO(JOB_NAME => '*'));