I am new in datastage enviroment so please be detail in your solution
DataStage freezes when he loads data from IQ to SQL Server tables for a 1000 rows.He used source stage,transformer then to a flat file,that works fine but from flat file to sql server then datastage freezes.He stops all the jobs and note there is no option for Ctrl-alt-delete in unix.He stops everything and start all over but it continues to freezes.
Please help
DataStage freezes when i loads data from IQ to SQL Server
Moderators: chulett, rschirm, roy
More Details Needed
Can you provide more specifics, like Db Connection (ODBC, etc). Your environment details as well and exactly what happens when it "freezes".
odbc->tranfomer->flat file->transformer->odbc the problem start when it goes to the last odbc it freezes.if i take out the last odbc then it works fine.
using odbc(IQ data warehouse.The source is over 1million rows but the target is to get the last 30 days of information.There is a constrain for that.
It freezes when it suppose to load to the database using odbc stage but i change it to a flat file then it works.
thank you
using odbc(IQ data warehouse.The source is over 1million rows but the target is to get the last 30 days of information.There is a constrain for that.
It freezes when it suppose to load to the database using odbc stage but i change it to a flat file then it works.
thank you