Symptom
Customer is upgrading from IQ 16 SP11 to IQ 16.1 SP02. In addition moving tables from 100 GB dbfiles ( dbspace1 ) to 500 GB dbfiles ( dbspace2 ).
- CPU gets quite loaded with single table relocation operation
- Mostly unresponsive if more then 3 “alter table … move” statements are issued concurrently
Read more...
Environment
- SAP IQ 16.0
- SAP IQ 16.1
Product
SAP IQ 16.0 ; SAP IQ 16.1
Keywords
hang, stuck, performance, slow, slowness, lock, s_blockmap::AlterMoveData, hos_compress::CmprsLZRW1 , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed
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.