Schema IQUERY
ACTGRP( )
The Activation Groups (ACTGRP) User Defined Table Function returns one row for each activation group that exists in the job running the UDTF.
This UDTF has no parameters.
select * from table(iQuery.actgrp()) ag;
| Column | Data Type | Description |
| ACTGRPNBR |
BIGINT |
The activation group number assigned to the
activation group. |
| ACTGRP |
VARCHAR(16) | The name of the Activation Group. |
| PROGRAM |
VARCHAR(10) | The program that evoked the activation group.
This entry will be blank for certain activation groups
created by the system or the *DFTACTGRP. |
| LIBRARY |
VARCHAR(10) |
The library for the PROGRAM that started the
activation group. |
| DOMAIN | VARCHAR(10) | The domain of the activation group. This
entry is either *USER or *SYSTEM. |
| STGMDL |
VARCHAR(10) |
The Storage Model of the Activation Group.
*TERASPACE or *SNGLVL |
| NAMED |
VARCHAR(10) |
Whether the Activation Group is Named or not.
A Named Activation Group will return *YES specified for this
entry, while *DFTACTGRP and *NEW activation groups will
return *NO. |
| SHARED |
VARCHAR(10) |
If the Activation Group is Shared *YES is
returned, otherwise *NO. In most situations, this entry is
*NO. |
| DLTPEND |
VARCHAR(10) |
If the Activation Group is ending, *YES is
returned, otherwise *NO is returned. |