Hi All,
I have created one sequence, where independent jobs are running parallely(no dependency link).
In the sequence I will have max 100 db2 connection at a time.
Total no. of connection is set to 200 on db2 server.
But sometime I am getting following error.
POD_Elc_Load_Mst_Hist_Audit..DB2_Read_Source_Row_Count: [IBM][CLI Driver] SQL1040N The maximum number of applications is already connected to the database. SQLSTATE=57030
Just your connections might be 100, there might be other applications connected to the database at the same time. Take this error to your DBA so that he can analyze the number of open connections during the time this error occured and increase the maxappls.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Been switching back and forth between server and px questions so much that this time the switch couldnt happen. For some reason I thought you were on px. Anywho, my bad.
Get together with your dba, and ask him to monitor the number of connections that hit the database at a particular time. If your getting this error, obviously the limit is being reached.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
More line one connection per link going to a database stage. So if you have two links going to a database stage, two connections will be request. Right
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Let's put it this way - it only needs to open 1 connection per stage to do its work, and that's the behaviour I've seen with the stages I use. Now, if the DB2 stage does something stoopie... [shrug]
-craig
"You can never have too many knives" -- Logan Nine Fingers