sponsored links



No announcement yet.

Issue with multiple users executing same stored procedures

  • Filter
  • Time
  • Show
Clear All
new posts

  • Issue with multiple users executing same stored procedures

    I have a new application in a test mode at a few retail outlets.

    The user opens a web page and creates transactions.

    Under the covers I am using a single db2 profile for the connection to the System i. The connection happens as they open the application.

    When multiple sites enter data at the same time it is getting crossed.

    I use stored procedures that are executed when they click submit for new transactions or for updates.

    This just hit and I thought I would ask here as my mind starts to digest and come up with ideas.

    My initial ideas are they are all using the same profile and that is causing the issue. I would have expected each connection to be a separate session.

    I do not want separate profiles, but could go that route as a last resort.

    Any tips or leads would be appreciated.

  • #2
    I don't understand your environment. What programming language are you working with? When you say a "single db2 profile", do you mean one db2 database connection? Or, what is meant by "profile"?


    • #3
      Using a single service profile for an app is fairly typical, so I doubt that's your problem.


      • #4
        It is visual studio using C#.

        I found my problem. I had defined a collention as static by mistake. That meant everyone was entering into the same storage.

        WHen it first showed itself I thought It was something to do with the connection to the System i.

        Thank You for taking a moment to think about it.