IBM i Global

IBM i 

A space for professionals working with IBM’s integrated OS for Power systems to exchange ideas, ask questions, and share expertise on topics like RPG and COBOL development, application modernization, open source integration, system administration, and business continuity.


#Power


#IBMi
#Power
 View Only

  • 1.  ACS SQL Sessions Automatic Timeout

    Posted Mon August 04, 2025 09:50 AM

    Currently, users often leave ACS (Access Client Solutions) SQL sessions open after executing their queries. These idle sessions remain connected for extended periods, which may introduce potential security risks and consume unnecessary system resources.
    Is there any way to implement a configurable timeout mechanism that automatically disconnects inactive ACS SQL sessions after 15 minutes of inactivity?
    Thanks



    ------------------------------
    Sami Abou Karam System i expert
    Technical Support Manager
    QuanTech s.a.l
    009613278541
    ------------------------------


  • 2.  RE: ACS SQL Sessions Automatic Timeout

    Posted Tue August 05, 2025 01:46 AM

    Hi Sami-san,
    If you mean ACS's Run SQL script window, you can set timeout after inactive interval.

    In, Run SQL script window, open preferences panel, select General tab, and set inactive idel time(1-600min.).



    ------------------------------
    MIKIO SASAKI
    ------------------------------



  • 3.  RE: ACS SQL Sessions Automatic Timeout

    Posted Tue August 05, 2025 05:31 AM
    Edited by Satid S Tue August 05, 2025 06:16 AM

    Dear Sasaki-san

    Did you mean the option "Save files after specified period of inactivity" as shown be low?   If so, I see that your response to Sami's question does not serve the security purpose he asked.  



    ------------------------------
    Satid S
    ------------------------------

    Original Message


  • 4.  RE: ACS SQL Sessions Automatic Timeout

    Posted Tue August 05, 2025 05:59 AM
    There is something like that in Preferences:

    image0.jpeg

    This closes open result sets after a given time of inactivity.

    I don't know, if you can configure that centrally -  it it should work somehow. 


    HTH and kind regards,
    Daniel



    Original Message


  • 5.  RE: ACS SQL Sessions Automatic Timeout

    Posted Tue August 05, 2025 07:34 PM

    Sami-san,

    The parameters I explained are those in Daniel-san's reply. I didn't attach an image because my ACS environment was in Japanese.

    Daniel-san,

    Thank you!



    ------------------------------
    MIKIO SASAKI
    ------------------------------

    Original Message


  • 6.  RE: ACS SQL Sessions Automatic Timeout

    Posted Tue August 05, 2025 05:36 AM
    Edited by Satid S Tue August 05, 2025 06:15 AM

    Dear Sami

    Do you have a firewall in front of your IBM i server?  There should be one typically (Ask your security admin or network admin. If not, you are not providing sufficient security to your IBM i server.) and you can set one timer in the firewall to kill any idling connections.  Some firewalls use the word "Session Idle Timer/Timeout" or similar wording and you set 15 minutes for it.    



    ------------------------------
    Satid S
    ------------------------------



  • 7.  RE: ACS SQL Sessions Automatic Timeout

    Posted Wed August 06, 2025 06:28 AM

    Hello All,

    I tested Daniel's option and got disconnected after 15 minutes, it should do the thing.

    I will check the customer if the firewall is present or not.

    Thank you all , Mikio-san, Daniel and Satid.



    ------------------------------
    Sami Abou Karam System i expert
    Technical Support Manager
    QuanTech s.a.l
    009613278541
    ------------------------------



Related Content