2570227 - SQL0901N: unsuccessful FlushBlocks

• Shortdump occurred on the system with the SQL0901N error
  ==========================================================
  Category ABAP Programming Error
  Runtime Errors MESSAGE_TYPE_X_TEXT
  ABAP Program /FRE/SAPLFU_<SID>_MID
  Application Component SCM-FRE

  Error Text of the Database: "SQL0901N The SQL statement or command failed be a database system error. (Reason "unsuccessful FlushBlocks".)"

• DB2diag.log shows the below error
  =====================================
  2017-11-22-18.12.24.355029+000 I7829699A887 LEVEL: Severe
  PID : **** TID : **** PROC : db2sysc 0
  INSTANCE: db2<SID> NODE : 000 DB : <SID>
  APPHDL : 0-57 APPID: ************************************
  AUTHID : SAP<SID> HOSTNAME: **************
  EDUID : **** EDUNAME: db2agent (<SID>) 0
  FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:300
  DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
  sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 24
  sqlerrmc: unsuccessful FlushBlocks
  sqlerrp : SQLRI0FD
  sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
  (4) 0x00000000 (5) 0xFFFFF296 (6) 0x00000000
  sqlwarn : (1) (2) (3) (4) (5) (6)
  (7) (8) (9) (10) (11)

• FODC folder for the locked application shows below stack
  ===========================================================
  <StackTrace>
  -------Frame------ ------Function + Offset------
  0x090000000055BF94 pthread_kill + 0xD4
  0x090000000A0279F0 sqloDumpEDU + 0xD0
  0x09000000094C7D44 sqldDumpContext__FP9sqeBsuEduiN42PCcPvT2 + 0x104
  0x090000000AD3D964 sqlrr_dump_ffdc__FP8sqlrr_cbiT2 + 0x52C
  0x090000000AD3B38C sqlzeDumpFFDC__FP8sqeAgentUiP5sqlcai + 0x28
  0x090000000AD3B530 sqlzeSqlCode__FP8sqeAgentUiUlT2P5sqlcaiUsPc + 0xCC
  0x090000000AD3BB60 sqlrrSqlCode + 0xCC
  0x090000000AEBFDDC sqlri_hsjnPartitionFull__FP8sqlrr_cblP25sqlri_hsjnPartitionBucketP11sqlri_hsjnoP18sqlri_shared_hsjno + 0x5A8
  0x090000000AEBF550 sqlri_hsjnPartitionFull__FP8sqlrr_cblP25sqlri_hsjnPartitionBucketP11sqlri_hsjnoP18sqlri_shared_hsjno@glue4A4 + 0x44
  0x09000000098C35AC sqlrihsjnProbePD__FP8sqlrr_cb + 0x2E0
  0x090000000AF56714 @161@sqliScanLeaf2NoLocking__FP7SQLI_CBP11SQLI_SFGLOB + 0xB24
  0x090000000B060314 sqlifnxt__FP7SQLI_CBP11SQLI_SFGLOB + 0x390
  0x090000000B085694 sqlirdk__FP8sqeAgentP10SQLI_IXPCRP9SQLD_IXCBUlP8SQLD_KEYP12SQLI_KEYDATAP9sqli_scanPi + 0x6A0
  0x090000000B087188 sqldIndexFetch__FP8SQLD_CCBP8SQLZ_RID + 0x670
  0x090000000B058318 sqldRowFetch__FP8sqeAgentP8SQLD_CCBUlT3PP10SQLD_VALUEP8SQLZ_RIDT3P12SQLD_ID_LISTP9SQLP_LSN8 + 0x13A0
  0x090000000B053C70 sqlritaSimplePerm__FP8sqlrr_cb + 0x4A0
  0x090000000B0498B4 sqlrihsjn__FP8sqlrr_cb + 0x664
  0x090000000AFFF208 sqlriunn__FP8sqlrr_cbP10sqlri_stob + 0x160
  0x090000000AFFD954 sqlriset__FP8sqlrr_cb + 0xF0
  0x090000000B0554E8 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x24
  0x090000000AE845F4 sqlrr_process_fetch_request__FP14db2UCinterface + 0x64
  0x090000000AE93F0C sqlrr_fetch__FP14db2UCinterfaceP15db2UCCursorInfo + 0xF34
  0x090000000AE92F08 sqljs_ddm_cntqry__FP14db2UCinterfaceP13sqljDDMObject + 0x16FC
  0x090000000AFBBFD8 sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UCinterface + 0x1F0
  0x090000000AFBA204 .sqljsParse.fdpr.clone.82__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 0x1BD8
  0x090000000AFC2674 @73@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x2E8
  0x090000000AB4AEE4 @73@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB4
  0x090000000AB4B93C @73@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x558
  0x090000000AB4ABB0 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 0x21C
  0x090000000AD4AE64 RunEDU__8sqeAgentFv + 0x594
  0x090000000AD4A114 EDUDriver__9sqzEDUObjFv + 0x13C
  0x090000000AD49F9C sqlzRunEDU__FPcUi + 0x10
  0x090000000AD5D6BC sqloEDUEntry + 0x264
  </StackTrace>

DB2 LUW 10.1 Fix pack 5 and lower.
DB2 LUW 10.5 fix pack 6 and lower.

SQLRI0FD, FODC, hsjnPartitionBucket, sqlcabc: 136, PD_DB2_TYPE_SQLCA, MSG_CATCH_ABAP, HASH JOIN,  APPLICATION ERROR , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem