SAP Knowledge Base Article - Preview

2920078 - CREATE TABLE could crash SAP IQ if one of the dbspaces is OFFLINE - SAP IQ

Symptom

  • A database has several dbspaces
  • One of the dbspaces is OFFLINE
  • Default dbspace is set to one of the online dbspaces
  • SAP IQ could crash when executing CREATE TABLE
  • When the dbspace is converted from OFFLINE to ONLINE, then CREATE TABLE is successful

Excerpt of IQMSG

s_blockmap::RegisterPhysicalBlockId
s_blockmap::AllocOrReallocPhysicalBlocks
s_buf::Write
s_blockmap::Flush
db_Catalog::CreateTable
st_command::DoCmdThroughResourceGate
db_iqddl::CreateTable
UIQDDL_CreateTable


Read more...

Environment

  • SAP IQ 16.0
  • SAP IQ 16.1

Keywords

CR821491, CR#821491, 821491, RegisterPhysicalBlockId, ConvertTo6BytePhysicalBlockIdsIfNeeded, s_blockmap::RegisterPhysicalBlockId , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.