Datastage job hangs after main_program: orchgeneral: loaded;

[SURA]

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

[chulett]

Have you checked with your DBA, seen what's going on in your target database? I would guess some kind of locking...

[SURA]

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