Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2016
    Posts
    1

    Unanswered: DeadLock issue when SP is called parallely

    I have a batch code with inserts data in table1. and a SP which will update the same table1 (with update and merge stmt) and will push the data to table2. when SP is called parallel files.. facing dead loock issue.. please help

  2. #2
    Join Date
    Apr 2012
    Posts
    1,143
    Provided Answers: 27
    Insuffient information. Give basic facts about your environment and the SQL and tables and indexes involved. The DB2 knowledge centre for your version/platform of DB2 has information to help you diagnose lock conflicts. If you are using DB2 V10.5 or higher on Linux/Unix/Windows there is an event monitor for locking that if you properly configure will give you a lot of information.

    Troubleshooting deadlocks is a basic DBA skill, so try getting some education from the knowledge centre and help yourself.

  3. #3
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,540
    Provided Answers: 11
    maybe a lock table in the sp can help ...
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •