SQL commands in SQLRPGLE programs causing ibm_db.connect (from ibm_db library) to fail for new connections

[ibm]

SQL commands in SQLRPGLE programs causing ibm_db.connect (from ibm_db library) to fail for new connections

[kadler]

This is a strange sounding bug. Can you please list the version of itoolkit, ibm_db, Python, and IBM i you are running on. Also, which transport are you using to connect in itoolkit?

[edmundpf]

This is a strange sounding bug. Can you please list the version of itoolkit, ibm_db, Python, and IBM i you are running on. Also, which transport are you using to connect in itoolkit?

Python: 3.4.6
itoolkit: 1.2
ibm-db: 2.0.5.4
IBMi: V7R3M0 L00

Using iToolkit as follows:

self.itool = iToolkit(iparm=0, iret=0, ids=1, irow=1)
self.itransport = iLibCall()
self.itool.add(iPgm('pgm_call', 'SQLRPGLE_PGM_HERE'))
self.itool.call(self.itransport)

[kadler]

So, I take it you're running with the versions that we initially shipped with OPS?

I'm at a loss as to how this could be occurring. You're using iLibCall, which does not use ibm_db at all. Are the ibm_db connection failures occurring in the job that's running iToolkit or in a different job?

[edmundpf]

They're happening in the ibm_db connection somehow, very strange indeed. I haven't been able to narrow down the commands in the SQLRPGLE program causing this (no minimal SQLRPGLE code found yet). I do know the program called uses service programs, and SQL, this has been our first program we've called with iToolkit using these and it's uncanny that it will consistently cause these seemingly unrelated issues. I'll let you know if I can identify a minimal RPG example to cause what I'm experiencing

[jkyeung]

I don't know how SQLRPGLE figures into this, but it sounds suspiciously like a server mode issue to me.

[kadler]

@edmundpf did you ever figure out the problem here?