I mentioned earlier, what I want, or what I am trying to accomplish..
This is what I found based on my research so far:
By default DB2 creates 3 packages when you do the cli binds, these three packages together provides the capability of a total of 1344 open cursors. In my case due to some funky application code, the 1344 open cursor limit is exhausted and I was looking to find ways to increase them... ( this is what I was trying to accomplish)
The quick fix is to increase the number of packages and thereby increase the total limit on the number of open cursors.. The packages have a limit, you cannot take that higher than 30 which represents 11712 concurrently open cursors...
The real fix is to come from the application folks.. Do they really need so many open cursors? A code fix is in order: