Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2003
    Posts
    22

    Unanswered: Load replace vs bind package

    I have had a deadlock because a load replace was running in the same time of a bind package.
    The strange things is that the resource was not the table where I was loading, but a system tablespace (DSNDB06. SYSDBASE).

    I cannot understand why this could be appened....

    Someone has an idea?

    Thanks!
    Cristiana
    Data Base Administrator
    Bologna
    Italy

  2. #2
    Join Date
    Feb 2002
    Location
    Germany
    Posts
    141
    Just a guess:
    you run LOAD REPLACE ... STATISTICS?
    If yes, DB2 must get an X-Lock over DSNDB06.SYSDBASE (SYSTABLEPART, SYSTABLES and so on) to update the statistics columns.
    The bind process needs a S-Lock on DSNDB06.SYSDBASE (the optimizer needs the statistics for generating the access path).
    S-Lock and X-Lock cannot live together ;-) Ergo...
    Rodney Krick

  3. #3
    Join Date
    Feb 2003
    Posts
    22
    no.....the load is simple: keepdictionary, no statistic....

    In the same load we made modify recovery and repair nocopypending, too....

    Is this the problem????
    Cristiana
    Data Base Administrator
    Bologna
    Italy

  4. #4
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186

    Re: Load replace vs bind package

    We have seen the same problem and have not had any luck getting around it. It will put the lock on the system tables and until its finished, the other job will wait or cause the deadlock.

Posting Permissions

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