Level Set PTF 20.0.02 (LU14127) for the Database Management Solutions for IMS for z/OS is now available. This Level Set PTF helps you identify your current level of maintenance and features that have been installed.
Features Applied with Level Set PTF 20.0.2
This list summarizes the features that are delivered by applying Level Set PTF 20.0.02 (LU14127).
IMS 15.4 and 15.5 Support: Version 20.0 of the Database Management Solutions for IMS for z/OS supports IBM IMS versions 15.4 and 15.5.
Advanced Segment Selection for DEDB Extract: The EXTRACT function of Database Organizer for IMS for z/OS (DBO) adds support for the new CASE control statement. You can now specify detailed conditions for retrieving data from a DEDB database. The CASE control statement defines conditions that must be met before the data is extracted.
The CASE control statement provides broader syntax for conditions for extracting database segments. Selecting only relevant data to extract saves system resources and improves performance of the application by decreasing the processing time.
Support for Sorting in EXTRACT Function: The EXTRACT function of Database Organizer for IMS for z/OS (DBO) adds support for the new option SORT. When SORT=YES is specified for a DEDB database, the data in the extract output file is sorted by the root key.
Use this option to reload the data to a non-DEDB database, such as (P)HDAM or (P)HIDAM, that requires data in root key sequence. This feature also helps you to merge data from a large extract file and another large data source. You can easily merge two sorted data streams to recognize the same data or to find missing items in both lists.
Support to Extract a Portion of Segment Data: The EXTRACT function of Database Organizer adds support for selecting a portion of the segment data. The data to be extracted is identified by starting position and length. These values are specified in the FIELD attribute of the SELECT control statement.
Selecting only relevant data to extract saves system resources and improves performance of the application by decreasing the processing time. This feature also makes it easy to create a fixed column report.
DEDB Randomizer Callable Interface: Database Management Solutions for IMS introduce the Fast Path Randomizer Interface Subroutine (ITKDRMIF). ITKDRMIF provides an API for invoking a DEDB randomizing routine using a high-level language, such as COBOL. ITKDRMIF returns the RAP RBA and area number values for a given root segment key.
This feature helps database administrators easily retrieve the position of relevant segments in the Fast Path DEDB database. Other database utilities can process the relevant database areas, rather than processing the entire DEDB database.
Multiple Output Files for DEDB Extract and Unload: The EXTRACT and UNLOAD functions of the Database Organizer (DBO) now support extracting or unloading data from DEDB areas into multiple output data sets. The AREA control statement is enhanced with a new "DD:" prefix that lets you specify the output data set for selected areas.
This feature allows you to write data from different areas to different output files. You can now split the data to suit your environment.
Select the Format of Extracted Output Records: The EXTRACT function of Database Organizer (DBO) now lets you specify the format of output records. A new control statement, EXTRACTFORMAT, allows you to write each selected segment to a separate output record. Segments are prepended with the prefix and a concatenated key, and the extract file contains header records with segment information.
This feature simplifies identifying specific segments, where they start in the file record, and what type of segments they are. You can use COBOL copybook mapping. You no longer have to analyze DBDs to identify parent-child relationships between segments.
Online Reorg of Non-HALDB Databases with Internal Logical Relationships: The Full Function Online Reorganization (FFOR) component of Database Organizer now supports the reorganization of non-HALDB databases with internal logical relationships. A new ITKOPTN option, HPOONLINELR, is available. To enable the new functionality, specify HPOONLINELR=Y.
This feature reduces the time and effort that are required for reorganizations that include non-HALDB databases with internal logical relationships. You no longer have to process these databases offline using One-Step Batch Reorg.
EXTRACT Function Support for Segment Offset Value: The EXTRACT function of the Database Organizer (DBO) now supports segment offset in the CONDITION control statement. Segment offset allows you to specify search conditions based on segment data at the specified offset. This feature simplifies the data extraction process, as you are no longer limited to extracting data from fields only.
Accurate Level Set in ISV SCRT Reporting: The ISV Sub-Capacity Reporting Tool (SCRT) has been enhanced to display the correct modification level in the PTF maintenance Level Set version string. You can now accurately identify the maintenance level that has been applied for your products.
EXTRACT Function Support for Multiple Conditions: The EXTRACT function of the Database Organizer (DBO) now supports multiple conditions. A new control statement, CONDOPERATOR, lets you specify the Boolean operation between CONDITION statements. Database administrators can use longer condition statements to simplify the management of databases.
Segment Overflow Information for UNLOAD and RELOAD: The Segment Frequency Statistics report of the Database Organizer now includes segment overflow information for UNLOAD and RELOAD functions.
New metrics allow you to make better decisions about the maintenance of IMS databases. The number of segments in overflow for the UNLOAD function helps you determine whether a database reorganization is required. The number of segments in overflow for the RELOAD function helps you decide whether the database reorganization was successful, or another reorganization is required, along with database layout changes.
One-Step Batch Reorg of Non-HALDB Databases with Logical Relationships: The One-Step Batch Reorg function of the Database Organizer now supports the reorganization of non-HALDB databases with logical relationships. To enable the new functionality, specify HPOBATCHLR=YES in ITKOPTS.
This feature allows you to build and run UNLOAD, RELOAD, PREFIX RESOLUTION AND UPDATE, and COPY for databases with logical relationships in a single step.
Version String Update to Panels and Batch Jobs: The Database Management Solutions for IMS ISPF panels and batch jobs now display the currently installed Level Set in the vv.rr.mm format:
vv Specifies the version level of the product.
rr Specifies the release level of the product.
mm Specifies the maintenance level of the product.
For more information, see New Features in the Release Notes in the Database Management Solutions for IMS for z/OS documentation.