The following table contains descriptions of the thread definition table parameters:
Note: You can also use the thread definition table to create automatic startup and shutdown (PLTPI and PLTSD) programs.
Configuration Steps
Table 11–1 Thread Definition Table Parameters
Parameter Description
AM4COID is used, if specified, as the Oracle user id for the control thread.
It must be a constant character string of 30 characters or less, and requires the AM4CAUTH parameter. If omitted, then the CICS applid is used for autologon. This parameter is specified on the TYPE=START statement and requires that at least one thread be defined using the OID and AUTH parameters.
AM4CAUTH is the authentication string (password) for the Oracle user id specified in the AM4COID parameter. It must be a constant character string of 30 characters or less. This parameter is specified on the TYPE=START statement.
AUTH determines how the Oracle user id is derived without an explicit connect statement. The Oracle userid is also used for SMF accounting.
CINTERVL specifies the control transaction time interval. This interval is used to determine how frequently unprotected idle threads are dropped. Idle threads defined with PROTECT=YES are not affected by the setting of CINTERVL. The interval also affects the length of time it can take Oracle Access Manager for CICS TS to invoke emergency shutdown when the Oracle server cannot be contacted. The value is expressed in minutes and seconds, and valid values range from 0000 to 5959. The default value is 0030 (00 minutes, 30 seconds).
COMMIT specifies whether to use Oracle COMMIT processing or CICS SYNCPOINT for commit and rollback functions.
Valid values are CICS and ORACLE. The default is ORACLE.
This parameter can also be specified on the TYPE set to START statement or the Oracle Access Manager for CICS START command. Refer to the section"Recovery Considerations" on page 11-23 for information on these parameter values.
COPIES indicates the number of threads this definition generates.
DESC defines the z/OS descriptor code used for the console
message. Valid values are numeric. The default is 11. DESC is an optional parameter.
Configuration Steps
ENAME is used in conjunction with TYPE=ENV to specify
environment variables for Oracle Access Manager for CICS TS.
It is useful for setting the NLS environment variables to values appropriate for your environment. The syntax is:
ENAME=(var=val, ...)
where var is the name of the environment variable you wish to set, and val is the value you wish to give to var. You can specify several var=val pairs separated by commas in a single ENAME parameter, or a separate TYPE=ENV can be coded for each variable. Do not enclose the names or values in quotes.
The following example shows a single ENAME parameter being used to specify NLS_LANG and NLS_DATE_FORMAT:
ORACICS TYPE=START,SSN=ORA0
ORACICS TYPE=THREAD,COPIES=30,PROTECT=NO, X TRANSAC=*
ORACICS TYPE=ENV, X ENAME=(NLS_LANG=AMERICAN_AMERICA.WE8EBCDIC37C, X NLS_DATE_FORMAT=DD-MON-RR)
FREESPC defines the amount of free space to be allocated for later additions. This parameter is not implemented.
MAXCRSR defines the maximum number of cursors used. The MAXCRSR parameter is patterned after the precompiler option MAXOPENCURSORS. Refer to the Pro*C/C++
Precompiler Programmer’s Guide for more information about the MAXOPENCURSORS option. The default is 10.
MAXTHRD defines the maximum number of threads allocated for this table definition. If the total threads for the table exceed this value, then the MAXTHRD value is adjusted. The default is 10.
NAME identifies the adapter you want started. If NAME is not specified, then the started adapter name defaults to the thread table name. This parameter only applies if TYPE is set to PLTPI.
OID is used, if specified, as the Oracle user id for this thread definition, including all threads generated with the COPIES parameter. It must be a constant character string of 30 characters or less. When specified, the value in the AUTH parameter is used as the associated authentication string.
Table 11–1 (Cont.) Thread Definition Table Parameters
Parameter Description
Configuration Steps
PRIORITY specifies whether Oracle Access Manager for CICS TS subtasks are run at a higher or lower priority than the current
dispatching priority when subtasking is used. Valid values are HIGH and LOW. If HIGH is specified, then Oracle Access Manager for CICS TS subtasks are run at a higher dispatching priority. If LOW is specified, then Oracle Access Manager for CICS TS subtasks run at a lower dispatching priority. LOW is the default.
PROGRAM specifies the name of the program used with the Oracle Access Manager for CICS TS transaction. ORACICS is the default.
This parameter only applies if TYPE is set to PLTSD.
PROTECT specifies whether a thread is protected. Valid values are YES, NO, and nn, where nn is the number of protected threads when used with the COPIES parameter. A value of YES indicates the thread must be protected. (The session is not dropped, even if IDLE TIME has expired.) A value of NO indicates the thread does not need to be protected. NO is the default.
ROUTCDE defines the z/OS route code to use when writing messages to the z/OS operator console. The default is 11.
SSN specifies the alias name used for the Oracle Net connection (as specified in the TNSNAMES entry used as input to the CIN step of the TBLJCLN job in SRCLIB) for database access.
The alias must be four characters or fewer.
START specifies the name of the program for CICS PLTPI processing when TYPE is set to PLTPI.
STOP specifies the name of the adapter stopped during PLTSD shutdown processing. This name corresponds to the value of the NAME parameter used if shutdown processing is performed manually with the STOP command.
TRANSAC specifies the transaction codes eligible to use the thread. A value of * indicates the thread is to be used as a default and no other definitions apply.
WAIT specifies the action to be taken when all threads specified for a transaction are in use. Valid values are YES, NO, and POOL.
YES indicates the transaction is placed in a CICS WAIT state until a thread is available. NO indicates a return code is set indicating no threads are available. POOL indicates the general thread pool (TRANSAC=*) is used. YES is the default.
Table 11–1 (Cont.) Thread Definition Table Parameters
Parameter Description
Configuration Steps
Two additional thread definition table parameters (AUTH and TYPE) are described in the following sections.