DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
atul9806
Participant



Joined: 06 Mar 2012
Posts: 96
Location: Pune
Points: 840

Post Posted: Fri Nov 25, 2016 7:43 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: v11.5
Hi Guys,

We have an ISD enabled parallel job which is calling a Sequencer with the help of Job Controller, now the problem is whenever we are trying to compile the Sequencer, it says, it is being monitored even after undeploying ISD service.

Job flow is something like below --
ISD Service --> Parallel job (Job Crontroller)--> Sequencer Job

Here, Parallel job is only having Job controller code which is triggering the Sequencer. Admin team is unable to trace the locks and restarted the DS services to unlock the job but this is not a feasible solution in PROD

Kindly suggest if someone faced this issue before.

_________________
~Atul Singh
DataGenX | LinkedIn
JRodriguez



Group memberships:
Premium Members

Joined: 19 Nov 2005
Posts: 413
Location: New York City
Points: 4531

Post Posted: Fri Nov 25, 2016 8:39 pm Reply with quote    Back to top    

Did the admin team try to clear the locks with the cleanup_abandoned_locks.sh utility from /opt/IBM/InformationServer/ASBServer/bin? This might help specially if they can not see an active session in the webconsole or via the traditional Unix commands

_________________
Julio Rodriguez
ETL Developer by choice

"Sure we have lots of reasons for being rude - But no excuses
Rate this response:  
Not yet rated
atul9806
Participant



Joined: 06 Mar 2012
Posts: 96
Location: Pune
Points: 840

Post Posted: Sat Nov 26, 2016 5:49 am Reply with quote    Back to top    

No, in version 11.5 this script is not available.

_________________
~Atul Singh
DataGenX | LinkedIn
Rate this response:  
Not yet rated
JRodriguez



Group memberships:
Premium Members

Joined: 19 Nov 2005
Posts: 413
Location: New York City
Points: 4531

Post Posted: Sat Nov 26, 2016 9:43 am Reply with quote    Back to top    

...try below from same location

./xmetaAdmin.sh cleanupAbandonedLocks -dbfile ../conf/database.properties

Notice that you could also list and kill all user and trusted active sessions, including the sessions that are not visible from the web console, using the SessioAdmin.sh utility from same directory, but you are trying to clean up locks in production environment .. just need to be sure and extra careful

_________________
Julio Rodriguez
ETL Developer by choice

"Sure we have lots of reasons for being rude - But no excuses
Rate this response:  
Not yet rated
atul9806
Participant



Joined: 06 Mar 2012
Posts: 96
Location: Pune
Points: 840

Post Posted: Sat Nov 26, 2016 11:16 pm Reply with quote    Back to top    

Thanks Julio, I'll ask my admin team to execute this script and update with the outcome.

But any idea why my sequncer is getting locked? This sequencer is not being called by the service as design is:
service --> parallel job(job controller) --> this sequencer

_________________
~Atul Singh
DataGenX | LinkedIn
Rate this response:  
Not yet rated
JRodriguez



Group memberships:
Premium Members

Joined: 19 Nov 2005
Posts: 413
Location: New York City
Points: 4531

Post Posted: Mon Nov 28, 2016 7:10 am Reply with quote    Back to top    

The most common cause for DataStage jobs to get locked is leaving them open or force them to terminate, but your issue is in production environment where you wouldn't need to compile your jobs unless is your standard practice

What's the topology of your ISD job? I would guess that it executes the DS Sequence one to completion...right? Is the job Sequence defined as multi instance? Give us more details to be able to figure out the root cause of your locking issue

Regards

_________________
Julio Rodriguez
ETL Developer by choice

"Sure we have lots of reasons for being rude - But no excuses
Rate this response:  
Not yet rated
atul9806
Participant



Joined: 06 Mar 2012
Posts: 96
Location: Pune
Points: 840

Post Posted: Tue Dec 06, 2016 7:26 am Reply with quote    Back to top    

JRodriguez,

My service is invoking a parallel job which has a job controller. This job controller code is calling a sequencer which calls other job
After successful completion of sequencer , it will generate a status file, which has been returned by the service on display to invoker.

Service --> Parallel job (Job Controller) ---> Sequencer ---> Generate Status file ---> Read by Parallel job (Job Controller) ---> return the status to Invoker

_________________
~Atul Singh
DataGenX | LinkedIn
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours