03-16-2017 03:40 AM
We have scheduled One flow which run through LSF and one job in that flow which is running from last 8 hours. Usually it took only 1 hour but today it is taking more than 10 hours and this same job/flow has been running successfully from last 2 years and no changes has been made also.
i want to know where this job is runnig ? this there any to find out where sas di job is running ?
SAS DI job consist only user wrriten code and in that it is taking data from source and updating it through sas code only.
03-16-2017 04:09 AM
03-16-2017 08:29 AM
Oh, I assumed when you asked on which host the batch was running on, that you had a grid.
So then there's just one host chose from, or do I miss something...?
03-17-2017 07:41 PM - edited 03-17-2017 07:48 PM
Once you found the SAS log the first thing I'd be looking into:
1. are there much higher data volumes than usually (i.e. after a bad data load into source)
2. bad data loaded resulting in many to many relationships where the code expects it to be 1:1 or 1:m
3. has anything structurally changed in the data source or data target
- disabled, removed or changed index
- change to a column (i.e. change from VARCHAR5 to VARCHAR4000)
- additional columns and somewhere in the SAS code a SELECT *
Comparing the real times between a "good" and the "bad" SAS log should tell you which step needs further investigation.
I'd probably also check if there had been any maintenance work going on (like a massive backup process on the target DBMS).