Configuring the Adapter for Adabas

In this section:

How to:

Reference:

x

Configuring the adapter consists of specifying connection information for each of the connections you want to establish.

No user ID and password are needed to establish a connection to Adabas. This means that Trusted Mode is the standard for Adabas. To secure a connection, use the SET PASSWORD feature.


Top of page

x
Procedure: How to Configure the Adapter

You can configure the adapter from either the Web Console or the Data Management Console.

  1. From the Web Console menu bar, click Adapters.

    or

    From the Data Management Console, expand the Adapters folder.

    The Adapters folder opens.

  2. Expand the Available folder, if it is not already expanded.
  3. Expand the appropriate group folder and the specific adapter folder. The group folder is described in the connection attributes reference.
  4. Right-click the adapter name and/or version and select Configure.

    The Add Adapter to Configuration pane opens.

  5. Enter values for the parameters required by the adapter, as described in the connection attributes reference.
  6. Click Configure. The configured adapter is added to the Adapters list in the navigation pane.

Note:


Top of page

x
Reference: Connection Attributes for Adabas

The Adabas adapter is under the DBMS group folder.

This following list describes the connection attributes for which you can supply values. To complete the attribute declaration, click the Configure button.x

Connection Name

Is the logical name used to identify this particular set of connection attributes. There is no default Connection Name. You must provide a value.

The Connection Name is a new parameter added in Version 7 Release 7.4. It is designed to support access to different databases with different SVCs and releases through the same adapter. It corresponds to the new CONNECTION parameterin an Access File.

Adapter continues to support connection strings and Access Files without a Connection Name parameter, as they were declared prior to Version 7 Release 7.4.

Note that the connection name <local> will be displayed on the Web Console for the legacy connection strings.

Users may assign a more meaningful name instead. For example, the legacy connection

ENGINE ADBSINX SET CONNECTION_ATTRIBUTES 
/,;3:',ADAEMPL=1,ADASVC=214,ADADEVICE=3,390,ADAASSO=SAGLIB.ADA814.IBIMVS.DB03.ASSOR1'

can be converted into new connection supported since Version 7 Release 7.4

ENGINE ADBSINX SET CONNECTION_ATTRIBUTES 
ADA814/,;3:',ADAEMPL=1,ADASVC=214,ADADEVICE=3,390,ADAASSO=SAGLIB.ADA814.IBIMVS.DB03.ASSOR1'
Default DB number

Number of the database to access. For example: 001(Required for all platforms.)

SAG Employee/Demo file number

Number of the Adabas Employee or another Demo File. For example: 011 (Required for all platforms.)

SVC number

SVC number of the Adabas router. For example: 240 (Required only for z/OS.)

Device type

Type of device where the Adabas Associator is located. For example: 3390 (Required only for z/OS.)

ADABAS Load Library name

Name of the Adabas load library that contains the zapped member ADALNKR (see notes below). This name needs to be added after the IBI load library; the order is important. For example:

//TASKLIB ...   
   // DD DISP=SHR,DSN=IBI.HOME.LOAD   
   // DD DISP=SHR,DSN=SAGLIB.ADA814.LOAD   
   ...

(Required only for z/OS.)

Associator data set name

Name of the Adabas Associator data set. For example: SAGLIB.ADA814.EXAMPLE.DB001.ASSOR1 (Required only for z/OS.)x

ADABAS LOAD library

This parameter is needed only if the Adapter will be used to access Adabas databases with different SVCs. It lets you specify your own high_level_qualifier for each database.

If only one SVC is used, this parameter is not needed.x

Select profile

Select a profile from the drop-down menu to indicate the level of profile in which to store the CONNECTION_ATTRIBUTES command. The global profile, edasprof.prf, is the default.

If you wish to create a new profile, either a user profile (user.prf) or a group profile if available on your platform (using the appropriate naming convention), choose New Profile from the drop-down menu and enter a name in the Profile Name field (The extension is added automatically).

Store the connection attributes in the server profile (edasprof).</p>

Note:


Top of page

x
Overriding Default Passwords in Specific Files

How to:

You can set passwords for Adabas files in the server profile using the SET PASSWORD command. You can set default passwords for all files and/or databases. Specific passwords can be set for specific files which will override the default. The SET command overrides the password coded in the Access File. The SET PASSWORD command remains valid throughout the user session.



x
Syntax: How to Use the SET PASSWORD Command
x

Tip: You can change this setting manually or from the Web Console by clicking Adapters on the menu bar, clicking a configured adapter, and choosing Change Settings from the right-click menu. The Change Settings pane opens.

ENGINE ADBSINX SET PASSWORD password FILENO ALL DBNO {ALL|dbno}
ENGINE ADBSINX SET PASSWORD password FILENO fileno DBNO dbno 
ENGINE ADBSINX SET PASSWORD OFF
ENGINE ADBSINX SET PASSWORD DEFAULT

where:

ADBSINX

Indicates the adapter. You can omit this value if you previously issued the SET SQLENGINE command.

password

Is the password, which can be from one to eight characters in length.

FILENO

Specifies the file number for which the password is set.

DBNO

Specifies the database or databases for which the password is set.

ALL

Indicates all files and/or databases used with the FILENO and DBNO parameters. If you want to use ALL for both FILENO and DBNO, issue this command before any other subsequent password commands. ALL overrides any prior settings.

dbno

Is any valid numeric database value between 0 and 255 (65,535 is the maximum value on a mainframe platform). The DBNO parameter indicates the actual database number.

fileno

Provides a file number, a list of file numbers, and/or a range of file numbers used with the FILENO parameter. Numbers and ranges can be combined by separating items with commas. Valid file numbers range between 0 and 255 (5000 is the maximum value on a mainframe platform).

OFF

Clears all previous ADBSINX SET PASSWORD commands. The Adapter for Adabas does not use any passwords specified in the Access File. This command lets you access only those files that have no password security.

DEFAULT

Clears all previous ADBSINX SET PASSWORD commands and causes the Adapter for Adabas to use the password in the Access File.

To set a default password:

Note that subsequent requests are appended to previous requests. Changes are cumulative. The passwords can be issued from a FOCEXEC, which may be encrypted.



Example: Using the SET PASSWORD Command to Specify Files in a Database

To set the password to BRUCE for specific files in database number 123 on z/OS, issue the following command:

ENGINE ADBSINX SET PASSWORD BRUCE FILENO 1,3-5,23,89-93 DBNO 123

To clear all previous ADBSINX SET PASSWORD commands on z/OS, and tell Adabas to use the password in the Access File, issue the following command:

ENGINE ADBSINX SET PASSWORD DEFAULT

iWay Software