IBM Support

QSYS2.PROGRAM_RESOLVED_ACTIVATIONS()

News


Abstract

The PROGRAM_RESOLVED_ACTIVATIONS table function returns information about the service programs that need to be activated for a given ILE program or service program. The table function returns a row for each service program that would be statically activated. In addition, it can return rows for service programs defined with deferred activation.

This table function is similar to the BOUND_SRVPGM_INFO view in that it returns information about service programs bound to an ILE program or service program. However, the BOUND_SRVPGM_INFO view returns the definitional bind information, while PROGRAM_RESOLVED_ACTIVATIONS returns the entire network of activations. In other words, what is returned is the program's entire activation chain which is the list of all service programs that will be activated for the given ILE program or service program.

The PROGRAM_RESOLVED_ACTIVATIONS table function performs a static analysis of the input program to determine the set of bound service programs that must also be activated. It does not attempt to simulate the precise set or ordering of activations that will be done at run time. If the given program or service program dynamically activates an export in a service program, that service program's activation chain is not included in the results of this table function.

Content

You are in: IBM i Technology Updates > Db2 for i - Technology Updates > IBM i Services (SQL) > QSYS2.PROGRAM_RESOLVED_ACTIVATIONS
For complete detail, visit this IBM Documentation page: PROGRAM_RESOLVED_ACTIVATIONS table function

[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000001go6AAA","label":"IBM i Db2-\u003ESQL Services \/ table functions"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"and future releases;7.5.0"}]

Document Information

Modified date:
07 October 2025

UID

ibm17246482