Modifying the configuration member for ADDI access

Edit online

Enable and configure the parameters for IBM Application Discovery and Delivery Intelligence (ADDI) in the Data Virtualization Manager configuration member.

About this task

The Data Virtualization Manager configuration member contains a sample DATABASE definition that defines the first ADDI project. The initial definition is named IAD1 and is disabled.

When enabling the database definition for the first ADDI project, the LOCATION and IPADDR parameters must be set to the correct project name and IP address of the Microsoft HIS DRDA Provider Service for SQL Server. The LOCATION provides the name of the SQL Server project, and IPADDR(...) PORT(...) provide the TCP/IP information for the HIS DRDA Service. DOMAIN(...) can be used instead of IPADDR to provide the DNS of the HIS DRDA Service. The subsystem NAME(IAD1) should not be changed because a target subsystem map is configured to use this name for the virtual tables accessing the ADDI project.

For multiple ADDI projects, see Adding an ADDI project.

The Data Virtualization Manager configuration member is shipped in data set member hlq.SAVZEXEC(AVZSIN00) and copied to hlq.AVZS.SAVZEXEC(AVZSIN00) by the job in the AVZGNMP1 member for you to make your local modifications.

Procedure

In the AVZSIN00 member, locate the comment “Sample IBM Application Discovery configuration".

Enable the ADDI parameters by changing the syntax if DontDoThis to if DoThis. The following example shows the section in the configuration member to enable:

/*---------------------------------------------------------------*/
/* Sample IBM Application Discovery configuration using DRDA to  */
/* communicate with a Microsoft SQLServer database.              */
/*---------------------------------------------------------------*/
if DoThis then do
"DEFINE DATABASE TYPE(MSSQL)"                  ,
                 "NAME(IAD1)"                  ,
                 "LOCATION(EZ_Project1)"       ,
                 "DDFSTATUS(ENABLE)"           ,
                 "SECMEC(USRIDPWD)"            ,
                 "IPADDR(::FFFF:0.0.0.0)"      ,
                 "PORT(446)"                   ,
                 "CCSID(37)"                   ,
                 "IDLETIME(0)"                 
end

The following table lists the parameters for configuring support for ADDI:


Parameter	Description	Valid values
TYPE	Database type. Because ADDI stores information in Microsoft SQL Server, this value must be MSSQL.	MSSQL
NAME	The database name as known to the server. The first definition must be `IAD1` because the target system map names this as the subsystem to access for ADDI. For additional ADDI projects, subsystems can have any name since you must also create a virtual target system to point to it; however, it recommended that the name start with `IAD`. (Required)	A valid value consists of 1 - 4 characters. For example, `IAD1`.
LOCATION	Name of the database for the ADDI project. The LOCATION parameter must be set to the correct database name of the target MSSQL server. (Required)	A valid value is a string 1 - 16 characters.
DDFSTATUS	The DDF activation status (Required)	ENABLE Make this DDF definition active within Data Virtualization Manager server. DDFSTATUS should always be ENABLE for TYPE(MSSQL). DISABLE DDF endpoint is not used. This value disables the MSSQL database. This value should only be used if the database is off-line or otherwise not available for access.
SECMEC	Security mechanism. The DRDA security mechanism for authentication with the HIS DRDA Service for SQL Server. The SECMEC setting for TYPE(MSSQL) must match the HIS DRDA Service configuration.	USRIDPWD User ID and password USRIDONL User ID only USRENCPWD Encrypt the password only EUSRIDPWD Encrypt the user ID and password
IPADDR	Specify the IPV4 or IVP6 address of the target MSSQL server. Use DOMAIN instead of IPADDR to supply the DNS of the target HIS DRDA Server for SQL Server. Use DOMAIN if the IPADDR or the HIS DRDA Service Provider can change. Either DOMAIN or IPADDR is required, but not both.	A valid IPV4 or IVP6 address set to the correct remote IP address for the system running Microsoft SQL Server.
DOMAIN	The part of a network address that identifies it as belonging to a particular domain. Use DOMAIN instead of IPADDR to supply the DNS of the target HIS DRDA Server for SQL Server. Use DOMAIN if the IPADDR or the HIS DRDA Service Provider can change. Either DOMAIN or IPADDR is required, but not both.	No default value.
PORT	The TCP/IP port defined for Microsoft HIS DRDA Service Provider. For TYPE(MSSQL), the standard HIS default is 446. (Required)	A valid 1-5 numeric string.
CCSID	Specify the EBCDIC single-byte application CCSID (Coded Character Set Identifier). (Required)	Refer to the Microsoft SQL Server documentation for a list of valid CCSIDs. Refer to the ISV documentation on HIS DRDA Service to SQL Server. For USA, this value is `037`.
IDLETIME	This setting is not used for TYPE(MSSQL).	0