Hi All
We are using Datastage 7.5.2 in Unix Platform and the database is DB2 8.2.3.
So far everything was working fine and recently in our datastage jobs we find that, the ODBC stage used in jobs has got ssome problem when we try to view data from teh same.
When we click on View data button on the ODBC stage,whole datastage hangs totally and final nothing is visible.
But using a DRS stage View data is working fine with no issues.
Can anyone help us in reslving this?
A small clue also would be highly Appreciated.
Thanks in Advance!!!!
Unable to View data using a ODBC stage
Moderators: chulett, rschirm, roy
-
Sainath.Srinivasan
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
You can try out following things !
1. When you fire your query on database, whether it works fine.Check the cost of the query.
2. Is there any other job using ODBC stage in your project.Check what are the properties set for that particular stage.There might be some property which you have set incorrectly causing that stage to hang.
Hope this helps !
1. When you fire your query on database, whether it works fine.Check the cost of the query.
2. Is there any other job using ODBC stage in your project.Check what are the properties set for that particular stage.There might be some property which you have set incorrectly causing that stage to hang.
Hope this helps !
-----------------------------------
Regards
MK
What would you attempt to do if you knew you could not fail?
-----------------------------------
Regards
MK
What would you attempt to do if you knew you could not fail?
-----------------------------------
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Is there any update of the db2 database environment,such as ipaddress/hostname/credentials.etc.
It seems there is something wrong with the .odbc.ini file or uvodbc.config file loacated at "$DSHOME" .......
It seems there is something wrong with the .odbc.ini file or uvodbc.config file loacated at "$DSHOME" .......
sri85 wrote:Ray
The DB type we use is IBM DB2.
Bobyon
We have configured both the files.its has been working fine quite some time .
mk_ds09
Query in DB and any other Jobs using the ODBC stage is working fine.
Sainath.Srinivasan
The New Job also shows the same behaviour.
Please Help is in resolving this.
Let's Progress Together....