PL52346: RC00C90102 ON RESTART FOLLOWING AN INSERT WHICH HAD BEEN INTERRUPTED (PA1)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• INSERT WAS TERMINATED VIA AN ATTENTION KEY INTERRUPT (PA1).
  DB2 CRASHED, FOLLOWED BY A RESTART WHICH TOOK AN ABEND04E
  RC00C90102.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND04E RC00C90102 DSNIBHUN VRACE0C2B  *
  *                      DURING RESTART AFTER AN AGENT WAS       *
  *                      CANCELLED IN INSERT.                    *
  ****************************************************************
  * RECOMMENDATION: APPLY PTF                                    *
  ****************************************************************
  THE ERROR OCCURRED BECAUSE THE PAGE SYNCHRONIZATION FLAGS IN
  THE FIRST AND LAST BYTE OF A PAGE WERE OUT OF SYNC. THE SYNC
  FLAGS ARE NOT TESTED AT PAGE READ TIME TO DETERMINE IF A PAGE
  IS IN ERROR.
  

Problem conclusion

• WE HAVE PROVIDED BETTER DETECTION MECHANISM TO AN INCOMPLETE
  I/O TRANSFER. THE FIX AFFECTS THREE DB2 COMPONENTS, DATA
  MANAGER, BUFFER MANAGER, AND UTILITY. THE CHANGES TO DATA
  MANAGER IS NOT TO TOUCH THE I/O PARITY BIT WHICH IS
  EXCLUSIVELY OWNED AND MAINTAINED BY THE BUFFER MANAGER. THE
  CURRENT PROBLEM IS SETTING THIS I/O PARITY BIT TO ZERO DURING
  THE FORMATTING OF A NEW PAGE (DATA PAGE, SPACE MAP PAGE, INDEX
  PAGE, HEADER PAGE ETC.). BY DOING THIS, WE LOST THE BUFFER
  MANAGER'S ABILITY TO DETECT THE BROKEN PAGE SOONER. DATA
  MANAGER WILL NOT TOUCH THE I/O PARITY BIT DURING THE PAGE
  FORMATTING AND WHILE APPLYING THE REDO PAGE FORMAT LOG. BUFFER
  MANAGER IS CHANGED TO DETECT A BAD PAGE (INCONSISTENT I/O
  PARITY BIT OR LAST BYTE OF PAGE NOT E OR N). BUFFER MANAGER
  WILL RETURN A NEW RESOURCE UNAVAILABLE REASON CODE RC00C200FD.
  THE UTILITY CHANGE IS TO RECOGNIZE THIS NEW REASON CODE AND
  NOT ABEND.
  
  00C200FD
  
  EXPLANATION:  THE BUFFER MANAGER IS UNABLE TO PERFORM THE I/O
  OPERATION ON A DATASET DUE TO AN ERROR ON PAGES'S PARITY FLAG
  DETECTED BY THE BUFFER MANAGER'S I/O FUNCTION.
  
  THIS REASON CODE IS ISSUED BY THE FOLLOWING CSECTS(S): DSNB1GET
  
  SYSTEM ACTION:  A 'RESOURCE NOT AVAILABLE' RETURN CODE IS
  RETURNED TO THE USER. THE RELATED REASON CODE 00C200FD, THE PAGE
  NUMBER, THE PAGESET NAME AND THE DATA BASE NAME IN QUESTION ARE
  RECORDED IN THE CURSOR TABLE (CT) AND MADE AVAILABLE TO THE USER
  IN THE SQLCA.
  
  USER RESPONSE:  NOTIFY THE SYSTEM PROGRAMMER.
  
  OPERATOR RESPONSE:  NOTIFY THE SYSTEM PROGRAMMER.
  
  SYSTEM PROGRAMMER RESPONSE: THE ERROR PAGE CAN BE FOUND VIA
  SQLCA. CORRECT THE ERROR PAGES WITH THE RECOVERY UTILITY, AND
  NOTIFY THE USER TO INVOKE THE APPLICATION AGAIN. REFER TO
  SECTION 5 OF DIAGNOSIS GUIDE AND REFERENCE FOR FAILURE ANALYSIS
  PROCEDURES.
  
  PROBLEM DETERMINATION: COLLECT THE FOLLOWING DIAGNOSTIC ITEMS
  LISTED IN "APPENDIX B. DIAGNOSTIC ITEMS FOR PROBLEM
  DETERMINATION" ON PAGE 633: 1, 10, 11.
  

Temporary fix

Comments

APAR Information

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

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

  UL78559 UL78560

Modules/Macros

•    DSNB1GET DSNB5RAP DSNB5RDP DSNDBB   DSNDPMB
  DSNIBMCL DSNIBMOC DSNIFFRE DSNIFNP  DSNIFOD  DSNIFOI  DSNIFXRE
  DSNILPG  DSNISGFO DSNISGRT DSNISMEX DSNISMFO DSNISMRT DSNISMXS
  DSNISMXX DSNITLPE DSNITSMF DSNUCBFW
  

Fix information

• Fixed component name

  5740 IBM DATABA

• Fixed component ID

  5740XYR00

Applicable component levels

• R210 PSY UL78559

     UP90/10/12 P F007

• R220 PSY UL78560

     UP P

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.