SAP Knowledge Base Article - Preview

2465529 - sp_jdbc_getprocedurecolumns cause contention and CPU at 100% – SDK for SAP ASE


  • Performance degradation (CPU at 100%)
  • Contention in sysusers
  • JDBC script updated
  • Many processes running the system procedure called "sp_jdbc_getprocedurecolumns"
  • The problem occurs with the connections coming from WebSphere



  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Sybase Software Developer Kit (SDK) 15.7
  • JConnect
    • JDBC 7.07
  • IBM WebSphere


SAP Adaptive Server Enterprise 15.7 ; Sybase SDK 15.7


get procedure columns, CR806179, 806179, CR#806179, jconn, jconn4, jconn4.jar , KBA , BC-SYB-SDK , SDK , 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.