Strange Issue - Datastage Going down
Moderators: chulett, rschirm, roy
Strange Issue - Datastage Going down
Hi
We have created a new job which will fetch the data from flat file and loaded into Oracle table which is there in the same box.
When we run this Job, it runs for some time and later the entire Datastage apps is going down. We cannot able to login to datastage.
Tried to running on multiple servers like Development and Production. Same thing was happened.
File size is aroung 9lacks records.
Commit Interval is 0.
Version: 7.5 Server Edition.
Can any help me out to resolve this issue.
We have created a new job which will fetch the data from flat file and loaded into Oracle table which is there in the same box.
When we run this Job, it runs for some time and later the entire Datastage apps is going down. We cannot able to login to datastage.
Tried to running on multiple servers like Development and Production. Same thing was happened.
File size is aroung 9lacks records.
Commit Interval is 0.
Version: 7.5 Server Edition.
Can any help me out to resolve this issue.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Very difficult to predict with limited information supplied. It is similar to saying 'Everytime I start my car, it breaks down'.
Is there a before / after routine or calls from transformer that may stop ?
Is it writing to some restricted structure ?
Are you running when the system is hit hard by other processes ?
What about any other similar jobs ?
If you cannot resolve in simple steps, run the Unix trace to see the system calls.
Is there a before / after routine or calls from transformer that may stop ?
Is it writing to some restricted structure ?
Are you running when the system is hit hard by other processes ?
What about any other similar jobs ?
If you cannot resolve in simple steps, run the Unix trace to see the system calls.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
What do you mean that you cannot find the log? What is meant here is the output from the job and is visible in the Director for that job.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Few years back I had seen a similar thing happen in one of the projects. On investigating the issue it was found that in the DataStage flow a Unix delete command was being fired rm * and it was deleting some internal set up files as it did not have the right path specified.
..Good Stuff .. :D ..i hope you dont have that happening!!
..Good Stuff .. :D ..i hope you dont have that happening!!
I still cannot understand the exact problem.
Can you change your job to write to a sequential file or PEEK stage, does that work correctly? If yes, then the cause is most likely in the Oracle portion. Do you have specific SQL in Oracle?
Can you change your job to write to a sequential file or PEEK stage, does that work correctly? If yes, then the cause is most likely in the Oracle portion. Do you have specific SQL in Oracle?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 81
- Joined: Tue Aug 15, 2006 8:31 am
- Location: Zürich
- Contact:
Hi Prasad,
Try deleting the job from your live environment. Import the job again from your development environment and share the results.
"The Datastage app is going down" is not understood. Your machine could have been occupied by the Oracle load process and no user is allowed entry; this is quite possible.
-Abhijit
Try deleting the job from your live environment. Import the job again from your development environment and share the results.
"The Datastage app is going down" is not understood. Your machine could have been occupied by the Oracle load process and no user is allowed entry; this is quite possible.
-Abhijit
-
- Participant
- Posts: 102
- Joined: Thu Sep 17, 2009 1:23 am