Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• OnLine REORG claim/drain deadlock.
  Symptoms include:
    DSNT501I  -xxxx DSNB1LDA RESOURCE UNAVAILABLE
               CORRELATION-ID=010.TLPLKNC3
               CONNECTION-ID=xxxx
               LUW-ID=*
               REASON 00C200EA
               TYPE 00000210
               NAME DB2DT001.IDTIAI00.00000007
    or DSNT501i rsn00c200EC from DSNB1DRA
    00c200ea 00c200ec rsn00c200ea type210 drain type 210
    timeout or deadlock with Utility
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 users.                               *
  ****************************************************************
  * PROBLEM DESCRIPTION: Undetected claim/drain deadlocks        *
  *                      between SQL and utilities, resulting in *
  *                      either drain failures on the utility    *
  *                      side (RNA RC00C200EA or RC00C200EC) or  *
  *                      in drain lock timeouts on the SQL side  *
  *                      (SQLCODE -911).                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Claim/drain deadlocks often occur between a utility trying to
  drain multiple objects and an SQL job trying to claim multiple
  objects.  A deadlock occurs when the utility has completed the
  drain for one object and is trying to drain another (waiting
  for claimers to go away) and one of the claimers of that object
  is trying to acquire a claim on an object the utility has
  already drained (waiting on the drain lock).  The deadlock is
  eventually broken when the SQL job times out on the drain lock,
  or when the utility times out on the claimer wait.
  
  These deadlocks occur because of the unpredictability of the
  order in which SQL jobs acquire claims on objects.  Indexes
  may be claimed either before or after their associated table
  space, and table space partitions may be claimed in any order.
  

Problem conclusion

• In order to avoid claim/drain deadlocks caused by the order in
  which SQL claims data and index objects, code has been modified
  to ensure that SQL jobs will always acquire claims on a table
  space or partition prior to acquiring claims on any of its
  indexes.  Those utilities which drain multiple objects have also
  been modified to drain the data before the index(es).
  
  To avoid claim/drain deadlocks caused by the order in which SQL
  claims partitions of a tablespace, a new tablespace-level claim
  has been introduced, which will always be acquired before any
  partition claim.  Those utilities which operate on an entire
  partitioned table space will acquire the tablespace-level drain
  before any partition drain.
  
  The DISPLAY DATABASE CLAIMERS command has been modified to
  show the new tablespace-level claims.  For these new claims,
  the partition number displayed will be left blank.  Similarly,
  the DISPLAY DATABASE LOCKS command has been modified to show
  the new tablespace-level drain locks with blanks for the part
  number.
  
  For DB2 V7, the data-first claiming and tablespace-level
  claim/drain will only be enabled if the new CLAIMDTA ZPARM
  is set to YES.
  
  For DB2 V8, data-first claiming and tablespace-level claim
  and drain is always enabled.
  

Temporary fix

Comments

• **** PE05/08/11 FIX IN ERROR. SEE APAR PK09781  FOR DESCRIPTION
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK01429 UK01430

Modules/Macros

• DSN@ZP   DSNBCLM  DSNB1CLM DSNB1DCM DSNB1DDN
  DSNB1DRA DSNB1LCM DSNB1LDA DSNB1OPS DSNB1POC DSNB1RCM DSNDPB
  DSNDPBA  DSNDQWPZ DSNDQW03 DSNDSPRM DSNIBMOP DSNICLDR DSNILKDR
  DSNILKES DSNIPSFI DSNIPTYM DSNKDLE  DSNTDINQ DSNUBACI DSNUBAII
  DSNUCAIN DSNUGUCA DSNUQUIA DSNURDRN DSNURLOG DSNVFMC  DSNWVZPM
  DSNWZP   DSN6SPRM
  

Fix information

• Fixed component name

  5740 IBM DATABA

• Fixed component ID

  5740XYR00

Applicable component levels

• R710 PSY UK01429

     UP05/03/29 P F503

• R810 PSY UK01430

     UP05/03/29 P F503

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.

IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.

Product categories:

Software

Data Management

Data Servers (Database Management Systems)

DB2 for z/OS

Software version:

710

Reference #:

PQ96628

IBM Group:

Software Group

Modified date:

2005-09-01