IQ becomes extremely slow while dropping several users in short time period.
These are temporary users created for summer interns or application testing.
Each temporary user has membership in several groups and permissions on several tables.
While dropping these users in a batch, along with extreme slowness, System administrator may see just one core being used out of several cores on the box.
pstack captured while IQ is hang-like condition will show one or multiple threads with following stack frames.
performance , extremely slow , hang , pstack , MainHeap::Free , RoleInfo::~RoleInfo , CheckManageRolesPrivs , checkRecurse , CheckRBAC ,
dbi_load_table_perms , reload_table_permissions , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed
About this pageThis 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.