Skip to Main Content
Due to the recent acquisition by IBM, the Adabas & Natural Ideas Portal does not contain ideas from products ApplinX and EntireX any longer. Please refer to the IBM Ideas Portal for these products from now on (IBMid required). Existing content will be migrated during the next few weeks.
Status New
Workspace Adabas for z/OS
Categories Adabas (ADA-zOS)
Created by Dana Sherbondy
Created on Jun 21, 2022

Add non-keyed search functions

This could apply to all ADABAS versions and platforms.

During the customer story on 6/21 with Michael S and St. of Delaware, they noted that connx queries for null values or non-keyed searches on million record files take minutes to respond and are not suitable for customer response time.

These types of queries are common for Oracle (and other) SQL dbs.

While it would be possible to create many DEs on every field, the subsequent update / delete processing may become slow to maintain all the ASSO space / values.

How do SQL dbs handle such queries internally - it does not appear as though they read the entire DB / file of data? And then joins add another level of complexity / overhead.

Would it be possible for ADABAS to use a user exit to maintain a separate "SEARCH PATH" (using the ORacle term for "show path") - that could keep updates to data indexes in an async mode - not exactly up to the second - and not delaying response times for ADD / UPDATE / DELETE commands which must maintain NI structures. But reduce the response time on million record files of non-keyed searches to seconds instead of minutes.

Use Case extend ADABAS connx queries to be more dynamic and not practically limited to keyed selection criteria
  • Dana Sherbondy
    Reply
    |
    Jun 21, 2022

    Adding to the DB itself would expand the usage to other tools and not just for ConnX / SQL Gateway.