SAP Knowledge Base Article - Preview

2333505 - jConnect: sp_drv_getcomment is doing a table scan on syscomments table - SDK for SAP ASE


  • sp_drv_getcomment causes a bad ASE plan
  • sp_drv_getcomment is responsible for about half a billion logical i/os every hour
  • Leads to performance degradation



  • jConnect
    • JDBC 7.07
  • SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0
  • SAP Sybase Software Developers Kit (SDK) 15.7
  • SAP Software Developers Kit (SDK) for Adaptive Server Enterprise (ASE) 16.0


SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise SDK 16.0 ; Sybase SDK 15.7 ; Sybase Software Developer Kit 15.7


Java, SDK, isql, stored procedure, ODBC, MDA, CR#797002, CR797002, 797002, CR#790811, CR790811, 790811 , KBA , BC-SYB-SDK , SDK , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.