Datastage job hangs after main_program: orchgeneral: loaded;
A simple Datastage job: Read the data from SQL server and write (Truncate and insert) into SQL server.
SQL Server Enterprise Stage --> Transformer --> SQL Server Enterprise Stage is the job design.
It is running for more than 24 hrs and noticed the below details in the log.
Starting Job <Job name>.
Environment variable settings:
Parallel job initiated
OSH script
# End of OSH code
Parallel job default NLS map ASCL_MS1252, default locale OFF
main_program: IBM WebSphere DataStage Enterprise Edition 8.1.0.5447
Copyright (c) 2001, 2005-2008 IBM Corporation. All rights reserved
main_program: conductor uname: -s=Windows_NT; -r=2; -v=5; -n=ServerName; -m=Pentium
main_program: orchgeneral: loaded
orchsort: loaded
orchstats: loaded
After that no progress and job is in running status.
It will be great of any one have
Thanks in Advance,
Ds User
Datastage job hangs after main_program: orchgeneral: loaded;
Moderators: chulett, rschirm, roy
Something happened on that time in Database level
I understood the query is suspended as per the log in Database. But no one did it and it happened for some reasons I guess. I will investigate in detail and update the status.
Thanks
DS_User
Thanks
DS_User