LICENSE_EXPIRATION_CHECK procedure

The LICENSE_EXPIRATION_CHECK procedure sends a message to the QSYSOPR message queue for every license that corresponds to an installed product that has already expired or is set to expire within the specified number of days.

Authorization: See Note below.

Read syntax diagramSkip visual syntax diagramLICENSE_EXPIRATION_CHECK(EXPIRATION_INTERVAL => expiration-interval)

The schema is SYSTOOLS.

expiration-interval
An integer value that indicates the number of days to use as the threshold for checking license information. If not specified, 30 will be used.

Note

This procedure is provided in the SYSTOOLS schema as an example of how to work with license information using an SQL procedure. Similar to other Db2® for i provided tools within SYSTOOLS, the SQL source can be extracted and used as a model for building similar procedures, or to create a customized version within a user-specified schema.

Services provided in SYSTOOLS have authorization requirements that are determined by the interfaces used to implement the service. To understand the authority requirements, extract the SQL for the service and examine the implementation.

Example

  • Send an informational message to the system operator message queue, QSYS/QSYSOPR, for every installed product with a license that will expire in the next 10 days.
    CALL SYSTOOLS.LICENSE_EXPIRATION_CHECK(10);