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

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

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

KBA , BC-SYB-SDK , SDK , Problem