In this section: How to: Reference: |
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.
You can configure the adapter from either the Web Console or the Data Management Console.
or
From the Data Management Console, expand the Adapters folder.
The Adapters folder opens.
The Add Adapter to Configuration pane opens.
Note:
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.
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'
Number of the database to access. For example: 001(Required for all platforms.)
Number of the Adabas Employee or another Demo File. For example: 011 (Required for all platforms.)
SVC number of the Adabas router. For example: 240 (Required only for z/OS.)
Type of device where the Adabas Associator is located. For example: 3390 (Required only for z/OS.)
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.)
Name of the Adabas Associator data set. For example: SAGLIB.ADA814.EXAMPLE.DB001.ASSOR1 (Required only for z/OS.)
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.
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:
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.
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:
Indicates the adapter. You can omit this value if you previously issued the SET SQLENGINE command.
Is the password, which can be from one to eight characters in length.
Specifies the file number for which the password is set.
Specifies the database or databases for which the password is set.
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.
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.
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).
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.
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.
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 |