The following sections describe the new and enhanced features that are introduced in this release.
Tip:Use this link to view the PTF numbers for each new feature in this article. The PTFs are updated programmatically so you always have access to the current New Feature PTFs.
The following sections describe the new and enhanced features introduced in this release:
Enhanced SCRT Reporting through PTF (LU02768)
This enhancement improves reporting by making the Level Set currency visible in SCRT reports. With the update, SCRT reports include the release, version, and modification level. For more information, see #CSADS.
SQL Binary Enhancement (LU02793)
CA IDMS adds a USAGE type of SQLBINARY on an element that is stored in the dictionary (IDD). The element can be added to a record through the IDD compiler or the SCHEMA compiler. The precompilers expand this element with picture X with the appropriate length (equivalent to the size specified on the USAGE clause) when copied into a program using COPY IDMS (COBOL) or INCLUDE IDMS (PL/I).
SQLBINARY USAGE type is not supported in the IDD menu facility on the Element Entity and Record Element screens.
For information, see the following updated topics:
Level Set 19.0.02 PTF (LU02574)
The Level Set PTF includes a requisite list of all published PTFs in the release stream. The PTF supersedes previous Level Set PTFs, ensuring that your product is current with maintenance. The Level Set PTF makes it easy to determine what features are installed at your site and to apply all maintenance and new feature PTFs up to a specific modification level.
This Level Set PTF includes the following features (see descriptions in the sections that follow):
- VSCode COBOL Language Support Extension
- Enhancement Includes Deadlock Statistics in the PMIM SMF Statistics Record (PTF LU01684)
- Enhancement to REST API (LU01108) Expands Services
- Install Products Using z/OSMF
- CA IDMS Introduces CA IDMS Plug-in for Zowe CLI 1.0
- Configure CA IDMS Using z/OSMF Workflows (SO15041)
- CA IDMS REST API
- CA IDMS Server Release 17.1
- Map Field Masking Support (SO12206)
- New SQL Data Exception Messages (SO13172)
- New Batch Program (IDMSCVUP) Determines Whether a CV is UP (SO12008)
- REORG Block Size Limitation Removed (SO11556)
- Dynamic Storage Pool Expansion (SO12292)
- CA IDMS for z/OS 19.0 S1912
- CICS Dynamic Tracing for DML and SQL (SO08599)
- Optimized Memory Caching (SO08855)
VSCode COBOL Language Support Extension Provides a Modern IDMS Development Experience
Application developers now have flexibility to build and maintain IDMS COBOL applications outside the mainframe in popular IDEs through the COBOL Language Support Extension, which is available for both Visual Studio Code (VSCode) and Eclipse Che.
The extension supports CA IDMS Cobol DML to make it easier to develop IDMS COBOL applications in a preferred development environment through features such as:
- Syntax highlighting and coloring
- Syntax and semantic analysis
- IDMS copybook support
For more information about installing and using the extension, see Build and Maintain IDMS COBOL Applications with VSCode.
Enhancement Includes Deadlock Statistics in the PMIM SMF Statistics Record (PTF LU01684)
This enhancement adds the following deadlock statistics to the PMIM SMF statistics record (default: 230): number of deadlocks and the number of deadlock victims.
This change enables other products or services to incorporate deadlock information into database monitoring solutions.
See #PMRUSDS for details.
Enhancement to REST API (LU01108) Expands Services
Through its REST API, CA IDMS provides a robust set of services to support interactions with the mainframe. The REST API enables you to use modern tooling and interfaces to perform administrative and development functions.
The existing set of services that are supported by the REST API has expanded. Version 1.0.1 provides new services to help you simplify database monitoring and administration. The latest version of the REST API supports the following:
- IDD, OCF, Schema, Subschema, and Sysgen compilers
- SQL statement execution and metadata functions
- System Statistics metrics
- Data Source reporting
To find out more, see the following topics:
Also, view the overview video on YouTube: CA IDMS REST API Version 1.0.1
Storage Pool Utilization Enhancements
Two PTFs provide enhancements designed to help you prevent short-on-storage (SOS) conditions.
This PTF provides new capabilities for monitoring and managing storage more efficiently to give you greater control over and visibility into storage use.
- Storage Pool Interval MonitorThis online task analyzes storage use and reports on contiguous free storage within storage pools. When a specified percentage of pool utilization is reached, the task sends a message to the CV LOG and JOBLOG with the size of the largest contiguous free area in the storage pool. The monitor can be activated automatically when a specified threshold is reached.
- Free Storage (Fragmentation) ReportA new DCMT command, DISPLAY FREE STORAGE, analyzes storage use in the storage pools and categorizes the free storage by size. The report showing distribution of areas with free storage gives you better visibility into storage utilization.
This feature allows a CUSHION IS clause on the SYSTEM XA STORAGE statement, which removes the need to manually create a cushion for the System XA storage pool. Before this feature, DCMT commands were required if you wanted a cushion on Subpool 255. The System XA Storage Cushion IS clause helps simplify maintenance and allows active tasks to finish without reaching a short on storage condition.
For more information about these enhancements, see the following topics:
Install Products Using z/OSMF
As a systems programmer, your responsibilities include acquiring, installing, maintaining, and configuring mainframe products on your systems. IBM® z/OS Management Facility (z/OSMF) lets you perform these tasks for Broadcom mainframe products and mainframe products from other vendors. z/OSMF lets you manage software on your z/OS systems through a browser at any time, from any location. By streamlining some traditional tasks and automating others, z/OSMF can simplify some areas of system management and reduce the level of expertise that is required for managing system activities. Experienced users can view, define, and update policies that affect system behavior, monitor system performance, and manage their z/OS software.
For more information, see the following topics:
CA IDMS Introduces CA IDMS Plug-in for Zowe CLI 1.0
Zowe CLI is a command-line interface that lets users interact with the mainframe in a familiar format. The CA IDMS Plug-in for Zowe CLI provides the ability to execute and automate CA IDMS commands and administrative tasks. You can manage CA IDMS by using common tools and modern integrated development environments (IDEs) and by writing scripts or programs that can be incorporated within automation for continuous integration/continuous development (CI/CD) workflows.
Configure CA IDMS Using z/OSMF Workflows (SO15041)
After you install CA IDMS on a mainframe system, you can use z/OSMF workflows to configure the product software instance. z/OSMF workflows help automate the deployment and configuration of a product instance. z/OSMF helps system programmers with minimum mainframe experience perform these tasks. Using z/OSMF workflows significantly reduces the time that is required to perform these tasks. The workflow configuration of a CA IDMS environment follows the same post installation process. z/OSMF provides the flexibility of a menu-driven GUI to input the required variables. The variables are populated into the job stream. Job streams can be modified before submission and can be executed again if the job fails.
CA IDMS provides three configuration workflows that perform the following tasks:
- Perform a full base configuration (AGJ190BX)
- Upgrade an existing configuration to a new release (AGJ190UX)
- Add on new product components to an existing configuration (AGJ190UX)
CA IDMS REST API
The CA IDMS REST API is now available. As part of the Broadcom CA Database modernization strategy, the API plays a role in transforming the mainframe for hybrid IT by making the mainframe a more integrated, agile platform.
With the API, you have modern, scalable access to z/OS services, tools, and data, allowing you to extend database applications and automate database application maintenance and administration. With the CA IDMS REST API, you can use modern development tools to maintain your CA IDMS applications and leverage your mainframe investment.
CA IDMS Server Release 17.1
The 17.1 release of CA IDMS Server is available. Download your copy online from the Download Management page on Broadcom Support. The download is available in both 32-bit and 64-bit versions.
Release 17.1, primarily a Technical Currency release, includes the following changes:
- Incorporates all published fixes for both the ODBC and JDBC drivers
- Employs the latest compilers:
- Java code is built with OpenJDK
- C code is built with Visual Studio 2019
- Built with the 1.1.1f version of OpenSSL
- Includes changes to the product installation image, that include:
- Compatibility with Windows 10
- Branding as a Broadcom, Inc. product
- Modifications to accommodate the future delivery of PTFs using the standard installer
- Removal of CAICCI/PC, which is outdated
- Includes a new sample program called IdmsCSV.java, which generates the result set of a query in comma-separated format
Map Field Masking Support (SO12206)
The IDMS mapping facility now supports use of a masking character. Alphabetic, alphanumeric, and numeric display fields can be masked. An 'M' can be substituted for an 'A', 'X' or '9' in edit pictures. Runtime display of fields display an asterisk where 'M' is used.
Mapping support for output edit fields enables sensitive data to be protected to meet security compliance regulations. A DBA can hide sensitive data, like social security numbers, within minutes and with minimal effort without writing complicated programs.
For more information about applying masking for output map displays, see Automatic Editing Criteria in the "Mapping Facility" section of the CA IDMS Reference documentation.
New SQL Data Exception Messages (SO13172)
SQL data exception messages DB001110 and DB001111 were added to provide more information about where a data exception occurred. Before this enhancement, message DB001025 displayed to inform users that an exception occurred but did not provide the information of where it occurred. DB001110 indicates which column and row the exception occurred. DB001111 indicates which table, offset within the table, and row that the exception occurred when the column name is not available.
The new messages help users debug queries by displaying more information about which field in the database is causing the data exception.
New Batch Program (IDMSCVUP) Determines Whether a CV is UP (SO12008)
IDMSCVUP is a batch program that determines whether a CV is up and sets a return code. You can use it in a job step to conditionally execute subsequent job steps based on system availability.
For more information about this program, see Use IDMSCVUP to Determine If an IDMS System is Active.
REORG Block Size Limitation Removed (SO11556)
The REORG utility is enhanced to remove a limitation on the number of output files that can be defined. This enhancement allows REORG to run on databases with a large number of indexes in unique page ranges. The number of output files for a REORG task is based on the task being performed, the DIVIDE PROCESSING NN WAYS value, and the number of index groups defined in the database being reorganized. An index group is one or more indexes that share a page range.
Before this enhancement, REORG could not be used to reorganize databases with a large number of indexes in unique page ranges unless the scope of what was being reorganized was reduced. The maximum number of output files for a single REORG task was limited by the block size of the control file.
The block size for the control file is no longer fixed at 8192. REORG uses the block size that the control file is created with. The default size is 8192 when not specified. The minimum size supported is 2048. For z/VSE, the block size is 8192.
For more information, see the following topics in the CA IDMS Reference documentation:
Dynamic Storage Pool Expansion (SO12292)
CA IDMS is now enhanced to dynamically expand storage allocations for designated storage pools, rather than initiate short on storage actions. XA storage pools can be expanded by 50% of the original size and expanded up to four times. Dynamic expansion is enabled by SYSGEN specifications. Message DC015008 is issued when an XA storage pool is expanded. The message indicates which pool was expanded and how much storage was added. A count of how many expansions have occurred also displays, for example, 1 of 4. Message DC015009 is issued if storage is not available.
Before the dynamic storage pool expansion enhancement, a message displayed for the following storage conditions which required a DBA to take action:
- A storage request was satisfied, but the total amount of free storage remaining in the pool is less than the storage cushion for that pool.
- A storage request was issued. The DC system determined that this pool was eligible to satisfy the request, but not enough contiguous storage was available in the pool to satisfy the request.
- The task was abended.
- The task was put in a wait state until enough storage is available.
- A return code was sent back to the requesting program.
- The request was fulfilled from another storage pool.
Additional information about this enhancement:
- Dynamic expansion does not occur if a requested storage amount exceeds 50% of the original storage pool size.
- Expansion can be enabled or disabled by updating the SYSGEN, generating, and issuing DCMT VARY SYSGEN REFRESH ALL.
- SOS conditions and behaviors will not occur until a storage pool has expanded four times by design.
- Turning dynamic expansion off and on does not reset the counter. Four expansions are the maximum for the life of the CV.
- Storage cushions can be utilized to minimize expansions and the resulting DC015008 message in the job log.
- If an expansion attempt fails, a DC015009 message is issued. The requesting task is subject to SOS behavior.
For more information, see the following topics:
CA IDMS for z/OS 19.0 S1912
This Service Update installs CA IDMS for z/OS 19.0 at the CA Recommended Service (CA RS) S1912. By installing this Service Update, you ensure that your systems are current on maintenance for CA IDMS for z/OS 19.0. Download your copy of CA IDMS for z/OS 19.0 S1912 online at Broadcom Support.
For information about installing the PAX file, see Installing Your Product Using CA CSM.
CICS Dynamic Tracing for DML and SQL (SO08599)
A new parameter, SYSIDMS, for use with DMLTRACE or SQLTRACE, isolates tracing to a single program in a CICS transaction, instead of all programs, which helps you diagnose and resolve problems faster and easier.
For more information, see the following topics:
Optimized Memory Caching (SO08855)
The new 64-bit memory caching option lets you limit the amount of 64-bit storage that is allocated for a given file to a percentage of total size of a file.
For more information, see the following topics:
The LOOK System Task and the IDMSLOOK load modules are enhanced:
- TheDMCL optionshows memory cache percentages for files.
- TheDMCL optionALL shows memory cache percentages for files and areas.
New Level-Set PTF (SO10358) Now Available
This PTF applies all maintenance up to the modification level 19.0.01. A Level Set PTF is used to provide you with an easy method to receive and/or apply all maintenance up to a specific modification level. This PTF PREREQs all published PTFs. To view the HOLDDATA for all maintenance included in the PTF, see IDMS Level Set PTF 19.0.01 HOLDDATA.
For more information about applying the PTF, see Continuous Delivery.
SYSGEN Enhancements to Avoid Surprises (SO09820)
As system currency is established in the SYSGEN compiler, the following message appears if ungenerated entity changes exist: DC601273.A new command, DISPLAY CHANGES, allows you to display all changed entities. The SYSGEN Generation Summary is enhanced to include all entities.
For more information, see the following topics:
SQL Resource Limits (SO08757)
Specifying the SQL Row Limit on the SET SESSION overrides both the SYSTEM and TASK settings and allows a lower limit to be used for a session. If an attempt is made to specify an SQL Row Limit that exceeds the limit for the system or task, an error message displays and the limit for the current session is not updated.
DCMT DISPLAY UTAB Command (SO08527)
New DCMT DISPLAY UTAB command displays the Utility Command Assignments (UTAB). CA IDMS also includes a new batch processor to produce source syntax from the IDMSUTAB load module. This enhancement allows the DBA to easily view existing definitions and also provides a means to recover IDMSUTAB source syntax from the load module.
After applying the PTF, use the RHDCSGEN utility or SYSGEN online to update the CV SYSGEN with the following definition:
ADD PROGRAM RHDCUTAD CONCURRENT NODYNAMIC DUMP THRESHOLD IS 0 ENABLED ERROR THRESHOLD IS 5 ISA SIZE IS 0 LANGUAGE IS ASSEMBLER MPMODE IS SYSTEM NOMAINLINE MULTIPLE ENCLAVE IS ON NEW COPY IS ENABLED OVERLAYABLE PROGRAM NOPROTECT REENTRANT NONRESIDENT REUSABLE SAVEAREA
Using Zowe CLI with CA IDMS (SO08699)
Administrating CA IDMS System Operations (SO08256 and SO08257)
3270 dynamic display size is now supported. When using an emulator with a dynamic, alternate display size, CA IDMS can use an 80-column default display size for VTAM, UCFTSO, and UCFCICS sessions. You do not need to set the alternate display size of the emulator to a supported 3270 model.UCFTSO and UCFCICS use the DFLTSIZ= parameter to indicate the default 3270 model display size.
Programming IDMS SQL (SO08292)
Caching is supported for the INSERT SQL statement only if it contains at least one dynamic parameter.
SQL Resource Limit Message DB001108 (SO08356)
Message DB001108 is enhanced to display in the CA IDMS log to determine when the SQL resource limit is reached.
CA IDMS Server PTF (SO08088)
This is a cumulative PTF that contains all corrections to date, for both the 32-bit and 64-bit versions of the CA IDMS ODBC and JDBC drivers.
DCMT DISPLAY CTAB Command
New DCMT DISPLAY CTAB command displays the DCMT Command Activity Assignments (CTAB). CA IDMS also includes a new batch processor to produce source syntax from the IDMSCTAB load module. This enhancement allows the DBA to easily view existing definitions and also provides a means to recover IDMSCTAB source syntax from the load module.
For more information see, DCMT DISPLAY CTAB and Recreate the DCMT Command Activity Assignments (CTAB).
After applying the PTF, use the RHDCSGEN utility or SYSGEN online to update the CV SYSGEN with the following definition:
ADD PROGRAM RHDCCTAD CONCURRENT NODYNAMIC DUMP THRESHOLD IS 0 ENABLED ERROR THRESHOLD IS 5 ISA SIZE IS 0 LANGUAGE IS ASSEMBLER MPMODE IS SYSTEM NOMAINLINE MULTIPLE ENCLAVE IS ON NEW COPY IS ENABLED OVERLAYABLE PROGRAM NOPROTECT REENTRANT NONRESIDENT REUSABLE SAVEAREA
DCMT DISPLAY SRTT Command (SO07995)
DCMT DISPLAY SRTTcommand that displays the Security Resource Type Table (SRTT). CA IDMS also includes a new batch processor to produce source syntax from the RHDCSRTT load module.
Storage Key Considerations for z/OS CSA Subpools (SO07073)
Setting the DIAGxx parmlib statement VSM ALLOWUSERKEYCSA to YES will not be supported after z/OS V2R3. Allocation and modification of common areas of virtual storage in user key (8-15), will no longer be possible. This change may impact systems with code accessing External Run Unit Storage (ERE/ESE) areas from a Common CSA/ECSA fetch protected sub-pool.
See the section, Using ALLOWUSERKEYCSA(NO) in Storage Key Considerations for z/OS CSA Subpools.
CA IDMS now includes new SYSGEN and SYSIDMS parameters that allow you to specify whether to allocate External Run Unit Storage (ERE/ESE) areas in a fetch or non-fetch protected sub-pool.
CA IDMS Visual DBA Version 18.1 Update
CA IDMS Visual DBA is updated to Version 18.1, which includes all maintenance fixes and support for Windows® 8 and 10.
Updated Messages (SO07852)
Added index name that is displayed in a message when an 11xx abend occurs that is related to an index to diagnose and solve issues.
CA IDMS MQ Adapter (SO07191, SO07979, and SO09453)
CA IDMS provides an MQ Adapter to support message queueing and trigger monitoring. The MQ Adapter supplies an interface for CA IDMS applications to exchange messages when connected to an IBM MQ queue manager.
Key Benefits and Features
The MQ Adapter enables further integration of CA IDMS with modern applications, with reduced costs and high-quality support, and provides the following key features:
- Seamless CA IDMS integration
- Support for CA IDMS programming languages
- Support for Message Queue Interface (MQI) API
- MQ Trigger Monitor with polling for online queue managerInvokes an IDMS task to process incoming messages on local queues.
- MQ statisticsExtended IDMS system-wide statistics and statistics by queue.
- Extended DCMT commands for MQ
- Nodes for securing MQ-related DCMT commands
- MQ trace debugging
- MQ Error Codes
Added administration information to configure, manage, secure, and analyze the MQ environment using the MQ Adapter.
Added information for application developers to get started programming their online applications with the MQ Adapter:
Added reference information for the MQ Adapter:
The following DCMT DISPLAY commands were enhanced to include MQ:
- DCMT DISPLAY PTERM
- DCMT DISPLAY STATISTICS
- DCMT DISPLAY SUBTASK
The following DCMT VARY commands were enhanced for include MQ:
- DCMT VARY CSAFLAGS
- DCMT VARY LTERM
- DCMT VARY PTERM
DCMT HELP command is enhanced to include MQ. For more information, see DCMT HELP.
DCMT Command Codes
The following DCMT command codes are added for MQ:
- N028015 - MQ Trace
- N029011 - INITIATION QUEUE queue-name
- N035054 - MQ
- N041014 - DISPLAY STATISTICS MQ
- N041015 - DISPLAY STATISTICS MQ QUEUES
- N041016 - DISPLAY STATISTICS MQ QUEUE queue-name
- N100007 - Internal use only
- N100008 - VARY CSADBMSnON/OFF
- N114 - DISPLAY MQ
- N114001 - DISPLAY MQ
- N115 - VARY MQ
- N115001 - ENABLED/DISABLED
- N115002 - QUEUE MANAGER queue-manager-name
Added the following new messages for MQ support:
- DC131000 to 31030
- DC268014 to DC268016
CA IDMS Performance Monitor (SO06628, SO06629, SO12693, and SO12009)
CA IDMS includes CICS Unit of Work ID and Network-wide ID to Performance Monitor SMF230 job termination records. These fields are defined in the #PMTASDS, #PMS30DS, and #PMSVXDS DSECTs. This enhancement allows CA IDMS customers to correlate IDMS transactions for analysis and management reporting. After you install this PTF, use the IDMSDDDL utility to update PMARPT00 in the dictionary containing PERFMON reports, which is typically the SYSDIRL dictionary. The updated PMARPT00 source is in the CAGJSRC library:
- TASDNETN, for UCF CICS Netname, is added to DC Task Data section
- TASCUOWI and TASCNETN, for CICS Unit of Work ID and Network Unit of Work ID respectively, added to CICS ERUS Task Data section
A new parameter, UOWID, has been added, which specifies whether the IDMS interface should acquire the CICS transaction unit of work ID for Performance Monitor SMF230 job termination records. For more information, see IDMSINTL and IDMSCINL CICS Interface Macros and Standard CICS Interface.
CA MICS Analyzer Option for CA IDMS is also updated as part of this CA IDMS enhancement. For more information about the CA MICS updates, see the CA MICS Resource Management documentation.
CA IDMS is enhanced to limit the resources that are used by an SQL statement. SQL Application Developers, DBAs, and Systems Programmers can stop long-running SQL requests before the systems are burdened.
SQL Resource Limits Enhancement (SO06940)
SQL Row Limit is a new Resource Management Parameter option that limits the number of rows that can be read or updated by a single SQL statement, including rows that are processed internally, for example, by a sort or an aggregate function. SQL Row Limit is more powerful than standard row count options because it can be used to limit additional database I/O activity, rather than only limit the number of rows that are returned to the user in a result set. SQL Row Limit differs from other CA IDMS limits as it is enforced at the statement level, by the SQL engine, and provides a recoverable error message instead of task abend. SQL Row Limit is an attribute of the SQL session. It can be set on the SYSTEM statement and overridden on the TASK statement in the SYSGEN and passed down to the session. Specifying the SQL Row Limit on the SET SESSION overrides both the SYSTEM and TASK settings.
SQL Row Limit Enhancement (SO07829)
CA IDMS supports running ADS on zIIP. Running ADS on zIIP allows CA IDMS ADS Dialogs to execute in SRB mode and run on the zIIP specialty engines. Running ADS on zIIP can result in increased throughput, while reducing overall costs by offloading processing from the GP to the specialty engines and reducing swaps.To view benchmark test results from running ADS with zIIP on and off, see Document on enhancement to allow ADS to be zIIP eligible (KB000124014).
ADS zIIp Enablement (SO06651)
CA IDMS provides a COBOL and PL/1 version of the demo Consumer service program, see Web Services Employee Demonstration.
Web Services Employee Demonstration (SO06075)
For added security for external security signon, CA IDMS is enhanced to support using a password phrase (passphrase) of 9 through 100 characters as a password.
CA IDMS Security (SO05694)
PTF SO05694 Replaces PTF SO04635.
When running the IDMSLOOK utility in batch or the LOOK transaction within a CV, the expanded information on the DMCL ALL report includes the SMI Interval and Default CALC Page Range clauses. PTF SO04062 includes an enhancement to the DMCL report. The report includes the SMI Interval and Default CALC Page Range clauses, when the values for these items do not agree with the standard definition of the area due to earlier EXPAND PAGE or EXTEND SPACE actions against the area.
Utility Programs (CA IDMS/DB Utilities) (SO04062)
The output of the SVC CV Table is enhanced to show when a CV has abended or shutdown abnormally and left residual CSA data.
DCPROFIL System Task (SO01912)
The content of the SMF type 30 record is enhanced to include the job identifier in the SMF30JNM field that is described by #PMS30DS.For more information, see #PMS30DS.A new Application Monitor report—PMARPT21, Batch Job Accounting summary report— is added to report on batch erus job statistics. The report includes statistics for job identifier, job name, accounting information, and task start/end date and times. For more information, select the report name in Report Samples (Application Monitor).
Performance Monitor Application Monitor (RO98392)
(RO99485) CA IDMS provides an XML file with DML Assembler Macros for integration with IDz/RDz or CA DEz. For more information, see Assembler Customization. (RO98318) CA IDMS provides several sample REXX execs and JCL procedures, which are in the CA IDMS SAMPLES distribution library. The samples facilitate the integration of CA Development Environment for z Systems with CA IDMS. For more information, see Integration with IDz/RDz or CA DEz.
Integration with IDz/RDz or CA DEz (RO99485 and RO98318)
The following samples are added to show you how to convert table procedures, generated by Quick Bridge using network DML, to instead use SQL:
SQL Quick Bridge (RO97698)
- AGJCOVEN - 2 level, network. Generated by QB
- AGJCOVEQ - 2 level, converted to SQL
- AGJHOSPN - 3 level, network. Generated by QB
- AGJHOSPQ - 3 level, converted to SQL
Convert a Generated Table Procedure to Use SQL
To be aware of storage consumption by database locks and prevent storage problems, message DC040107 is added to indicate when more storage is allocated.
System Generation (RO97690)
A new profile option, SQLIND, is added to specify the suffix to use to create the generated null indicator REC card for an SQL column. Set the SQLIND parameter in the profile to I to use the _I suffix, instead of using the default suffix
CA Culprit (RO96918)
You do not need to download and install LMP keys for the other CA IDMS product components. PTF R096807 makes the LMP keys available through the base CA IDMS product.
Portfolio Simplification (RO96807)
A new field SMF30IPA is added to the DSEC #PMS30 - APPLICATION MONITOR SMF TYPE 30 RECORDS. SMF30IPA is a maximum of 16 bytes and contains the IPV4 or IPV6 TCP/IP address (binary format) for tasks that execute transactions over an IDMS TCP/IP socket connection.
Performance Monitor Application Monitor (RO97013)
The following new statistics reports are added:
DC/UCF Statistics Reports (RO97013)
- SREPORT 004Provides task statistics information by IP Address (displayed in IPV4 or IPV6 dotted string format) for tasks that execute transactions over an IDMS TCP/IP socket connection.
- SREPORT 022Provides transaction statistics information by IP Address (displayed in IPV4 or IPV6 dotted string format) for user programs/tasks that request transaction statistics and execute over an IDMS TCP/IP socket connection. The user program initiates collection of transaction statistics with a BIND TRANSACTION STATISTICS statement and terminates collection with an END TRANSACTION STATISTICS statement.
The DCPROFIL system task is enhanced to display more information from the current SVC module that is used by CV, as follows:
DCPROFIL System Task (RO96512)
- SVC module headerSVC Release, SVC FMID, and SVC PTF number, if applied.
- SVC options block linked with the SVC module
- SVC Number: From #SVCOPT
- AUTHREQ=YES/NO: Specifies if SVC requires an authorized CV
- CVKEY: Identifies the primary protect key that a CV must be using when AUTHREQ=YES.
- SMF=YES/NO: Specifies whether the SVC supports SMF writes
- SVCXLEN: Length of ERE extension that is used by IDMSSVCX exit.
- SVC CV tableA list of CVs by number which are currently using the SVC.
The CA IDMS COBOL precompiler IDMSDMLC is enhanced to support inline (floating) comments using
COBOL Precompiler (RO96611)
* >,introduced in IBM Enterprise COBOL for z/OS v5.1. For more information, see the IBM Enterprise COBOL for z/OS documentation.
Culprit now supports Large Block Interface (LBI) for INPUT and OUTPUT files. LBI is an IBM feature that allows you to read and write blocks larger than 32760 bytes from and to devices that support LBI, such as tape, cartridge, or virtual tape. For more information, see OUTput Parameter and INPUT Parameter.
(RO92366) CA IDMS introduces zIIP suspension. When a database procedure, system mode SQL procedure, or system mode user exit is loaded from an unauthorized library, zIIP is suspended instead of permanently stopped. zIIP suspension allows you to restart zIIP processing while the CV remains running.(RO93622) You can now re-enable zIIP processing without restarting the CV, after it was suspended due to the loading an IDMS Nucleus Module from an unauthorized library.
zIIP Exploitation (RO92366 and RO93622)
IDMSUXIT replaces IDMSBALI and OLQSDMLE in the link edit of the OLQDMLX exit load module.
OLQDMLX User Exit (RO94965)
A new #STRDS DSECT type—STRTDCX—is added for task or transaction and system statistics.
DC/UCF Statistics Reports: SREPORTS (RO92672)
The range of the number of ERUs to allocate at system startup is changed from 0 to 255 to 0 to 1000. Calculating the number of TCEs is enhanced to prevent over-allocating memory below the 16-Mb line.
System Generation and UC/UCF System Generation Resource Management (RO93347)
(SO08620) The MSM upgrade process is changed to run several IDDXI5J0 jobs. Only new or changed modules are added to the system during the upgrade process. This PTF also includes fixes to various install issues, which are described in the HOLDDATA enhancement description. The behavior for dictionary entities in Jobs 7, 9, and 10, is changed. During installation from 18.5 to a later release using CAISAG, CA IDMS updates only the dictionary entities that are changed. The list of the changed entities is in CAGJSRC dataset, member IDDXI5J0. (RO93158) For a running list of the PTFs that include the changed dictionary entities, see Upgrade from Release 18.5 to Version 19.0 in the Upgrade Considerations.
Upgrade (SO08620 and RO93158)
The IDMSIN01 macro is updated to show UTC time in local time. For more information, see IDMSIN01.