Symptom
On a Multiplex system, after moving data using sp_iqemptyfile from existing DBspace to new dbspace, and dropping the empty dbspace, then the next load table cound hit a stack trace and sp_iqcheckdb 'allocation database' could report a corruption error "Blocks with Multiple Owners".
* Error stack trace >>
..
.. ** Non-Fatal IQ Internal Error Detected
.. ** at slib/s_barray.cxx:11806 on thread 139776680490752 (TID 752)
.. **
...
* STACKTRACE >>
..
.. pcstkwalk ..
.. ucstkgentrace ..
.. StackTraceForThisThread ..
.. s_mergeFINALWriter::LoadPageForMerge ..
.. s_mergeFINALWriter::DoInsert ..
.. hs_dpInsert::Insert ..
.. dfiio_FP::FetchOpus ..
.. dfo_IndexInsert::FetchOpus ..
.. df_CombinerFetchContext::Fetch ..
Read more...
Environment
SAP IQ 16.1
Keywords
"Blocks with Multiple Owners" , "Unallocated Blocks in Use", multiple, owners, unallocated, s_barray , "s_mergeFINALWriter::LoadPageForMerge" , "s_mergeFINALWriter::DoInsert", 825997 , , KBA , BC-SYB-IQ , Sybase IQ , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.