Hi,
I am using ODBC as target stage for loading data into Mainframe DB2 database.While running the job i got below error msg
main_program: Fatal Error: Could not connect to datasource[DataDirect][ODBC DB2 Wire Protocol driver]Connection to application server DB2DSN would exceed the installation-defined limit.
Pls help me out to resolve this issue.
Thanks,
Raj.
ODBC stage
Moderators: chulett, rschirm, roy
ODBC stage
Raj
-
- Premium Member
- Posts: 138
- Joined: Wed Jul 16, 2008 9:51 pm
- Location: Kolkata
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Did the error message include SQLSTATE and DBMS Code? If so, you might search for these on the internet.
It seems to me that there is a finite limit imposed on the mainframe application server on the number of concurrent connections, and your connection attempt was thwarted by that limit already having been reached.
It seems to me that there is a finite limit imposed on the mainframe application server on the number of concurrent connections, and your connection attempt was thwarted by that limit already having been reached.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.