Open KalyanMolakalapalli opened 6 days ago
Can someone take a look into this issue and let us know what we should need to do to resolve the performance issue of ibm_db
@KalyanMolakalapalli I think you observe more time consumption for large data because nodejs need to store all data in memory as an object and then return to the caller. To avoid it, you can try prepare, execute and then fetch() in a loop as in the example of fetchSync() API here
Also, to avoid buffering of data in nodejs memory, you can use queryStream() API in your program as used in test-queryStream.js test file. Try these methods and let me know your observations. Thanks.
thankyou @bimaljha will work on the above solutions.
Please provide below information while opening an issue to understand your problem
db2level
command from Db2 database system:For non-Windows system, output of below commands from terminal:
uname uname -m node -v npm ls ibm_db db2level echo $IBM_DB_HOME echo $PATH echo $LD_LIBRARY_PATH $DYLD_LIBRARY_PATH
For Windows system, output of below commands from windows command prompt:
node -v 20.14.0 npm ls ibm_db ibm_db@3.2.4 db2level 2.7.1 echo %IBM_DB_HOME% node_modules\ibm_db\installer\clidriver echo %PATH% echo %LIB%
Please provide below problem specific info:
=========================================
For Installation related issue
npm install ibm_db
command.For Connection related issue - connection is good , retrieving the data from DB2 is taking 20 sec for 11K records
SSLServerCertificate
keyword in connection string or using your own keystore db?ibm_db/test/config.json
file and share complete output of below commands:db2cli validate
command in fileibm_db/installer/testODBCConnection.bat
for windows oribm_db/installer/testODBCConnection.sh
for non-Windows. Then executetestODBCConnection.bat
from Administrator command prompt on Windows ortestODBCConnection.sh
script from terminal on non-Windows and share complete output of script along will all generated 1.* files in zip file.db2cli validate
command.For SQL1598N Error
For other issues
1. 2.