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.

Begin general-use programming interface information.

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 commands in Commands in Db2.

Syntax

The following syntax diagram shows the SQL CALL statement for invoking this stored procedure:

Read syntax diagramSkip visual syntax diagramCALLSYSPROC.ADMIN_COMMAND_DB2(db2-command,command-length,processing-type,db2-memberNULL,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:
Note: Start of changeIf you specify any of the following values, ADMIN_COMMAND_DB2 returns the parsed output message in a second result, as described in the Output section. Otherwise, if you specify any value that does not appear in the list below, ADMIN_COMMAND_DB2 returns the complete unparsed command output message, and only one result set is returned.End of change
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.

Start of changeIf the -DISPLAY THREAD command includes the SCOPE(GROUP) option, ADMIN_COMMAND_DB2 returns parsed output in the second result set (in created temporary table SYSIBM.DB2_THREAD_STATUS) only for the data sharing member that appears first in the output. ADMIN_COMMAND_DB2 returns unparsed output in the first result set (in created temporary table SYSIBM.DB2_CMD_OUTPUT) for the other data sharing members.End of change

UT
Parse -DISPLAY UTILITY command output messages.
GRP
Parse -DISPLAY GROUP command output messages.
DDF
Parse -DISPLAY DDF command output messages.
LS
Parse -DISPLAY DATABASE(...) SPACENAM(...) command output messages and return information for LOB table spaces.
XS
Parse -DISPLAY DATABASE(...) SPACENAM(...) command output messages and return information for XML table spaces.
UN
Parse -DISPLAY DATABASE(...) SPACENAM(...) command output messages and return information for table spaces when the type is unknown.

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

Start of changeThis is an input parameter of type VARCHAR(3).End of change

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:

Table 1. Result set row for first ADMIN_COMMAND_DB2 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.

The following table shows the format of the result set returned in the created global temporary table SYSIBM.BUFFERPOOL_STATUS when processing-type = BP:

Table 2. Result set row for second ADMIN_COMMAND_DB2 result set (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
FRAMESIZE VARCHAR(4) The frame size that the buffer pool uses
ALLOC_FRAME4K INTEGER The number of buffers that are allocated with a 4K frame size
ALLOC_FRAME1M INTEGER The number of buffers that are allocated with a 1M frame size
VPSIZEMIN INTEGER The minimum buffer pool size
VPSIZEMAX INTEGER The maximum buffer pool size

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:

Table 3. Result set row for second ADMIN_COMMAND_DB2 result set (processing-type = THD)
Column name Data type Contents
ROWNUM INTEGER Sequence number of the table row, from 1 to n
TYPE INTEGER Thread type:
0
Unknown
1
Active
2
Inactive
3
Indoubt
4
Postponed
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 Start of changeCHAR(20)End of change Unit of recovery identifier
LUWID CHAR(35) Logical unit of work ID of the thread
WORKSTATION VARCHAR(255) Client workstation name
USERID VARCHAR(128) Client user ID
APPLICATION VARCHAR(255) Client application name
ACCOUNTING VARCHAR(255) 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:

Table 4. Result set row for second ADMIN_COMMAND_DB2 result set (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:

Table 5. Result set row for second ADMIN_COMMAND_DB2 result set (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:
DB
Database
TS
Table space
IX
Index
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:

Table 6. Result set row for second ADMIN_COMMAND_DB2 result set (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 Start of changeCHAR(6)End of change 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:

Table 7. Result set row for second ADMIN_COMMAND_DB2 result set (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

End general-use programming interface information.