II10348: II06335 PART II ( DB2 R410 R510 - IRLM R101 ) FIXLIST

APAR status

• Closed as canceled.

Error description

• DB2 / IRLM Fixlist (last update 10/22/99 jbw)
  5740XYR00 + 569516401 R410 R101 WAIT + LOOP + SUSPEND + HANG
  Note: although unlisted, apars listed for R410 will most
        likely have a corresponding R510 ptf available.
  ---------------------------------------------------------------
  II09636 Various DPropR CAPTURE MVS R121 and DB2/MVS R410 errors
  II04309 DB2 virtual storage usage errors and diagnostics
  --------------- START put9601 ---------------------------------
  PN79083 UN85663 QUERY using CP PARALLELISM  returns NO rows.
  PN79180 UN86833 DSNB1CPS RC00C20303 CLOSE issued for a PAGESET
  PN79203 UN86070 DB2 would NOT SHUTDOWN with STORED PROCEDURES
  PN79234 UN87748 RC00C200E0 START DB(*) SPACE(*) and ALTER BP0
  PN79276 UN88724 PN69278/UN75996 CHANGES OPTIMIZER
  PN79334 UN97859 ABENDU2025 OCCURS FROM DXRRL2R1 + X'598'.
  PN79342 UN86800 LOOP AT PRECOMPILE BECAUSE OF A COLUMN NAMED
  PN79419 UN86619 DB2 HUNG AFTER S0D6 AND S0D7 IN MSTR AND DBM1
  PN79569 UN86904 ABEND0C4 PIC10 DSNB5COM +1A76 BAD ROB POINTER.
  PN79583 UN88976 DB2 DOES NOT TERMINATE AFTER A 'F IRLM,ABEND'
  PN79636 UN86725 REORG DSNDB06.SYSDBASE LOOPS. UNLOAD PHASE. 1.5
  PN79781 UN93444 SVC99, S99WTUNT BIT NOT SET PROPERLY, ATL
  PN79938 UN88975 NO ERROR. NEW ENHANCEMENT.
  PN79970 UN86910 ABEND04E RC00C90101 IN DSNKILNX AT ERQUAL5001
  PN80229 UN90441 INCORROUT (No Record Found) FETCH SECOND CURSOR
  PN80461 UN88180 I/O PARALLELISM IOP INCORROUT ISSUED
  PN80742 UN87620 MSGIEF238D DURING LOG OFFLOAD. ARCHIVE LOG ERR.
  PN80919 UN88409 S04E RC00C90101 DSNKNXT2 VRACE5007 ERQUAL5007
  PN81194 UN89279 CANCEL CPU PARALLEL QUERY DOES NOT WORK.
  PN81276 UN89097 INCORRECT OUTPUT WITH PARALLELISM AND JOIN
  PN81283 UN87743 S04E RC00D1032B DSNJR003 +064A DURING DB2 START
  PN81413 UN89432 ABEND0C4 AT DSNWVCOL +79A WHILE DB2PM MONITOR
  PN81469 UN94461 ABEND04E RC00C90101 DSNITCUS VRACE5002. BAD CUB
  PN81663 UN88474 ABEND071 SPINLOOP IN DSNB1CLM ON AN SQL INSERT
  PN81711 UN88494 QUERY SOMETIMES HANGS WHEN USING CP PARALLELISM
  PN81720 UN88719 THREAD HANG or SUSPEND in DSNB1GET
  PN81762 UN88255 INTERMITTENT LOOP (SPINLOOP)
  PN81763 UN89522 WAIT - LOCK REQUEST WAIT IN SLM
  PN81994 UN90535 PLOCK NEGOTIATION CANCEL FUNCTION
  PN82210 UN90426 SQLIOP INCORROUT ON SELECT COUNT(*) GROUP BY
  PN82373 UN89014 OPTION TO WAIT FOR RETAINED LOCKS, DATA SHARING
  PN82889 UN90796 S04E RC00C90105 ERQUAL0C04 FROM DSNIONX2
  PN83397 UN94699 HANG OR SUSPEND IN DSNB1TMR FOR A TASK
  PN83443 UN90997 HANG OR STOPP ISSUED FOR A SECOND STOP DATABASE
  PN84107 UN97323 DB2 HUNG WHILE ALLIED ADDRESS SPACE, IDENTIFY
  PN84281 UN93759 ABEND04E RC00E50002 DSNVGEPL DSNVXUL0 +0202
  PN84282 UN91656 ABEND071 SPINLOOP: LOOP OUTER JOIN LOGIC AROUND
  PN84362 UN94592 RC00E40316 RC00C90088 TYPE303 DSNDB06.DSNTCX01
  PN84374 UN92037 S04E RC00E50097 ISSUED FROM DSNVEUS2
  PN84396 UN91071 EXCESSIVE IO WAIT TIMES RESULTING IN SLOW,
  PN84481 UN92132 REPEATED MSGDSNR031I WITH THE SAME RBA
  PN84486 UN91550 STOP DATABASE SPACENAM RESULTS IN A HANG
  PN84497 UN90878 S0C4 DSNLAGNT+08DC OR DSNLSSST+0DAE AFTER STOP
  PN84846 UN92593 ABEND04E RC00C20302 DSNIWKFD +0774 PBAOPEN
  PN84915 UN94291 GLOBAL DEADLOCK HANG NOT DETECTED OR NOT BROKEN
  PN85131 UN92811 DSNB250E DSNB5COM RC00C90101 REG0 = 00C20042
  PN85528 UN92051 LOOP ON LOAD RESUME YES LOG YES DISCARDS 1
  PN85615 UN92698 S0C4 DXRRL760, HANG IN CHILD LOCK PROGAGATE
  PN85652 UN92082 DB2 HANG WAITING ON NOTIFY RESPONSE
  PN85692 UN92699 DEADLOCK OCCURRED WITH ONESELF
  PN86072 UN93949 ABEND04E RC00E70005 DSNXECMP P404
  PN86579 UN94518 ABENDU2025 IRLM PERFORMANCE ISSUE
  PN86773 UN93509 HANG AFTER DSNL030I DSNLTACC RC00D3001B
  PN86831 UN94204 SUSPEND DSNB1TMR +860 FOR WORKFILE SPACE MAP
  PN87181 UN93634 HANG ARCHIVE LOG MODE QUIESCE USING DATASHARING
  PN87220 UN96588 MSGDSNV086E - ABEND04F RC00E50702
  PN87599 UN97300 S0C4 DSNTFRCV + X'184' IN THE dsnSPAS ASID
  PN87723 UN97109 ABEND04E WITH RC00C200D8 IN DSNB5COM+077A
  PN87724 UN94781 DB2 CASTOUT WAIT IN IRLM
  PN87728 UN94792 DB2 CASTOUT WAIT IN IRLM
  PN87924 UN94866 CICS THREAD SUSPENDED FROM CSECT DSNTABA +56C.
  PN88155 UN96112 ABEND04E RC00C202B1 IN DSNB1PER +'26C'
  PN88277 UN94725 HANG (DETECTED WAIT) MVS/CAPTURE COMPONENT
  PN88411 UN95492 SUSPEND DSNXESP2 +0518 DSNTLSUS +04B0 (UN80513)
  PN88437 UN95661 ABEND0C4 IN DSNB1AHT +BA8 ALTER BUFFERPOOL
  PN88492 UN94925 HANG OR SUSPEND IN DSNB1TMR
  PN88919 UN95654 ABEND04E RC00C200A9 IN DSNB1DLK
  PN90571 UN98811 S0C4 DXRRL210 = B40 WHEN IRLM HAD BEEN ISSUED
  PN89250 UN95965 RESYNC INDOUBT SERVER HANG AFTER DDF STOP FORCE
  PN89320 UN95926 SERVAPAR SERVICEABILITY ENHANCEMENT
  PN88155 UN96112 DXRRL750 ABENDU2031 S04E RC00C202B1 DSNB1PER
  PN89715 UN96384 ENQUEUE CONTENTION FOR RESOURCE NAME DSNJBSDS
  PN89796 UN96662 MODIFY UTILITY MAKES SYSCOPY TS UNAVAILABLE
  PN89904 UN97709 IRLM DOES NOT ABTERM: F DB2SIRLM,ABEND,NODUMP
  PN90233 UN98336 ABEND04E RC00C90101 DSNIMSAR VRACE5003
  PN90405 UN97791 RC00E50097 FROM DSNB5COM +3926 (UN92811)
  PN90618 UN97759 ABEND04E RC00E50097 DSNVGEPL.DSNVEUS2+X'0C00'
  PN88076 UN99010 msgDSNT375i deadlock, hung thread
  PN91958 UN99082 S0C4 DSNVRSRB +62 after rc00E50013 soft CANCEL
  
  *************** START put9701 *********************************
  PN92451 UN99651 IRLM DB2 DataSharing hangs SYSPLEX
  PN92563 UN99652 Unbroken IRLM deadlock with waiters
  PN87849 UQ00155 CATMAINT loop during DB2 migration
  PN90646 UQ00561 ABEND04E RC00E70005 LOC=DSNXGRDS DSNXERT :P100
  PN91127 UQ01106 INCORROUT WHEN FETCHING ROWS INSERTED
  PN89677 UQ01114 Query request pending in RLMQCOMP
  PN92324 UQ01418 Unpredictable results, loop DBM1
  PN90313 UQ01573 Excess LOGREC entries during DB2 shutdown
  PQ00140 UQ01533 THREADS HUNG DISCONNECT.  DSNB5PUR IN ECB WAIT
  PQ01325 UQ01687 LOOP IN DSNTFRCV
  PN91427 UQ02368 DDF ASID LOOPS DSNLVLOS BAD VCB CHAIN (DSNYALLI
  PQ00845 UQ02428 NO TIMEOUT NO DEADLOCK DETECTED AND HANG
  PQ01375 UQ02568 SUPPORT DB2/400 V4 (PA) PRESUMED ABORT PROTOCOL
  PQ01485 UQ02592 INCORROUT FROM LEFT OUTER JOIN LOJ NESTED
  PQ02055 UQ02277 WAIT084 rc0C after retry from FRR in DSNVIALC
  PQ02422 UQ02422 LOOP in IRLM DXRRL1E0 RCVYEXIT
  PQ01713 UQ03363 LESS ROWS RETURNED FOR QUERY INVOLVING Hi-Join
  PQ00474 UQ04391 DB2 LOAD utility hung after CANCEL attempt.
  PQ00137 UQ04814 Various abends and hangs at agent termination.
  PQ03532 UQ05260 DBM1 hang after command ALTER BUFFERPOOL
  PQ04688 UQ05646 Hang in DSNTABA after agent cancelled
  PQ02380 UQ05649 DBM1 hang after STOP DB2 MODE(FORCE)
  PQ04300 UQ05699 SYSTEM appears HUNG due to DDF SRBmode process
  PQ04407 UQ07822 DBM1 hang/loop broken VDW queue
  PQ06386 UQ08324 Hang / S04E DSNB1CPS DURING STOP DB2 MODE(FORCE
  PQ08642 UQ10001 THREAD HUNG DSNB5FOR MSGDSNP014I (ow31485)
  PQ06210 UQ10809 DBM1 SPINLOOP DSNIWKFD CTBCRELP is zero.
  
  *************** START put9801 **************************
  PQ10118 UQ12235 Various errors, broken VDWQ
  PQ09587 UQ12747 Thread hung after cancel, see pq01773
  PQ07598 UQ12766 Hung thread abort process ABENDx22
  PQ13085 UQ14811 Same as above, hung awaiting IRLM process.
  PQ13089 UQ17855 DBM1 hung looping CP Parallelism
  PQ11781 UQ16679 IRLM hangs plus PQ11803 PQ15126 included
  PQ13944 UQ18074 Loop DBM1 drop database
  PQ16196 UQ18325 Hang preformat Logs, SYSZTIOT enqueue
  PQ13498 UQ19269 No IRLM autostart
  PQ16081 UQ19369 IRLM WAIT undetected deadlock
  PQ16906 UQ19656 DDF or Parallelism thread hung, Enclave SRB
  PQ16400 UQ19736 Thread suspended DSNTLSUS at RESTART
  PQ15726 UQ20185 Insert perf. Hang Suspend DSNVXLT0  (R510 only)
  PQ18079 UQ20229 Enclave srbmode hang
  PQ14893 UQ21098 MSTR cpu cycles, Stmt Cache usage   (R510 only)
  PQ18722 UQ21613 IRLM CSA shortage hangs sp231 sp241
  PQ19076 UQ22529 Loop DSNXOVP hung thread (locks sysview)
  PQ18396 UQ22721 Batch thread hung, timeout rc00C200EA
  PQ18318 UQ22915 Extend processing hang, DataSharing
  PQ20566 UQ22949 Parallelism hung thread abort process
  PQ18500 UQ23393 HANG/SUSPEND DSNTABA DSNRUA01 after ABEND13E
  PQ19978 UQ23606 HANG/SUSPEND DSNVDISC after IRLM error
  PQ18780 UQ28859 HANG in CICS due to Thread with T status
  *************** START put9901 *********************************
  PQ22980 UQ25766 IRLM PLock waits Retained Locks
  PQ21341 UQ25773 DB2  serialization RESUME vs CANCEL hung thread
  PQ21809 UQ25776 IRLM serialization RESUME vs CANCEL hung thread
  PQ20301 UQ26207 LOOP broken VDWQ various hangs, abends
  PQ24098 UQ27192 ABENDs/hangs after S13E task cancel (PA1 key)
  PQ23978 UQ27961 IRLM Undetected/Unbroken Deadlocks
  PQ24904 UQ28185 EDMpool corrupted hangs, loops, abends
  PQ25136 UQ28487 Thread hung IRLM SUSPENDED DSNTLSUS see pq21341
  PQ25378 UQ28930 Parallel task hung SUSPENDED DSNTTSPD (r510)
  PQ23185 UQ29405 SSAR Loop DSNVSR Resume invalid ROB, EOM
  PQ25419 UQ30020 IRLM DSNTLSUS hung threads, suspended, EOM
  PQ25950 UQ30105 Coreq to pq25419 IRLM r101 EOM  (r510 r610)
  PQ25996 UQ30271 Hang, loop Join with fetch      (all)
  PQ27186 UQ30617 LOOP suspend DSNB5RDP after uq20575  (r510)
  PQ27407 UQ32031 SRB processing LOOP DDF to DBM1      (r510)
  PQ26774 UQ32434 DDF and/or DB2 fails to shutdown     (r510)
  PQ27360 UQ32811 No shutdown SPAS stopping            (r510)
  PQ29004 UQ33842 Loop Select with View (pq30065)      (r510)
  PQ29282 UQ34606 Plock LOTCH hang SSAR loop ALL DS users
  PQ28664 UQ34842 DIST loop DSNLILOS, TCPIP disco (r510 r610)
  PQ30767 UQ35570 Hang Lockwait DSNTLSUS          (all)
  

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

• Closed for DB2INFO retention
  

APAR Information

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

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

Fix information

Applicable component levels