Configuring the Adapter for Model 204

Topics:

x

Configuring the adapter consists of specifying connection and authentication information for each of the connections you want to establish. The Adapter for Model 204 can be configured from the Web Console or from the Data Management Console.

Allocating the Model 204 Libraries

Prior to configuring the Adapter for Model 204, you must allocate the following Model 204 libraries.

Edit the ISTART JCL:

  • Allocate the Model 204 load library to ddname STEPLIB.
  • Any private Master File libraries and prefix.EDAMFD.DATA should be allocated to ddname MASTER in the JCL.
  • Any private Access File libraries and prefix.EDAAFD.DATA should be allocated to ddname ACCESS in the JCL.

Specifying Account and File Passwords

Your Model 204 database administrator must provide account and file security information in order for the adapter to access password protected Model 204 files or groups.

An account consists of the Model 204 user ID, an optional account name, and the associated password. You can specify these security values using the following methods:

  • Set appropriate values to declare the CONNECTION attributes and then use the connection name in the Access File CONNECTION attribute.
  • Include the ACCOUNT and ACCOUNTPASS attributes in the first declaration of the Access File.
  • Issue the adapter M204IN SET M204ACCNT and M204PASS commands.
  • Use a security exit. If you use this method, you must omit all previously mentioned sources of account information. For details, see Using Customized Security Exits.

You must also know the file name and password (if there is one) for each Model 204 file or group you access. Specify these values with the FILE and PASS attributes in each SEGNAME declaration of the Access File.

Testing the Adapter Installation

To verify the adapter installation, run a simple query using one of the pairs of Master and Access Files you have defined for a Model 204 file.

Declaring Connection Attributes

How to:

Reference:

In order to connect to Model 204, the adapter requires connection information. You supply this information using the SET CONNECTION_ATTRIBUTES command. You can:

  • Enter connection and authentication information in the Web Console or the Data Management Console configuration panes. The consoles add the command to the profile you select: the global server profile (edasprof.prf), a user profile (user.prf), or a group profile (if supported on your platform).
  • Manually add the command in the global server profile (edasprof.prf), in a user profile (user.prf), or in a group profile (if supported on your platform).

Procedure: How to Configure an Adapter

  1. From the Web Console sidebar, click Connect to Data.

    or

    From the Data Management Console, expand the Adapters folder.

    In the DMC, the Adapters folder opens. In the Web Console, the Adapters page opens showing your configured adapters.

  2. In the Web Console, click the New Datasource button on the menu bar and find the adapter on the drop-down list or, in the DMC, expand the Available folder if it is not already expanded.
    On the Web Console, you can select a category of adapter from the drop-down list or use the search option (magnifying glass) to search for specific characters.
  3. In the DMC, 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 chapter for the specific adapter you want to configure.
  6. Click Configure. The configured adapter is added to the Adapters list in the DMC resources tree or the Configured list in the Web Console.
    In the Web Console, the adapter remains on the Available Adapters list with a check mark to indicate that at least one connection has been configured. You can configure additional connections from either the Configured or Available list by right-clicking the adapter and clicking Add Connection.

Reference: Connection Attributes for Model 204

The MODEL 204 adapter is under the DBMS group folder.

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

Connection name

Logical name used to identify this particular set of connection attributes. The default is CON01.

Channel Name

Is the CRAM, IUCV, or VMCF communication channel name (up to 8 characters).

Account

Is a string of 1-10 characters, to be used only if an account under which the user will log in to MODEL 204 must be supplied.

Readwol

Readwol (read without locks) instructs the adapter to issue an IFFWOL (find without locks) HLI call. To use this setting, enter ON.

If you leave the setting blank (OFF), the adapter holds locks on the appropriate records in order to ensure accurate data for reports. The locks prevent other users from updating the target records while Model 204 constructs answer sets. The adapter generates standard IFFIND calls that lock the found set in SHR mode.

Singlethread

There are two types (or modes) of thread management:

  • Multiple. The adapter creates as many threads as it needs whenever they are needed to access files. This setting is recommended for performance reasons.

    To use the default setting (OFF), leave this option blank.

  • Single. The adapter creates one thread for all file access; this restricts processing to one request. Single thread forces the adapter to use a single thread for all file access. For example, if a request joins 10 files, only one thread is used to access all of the files.

    To use this setting, enter ON.

Missing

You can control the display of Model 204 null data on reports. Null data is translated into the server missing data display value. The default NODATA display value is the period (.).

When the Missing option is selected, the edit specification for all IFGET calls includes an (L) format code. If Model 204 returns a zero in the first byte, the adapter considers that field to be missing. To use this setting, enter ON.

Note: IFFIND calls contain IS PRESENT or IS NOT PRESENT criteria only when the request includes a server IF or WHERE MISSING selection test.

If you leave this setting blank (OFF), null values are not represented on reports. (This is the default setting.)

Note:

  • The default setting can affect the results of server DML SUM or COUNT aggregate operations. Null values may be counted or averaged in as existing values.
  • You must include the Missing setting in order to specify screening conditions (IF or WHERE MISSING tests) for null values.
Maxmbuf

You can set or change the maximum size of all adapter buffers.

Note that Maxmbuf:

  • Should be greater than the larger of two Model 204 buffer settings, LIBUFF and LOBUFF. To identify which buffer is larger, check the parameters in the Model 204 start-up procedure or use the adapter Trace Facility (SET TRACEON=M204IN) to display the settings.
  • Should be equal to the size of the largest segment in the Master File if the segment size is greater than the Model 204 LIBUFF and LOBUFF buffer settings. Having the maximum buffer size equal to that of the largest segment prevents S0C4 ABEND conditions.

Enter:

nnnn

To represent the maximum size in bytes. (For example, specify 4096 for a MAXMBUFF value of 4K.) There is no default value.

Ftblsize

The Ftblsize option enables you to control the size of the Model 204 FTBL buffer. The LFTBL parameter, specified in the Model 204 start-up procedure, governs the size of the FTBL buffer.

Enter:

nnnn

To represent the FTBL size in bytes. (For example, specify 4096 for an FTBL value of 4K.)

You should set FTBL to a value larger than the previously defined Model 204 LFTBL value.

User

Is the user ID (1-10 characters) by which you are known to MODEL 204. If omitted, other sources of this data will be used (that is, file level information from the Access File or a security exit).

Password

Is the password associated with the user ID. If omitted, other sources of this data will be used (that is, file level information from the Access File or a security exit)

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).

Syntax: How to Declare Connection Attributes Manually

ENGINE M204INX SET CONNECTION_ATTRIBUTES connection_name 
channel_name/userid,password: 
"[ACCOUNT account] [READWOL {ON|OFF}] [SINGLETHREAD {ON|OFF}]
[MISSING {ON|OFF}] [MAXMBUF nnnnn] [FTBLSIzE nnnnn]"]

where:

connection_name

Is the name of the current connection.

channel_name

Is the CRAM, IUCV, or VMCF communication channel name (up to 8 characters).

userid,password

Are valid M204 user IDs and passwords. If they are omitted then other sources of this data will be used (that is, file level information from the Access File or a security exit).

account

Is a string of 1-10 characters, to be used only if an account under which the user will log in to Model 204 must be supplied.

A space is used as the delimiter between the parameters and values.

READWOL

The options are:

ON instructs the adapter read without locks and issue an IFFWOL (find without locks) HLI call.

OFF holds locks on the appropriate records to ensure accurate data for reports. The locks prevent other users from updating the target records while Model 204 constructs answer sets. The adapter generates standard IFFIND calls that lock the found set in SHR mode. (This is the default setting.)

SINGLETHREAD

The options are:

ON is used for single thread processing. With this setting, the adapter creates one thread for all file access; this restricts processing to one request. For example, if a request joins 10 files, only one thread is used to access all of the files.

OFF is used for multiple thread processing. With this setting, the adapter creates as many threads as it needs whenever they are needed to access files. OFF, the default setting, is recommended for performance reasons.

MISSING

You can control the display of Model 204 null data on reports. Null data is translated into the server missing data display value. The default NODATA display value is the period (.).

The options are:

ON where in this setting, the edit specification for all IFGET calls includes an (L) format code. If Model 204 returns a zero in the first byte, the adapter considers that field to be missing.

Note that IFFIND calls contain IS PRESENT or IS NOT PRESENT criteria only when the request includes a server IF or WHERE MISSING selection test.

OFF where in this setting, null values are not represented on reports. This is the default setting.

Note: The default setting can affect the results of server DML SUM or COUNT aggregate operations. Null values may be counted or averaged in as existing values.

You must include the Missing setting in order to specify screening conditions (IF or WHERE MISSING tests) for null values.

MAXMBUF

You can set or change the maximum size of all adapter buffers.

nnnn represents the maximum size in bytes. (For example, specify 4096 for a MAXMBUFF value of 4K.) There is no default value.

Note that MAXMBUF:

  • Should be greater than the larger of two Model 204 buffer settings, LIBUFF and LOBUFF. To identify which buffer is larger, check the parameters in the Model 204 start-up procedure or use the adapter Trace Facility (SET TRACEON=M204IN) to display the settings.
  • Should be equal to the size of the largest segment in the Master File if the segment size is greater than the Model 204 LIBUFF and LOBUFF buffer settings. Having the maximum buffer size equal to that of the largest segment prevents S0C4 ABEND conditions.
FTBLSIZE

The FTBLSIZE option enables you to control the size of the Model 204 FTBL buffer. The LFTBL parameter, specified in the Model 204 start-up procedure, governs the size of the FTBL buffer.

nnnn represents the FTBL size in bytes. (For example, specify 4096 for an FTBL value of 4K.)

Note that you should set FTBL to a value larger than the previously defined Model 204 LFTBL value.

Any of the environmental SET commands in the prior version of Model 204 may be used, except M204ACCNT and M204PASS.

Example: Sample Connection Declarations

ENGINE M204INX SET CONNECTION_ATTRIBUTES m204a IFAMCHNL/user1,
pwd1: "ACCOUNT acc1 MISSING ON READWOL ON FTBLSIZE 16000"
ENGINE M204INX SET CONNECTION_ATTRIBUTES m204b IFAMCHNL/user2,
pwd2: "SINGLETHREAD ON"

The command ? SET may point to a valid connection_name. For example:

ENGINE M204INX SET CONNECTION_ATTRIBUTES M204
IFAMSUPT/SUPERKLUGE,PIGFLOUR: "ACCOUNT ACT1 MISSING ON"
 
ENGINE M204INX ? SET
(FOC4855) Set M204ACCNT option
(FOC4856) Set M204PASS option
(FOC4857) Set SINGLETHREAD option   : OFF
(FOC4858) Set READWOL option        : OFF
(FOC4859) Set MISSING option        : OFF
(FOC4860) Set MAXMBUFF option
(FOC4861) Set FTBLSIZE option
ENGINE M204INX ? SET M204
(FOC4863) Set IFAMCHNL option       : IFAMSUPT
(FOC4855) Set M204ACCNT option      : SUPERKLUGE ACT1
(FOC4856) Set M204PASS option       : PIGFLOUR
(FOC4857) Set SINGLETHREAD option   : OFF
(FOC4858) Set READWOL option        : OFF
(FOC4859) Set MISSING option        : ON
(FOC4860) Set MAXMBUFF option       : 0
(FOC4861) Set FTBLSIZE option       : 0

WebFOCUS

Feedback