Db2

 View Only
  • 1.  Slow connection EF Core 3 and 5

    Posted Mon February 22, 2021 03:15 AM
    Edited by System Fri January 20, 2023 04:35 PM
    We have a very slow connection on first query with EF Core 3 and 5.
    After the first query everything works fine, until some time the first query is slow again.
    What could be wrong?

    -- UPDATE --

    I created a local user account on the Win server, with the same name as the user account that is being used to make the connection. The local user account does not have to be a member of any acl groups and it can be disabled.

    I tried this solution, and to my amazement, it actually worked. The connection was made within milliseconds. What I am concerned with is that this "feature" seems like a flaw in the DB2 driver, and any new versions of this driver could actually prevent this from working again.

    Does anyone know if there is an actual setting in the DB2 driver that we could set, so it does not try to authenticate with Active Directory? I would feel more comfortable using that setting, than relying on, what looks to me, a flaw in their authentication algorithm.



    ------------------------------
    Jean-Pierre Nulens
    ------------------------------
    #Db2


  • 2.  RE: Slow connection EF Core 3 and 5

    Posted Mon February 22, 2021 08:53 AM
    Edited by System Fri January 20, 2023 04:12 PM
    Hi,
     can you please contact IBM tech support for help on this? We need few artifacts on this to analyze further. Its not clear whether it is a driver issue or the other settings.

    Thanks
    Vishwa


  • 3.  RE: Slow connection EF Core 3 and 5

    Posted Wed December 06, 2023 09:46 AM
    Edited by Robert van der Doelen Wed December 06, 2023 09:47 AM

    Hi,

    We have the same behaviour regarding the first query or "connection.open" takes about 15 seconds.

    Is there an update on this issue since february 2023?

    See also my post: https://community.ibm.com/community/user/datamanagement/discussion/db2-ibmentityframeworkcore#bmfac56fd3-7438-4335-a74c-1e759224a35a

    Thanks,

    Robert



    ------------------------------
    Robert van der Doelen
    ------------------------------