SYSIDMS Parameter Descriptions

This article describes the SYSIDMS parameters.
This article describes the SYSIDMS parameters.
  • ABEND_ON_DEADLOCK
    Forces the abnormal termination of a task that encounters a database resource deadlock. In normal CV operations, a database resource deadlock results in control being returned to the application program with an indication that a deadlock occurred. This parameter causes the task to be abended.
    This parameter is meaningful only in the SYSIDMS file that is associated with a central version.
  • ABEND_SVC_DUMP=ON|OFF
    Causes an SVC dump to be requested when CV abends prematurely (ON) or not at all (OFF).
    Default:
    ON
    Specifying OFF is not recommended. If the CV address space abends, a dump is required to determine the cause of the abend.
  • ABENDTRACE=ON|OFF
    Activates the tracing of various pieces of CA IDMS data when using CA Optimizer/II or CA SymDump Batch. This parameter is meaningful only in the SYSIDMS file that is associated with a batch job.
    CA Optimizer/II or CA SymDump Batch is required to use this parameter.
    if CA Optimizer/II or CA SymDump Batch is not installed, and you do not specify ABENDTRACE=ON, you can still get an abbreviated trace of CA IDMS activity by setting optional bit 265 in RHDCOPTF.
  • ABENDTRACE_ENTRIES=
    nnn
    Overrides the default number of entries being traced by ABENDTRACE. This parameter is meaningful only in the SYSIDMS file that is associated with a batch job.
    CA Optimizer/II or CA SymDump Batch is required to use this parameter.
  • ABENDTRACE_SUBSCHEMA_DISPLAY=ON
    Activates the display of information from the subschema in use at the time of abend when using ABENDTRACE. This parameter is meaningful only in the SYSIDMS file that is associated with a batch job.
    CA Optimizer/II or CA SymDump Batch is required to use this parameter.
  • ABENDTRACE_VIBSNAP=ON
    Causes the dump of the VIB at the time of abend when using ABENDTRACE. This parameter is meaningful only in the SYSIDMS file that is associated with a batch job.
    CA Optimizer/II or CA SymDump Batch is required to use this parameter.
  • ADJUNCT_TRACE_TABLE=table-size KB|MB
    Specifies the size of the adjunct trace table in kilobytes (KB) or megabytes (MB).
    Limit:
    0 - 9999
    Default:
    0
    Any non-zero adjunct table size that is established by a SYSIDMS parameter overrides the adjunct trace table size that is specified in the system definition.
  • ARCHIVE_JOURNAL_WARNING_PERCENT=
    percent-number
    Specifies the threshold percent that ARCHIVE JOURNAL uses to issue a warning message that a journal file is nearly full. If the amount of available space after condensing a journal is less than percent-number, ARCHIVE JOURNAL issues a warning message indicating that the journal is nearly full of condensed segments.
    Default:
    10 percent
  • AREA_VALIDATION_MSGS=ON|OFF
    ON causes the informational messages DB347042 and DB347043 to be displayed on the JES log during startup and shutdownentt for each area being shared in a SYSPLEX data sharing environment. Sharing many areas can cause congestion on the JES log.
    Default:
    OFF
    This parameter is only applicable in a SYSPLEX data sharing environment.
  • BCF_INPUT_80=ON|OFF
    IDMSBCF input is done over 80 characters by a #LINEIN INAREA=CARD,MAXIN=80,... statement. However, afterwards, all information starting from column 73 until column 80 is cleared and overwritten by spaces. That is, the actual maximum input size is only 72 characters.
    Executing any SQL PUNCH command may produce a SYSPCH output exceeding column 72. Using this output as input for an IDMSBCF job afterwards may result in possible syntax errors, because the input is truncated after column 72.
    By specifying SYSIDMS parameter BCF_INPUT_80=ON, information between columns 73 and 80 is not cleared, and input for BCF will be over 80 characters. In all other cases it defaults to 72 characters, for example, no BCF_INPUT_80 parameter or not specifying BCF_INPUT_80=OFF. .
    Default:
    OFF
  • BUFFER_PURGE
    Causes updated pages to be written to the database whenever the number of buffers containing such pages exceeds one-quarter of the number of pages in the buffer pool. This parameter may improve the performance of local mode update jobs that do not frequently commit, because it makes buffers available for pre-fetch. This parameter is meant for only local mode batch jobs.
  • BUFFERSTAT
    Produces a report containing buffer pool I/O statistics that can be used for tuning purposes. The report is written to SYSLST at the end of the job. It is meant only for local mode batch jobs
    For a description of the fields in the report, see "BUFFERSTAT Report Field Descriptions."
  • CICS_NAME=
    cics-name
    Specifies a 1 to 4 character value that identifies the CICS system name.
  • CVMACH=
    cms-machine-name
    (z/VM only) Specifies the virtual machine in which the DC/UCF system is executing.
  • CVNUM=
    nnn
    (z/VM only) Specifies the number of the central version that is accessible by CMS and is used to route database requests through the IDMSVMCF facility.
    Limits:
    0-255
  • CVRETRY=ON|OFF
    ON indicates that the following message is displayed on the operator console when the CA IDMS central version is not active:
    CV nnn NOT ACTIVE. REPLY RETRY OR CANCEL.
    Default:
    ON
  • CVRETRY_MSG_CODES=descriptor-route-codes
    Specifies the descriptor and route codes, in an eight-hexadecimal format, to be used for batch message DC208002 (CV cv-number NOT ACTIVE. REPLY RETRY OR CANCEL).
    The first four digits of descriptor-route-codes represent the descriptor codes and the last four digits represent the route codes. Each bit within the descriptor or route codes represents a code value. The first bit (x’8000’) represents code value 1 and the last bit (x’0001’) represents code value 16. Multiple bits can be on in each set of codes so that x’8101’ represents code values 1, 8 and 16.
    Default:
    00004000 (representing descriptor code zero (0) and route code two)
  • CV_STARTUP_XA_REGION_MB=
    nnn
    Specifies the size of the initial XA storage pool that is acquired during early CV startup.
    • nnn
      Specifies the size in MB (megabytes) of the initial XA storage pool.
    Default:
    32 MB
  • DATE_SIMULATOR_SVC=nnn
    Causes CA IDMS to issue an SVC to call the DATE SIMULATOR instead of issuing STCK and STCKE commands.
    The purpose of this parameter is to run DATE SIMULATOR without affecting CA IDMS modules.
  • DB_DEADLOCK_DUMP
    Specifies that a dump is produced for a task that abends due to a database resource deadlock. This parameter is used with the ABEND_ON_DEADLOCK parameter. If not specified, a dump is not produced when a task abends due to a database deadlock.
  • DBIO_HICCUP=nn
    By default, the Central Version (CV) generates a "hiccup wait" if a task accesses 100 pages without generating a wait. This parameter allows 1-99 pages to be accessed before a wait is generated. Specifying a value greater than 100 results in a page count of 100.
    Specifying a value less than 99 pages could result in increased run times for some tasks, because they may wait too often. We recommend experimenting with different values to choose the appropriate value for your site.
  • DBAN_SORT_PASSES=
    sort-passes
    Specifies the number of sorts that IDMSDBAN uses when auditing index orphan chains.
    Default:
    1
    The higher the number of sorts, the greater the number of errors that can be detected. However, increasing the number of sorts also increases the overhead for auditing orphan chains, which can be significant when processing large indexes. Because most errors are detected with a single sort, the default of one is usually sufficient. You should increase the number of sorts beyond 1 only when you must identify every error in an index.
  • DBNAME=
    database-name
    Specifies the name of the database to access at run time for non-SQL applications. DBNAME is either a segment name or a name defined in a database name table.
  • DC_DEADLOCK_NODUMP
    Specifies that a dump is not produced for a task that abends due to a DC resource deadlock. This parameter overrides the DUMP/NODUMP sysgen parameter.
  • DC_DEADLOCK_0029
    Specifies that tasks that encounter a DC resource deadlock abend with a code of 0029 rather than a code of DEAD.
  • DC_SCRATCH=ON|OFF
    • ON:
      Directs local jobs to use the central version scratch area (DDLDCSCR) when defined in the DMCL.
    • OFF:
      Directs local jobs to use the local scratch area (DDLOCSCR) when defined in the DMCL. When DDLOCSCR is not defined, DDLDCSCR is used when SCRATCH_IN_STORAGE=ON, ANY, or XA is also specified.
    Default:
    OFF
  • DCNAME=
    member-name
    (z/OS only) Specifies the member name of the system within a data sharing group. This name also becomes the system (node) name, overriding the value that is specified in the system definition. DCNAME must consist of characters A-Z, 0-9, $, #, or @.
    Limits:
    1-8 characters
    This parameter is only applicable in a data sharing environment.
  • DEADLOCK_ABEND_ERUS
    Specifies that ERUS tasks that encounter a database resource deadlock be abnormally terminated. This parameter is meaningful only if the ABEND_ON_DEADLOCK parameter is also specified.
  • DEADLOCK_ABEND_0029
    Specifies that tasks that abend due to database resource deadlocks use a code of 0029 rather xx29, where "xx" represents the major code of the DML request that was being issued at the time of the abend. This parameter has meaning only if the ABEND_ON_DEADLOCK parameter is also specified.
  • DEADLOCK_DETAILS=ON|OFF
    ON specifies that more detail be provided in a deadlock situation.
    Default:
    OFF
  • DICTNAME=
    dictionary-name
    Specifies a dictionary to use when loading a subschema from a load area. For dictionary-related tools, for example, CA IDMS compilers and pre-compilers, and IDMSBCF, DICTNAME specifies the dictionary to access at run time. For SQL applications, DICTNAME specifies the name of the dictionary to connect to at run time.
  • DICTNODE=
    dictionary-node-name
    For SQL applications and dictionary-related tools under the central version, specifies the name of the DC/UCF system that controls the dictionary to access at run time. For applications running in local mode, this parameter is not applicable.
  • DISABLE_SVC_SCREEN=SVC-number
    Specifies the number of an SVC for which screening is to be disabled.
    Limits:
    0 - 255
    Disabling screening of an SVC allows it to be issued by a program executing within the DC/UCF address space.
    The DISABLE_SVC_SCREEN parameter can be specified multiple times.
    Use this parameter with caution, because issuing unscreened SVCs within the DC/UCF system can degrade performance and result in abends. For more information about SVC screening, see "DML Reference for Assembler" in the CA IDMS Reference documentation.
  • DLBLMOD=ON|OFF
    (z/VSE only) ON specifies that the DLBL type in the disk label changes from 'DA' to 'SD' when sequential processing (IDMSQSAM) is activated. After the disk labels are processed as 'SD' during the QSAM file OPEN, the DLBLs are changed back to 'DA' to allow random BDAM processing.
    Default:
    OFF
  • DMCL=
    dmcl-name
    Specifies the name of the DMCL load module to use in local mode.
    Default:
    IDMSDMCL
  • DMLTRACE=ON|OFF
    ON activates a trace facility that traces all navigational DML requests made by an application.
    Default:
    OFF
  • DSGROUP=
    data-sharing-group-name
    (z/OS only) Specifies the name of the data sharing group, which this system is a member. All CA IDMS systems that are members of the same group must specify the same group name. DSGROUP must consist of characters A-Z, 0-9, $, #, or @. Names that begin with SYS or UNDESIG are reserved and cannot be used. Names that begin with A to I may be in use by the operating system and should be avoided.
    Limits:
    1-8 characters
    This parameter is only applicable in a data sharing environment.
  • DYNALLOC_WAIT=ON|OFF
    ON specifies that dynamic allocation does an ENQ wait for the DSN until it becomes available, when a data set is in use.
    OFF specifies that dynamic allocation request fails, when DYNALLOC_WAIT_SECONDS option is zero or not specified.
    This option applies to local mode jobs and to CV startup.
    Default:
    OFF
  • DYNALLOC_WAIT_SECONDS=nnn
    Specifies that when a data set is in use, dynamic allocation waits for a specified interval and retries the allocation. If the DSN is still unavailable, it repeats the process until the data set is available. If this option is specified with a non-zero value, it overrides the DYNALLOC_WAIT option. If zero is specified and the DYNALLOC_WAIT option is OFF or not specified; the dynamic allocation request fails.
    This option applies to local mode jobs and to CV startup.
    Limits:
    255
  • ECHO=ON|OFF
    Indicates whether SYSIDMS parameters are displayed on the JES log.
    Default:
    OFF
  • ENABLE_RRS=ON|OFF
    (z/OS only) ON activates RRS support for batch applications.
    Default:
    OFF
  • ENTC_LINE_LENGTH=
    nnn
    Specifies the length of the input field of the ENTER NEXT TASK CODE prompt.
    Limits:
    1-999
    Default:
    240 (Without the implementation of PASSPHRASE SUPPORT added with SO04635, it is 80.)
  • ERUS_FETCH_PROTECT_OFF
    Indicates that the system allocates External Run Unit Storage (ERE, ESE) in a sub-pool that is not fetch protected.
    Default:
    The system allocates storage in a sub-pool that is fetch protected.
    For more information, see SYSTEM Statement Usage.
  • EVAL_BASE_YEAR=base-year
    Specifies the base year to be assumed by the DATEDIFF and DATEOFF built-in functions. The base year is used to determine whether a two-digit year is considered to be in the 20th or 21st centuries. A year whose value is greater than the base year is considered to be in the 20th century. Values less than or equal to the base year are considered to be in the 21st century.
    Limits:
    1 - 99
    Default:
    68
  • EVAL_CENTURY_VALIDATION=ON|OFF
    Specifies whether century values are to be validated by built-in functions that accept four-digit years such as GOODDATEX.
    • ON
      Validate century values.
    • OFF
      Does not validate century values.
    Default:
    OFF
  • EVAL_LOW_CENTURY=low-century
    Specifies the lowest century value to be considered valid. The value that is specified is used during century validation in built-in functions that accept four-digit years such as GOODDATEX. Centuries are validated only if the EVAL CENTURY VALIDATION is ON.
    Limits:
    1 - 99
    Default:
    19
  • EVAL_HIGH_CENTURY=high-century
    Specifies the highest century value to be considered valid. The value that is specified is used during century validation in built-in functions that accept 4-digit years such as GOODDATEX. Centuries are validated only if EVAL CENTURY VALIDATION is ON.
    Limits:
    1 - 99
    Default:
    20
  • EXCLUDE_TCP/IP_STACK=stack=name
    (z/OS and z/VM only) Creates an EXCLUDE list of up to eight TCP/IP stack names to override the list of stacks that are supplied by the operating system (z/OS) or through SYSGEN (and z/VM).
    All the stack-names that are specified on these SYSIDMS parameters are excluded from the run-time list of stacks. INCLUDE_TCP/IP_STACK and EXCLUDE_TCP/IP_STACK are mutually exclusive parameters and support wildcards.
  • EXIT14_BATCH_RU
    Restricts calling EXIT14 to batch run-units.
  • FILE_BUF=
    ddname
    =
    nnnnn
    Allows users to increase the number of pages in a buffer that is used by a specific file for a local mode job without having to change the DMCL. In CV, a DCMT command can be used to alter the number of pages in a buffer. The FILE_BUF parameter provides a similar capability for local mode jobs. If specified, the number of pages in the buffer pool that is associated with the specified file is increased by
    nnnnn
    .
    This parameter can be used to tune PREFETCH processing by allowing the local mode user to increase the number of pages in a specific buffer for a job and thereby maximize the benefit of prefetch processing.
  • IDMSIN01_ONLY
    (CICS only) Used in conjunction with the SYSIDMS parameters DMLTRACE or SQLTRACE.
    • DMLTRACE=ON or SQLTRACE=ON with IDMSIN01_ONLY causes DML or SQL tracing to be limited to programs that call IDMSIN01 specifying TRACE.
    • The IDMSIN01 calls can be made at any time, and an active run unit is not required.
    • End tracing by calling IDMSIN01 specifying NOTRACE, or when the transaction terminates.
  • IDMSQSAM=ON|OFF
    ON activates the IDMSQSAM facility (sequential access for look-ahead database reads).
    Default:
    OFF
  • IGNORE_SYSTRK_DMCL=ON|OFF
    Specifies whether to disable building the runtime DMCL from the SYSTRK file and instead force the use of the DMCL load module.
    • ON
      Specifies to disable use of SYSTRK for building the runtime DMCL.
    • OFF
      Specifies to build the runtime DMCL from SYSTRK if the CV was not previously shut down normally.
    Default:
    OFF
  • INCLUDE_TCP/IP_STACK=stack-name
    (z/OS and z/VM only) Creates an INCLUDE list of up to eight TCP/IP stack names to override the list of stacks that are supplied by the operating system (z/OS) or through SYSGEN (z/OS and z/VM). For z/VM only, it can be used to include a new stack.
    All the stack-names that are not specified on these SYSIDMS parameters are excluded from the runtime list of stacks. INCLUDE_TCP/IP STACK and EXCLUDE_TCP/IP_STACK are mutually exclusive parameters and support wildcards.
  • JOURNAL=ON|OFF
    Specifies whether journaling is performed in local mode. OFF specifies that local mode journaling is not performed, even if journals are defined in the DMCL.
    Default:
    ON
  • JRNLDTS=
    yyyy-mm-dd-hh.mm.ss.nnnnnn
    Provides a way to bypass a date timestamp mismatch problem between the DMCL and the journal files. The yyy-mm-dd-hh.mm.ss.nnnnnn is the date timestamp on the journal file. This should only be used if you know that the reason for the mismatch will not cause a problem. Inappropriate use of this parameter may cause database corruption.
  • LANG=
    xxxxxxxxxxxxxxxxxxx
    Sets an alternate environment for DBCS support. This parameter is useful for local mode batch jobs and is equivalent to issuing the DCUF SET LANG command for online users.
    Limits:
    19 characters
  • LENGTH_PAGE=
    nnn
    Specifies the allowable number of lines on a page.
    Limits:
    10 to 32,767 lines
    Default:
    60
  • LIMIT_PREFETCH=
    nnn
    When a batch job is performing an area sweep, prefetch takes three-quarters of the number of buffers and divides the value by the number of records per track to determine the maximum number of start I/Os it can issue. If the number is greater than 100, a value of 100 is used. At the start of a job, this can swamp the system with I/O requests.
    By coding LIMIT_PREFETCH=nnn prefetch will only issue nnn I/Os at any time. If this number is greater than the value calculated by CA IDMS, the lower value is used.
  • LOADAREA=ON|OFF
    Specifies whether the dictionary load (DDLDCLOD) area is accessed when loading a module. If OFF is specified, the dictionary load area is not accessed. Specify OFF only when all load modules are linked into an OPSYS load library.
    Default:
    ON
  • LOCAL=ON|OFF
    Specifies whether a batch job executes in local mode. If ON is specified, all requests are processed locally even if an IDMSOPTI is link-edited with the program, or a SYSCTL file is specified in the JCL.
    Default:
    OFF
  • LOCAL_DYNAMIC_ALLOCATION= ON|OFF
    OFF directs a local CA IDMS batch job to ignore any DSN information that is defined in the DMCL for database files, and requires that the DSN information be included in the JCL to access a database file.
    Default:
    ON
  • LOCAL_NOJOURNAL_RETRIEVAL
    Specifies that local batch jobs not journal RETRIEVAL ONLY transactions.
  • LOCALPUR=ON|OFF
    ON forces purging of the local mode buffer pool whenever a transaction terminates.
    This parameter addresses a change in the way local mode buffers are handled, between 10.21 and later releases, as follows:
    • In release 10.21, a local mode job with multiple transactions (run units) separates buffer pools for each transaction, and each transaction has no knowledge of the others. When a transaction terminates its buffer pool purges.
    • Starting in release 12.0, a local job with multiple transactions has only one buffer pool that is shared by all transactions. When a transaction terminates the buffer remains unchanged until the last transaction terminates, and the shared buffer pool is purged. To make the system purge the common buffer pool when each transaction terminates (mimicking what happens in release 10.21), use the parm LOCALPUR=ON.
      Default:
      OFF
      Use this parameter only if there is a compatibility problem, because there can be performance implications by specifying LOCALPUR=ON.
  • MSGDICT=ON|OFF
    Specifies whether the dictionary message (SYSMSG) area is accessed to retrieve the text of messages. If OFF is specified, the dictionary message area is not accessed. OFF should be specified only when using a DMCL that does not contain the SYSMSG segment, such as during installation.
    Default:
    ON
  • MULTIDSN=ON|OFF
    (z/VSE only) ON specifies that tape files may span multiple volumes. At the end of a tape reel, EOF (end of file) or EOV (end of volume) prompts the user to specify an END OF JOB or an END OF VOLUME condition. OFF specifies that END OF JOB is automatically the condition at the end of a tape reel.
    Default:
    OFF
  • NODENAME=
    nodename
    For non-SQL applications running under the central version, identifies the DC/UCF system to bind to at run time.
  • PARM=
    'parameter-string'
    Allows you to specify parameters typically specified in a JCL EXEC PARM statement. The format is the same as the IBM PARM parameter on the EXEC JCL statement. PARM can contain 1 to 256 characters, and can be specified on multiple lines.
  • PDAT_LOCATION=ANY|BELOW
    Specifies whether the UCF line driver allocates PDAT storage above or below the 16-MB line. The default, ANY, allocates PDAT storage above the line. BELOW allocates PDAT storage below the line. BELOW must be specified if a back-end PDAT application runs with AMODE 24.
    Default:
    ANY
  • PREFETCH=ON|OFF
    OFF overrides the default ON and prevents CA IDMS from prefetching database pages, the normal processing when an area or index sweep is detected. Specify OFF, as follows:
    • For a local batch job to prevent prefetching database pages for the job step.
    • In the SYSIDMS file that is associated with a central version to prevent prefetching pages for all transactions running with the central version.
    Default:
    ON
  • PREFETCH_BUF=
    nnnnn
    Specifies the minimum number of pages in a buffer pool that must be present before CA IDMS uses prefetch processing for non-area sweep requests. This parameter applies to both local and central version environments.
  • PRMPT_MSG='
    prompt_message
    '
    Customizes the WTOR (Write-To-Operator-With-Reply) message. Customizing this message lets you distinguish the different CVs that are running.
    Enclose
    prompt_message
    in single (') or double (") quotes. You can write the message in free-form, but, do not enter internal quotes.
    Limits:
    The message can be 1 to 58 characters (without quotes).
    Default:
    If the parameter is not specified, the following message is displayed
    ,
    where
    nnn
    is the system number that is present, regardless if the default or a customized message is displayed.
    REPLY WITH REQUEST TO IDMS V
    nnn
  • PROCTRACE=ON|OFF
    ON activates a trace of key user blocks that participate in an SQL PROCEDURE call.
    Default:
    OFF
  • QSAMAREA=
    qsam-area-name
    Specifies the physical area in the DMCL for which the IDMSQSAM facility does look-ahead reads. If this parameter is omitted and the IDMSQSAM=ON parameter is specified, the look-ahead reads are performed on the first area that is accessed by the transaction.
    This parameter may also be used against journal files when executing the ARCHIVE JOURNAL utility, by specifying QSAMAREA=ARCHIVE.JOURNAL in the utility's SYSIDMS file.
  • QSAMBUF#=
    nnn
    (z/OS only) Specifies the number of buffers to use when the IDMSQSAM facility is active. QSAMBUF# enables you to set the number of QSAM buffers used without coding JCL for the file being processed by IDMSQSAM.
    If QSAMBUF# is not specified, the number of buffers is determined by the DCB parameter BUFNO=nnn, or defaults to 5 buffers.
    Limits:
    1-255
    Default:
    5 buffers
  • QSAMTRACE=ON|OFF
    ON activates a trace of all the IDMSQSAM look-ahead I/O reads. This trace shows the name of one or more files accessed by IDMSQSAM, each RBN that is read using QSAM or BDAM (DAM/EXCP), and a summary of the number of RBN's read through QSAM and BDAM. It also shows the area being accessed and the number of OPSYS QSAM buffers used as determined by the JCL.
    Default:
    OFF
  • REREAD_SYSCTL=ON|OFF
    ON directs local mode operations to reread the SYSCTL file for each new transaction. This lets you:
    1. Include a SYSCTL in a batch job step's JCL.
    2. Start a transaction that executes under central version, based on the contents of the SYSCTL file.
    3. Deallocate the SYSCTL file that is defined in the JCL.
    4. Start another transaction to execute in local mode.
    Default:
    OFF
  • RETRIEVAL_CV
    Specifies that IDMS converts READY UPDATE requests to READY RETRIEVAL when accessing an area set to RETRIEVAL mode on the CV.
  • ROLLBACK3490
    Enables the ROLLBACK utility to process archive files residing on devices that do not support backward read, such as disk and 3490E devices.
  • SAVE_SQL_SYNTAX=ON|OFF
    If ON is specified during CV startup, all dynamic SQL syntax is saved before it gets optimized. The SQL server module IDMSQSRV allocates a piece of long-term storage each time an sLTE (that is a secondary LTE representing the SQL session) is acquired. That storage is anchored off the sLTE and is used to save the dynamic SQL syntax before it is processed by the syntax parser and optimized.
    The storage is obtained only once per session and is re-used if there is more SQL syntax to save for the same session. The storage is released during the end of session processing just prior to freeing the sLTE.
    You can obtain the saved SQL syntax by Exit 39 - SQL Syntax Collecting Exit.
    Default:
    OFF
  • SCRATCH_IN_STORAGE=ON|OFF|ANY|XA|64-bit
    Enables storage allocation from the operating system for scratch processing.
    • ON
      Specifies the same as SCRATCH_IN_STORAGE=ANY.
    • OFF
      Specifies to allocate the scratch area as defined in the DMCL.
    • ANY
      Acquires 64-bit storage if possible. If the request to allocate 64-bit storage fails, XA storage is acquired.
    • XA
      Acquires 31-bit storage.
    • 64-bit
      Acquires 64-bit storage. If the request to allocate 64-bit storage fails, no attempt to acquire XA storage is done.
    Default:
    OFF
    Usage of 64-bit storage is controlled by the MEMLIMIT parameter of the JOB or EXEC JCL statement on z/OS, and by the MEMLIMIT option on the SYSDEF MEMOBJ command on z/VSE.
  • SCRATCH_LIMIT=
    limit-with-unit
    Specifies the maximum amount of scratch storage. The system continues to allocate more storage for scratch processing until the sum of all allocations reaches the value that is specified by
    limit-with-unit
    . Enter a number in the range 1 through 32767 followed by a unit of KB (Kilobyte: 2**10), MB (Megabyte: 2**20), GB (Gigabyte: 2**30), TB (Terabyte: 2**40), or PB (Petabyte: 2**50).
    The default value is determined as follows:
    • If the DMCL contains a scratch area definition, the default is the number of pages in the area multiplied by the page size.
    • If no scratch area is defined in the DMCL, the default is the size of the primary allocation plus 99 times the size of the secondary allocation.
  • SCRATCH_PRIMARY_EXTENT=
    prim-size-with-unit
    Specifies the primary scratch allocation size. Enter a number in the range 1 through 32767 followed by a unit of KB (Kilobyte: 2**10), MB (Megabyte: 2**20), GB (Gigabyte: 2**30), TB (Terabyte: 2**40), or PB (Petabyte: 2**50).
    The default value is determined as follows:
    • If the DMCL contains a scratch area definition, the default value is the number of pages in the area multiplied by the page size.
    • If no scratch area is defined in the DMCL, the system default value is 1 MB.
  • SCRATCH_SECONDARY_EXTENT=
    sec-size-with-unit
    Specifies the amount of storage to allocate when all existing storage is in use. Enter a number in the range 1 through 32767 followed by a unit of KB (Kilobyte: 2**10), MB (Megabyte: 2**20), GB (Gigabyte: 2**30), TB (Terabyte: 2**40), or PB (Petabyte: 2**50).
    The default size of the secondary allocation is equal to the size of the primary allocation.
  • SHUTDOWN_STALL_TIME=
    nnn
    Causes the stall interval for active user tasks to be set to
    nnn
    seconds after a SHUTDOWN command is issued. If the parameter is not coded or an interval of 0 (zero) is specified, then there is no effect on SHUTDOWN processing. This parameter allows normal SHUTDOWN processing even if a user task is in a long wait for an unavailable resource. The specified interval is used to force user tasks to be aborted if a given wait exceeds the interval even if the task normally has a longer STALL interval. This parameter affects online application tasks and ERUS tasks in either an INTERNAL or EXTERNAL wait. It has no effect on system tasks such as service drivers, line drivers, factotums, and helots.
  • SMON_THRESHOLD=
    nn
    Sets the default reporting threshold for the Storage Pool Interval Monitor online task.
    Valid values: 0-99
  • SMON_INTERVAL=
    nnn
    Sets the default reporting interval for the Storage Pool Interval Monitor online task.
    Valid values: 0-999
  • SORT FIELD MAX LEN=
    n
    Specifies the maximum sort key field length that is allowed by a sort.
    Default (z/OS):
    2000
    Default (z/VSE):
    256
  • SORTSIZE=ON|OFF
    Directs whether CA IDMS utilities generate the SIZE= sort parameter card. Some sort packages cannot handle the SIZE= parameter.
    Default:
    OFF. The SIZE= sort parameter is not generated.
  • SQL_CACHE_ENTRIES=
    n
    Specifies the maximum number of entries that used in the dynamic SQL cache. One entry holds one cached SQL statement. Specify zero (0) to disable caching. The maximum theoretical value is 2,147,483,647. The actual maximum depends on available memory.
    Default:
    200
  • SQL_INTLSORT=ON|OFF
    Allows you to force the internal CA IDMS sort to be used in local mode. If ON is specified, an internal SORT rather than an operating system SORT is performed on SQL commands issued in a local batch job that contain an ORDER BY clause. Often, an internal SORT is faster than an operating system SORT when you are not dealing with a large amount of data. OFF is the default, indicating an operating system SORT is used.
    Default:
    OFF
  • SQLTRACE=ON|OFF
    ON activates a trace facility of all the SQL database requests made by an application.
    Default:
    OFF
  • SUPPRESS_RECORD_ON_STATUS=<minor code>
    Identifies the custom error status minor code that an AFTER GET DB procedure sets when suppressing a record occurrence. This activates Record Suppression Assistance. You can duplicate this line up to three times to support multiple codes. All alphanumeric minor codes, plus, the numeric code 99. Numeric codes 00-98 are reserved for IDMS use.
  • SYS_MSG=UPLOW|UPPER
    UPPER directs CA IDMS to translate the text of internal #WTL messages to uppercase before being displayed at the output destination. The default is UPLOW. This allows the text of an internal #WTL message that is issued by CA software to be displayed in mixed-case letters.
    Specify UPPER in the following conditions:
    • In local batch jobs to translate any internal #WTL messages issued by CA software to uppercase for that job step.
    • In the SYSIDMS file that is associated with a central version to translate any internal #WTL messages issued by CA software to uppercase for that CV region.
  • SYSCTL=
    ddname
    Specifies an alternate ddname for the SYSCTL file (other than the default ddname of SYSCTL).
  • SYSTRACE=ON|OFF
    Controls whether basic system tracing is enabled.
    • ON
      Enables basic system tracing.
      If basic system tracing is enabled by the SYSIDMS SYSTRACE parameter, it remains enabled for a system even if its system definition indicates that SYSTRACE is OFF.
    • OFF
      Does not enable basic system tracing.
  • SYSTRK_DDNAME_PREFIX=
    xxxxxxx
    Specifies the DDname prefix to be used for referencing SYSTRK files in execution JCL.
    • xxxxxxx
      Specifies the 1- to 7-character DDname prefix.
    Default:
    SYSTRK
  • TCP/IP_STACK_
    <1 to 8>
    =tcp/ip-stack-name
    In CA IDMS Release 16, the default TCP/IP stack name was extracted from the SYSTCPD file, and the following SYSIDMS parameters can be used to include eight more stacks to the CA IDMS TCP/IP environment. In Release 17, these parameters are supported for compatibility reasons, but, the method to define the TCP/IP stacks using the INCLUDE STACK clause in SYSGEN, or the two new SYSIDMS parameters INCLUDE_TCP/IP_STACK and EXCLUDE_TCP/IP_STACK take precedence on Release 16 definitions:
    • TCP/IP_STACK_1=tcp/ip-stack-name
    • TCP/IP_STACK_2=tcp/ip-stack-name
    • TCP/IP_STACK_3=tcp/ip-stack-name
    • TCP/IP_STACK_4=tcp/ip-stack-name
    • TCP/IP_STACK_5=tcp/ip-stack-name
    • TCP/IP_STACK_6=tcp/ip-stack-name
    • TCP/IP_STACK_7=tcp/ip-stack-name
    • TCP/IP_STACK_8=tcp/ip-stack-name
  • TCP/IP_STATUS=ON|OFF
    Specifies the default status of TCP/IP support at startup. It overwrites the DEFAULT STATUS value that is defined to SYSGEN. OFF disables TCP/IP support for CA IDMS at startup. ON enables TCP/IP support.
  • TRACE_TABLE_SIZE=table-size KB | MB
    Specifies the size of the system trace table in kilobytes (KB) or megabytes (MB).
    Limit:
    0 - 9999
    Default:
    0
    If basic system tracing is enabled by the SYSIDMS SYSTRACE parameter and the table size is 0, the table size is changed to 4 MB. Any non-zero table size that is established by a SYSIDMS parameter overrides the trace table size specified in the system definition.
  • TRANSACTION_SHARING=ON|OFF
    ON activates the Transaction Sharing feature for all database activity that is used in a batch application.
    Default:
    OFF
  • UPPER=INPUT|OUPUT|BOTH|OFF
    Specifies whether input and/or output files are converted to uppercase:
    • INPUT
      Converts SYSIPT input files to uppercase.
    • OUTPUT
      Converts SYSLST output files to uppercase.
    • BOTH
      Converts both SYSIPT input files and SYSLST output files to uppercase.
    • OFF
      Does not convert SYSIPT input files or SYSLST output files to uppercase.
    Default:
    OFF
  • USERCAT=ON|OFF
    Specifies whether the user catalog is to be accessed. Specify OFF only when formatting the user catalog or when the DMCL does not have access to a user catalog.
    Default:
    ON
  • WIDTH_PAGE=
    nnn
    Specifies a maximum number of characters to be printed on a SYSLST output line.
    Limits:
    71-132
    Default:
    132
  • WORK=n
    CA IDMS utilities that generate SORT input cards for use within a VSE environment typically hard code the number of SORTWK files to be allocated. This value can be insufficient for the amount of data to be sorted. This parameter allows sites to specify the number of SORTWK files to be allocated by their SORT.
    Limits:
    1-9
    Any other values are ignored and the default value of the utility is used instead.
  • XA_SCRATCH=ON|OFF
    Specifies whether scratch space is allocated out of XA storage.
    Default:
    OFF
    Indicates that a scratch file is used.
    XA_SCRATCH=ON/OFF is maintained only for compatibility reasons. Instead, use SCRATCH_IN_STORAGE instead.