Configuring the Adapter for Model 204

In this section:

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.


Top of page

x
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:


Top of page

x
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:

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.


Top of page

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


Top of page

x
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:



x
Procedure: How to Declare Connection Attributes

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.


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



x
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:

FTBLSIZE

The FTBLSIZE options 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

iWay Software