DSXchange

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

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

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