SAP Knowledge Base Article - Preview

2542381 - No new connections allowed on SAP IQ server

Symptom

No new connections are allowed.
SAP IQ server performance comes down to a crawl and appears to be in a hung state.
Executing pstacks on the server will show multiple threads executing "dbi_alter"

void hos_condvar::Wait                     
void st_database::GetSaintForbidLatch      
int st_connection::GetIQForbid             
unsigned long long st_txnMgr::PrepareToCommi
void db_PrepareToCommit::Execute           
void st_command::DoCmdThroughResourceGate  
unsigned st_iqtxn::PrepareToCommit         
UIQTxn_PrepareToCommit                     
void st_SAIQInterfaceInfo::callFunction    
void st_SAIQInterface::RunIQFunc           
void st_SAIQInterface::Execute             
void saint_iqthresholdtxn::PrepareToCommit 
void DB_Commit_Chgs                        
unsigned ri_commit                         
unsigned _ri_pre_commit                    
void dbi_alter


Read more...

Environment

SAP IQ 16.1

 

Product

SAP IQ 16.1

Keywords

 Sybase , 15.4 , IQ 15.4 , CR810903, CR#810903, 810903 , hang , deadlock , 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.