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 Under Review
Categories Natural (NAT)
Created by Hezi Shirazi
Created on May 22, 2024

handle db connection with rpc server

Hi,

In our environment we are using REST API to access Natural RPC servers.

I have noticed that the RPC process isn’t closing its db (adabas) connections.
Using ADAOPR DI=UQ_FILE I saw that NATRPC is still holding files that a request that had ran long time ago accessed.
In this case, it is not possible to execute utilities like ADADBM REFRESH, or ADADBM ADD_FIELD.

For me, it means that the REST-API request isn’t a stateless REST-API.

To solve this issue I have written a Natural function that close Adabas conecction, and I have set it in NATRPC01/03 (exit/Error).

I think that the current behavior isn’t suitable or correct for now days (working with REST-APIs).

I would like to have an option that will cause Natural RPC Server to close the connection to the database after every request.

Use Case Natural RPC & Adabas
  • Anat Devir
    Reply
    |
    Jun 6, 2024

    The requirement is to have Natural RPC supporting stateless Rest APIs.

  • Hezi Shirazi
    Reply
    |
    Jun 5, 2024

    same when a request run usr2005n (mapping db files)

    When another request comes after, it gets the mapping, which is wrong