Db2

 View Only
  • 1.  IBM DMC 3.1.7.1 Windows dsweb inactive after logout

    Posted Fri April 21, 2023 10:52 AM

    Hello,
    I have installed IBM DMC version 3.1.7.1 in a Windows Server 2022 Standard (I have used DMC version 3.1.7.1 because it is the latest version supporting AUTHENTICATION=DATA_ENCRYPT) and I'm experiencing a strange behaviour: when I disconnect from the remote desktop the dsweb service goes inactive after the logout. I've already increased the jvm memory limits but without success. I'm suspecting a Windows problem but I'm not sure.

    Has anyone experienced the same problem as mine ? Any ideas ?

    Thanks a lot.
    Best Regards.
    Roberto



    ------------------------------
    Roberto Stradella
    ------------------------------


  • 2.  RE: IBM DMC 3.1.7.1 Windows dsweb inactive after logout

    IBM Champion
    Posted Mon April 24, 2023 07:35 AM

    Hi Roberto,

    my assumption is, you run DMC under your local user account and Windows closes all open processes at logout.
    You need admin privileges and should run this script <install_directory>/bin/enableservice.sh to switch DMC to run as a service.

    Cheers



    ------------------------------
    Roland Schock
    IBM Champion and IBM Gold Consultant
    ------------------------------



  • 3.  RE: IBM DMC 3.1.7.1 Windows dsweb inactive after logout

    Posted Wed April 26, 2023 06:09 AM

    Hello Roland,
    thanks for the answer, we found the problem: it was caused by a Windows setting. We fixed it as follows:

    As Windows Administrator press "Win + R" and type gpedit.msc on Run window. The local group policy editor will be opened on your system. Then navigate to the following location:

    Local Computer Policy 
       =>  Computer Configuration 
         =>  Administrative Templates 
           =>  Windows Components 
              =>  Remote Desktop Services 
                =>  Remote Desktop Session Host 
                  =>  Session Time Limits

    You will find a list of options on the right side, double click on "Set time limit for disconnected sessions" to open it.
    We found that it was Enabled and in Options the End a disconnected session was setted up to 1 minute.


    Updating End a disconnected session to 7 days fixed the problem. So any disconnected user will be logged off after 7 days.
    Please note that 7 days is a value based on our environment, we are sure that every day the IBM DB2 DMC userid will access the server. The alternative is to Disable the Set time limit for disconnected sessions, but this has to be assessed on the basis of security policies.

    Best Regards.
    Roberto.



    ------------------------------
    Roberto Stradella
    ------------------------------



  • 4.  RE: IBM DMC 3.1.7.1 Windows dsweb inactive after logout

    IBM Champion
    Posted Thu April 27, 2023 01:38 AM

    Hi Roberto,
    that just postpone the error but is not solving it.
    Windows kills any task started by a regular user after X mins (aka during logout)
    You probably want to let DMC run forever unattended and not required to login once a week?
    Aren't you sometimes want to go on holiday?

    DMC should be configured in a way to run as Windows service. This allows you to even let it start automagically in the background when the server gets restarted.

    Cheers



    ------------------------------
    Roland Schock
    IBM Champion and IBM Gold Consultant
    ------------------------------



  • 5.  RE: IBM DMC 3.1.7.1 Windows dsweb inactive after logout

    Posted Mon May 08, 2023 09:20 AM

    Hello Roland,
    thanks for the update, I will check how to configure dsweb to run as Windows service.

    Thanks. Ciao.
    Roberto



    ------------------------------
    Roberto Stradella
    ------------------------------



  • 6.  RE: IBM DMC 3.1.7.1 Windows dsweb inactive after logout

    Posted Mon May 08, 2023 09:54 AM

    Hello Roberto,
    To run the DMC as a Windows service, you just need to run the setup.bat script under the DMC bin directory as an Windows Administrator user.
    The script creates the Windows service for you:
    I hope that helps!



    ------------------------------
    Cintia Ogura
    ------------------------------



  • 7.  RE: IBM DMC 3.1.7.1 Windows dsweb inactive after logout

    Posted Mon May 08, 2023 12:22 PM

    Hello Cintia,
    thanks for the update. I have checked Windows Services and IBMDb2Console is already in the list. Our problem could be related to IBMDb2Console Log On setting: now it is configured to Local System account, we are thinking to change to the user that make the Db2 DMC installation and is a Windows Administrative user.

    Thanks. Ciao.
    Roberto



    ------------------------------
    Roberto Stradella
    ------------------------------