The BOUND_SRVPGM_INFO view returns information about service programs bound into an ILE program or service program.
The values returned for the columns in the view are closely related to the values returned for *SRVPGM detail on the DSPPGM (Display Program) and DSPSRVPGM (Display Service Program) CL commands and the List ILE Program Information (QBNLPGMI) and the List Service Program Information (QBNLSPGM) APIs.
- *USE authority to the program or service program, and
- *EXECUTE authority to the library containing the program or service program.
The following table describes the columns in the view. The system name is SRVPGM_INF. The schema is QSYS2.
|Column Name||System Column Name||Data Type||Description|
|PROGRAM_LIBRARY||PGM_LIB||VARCHAR(10)||Library containing the program or service program.|
|PROGRAM_NAME||PGM_NAME||VARCHAR(10)||Program or service program name.|
|OBJECT_TYPE||OBJ_TYPE||VARCHAR(7)||Object type for PROGRAM_NAME.
|BOUND_SERVICE_PROGRAM_LIBRARY||BDSRVPGMLB||VARCHAR(10)||The name of the library containing the service program bound to
PROGRAM_NAME at bind time. This is the library name in which the activation expects to find the
service program at run time. Can contain the following special value:
|BOUND_SERVICE_PROGRAM||BDSRVPGM||VARCHAR(10)||The name of the service program bound to PROGRAM_NAME.|
|BOUND_SERVICE_PROGRAM_SIGNATURE||SIGNATURE||BINARY(16)||The current signature of the service program at the time the service program was bound to PROGRAM_NAME.|
|BOUND_SERVICE_PROGRAM_ACTIVATION||SRVPGM_ACT||VARCHAR(6)||Specifies when the bound service program is activated.
- Examine whether service programs in APPLIB are taking advantage of deferred service program
SELECT BOUND_SERVICE_PROGRAM_ACTIVATION, COUNT(*) AS BOUND_SERVICE_PROGRAM_ACTIVATION_COUNT FROM QSYS2.BOUND_SRVPGM_INFO WHERE PROGRAM_LIBRARY = 'APPLIB' GROUP BY BOUND_SERVICE_PROGRAM_ACTIVATION ORDER BY 2 DESC;