DB2 AS/400 Connectivity Issue
Posted: Thu Nov 18, 2004 8:49 am
We are acessing a DB2 database on a AS/400 box using the client access ODBC driver. We were able to setup the connectivity and continue development, but all of a sudden Datastage was not able to connect to that dtabase anymore. The jobs would simply hang when trying to connect to it.
I was however able to connect using the very same DSN using other SQL tools.
We tried rebooting the ETL server, a soft reboot didnt do the trick, but when we powered off the box and brought it back it worked and we were able to connect without any problems.
All of a sudden the problem is back today. Obviously we cannot keep hard-rebooting a box all the time.
Any ideas why this problem is occuring ?
I was however able to connect using the very same DSN using other SQL tools.
We tried rebooting the ETL server, a soft reboot didnt do the trick, but when we powered off the box and brought it back it worked and we were able to connect without any problems.
All of a sudden the problem is back today. Obviously we cannot keep hard-rebooting a box all the time.
Any ideas why this problem is occuring ?