0

I need help with an issue which I am facing.

This is the error message I get:

Exception: [IBM][CLI Driver] SQL30020N Execution of the command or SQL statement failed because of a syntax error in the communication data stream that will affect the successful execution of subsequent commands and SQL statements: Reason Code "0x124C"("0214")"". SQLSTATE=58009 SQLCODE=-30020

This is an intermittent issue which I face when running my API's.

Can someone please help me understand what is causing this error and how can it be fixed?

Improve this question
4
  • this may help Commented Apr 19, 2020 at 19:40
  • Hi @sahasrara62, i did see this page but it doesn't have any clear resolution. I face the above error message 20-30% of the times and the API works perfectly the remaining time. I am using the package ibm-db-sa in my code, is there something i am missing? Commented Apr 19, 2020 at 20:13
  • Connecting to DB2 using ibm_db python library. Also see this: How to connect Python to Db2?. This may help, but partially. Commented Apr 19, 2020 at 21:36
  • Usually this symptom is configuration related. Your question has zero details about your configuration. EDIT your question (do not use comments to add facts), to add: (1) your Db2-server operating system (Z/OS, i-series, Linux/Unix/Windows, and the Db2-server version/modificiation/release (2) your client side operating system, name/release/edition, (3) the name and version of the Db2-driver that you are using on the client side. Commented Apr 20, 2020 at 8:18
Related questions
8
How to use mysql.connection db pool with python flask
0
Connect Python Flask web server application to DB2
1
Setting Up Flask DB2 connection
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.