Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
gooogle
Participant
Posts: 42 Joined: Tue Feb 23, 2010 3:40 pm
Post
by gooogle » Tue Aug 16, 2011 9:22 am
I created a job that loads a SQL > Transformer > Netezza table, after truncate & loading the table, the jobs gets stuck in the running status in director after loading the target table.
Any ideas ...
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Tue Aug 16, 2011 9:26 am
First task would usually be to trace the processes on the database side, see if there are locks / blocks there causing the 'hang'.
-craig
"You can never have too many knives" -- Logan Nine Fingers
gooogle
Participant
Posts: 42 Joined: Tue Feb 23, 2010 3:40 pm
Post
by gooogle » Tue Aug 16, 2011 12:52 pm
What exactly should I check ...
The job is still getting stuck in the Running status.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Tue Aug 16, 2011 1:28 pm
"On the database side" means you have your DBA check for you. Let them know what table(s) it is accessing and/or the connecting user.
-craig
"You can never have too many knives" -- Logan Nine Fingers
vijaykumarpj
Participant
Posts: 30 Joined: Sat Dec 19, 2009 5:19 am
Location: Manchester, UK
Post
by vijaykumarpj » Mon Aug 22, 2011 1:47 pm
Also, try clearing the status of the job, thru DS Director.. then, re run the job.
Thanks,
VJ.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Mon Aug 22, 2011 3:18 pm
You would only do that if you knew the job was not actually running.
-craig
"You can never have too many knives" -- Logan Nine Fingers
SURA
Premium Member
Posts: 1229 Joined: Sat Jul 14, 2007 5:16 am
Location: Sydney
Post
by SURA » Mon Aug 22, 2011 6:36 pm
Check the version compatibility.
DS User