SAP Knowledge Base Article - Preview

2792681 - Poor performance from isql when used with -X option

Symptom

When we traced isql with -X using strace utility on the container, there are many system calls made to all the files in /usr/bin. This takes a long time and causes us performance problems with the application. Example from Linux (not in a container ... but the strace() is the same):


$ echo -e "" | strace isql -Usa -P<password> -SSID -Dtestdb -X 2>&1 | grep -i 'open("' | grep '/usr/bin'
open("/usr/bin/gtroff", O_RDONLY) = 8
open("/usr/bin/catchsegv", O_RDONLY) = 8
open("/usr/bin/nroff", O_RDONLY) = 8
open("/usr/bin/toe", O_RDONLY) = 8
open("/usr/bin/gencat", O_RDONLY) = 8
open("/usr/bin/neqn", O_RDONLY) = 8
open("/usr/bin/tput", O_RDONLY) = 8
open("/usr/bin/getent", O_RDONLY) = 8
open("/usr/bin/pic", O_RDONLY) = 8
open("/usr/bin/tset", O_RDONLY) = 8
open("/usr/bin/iconv", O_RDONLY) = 8
open("/usr/bin/view", O_RDONLY) = 8
...
open("/usr/bin/ldd", O_RDONLY) = 8
open("/usr/bin/yum", O_RDONLY) = 8
open("/usr/bin/setup-nsssysinit", O_RDONLY) = 8
open("/usr/bin/mkinitrd", O_RDONLY) = 8

$ isql -v SAP CTISQL Utility/16.0 SP03 PL04/P-EBF27920/DRV.16.0.03.04/Linux x86_64/Linux 2.6.18-128.el5 x86_64/BUILD1600-021/64bit/OPT/Sun Apr 15 18:31:29 2018


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE)
  • SAP Adaptive Server Enterprise (ASE) Software Developer Kit (SDK) 16.0 SP03

Product

SAP Adaptive Server Enterprise 16.0

Keywords

KBA , BC-SYB-SDK , SDK , Problem

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.