I have a dataStage installed in an AIX machine. The source DB2 database is in AS400. After installing the DB2 connect in the AIX, we are able to connect and see the tables in the AS400 using DB2 command line.
I use DataStage Manager and DB2 plug-in, I can see the database and the list of tables in the DB2/400, after specifying the user name and password then click OK. It just hang there. How can I solve the problem? My problem is I cannot import the table definition of the db2/400 tables. Please advice.
DataStage and DB2 in AS400
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
That is the truth!!!
You can configure the client software (or ODBC driver) with filters that limit what is retrieved to the smallest reasonable set of table names.
You can configure the client software (or ODBC driver) with filters that limit what is retrieved to the smallest reasonable set of table names.
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.
Hi,
You might also recheck the default library/package that the used user gets to and make sure it is pointing to a real DB and not some arbitrary directory with (as mentioned) huge amounts of files.
I have seen cases that improper configuration caused the mentioned behaviour.
p.s.
make sure your first try is using a real working user on the AS400 and not a new one they built for you.
IHTH,
You might also recheck the default library/package that the used user gets to and make sure it is pointing to a real DB and not some arbitrary directory with (as mentioned) huge amounts of files.
I have seen cases that improper configuration caused the mentioned behaviour.
p.s.
make sure your first try is using a real working user on the AS400 and not a new one they built for you.
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org