Start of change

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 user must be running with the same user profile as the job being retrieved or have *JOBCTL special authority.

Read syntax diagramSkip visual syntax diagram IFS_JOB_INFO ( JOB_NAME => job-name,IGNORE_ERRORS => ignore-errors)
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.
No row is returned when an error is encountered. This is the default.

The result of the function is a table containing rows with the format shown in the following table. All the columns are nullable.

Table 1. IFS_JOB_INFO table function
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 in the root (/) file system, the QOpenSys file system, or a user-defined file system and is not linked to a path. 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.
NFS
The Network File System (NFS).
QDLS
The Document Library Services (QDLS) file system.
QFILSVR400
The QFileSvr.400 file system.
QNTC
The Windows NT® Server file system.
QOPENSYS
The QOpenSys file system.
QOPT
The optical file system (QOPT).
QSYS
The QSYS.LIB file system.
QSYSIASP
An independent ASP QSYS.LIB file system.
ROOT
The root (/) file system
UDFS
A user-defined file system.
UDFS MANAGEMENT
A file system that manages the block special files (*BLKSF) for the user-defined file systems.
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.
NO
The object is not a directory that is being used as the current directory of the job.
YES
The object is 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.
NO
The object is not a directory that is being used as the root directory of the job.
YES
The object is the root directory of the job.
ATTRIBUTE_LOCK VARCHAR(3) Indicates whether attribute changes are prevented.
NO
Attribute changes are not prevented.
YES
Attribute changes are prevented.
SAVE_LOCK VARCHAR(3) Indicates whether the object is being referenced by an object save operation.
NO
Object is not being referenced by an object save operation.
YES
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.
NO
The object is not being referenced internally during a save operation on a different object.
YES
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.
NO
Changes to links in the directory are not prevented.
YES
Changes to links in the directory are prevented.
CHECKED_OUT VARCHAR(3) Indicates whether the object is currently checked out.
NO
The object is not checked out.
YES
The object is 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.
NO
The File Server is not holding a generic reference on the object on behalf of a client.
YES
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.
NO
The object is not a directory or the File Server is not holding a working directory reference on it on behalf of a client.
YES
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.
NO
The NFS server job is not holding a generic reference on the object on behalf of a client.
YES
The NFS 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 => '*'));
End of change