ADMIN_COMMAND_DB2 stored procedure
The SYSPROC.ADMIN_COMMAND_DB2 stored procedure executes one or more DB2® commands on a connected DB2 subsystem, or on a DB2 data sharing group member. This stored procedure also returns the command output messages.
Environment
ADMIN_COMMAND_DB2 must run in a WLM-established stored procedure address space.
Authorization
To execute the CALL statement, the owner of the package or plan that contains the CALL statement must have one or more of the following privileges on each package that the stored procedure uses:
- The EXECUTE privilege on the package for DSNADMCD
- Ownership of the package
- PACKADM authority for the package collection
- SYSADM authority
To execute the DB2 command, you must use a privilege set that includes the authorization to execute the DB2 command. For more information, see Privileges and authorization IDs for DB2 commands.
Syntax
The following syntax diagram shows the SQL CALL statement for invoking this stored procedure:
>>-CALL--SYSPROC.ADMIN_COMMAND_DB2--(--db2-command,-------------> >--command-length,--processing-type,--+-db2-member-+-,----------> '-NULL-------' >--commands-executed,--IFI-return-code,--IFI-reason-code,-------> >--excess-bytes,--group-IFI-reason-code,--group-excess-bytes,---> >--return-code,--message--)------------------------------------><
Option descriptions
- db2-command
Specifies
any DB2 command, such as -DISPLAY
THREAD(*), or multiple DB2 commands. With
multiple DB2 commands, use a null value
(CHAR string of '\0') to delimit the commands. The DB2 command is executed using the authorization ID
of the user who invoked the stored procedure. If you specify processing-type, you must specify the command name in full, such as "-DISPLAY THREAD". You cannot abbreviate DB2 commands, such as "-DIS THD".
This is an input parameter of type VARCHAR(32704) and cannot be null.
- command-length
- Specifies the length of the DB2 command
or commands. When multiple DB2 commands are
specified in db2-command, command-length is the sum of all of
those commands, including the '\0' command delimiters.
This is an input parameter of type INTEGER and cannot be null.
- processing-type
- Identifies the action
that you want ADMIN_COMMAND_DB2 to complete. You can request ADMIN_COMMAND_DB2 to parse the output
messages of a command and provide the formatted result in a global temporary table, or you can
request for a command to run synchronously.If you specify
processing-type, you must specify db2-command as a full
command name, such as "-DISPLAY THREAD". You cannot abbreviate DB2 commands, such as "-DIS THD".
To request output message parsing, specify one of the following values:
- BP
- Parse "-DISPLAY BUFFERPOOL" command output messages.
- DB
- Parse "-DISPLAY DATABASE" command output messages and return database information.
- TS
- Parse "-DISPLAY DATABASE(...) SPACENAM(...)" command output messages and return table spaces information.
- IX
- Parse "-DISPLAY DATABASE(...) SPACENAM(...)" command output messages and return index spaces information.
- THD
- Parse "-DISPLAY THREAD" command output messages.
- UT
- Parse "-DISPLAY UTILITY" command output messages.
- GRP
- Parse "-DISPLAY GROUP" command output messages.
- DDF
- Parse "-DISPLAY DDF" command output messages.
To request for a command to run synchronously, specify:
- SYC
- Issue the command synchronously.Only the following commands can be processed synchronously. For all other commands, SYC is ignored.
- -ALTER BUFFERPOOL
- -SET LOG
- -SET SYSPARM
- -STOP DATABASE
This is an input parameter of type VARCHAR(3) and cannot be null.
- db2-member
- Specifies the name of a single data sharing group member on which an IFI request is to be
executed
This is an input parameter of type VARCHAR(8).
- commands-executed
- Provides the number of commands that were executed
This is an output parameter of type INTEGER.
- IFI-return-code
- Provides the IFI return code
This is an output parameter of type INTEGER.
- IFI-reason-code
- Provides the IFI reason code
This is an output parameter of type INTEGER.
- excess-bytes
- Indicates the number of bytes that did not fit in the return area
This is an output parameter of type INTEGER.
- group-IFI-reason-code
- Provides the reason code for the situation in which an IFI call requests data from members of a
data sharing group, and not all the data is returned from group members.
This is an output parameter of type INTEGER.
- group-excess-bytes
- Indicates the total length of data that was returned from other data sharing group members and
did not fit in the return area
This is an output parameter of type INTEGER.
- return-code
- Provides the return code from the stored procedure. Possible values are:
- 0
- The stored procedure did not encounter an SQL error during processing. Check the IFI-return-code value to determine whether the DB2 command issued using the instrumentation facility interface (IFI) was successful or not.
- 12
- The stored procedure encountered an SQL error during processing. The message output parameter contains messages describing the SQL error.
This is an output parameter of type INTEGER.
- message
- Contains messages describing the SQL error encountered by the stored procedure. If no SQL error
occurred, then no message is returned.
The first messages in this area are generated by the stored procedure. Messages that are generated by DB2 might follow the first messages.
This is an output parameter of type VARCHAR(1331).
Example
The following C language sample shows how to invoke ADMIN_COMMAND_DB2:
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
/******************** DB2 SQL Communication Area ********************/
EXEC SQL INCLUDE SQLCA;
int main( int argc, char *argv[] ) /* Argument count and list */
{
/****************** DB2 Host Variables ****************************/
EXEC SQL BEGIN DECLARE SECTION;
/* SYSPROC.ADMIN_COMMAND_DB2 parameters */
char command[32705]; /* DB2 command */
short int ind_command; /* Indicator variable */
long int lencommand; /* DB2 command length */
short int ind_lencommand; /* Indicator variable */
char parsetype[4]; /* Parse type required */
short int ind_parsetype; /* Indicator variable */
char mbrname[9]; /* DB2 data sharing group */
/* member name */
short int ind_mbrname; /* Indicator variable */
long int excommands; /* Number of commands exec. */
short int ind_excommands; /* Indicator variable */
long int retifca; /* IFI return code */
short int ind_retifca; /* Indicator variable */
long int resifca; /* IFI reason code */
short int ind_resifca; /* Indicator variable */
long int xsbytes; /* Excessive bytes */
short int ind_xsbytes; /* Indicator variable */
long int gresifca; /* IFI group reason code */
short int ind_gresifca; /* Indicator variable */
long int gxsbytes; /* Group excessive bytes */
short int ind_gxsbytes; /* Indicator variable */
long int retcd; /* Return code */
short int ind_retcd; /* Indicator variable */
char errmsg[1332]; /* Error message */
short int ind_errmsg; /* Indicator variable */
/* Result Set Locators */
volatile SQL TYPE IS RESULT_SET_LOCATOR * rs_loc1,
rs_loc2;
/* First result set row */
long int rownum; /* Sequence number of the */
/* table row */
char text[81]; /* Command output */
/* Second result set row */
long int ddfrownum; /* DDF table sequence */
char ddfstat[7]; /* DDF status */
char ddfloc[19]; /* DDF location */
char ddflunm[18]; /* DDF luname */
char ddfgenlu[18]; /* DDF generic lu */
char ddfv4ipaddr[18]; /* DDF IPv4 address */
char ddfv6ipaddr[40]; /* DDF IPv6 address */
short int ind_ddfv6ipaddr; /* Indicator variable */
long int ddftcpport; /* DDF tcpport */
long int ddfresport; /* DDF resport */
char ddfsqldom[46]; /* DDF sql domain */
char ddfrsyncdom[46]; /* DDF resync domain */
short int ind_ddfrsyncdom; /* Indicator variable */
long int ddfsecport; /* DDF secure port */
short int ind_ddfsecport; /* Indicator variable */
char ddfipname[9]; /* DDF IPNAME */
short int ind_ddfipname; /* Indicator variable */
char ddfaliasname1[19]; /* DDF alias 1 name */
short int ind_ddfaliasname1; /* Indicator variable */
long int ddfaliasport1; /* DDF alias 1 TCP/IP port */
short int ind_ddfaliasport1; /* Indicator variable */
long int ddfaliassecport1; /* DDF alias 1 secure port */
short int ind_ddfaliassecport1; /* Indicator variable */
char ddfaliasname2[19]; /* DDF alias 2 name */
short int ind_ddfaliasname2; /* Indicator variable */
long int ddfaliasport2; /* DDF alias 2 TCP/IP port */
short int ind_ddfaliasport2; /* Indicator variable */
long int ddfaliassecport2; /* DDF alias 2 secure port */
short int ind_ddfaliassecport2; /* Indicator variable */
char ddfaliasname3[19]; /* DDF alias 3 name */
short int ind_ddfaliasname3; /* Indicator variable */
long int ddfaliasport3; /* DDF alias 3 TCP/IP port */
short int ind_ddfaliasport3; /* Indicator variable */
long int ddfaliassecport3; /* DDF alias 3 secure port */
short int ind_ddfaliassecport3; /* Indicator variable */
char ddfaliasname4[19]; /* DDF alias 4 name */
short int ind_ddfaliasname4; /* Indicator variable */
long int ddfaliasport4; /* DDF alias 4 TCP/IP port */
short int ind_ddfaliasport4; /* Indicator variable */
long int ddfaliassecport4; /* DDF alias 4 secure port */
short int ind_ddfaliassecport4; /* Indicator variable */
char ddfaliasname5[19]; /* DDF alias 5 name */
short int ind_ddfaliasname5; /* Indicator variable */
long int ddfaliasport5; /* DDF alias 5 TCP/IP port */
short int ind_ddfaliasport5; /* Indicator variable */
long int ddfaliassecport5; /* DDF alias 5 secure port */
short int ind_ddfaliassecport5; /* Indicator variable */
char ddfaliasname6[19]; /* DDF alias 6 name */
short int ind_ddfaliasname6; /* Indicator variable */
long int ddfaliasport6; /* DDF alias 6 TCP/IP port */
short int ind_ddfaliasport6; /* Indicator variable */
long int ddfaliassecport6; /* DDF alias 6 secure port */
short int ind_ddfaliassecport6; /* Indicator variable */
char ddfaliasname7[19]; /* DDF alias 7 name */
short int ind_ddfaliasname7; /* Indicator variable */
long int ddfaliasport7; /* DDF alias 7 TCP/IP port */
short int ind_ddfaliasport7; /* Indicator variable */
long int ddfaliassecport7; /* DDF alias 7 secure port */
short int ind_ddfaliassecport7; /* Indicator variable */
char ddfaliasname8[19]; /* DDF alias 8 name */
short int ind_ddfaliasname8; /* Indicator variable */
long int ddfaliasport8; /* DDF alias 8 TCP/IP port */
short int ind_ddfaliasport8; /* Indicator variable */
long int ddfaliassecport8; /* DDF alias 8 secure port */
short int ind_ddfaliassecport8; /* Indicator variable */
char ddfmbripv4addr[18]; /* DDF DSG member IPv4 addr */
short int ind_ddfmbripv4addr; /* Indicator variable */
char ddfmbripv6addr[40]; /* DDF DSG member IPv6 addr */
short int ind_ddfmbripv6addr; /* Indicator variable */
EXEC SQL END DECLARE SECTION;
/******************************************************************/
/* Assign values to input parameters to execute the DB2 */
/* command "-DISPLAY DDF" */
/* Set the indicator variables to 0 for non-null input parameters */
/* Set the indicator variables to -1 for null input parameters */
/******************************************************************/
strcpy(command, "-DISPLAY DDF");
ind_command = 0;
lencommand = strlen(command);
ind_lencommand = 0;
strcpy(parsetype, "DDF");
ind_parsetype = 0;
ind_mbrname = -1;
/******************************************************************/
/* Call stored procedure SYSPROC.ADMIN_COMMAND_DB2 */
/******************************************************************/
EXEC SQL CALL SYSPROC.ADMIN_COMMAND_DB2
(:command :ind_command,
:lencommand :ind_lencommand,
:parsetype :ind_parsetype,
:mbrname :ind_mbrname,
:excommands :ind_excommands,
:retifca :ind_retifca,
:resifca :ind_resifca,
:xsbytes :ind_xsbytes,
:gresifca :ind_gresifca,
:gxsbytes :ind_gxsbytes,
:retcd :ind_retcd,
:errmsg :ind_errmsg);
/******************************************************************/
/* Retrieve result set(s) when the SQLCODE from the call is +466, */
/* which indicates that result sets were returned */
/******************************************************************/
if (SQLCODE == +466) /* Result sets were returned */
{
/* ESTABLISH A LINK BETWEEN EACH RESULT SET AND ITS LOCATOR */
EXEC SQL ASSOCIATE LOCATORS (:rs_loc1, :rs_loc2)
WITH PROCEDURE SYSPROC.ADMIN_COMMAND_DB2;
/* ASSOCIATE A CURSOR WITH EACH RESULT SET */
EXEC SQL ALLOCATE C1 CURSOR FOR RESULT SET :rs_loc1;
EXEC SQL ALLOCATE C2 CURSOR FOR RESULT SET :rs_loc2;
/* PERFORM FETCHES USING C1 TO RETRIEVE ALL ROWS FROM THE */
/* FIRST RESULT SET */
EXEC SQL FETCH C1 INTO :rownum, :text;
while(SQLCODE == 0)
{
EXEC SQL FETCH C1 INTO :rownum, :text;
}
EXEC SQL CLOSE C1;
/* PERFORM FETCHES USING C2 TO RETRIEVE THE -DISPLAY DDF */
/* PARSED OUTPUT FROM THE SECOND RESULT SET */
EXEC SQL FETCH C2 INTO :ddfrownum, :ddfstat, :ddfloc,
:ddflunm, :ddfgenlu,
:ddfv4ipaddr,
:ddfv6ipaddr:ind_ddfv6ipaddr,
:ddftcpport, :ddfresport,
:ddfsqldom,
:ddfrsyncdom:ind_ddfrsyncdom,
:ddfsecport:ind_ddfsecport,
:ddfipname:ind_ddfipname,
:ddfaliasname1:ind_ddfaliasname1,
:ddfaliasport1:ind_ddfaliasport1,
:ddfaliassecport1:ind_ddfaliassecport1,
:ddfaliasname2:ind_ddfaliasname2,
:ddfaliasport2:ind_ddfaliasport2,
:ddfaliassecport2:ind_ddfaliassecport2,
:ddfaliasname3:ind_ddfaliasname3,
:ddfaliasport3:ind_ddfaliasport3,
:ddfaliassecport3:ind_ddfaliassecport3,
:ddfaliasname4:ind_ddfaliasname4,
:ddfaliasport4:ind_ddfaliasport4,
:ddfaliassecport4:ind_ddfaliassecport4,
:ddfaliasname5:ind_ddfaliasname5,
:ddfaliasport5:ind_ddfaliasport5,
:ddfaliassecport5:ind_ddfaliassecport5,
:ddfaliasname6:ind_ddfaliasname6,
:ddfaliasport6:ind_ddfaliasport6,
:ddfaliassecport6:ind_ddfaliassecport6,
:ddfaliasname7:ind_ddfaliasname7,
:ddfaliasport7:ind_ddfaliasport7,
:ddfaliassecport7:ind_ddfaliassecport7,
:ddfaliasname8:ind_ddfaliasname8,
:ddfaliasport8:ind_ddfaliasport8,
:ddfaliassecport8:ind_ddfaliassecport8,
:ddfmbripv4addr:ind_ddfmbripv4addr,
:ddfmbripv6addr:ind_ddfmbripv6addr;
EXEC SQL CLOSE C2;
}
return(retcd);
}Output
This stored procedure returns the following output parameters, which are described in Option descriptions:
- commands-executed
- IFI-return-code
- IFI-reason-code
- excess-bytes
- group-IFI-reason-code
- group-excess-bytes
- return-code
- message
In addition to the preceding output, the stored procedure returns two result sets.
The first result set is returned in the created global temporary table SYSIBM.DB2_CMD_OUTPUT and contains the DB2 command output messages that were not parsed.
The following table shows the format of the first result set:
| Column name | Data type | Contents |
|---|---|---|
| ROWNUM | INTEGER | Sequence number of the table row, from 1 to n |
| TEXT | CHAR(80) | DB2 command output message line |
The format of the second result set varies, depending on the DB2 command issued and the processing-type value.
- Result set row for second ADMIN_COMMAND_DB2 result set (processing-type = "BP")
- Result set row for second ADMIN_COMMAND_DB2 result set (processing-type = "THD")
- Result set row for second ADMIN_COMMAND_DB2 result set (processing-type = "UT")
- Result set row for second ADMIN_COMMAND_DB2 result set (processing-type = "DB" or "TS" or "IX")
- Result set row for second ADMIN_COMMAND_DB2 result set (processing-type = "GRP")
- Result set row for second ADMIN_COMMAND_DB2 result set (processing-type = "DDF")
The following table shows the format of the result set returned in the created global temporary table SYSIBM.BUFFERPOOL_STATUS when processing-type = "BP":
| Column name | Data type | Contents |
|---|---|---|
| ROWNUM | INTEGER | Sequence number of the table row, from 1 to n |
| BPNAME | CHAR(6) | Buffer pool name |
| VPSIZE | INTEGER | Buffer pool size |
| VPSEQT | INTEGER | Sequential steal threshold for the buffer pool |
| VPPSEQT | INTEGER | Parallel sequential threshold for the buffer pool |
| VPXPSEQT | INTEGER | Assisting parallel sequential threshold for the buffer pool |
| DWQT | INTEGER | Deferred write threshold for the buffer pool |
| PCT_VDWQT | INTEGER | Vertical deferred write threshold for the buffer pool (as a percentage of virtual buffer pool size) |
| ABS_VDWQT | INTEGER | Vertical deferred write threshold for the buffer pool (as absolute number of buffers) |
| PGSTEAL | CHAR(4) | Page-stealing algorithm that DB2 uses for the buffer pool |
| ID | INTEGER | Buffer pool internal identifier |
| USE_COUNT | INTEGER | The number of open table spaces or index spaces that reference this buffer pool |
| PGFIX | CHAR(3) | Specifies whether the buffer pool should be fixed in real storage when it is used |
| AUTOSIZE | VARCHAR(3) | Specifies whether automatic buffer pool adjustment is on or off |
The following table shows the format of the result set returned in the created global temporary table SYSIBM.DB2_THREAD_STATUS when processing-type = "THD":
| Column name | Data type | Contents |
|---|---|---|
| ROWNUM | INTEGER | Sequence number of the table row, from 1 to n |
| TYPE | INTEGER | Thread type:
|
| NAME | CHAR(8) | Connection name used to establish the thread |
| STATUS | CHAR(11) | Status of the conversation or socket |
| ACTIVE | CHAR(1) | Indicates whether a thread is active or not. An asterisk means that the thread is active within DB2. |
| REQ | CHAR(5) | Current number of DB2 requests on the thread |
| ID | CHAR(12) | Recovery correlation ID associated with the thread |
| AUTHID | CHAR(8) | Authorization ID associated with the thread |
| PLAN | CHAR(8) | Plan name associated with the thread |
| ASID | CHAR(4) | Address space identifier |
| TOKEN | CHAR(6) | Unique thread identifier |
| COORDINATOR | CHAR(46) | Name of the two-phase commit coordinator |
| RESET | CHAR(5) | Indicates whether or not the thread needs to be reset to purge info from the indoubt thread report |
| URID | CHAR(20) | Unit of recovery identifier |
| LUWID | CHAR(35) | Logical unit of work ID of the thread |
| WORKSTATION | CHAR(18) | Client workstation name |
| USERID | CHAR(16) | Client user ID |
| APPLICATION | CHAR(32) | Client application name |
| ACCOUNTING | CHAR(247) | Client accounting information |
| LOCATION | VARCHAR(4050) | Location name of the remote system |
| DETAIL | VARCHAR(4050) | Additional thread information |
The following table shows the format of the result set returned in the created global temporary table SYSIBM.UTILITY_JOB_STATUS when processing-type = "UT":
| Column name | Data type | Contents |
|---|---|---|
| ROWNUM | INTEGER | Sequence number of the table row, from 1 to n |
| CSECT | CHAR(8) | Name of the command program CSECT that issued the message |
| USER | CHAR(8) | User ID of the person running the utility |
| MEMBER | CHAR(8) | Utility job is running on this member |
| UTILID | CHAR(16) | Utility job identifier |
| STATEMENT | INTEGER | Utility statement number |
| UTILITY | CHAR(20) | Utility name |
| PHASE | CHAR(20) | Utility restart from the beginning of this phase |
| COUNT | INTEGER | Number of pages or records processed in a utility phase |
| STATUS | CHAR(18) | Utility status |
| DETAIL | VARCHAR(4050) | Additional utility information |
| NUM_OBJ | INTEGER | Total number of objects in the list of objects the utility is processing |
| LAST_OBJ | INTEGER | Last object that started |
The following table shows the format of the result set returned in the created global temporary table SYSIBM.DB_STATUS when processing-type = "DB" or "TS" or "IX":
| Column name | Data type | Contents |
|---|---|---|
| ROWNUM | INTEGER | Sequence number of the table row, from 1 to n |
| DBNAME | CHAR(8) | Name of the database |
| SPACENAM | CHAR(8) | Name of the table space or index |
| TYPE | CHAR(2) | Status type:
|
| PART | SMALLINT | Individual partition or range of partition |
| STATUS | CHAR(18) | Status of the database, table space or index |
The following table shows the format of the result set returned in the created global temporary table SYSIBM.DATA_SHARING_GROUP when processing-type = "GRP":
| Column name | Data type | Contents |
|---|---|---|
| ROWNUM | INTEGER | Sequence number of the table row, from 1 to n |
| DB2_MEMBER | CHAR(8) | Name of the DB2 group member |
| ID | INTEGER | ID of the DB2 group member |
| SUBSYS | CHAR(4) | Subsystem name of the DB2 group member |
| CMDPREF | CHAR(8) | Command prefix for the DB2 group member |
| STATUS | CHAR(8) | Status of the DB2 group member |
| DB2_LVL | CHAR(3) | DB2 version, release and modification level |
| SYSTEM_NAME | CHAR(8) | Name of the z/OS® system where the member is running, or was last running in cases when the member status is QUIESCED or FAILED |
| IRLM_SUBSYS | CHAR(4) | Name of the IRLM subsystem to which the DB2 member is connected |
| IRLMPROC | CHAR(8) | Procedure name of the connected IRLM |
The following table shows the format of the result set returned in the created global temporary table SYSIBM.DDF_CONFIG when processing-type = "DDF":
| Column name | Data type | Contents |
|---|---|---|
| ROWNUM | INTEGER
NOT NULL |
Sequence number of the table row, from 1 to n |
| STATUS | CHAR(6)
NOT NULL |
Operational status of DDF |
| LOCATION | CHAR(18)
NOT NULL |
Location name of DDF |
| LUNAME | CHAR(17)
NOT NULL |
Fully qualified LUNAME of DDF |
| GENERICLU | CHAR(17)
NOT NULL |
Fully qualified generic LUNAME of DDF |
| IPV4ADDR | CHAR(17)
NOT NULL |
IPV4 address of DDF |
| IPV6ADDR | CHAR(39)
|
IPV6 address of DDF |
| TCPPORT | INTEGER
NOT NULL |
SQL listener port used by DDF |
| RESPORT | INTEGER
NOT NULL |
Resync listener port used by DDF |
| SQL_DOMAIN | CHAR(45)
NOT NULL |
Domain name associated with the IP address in IPV4ADDR or IPV6ADDR |
| RSYNC_DOMAIN | CHAR(45)
|
Domain name associated with a specific member IP address |
| SECPORT | INTEGER | Secure SQL listener TCP/IP port number |
| IPNAME | CHAR(8) | IPNAME used by DDF |
| ALIASNAME1 | CHAR(18) | An alias name value specified in the BSDS DDF record. |
| ALIASPORT1 | INTEGER | TCP/IP port associated with ALIASNAME1 |
| ALIASSECPORT1 | INTEGER | Secure TCP/IP port associated with ALIASNAME1 |
| ALIASNAME2 | CHAR(18) | An alias name value specified in the BSDS DDF record |
| ALIASPORT2 | INTEGER | TCP/IP port associated with ALIASNAME2 |
| ALIASSECPORT2 | INTEGER | Secure TCP/IP port associated with ALIASNAME2 |
| ALIASNAME3 | CHAR(18) | An alias name value specified in the BSDS DDF record |
| ALIASPORT3 | INTEGER | TCP/IP port associated with ALIASNAME3 |
| ALIASSECPORT3 | INTEGER | Secure TCP/IP port associated with ALIASNAME3 |
| ALIASNAME4 | CHAR(18) | An alias name value specified in the BSDS DDF record |
| ALIASPORT4 | INTEGER | TCP/IP port associated with ALIASNAME4 |
| ALIASSECPORT4 | INTEGER | Secure TCP/IP port associated with ALIASNAME4 |
| ALIASNAME5 | CHAR(18) | An alias name value specified in the BSDS DDF record |
| ALIASPORT5 | INTEGER | TCP/IP port associated with ALIASNAME5 |
| ALIASSECPORT5 | INTEGER | Secure TCP/IP port associated with ALIASNAME5 |
| ALIASNAME6 | CHAR(18) | An alias name value specified in the BSDS DDF record |
| ALIASPORT6 | INTEGER | TCP/IP port associated with ALIASNAME6 |
| ALIASSECPORT6 | INTEGER | Secure TCP/IP port associated with ALIASNAME6 |
| ALIASNAME7 | CHAR(18) | An alias name value specified in the BSDS DDF record |
| ALIASPORT7 | INTEGER | TCP/IP port associated with ALIASNAME7 |
| ALIASSECPORT7 | INTEGER | Secure TCP/IP port associated with ALIASNAME7 |
| ALIASNAME8 | CHAR(18) | An alias name value specified in the BSDS DDF record |
| ALIASPORT8 | INTEGER | TCP/IP port associated with ALIASNAME8 |
| ALIASSECPORT8 | INTEGER | Secure TCP/IP port associated with ALIASNAME8 |
| MEMBER_IPV4ADDR | CHAR(17) | IPV4 address associated with the specific member of a data sharing group |
| MEMBER_IPV6ADDR | CHAR(39) | IPV6 address associated with the specific member of a data sharing group |
