PL34152: DB2 HUNG AND USER IN STATUS 'D' .

APAR status

• Closed as duplicate of another APAR.

Error description

• DB2 HUNG AND USERS LOCKED OUT : DOING A DISPLAY THREAD FROM
  THE CONSOLE AND FOUND ONE USER IN STATUS 'D' , OTHER USERS
  QUEUED UP BEHIND THIS USER IN STATUS 'QD' AND 'QT' , UNABLE
  TO CREATE THREADS. WHEN THE USERS ATTEMPTED TO EXIT FROM DB2
  VIA THE ' ATTENTION ' OR ' PA1 ' KEY, THEY WERE GOING INTO
  'QD' STATUS . MSGDSN3201I ISSUED FOR THE USER IN STATUS 'D' IN
  THE DB2 JOBLOGS BUT NOTHING WAS SEEN IN THE LOGREC FOR THIS
  USER.
  

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

• THIS APAR IS BEING CLOSED AS A DUPLICATE OF PL33976. IN THIS
  CASE, YOU WERE ABLE TO GET JUST A FEW INSTRUCTIONS PAST THE
  ABEND0C4 IN DSNVRMEL AND INTO STORAGE MANAGER WHERE THE INVALID
  SKB WAS DETECTED AND AN ABEND04E RC00E20028 WAS ISSUED.
  FOLLOWING THE ABEND04E, THIS USER WAS LEFT IN 'D' STATUS,
  DEFERRED TERMINATION, AND ANY OTHER USER ATTEMPTING TO CANCEL
  WAS QUEUED FOR DEFERRED TERMINATION, STATUS 'QD'.
  THE FIX FOR THIS PROBLEM REQUIRES THE FIXES
  FROM APARS PL33976 AND PL34853.
  PLEASE APPLY THE FIXES FOR BOTH OF THESE APARS.
  

APAR Information

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

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

Fix information

• Fixed component name

  5740 IBM DATABA

• Fixed component ID

  5740XYR00

Applicable component levels