DRA startup table

The database resource adapter (DRA) Startup Table contains values used to define the characteristics of the DRA. You must make the required changes to these modules to correctly specify the DRA parameters.

The DRA Startup Table is created by assembling:

The DFSPZPxx module for a CCTL's use.
The DFSxxxx0 module for ODBA's use.

The CCTL or ODBA system programmer must make the required changes to these modules to correctly specify the DRA parameters. The DRA parameters are specified as keywords on the DFSPRP macro invocation.

Sample DFSPZP00 source code

DFSPZP00 CSECT
         DFSPRP DSECT=NO,FPBUF=10,FPBOF=5,CNBA=60,MINTHRD=3,MAXTHRD=6,DSNAME=IMS.SDFSRESL 
         END

DFSPRP macro keywords

Keyword

Description

AGN=

This keyword is no longer used. If specified, it is ignored.

CNBA=

Specifies the total number of Fast Path NBA buffers for OBDM use. Valid values for CNBA are from 0 to 9999 or 1K to 32K. The default value for CNBA is 0.

You can determine a starting value for CNBA by using the following formula: (FPBUF+FPBOF) x MAXTHRDS = CNBA. The minimum value of CNBA must be equal to or greater than the total of the FPBUF and FPBOF values. If needed, adjust the value of CNBA to meet the performance and storage requirements of your installation.

If the FPBUF is greater than 0, FPBOF greater than 0, and CNBA equal to 0, the IMS system will calculate CNBA size during connection request processing based on the above formula.

DBCTLID=

The four-character name of the IMS DB or DB/DC region. This is the same as the IMSID parameter in the DBC procedure. The default name is SYS1.

DDNAME=

A 1-to-8 character ddname used with the dynamic allocation of the IMS DB execution library. The default ddname is CCTLDD.

DSNAME=

A 1-to-44 character data set name of the IMS DB execution library, which must contain the DRA modules and must be z/OS® authorized. The default DSNAME is IMS.SDFSRESL. This library must contain the DRA modules.

FPBOF=

Specifies the number of Fast Path DEDB overflow buffers to be allocated per thread. Valid values for FPBOF are from 0 to 9999. The default value for FPBOF is 0. Values for FPBOF specified in the local section of CSLDCxxx override the value of FPBOF from the global section.

FPBUF=

Specifies the number of Fast Path DEDB buffers that are allocated and fixed per thread. Valid values for FPBUF are from 0 to 9999. The default value for FPBUF is 0. Values for FPBUF specified in the local section of CSLDCxxx override the value of FPBUF from the global section.

FUNCLV=

Specifies the DRA level that the CCTL or ODBA supports. The default is 3.

GENSNAP=

Specifies whether to produce or suppress SNAP output in DFSPAT20 during thread termination.

YES: Produces SNAP output in DFSPAT20 during thread termination. YES is the default.
NO: Suppresses the generation of SNAP output by DFSPAT20 during thread termination.

IDRETRY=

The number of times a z/OS application region is to attempt to IDENTIFY (or attach) to IMS after the first IDENTIFY attempt fails. The maximum number 255. The default is 0.

IMSPLEX=

A 1- to 5-character user-specified identifier that is concatenated to 'CSL' to create the z/OS cross-system coupling facility CSL IMSPLEX group name. The value specified here must match the IMSPLEX NAME= value specified in the SCI startup procedure. The IMS ODBA interface uses this XCF CSL IMSPLEX group to register with SCI using the CSLSCREG interface; the target ODBM address space must specify the same XCF CSL IMSPLEX group name when registering with SCI. If you specify this parameter, the IMS ODBA interface routes calls to the ODBM address space rather than directly to IMS. If IMSPLEX= is not specified, ODBA calls are routed directly to IMS.

This parameter is required for applications that route ODBA calls through the ODBM address space. There is no default value.

MAXTHRD=

The maximum number of DRA thread TCBs available at one time. The maximum number is 4095. The default is number 1.

MINTHRD=

The minimum number of DRA thread TCBs available at one time. The maximum number is 4095. The default is number 1.

When the DRA Open Thread TCB option is active, this value refers to the number of DRA threads that are signed on to IMS.

When the DRA Open Thread TCB option is inactive, this value refers to the number of DRA thread TCBs that remain attached and signed on to IMS.

ODBMNAME=

Specifies the name of the ODBM address space to which the ODBA interface registers using the CSLDMREG request, and to which the ODBA calls are routed using the CSLDMI interface. This is an optional parameter. There is no default. If ODBMNAME= is not specified, the ODBA interface selects which ODBM address space all ODBA calls are routed.

OPENTHRD=

Specifies whether or not to enable DRA Open Thread support processing. When enabled and using CICS® 4.2 or higher, this option directs the DRA not to attach dedicated IMS DRA thread task control blocks (TCBs). CICS TCBs are used instead, which are intended for increased parallelism within the CICS/DRA environment.

CCTL: Open Thread processing is enabled.
DISABLE: Open Thread processing is disabled. This is the default.

SOD=

The output class used for a SNAP DUMP of abnormal thread terminations. The default is A.

TIMEOUT=

(CCTL only). The amount of time (in seconds) a CCTL waits for the successful completion of a DRA TERM request. Specify this value only if the CCTL application is coded to use it. This value is returned to the CCTL upon completion of an INIT request.

TIMER=

The time (in seconds) between attempts of the DRA to identify itself to IMS DB or DB/DC during an INIT request. The default is 60 seconds.

TIMETHREADCPU=

Specifies whether the DRA monitors and reports the CPU usage statistics, that are related to DRA threads, when DRA Open Thread support is enabled. The time is reported in IMS 07 log record DLRTIME field, and to the CCTL in DRA thread statistics field PAPLCTM1.

YES: The DRA monitors and reports the CPU usage statistics. A value of YES overrides any value that is specified by the CCTL. YES is the default.
NO: The DRA does not monitor and report the CPU usage statistics. A value of NO overrides any value that is specified by the CCTL.
CLIENT: The DRA uses the setting that is specified by the DRA client through the INIT call (YES or NO) . If the client does not specify a setting, YES is the default.

USERID=

An 8-character name of the CCTL or ODBA region. The USERID name must not be the same as the IMSID name. This keyword is ignored for an ODBA Region.