Using SAS System Options for IMS Databases

Introduction to SAS System Options for IMS Databases

The SAS/ACCESS interface to IMS uses a group of SAS system options to specify the type of DL/I region through which DL/I calls are executed and to provide the DL/I region execution parameters. For example, either the IMSREGTP= option or its alias, DLIRGNTP=, specifies the type of DL/I region to be invoked. Appropriate defaults are assigned for the system options when the SAS/ACCESS interface is installed at a site.
The next section provides more information about how to use SAS options for IMS. In later sections, the options are divided into two sections according to their operating system. Each reference section includes a quick reference table for the options, followed by a longer description of each option.

Specifying System Options

Invocation and Session Options

The system options described in this appendix fall into two categories:
  • Invocation options are processed when SAS is initialized. They can be specified in the following ways:
    • in the default OPTIONS table
    • in a system or user configuration file
    • in the OPTIONS parameter of the host command that you use to invoke SAS at your site
  • Session options can be specified when SAS is invoked, in the configuration file, or in an OPTIONS statement.

Restrictable Options

The DBA or SAS support personnel at your installation might choose to restrict an invocation option to a particular value for security or data integrity reasons. Session options cannot be restricted; you can override them any time during a SAS session by using an OPTIONS statement. If you try to override a restricted invocation option, you get an error message.
You can use two methods to determine which invocation options are restricted at your installation:
  • Ask the SAS support personnel or DBA who installed the SAS/ACCESS interface to IMS at your site.
  • Invoke SAS with the VERBOSE option. In the list of options that appears, the restricted invocation options (if any) follow the VERBOSE option.
    Note: From a TSO session under z/OS, the list of options might be displayed only briefly on your computer before the SAS session comes up. In this case, you need to exit SAS in order to see the list of options.

Displaying the Current Values of the Options

To check your installation's current settings for the SAS system options for IMS, check the settings for the options (except for DLIREAD and BMPREAD) by executing PROC OPTIONS with the IMS option:
proc options ims;
run;
To see the values of DLIREAD and BMPREAD, use PROC OPTIONS without the IMS option. The OPTIONS procedure is documented in the Base SAS Procedures Guide.

Overriding Option Defaults

Most option defaults are probably correct for your applications, and you might never need to override the default settings. In fact, many of the options might specify information that is unfamiliar to a DL/I applications programmer. However, if you decide that one or more of the defaults is not appropriate for your IMS application, you can override the default value(s) as follows:
  • You can override the default value of an unrestricted invocation option in any of the following ways:
    • when you invoke SAS
    • in the system configuration file (if one is used)
    • in the user configuration file (if one is specified)
    • in the default options (DFLTOPTS) table
    • in the OPTIONS parameter at invocation of the CLIST (TSO)
    • in the OPTIONS parameter in the cataloged procedure (batch only).
    Note: You cannot override the default value of any invocation option, whether restricted or unrestricted, during a SAS session. For example, your installation might specify that the invocation option DLIREAD= is unrestricted, and set the value of that option at Y so that programs using a batch region can issue only get calls by default. Because DLIREAD= is not restricted, you can specify the following at invocation time to override the default value of Y.
    DLIREAD=N;
    However, you cannot override the value of DLIREAD= during a SAS session.
  • You can override the default value of a session option by specifying the option in any of the following ways:
    • in an OPTIONS statement
    • in the system configuration file (if one is used)
    • in the user configuration file (if one is specified)
    • in the Default Options (DFLTOPTS) table
    • in the OPTIONS parameter at invocation of the CLIST (TSO)
    • in the OPTIONS parameter in the cataloged procedure (batch only)
For more information about overriding SAS system options, see the SAS companion for your operating system.

Most Frequently Altered Options

Here are options that you might need to override.
IMSREGTP=
specifies the type of DL/I region that is used to execute DL/I calls. It is altered whenever you want to execute calls through a DL/I region that is not the installation default.
If you use a batch DLI or DBB region, you are not likely to alter any other system option. If you use an online access region (BMP), you might need to change one or more of these options:
IMSBPIN= IMSBPOUT=
identify message queues for access in advanced DL/I programming when running a BMP region. This option is valid only for the IMS DATA step interface.
IMSID=
identifies the IMS subsystem that contains the databases that you want to access. You might need to use this option with a BMP, DLI, or DBB region in order to specify a test or production system.

SAS System Options for IMS

Since SAS 6, the first three letters of all SAS system options for IMS are IMS. If the option applies only to certain region types, the next two letters indicate the region type: DL for DLI or DBB and BP for BMP. Some options such as IMSSPIE apply to more than one region type. These options do not include one of the region-type codes.
Most of the SAS system options for IMS parallel the functions of DL/I parameters. For example, the option IMSBPAGN= specifies a value for the AGN parameter, which is used in BMP regions. If you need more information about IMS parameters, see your IBM documentation.
Note: For the DATA step interface, the SLI region type--and hence, the SLICWTO, SLIREAD, and CICSID options--are no longer supported. Sites that use CICS as opposed to IMS/DC can gain access to CICS dedicated databases by using the IMS-ESA or CICS-ESA DBCTL feature. This feature enables an application like SAS software to access the databases through a BMP region.
The following sections describe the SAS system options for IMS.

Quick Reference for Options

The following table summarizes SAS system options for IMS.
SAS System Options for IMS
V6 and later Option
Default
Invocation
Session
Restrict
Engine
DATA Step
N
Y
Y
Y
N
Y
Y
Y
IMSBPAGN
*
Y
Y
Y
Y
IMSBPCPU
0
Y
Y
Y
Y
IMSBPDCA
0
Y
Y
Y
Y
IMSBPIN
*
Y
Y
Y
IMSBPNBA
0
Y
Y
Y
IMSBPOBA
0
Y
Y
Y
IMSBPOPT
C
Y
Y
Y
Y
IMSBPOUT
*
Y
Y
Y
IMSBPPAR
0
Y
Y
Y
Y
IMSBPSTI
0
Y
Y
Y
Y
IMSBPUPD
Y
Y
Y
Y
IMSDEBUG
N
Y
Y
Y
Y
IMSDLBKO
*
Y
Y
Y
Y
IMSDLBUF
16
Y
Y
Y
Y
IMSDLDBR
*
Y
Y
Y
Y
IMSDLEXC
0
Y
Y
Y
Y
IMSDLFMT
P
Y
Y
Y
Y
IMSDLIRL
*
Y
Y
Y
Y
IMSDLIRN
*
Y
Y
Y
Y
IMSDLLOG
0
Y
Y
Y
Y
IMSDLMON
N
Y
Y
Y
Y
IMSDLSRC
0
Y
Y
Y
Y
IMSDLSWP
*
Y
Y
Y
Y
IMSDLUPD
Y
Y
Y
Y
IMSID
*
Y
Y
Y
Y
IMSIOB
*
Y
Y
Y
Y
IMSREGTP
DLI
Y
Y
Y
Y
IMSSPIE
0
Y
Y
Y
Y
IMSTEST
0
Y
Y
Y
Y
IMSWHST
N
Y
Y
Y