Issue With Join Stage while joining header and detail record

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

Post Reply
ramsubbiah
Participant
Posts: 40
Joined: Tue Nov 11, 2008 5:49 am

Issue With Join Stage while joining header and detail record

Post by ramsubbiah »

Hi All,

Issue:
we are encountering a new issue with Join stage while combining the header and detail xml record.

Error Information:
node_node2: Player 22 terminated unexpectedly.
main_program: APT_PMsectionLeader(3, node2), player 22 - Unexpected termination by Unix signal 11(SIGSEGV)


Additional Information:

The size of details record is around 13 mb, the header record is very small,
we trying to make it as single xml after the join stage by using a dummy column which will always have value as "1".

is there any issue with scratch memory?

please advice me on the above issue.

Thanks,
Ram
Knowledge is Fair,execution is matter!
SURA
Premium Member
Premium Member
Posts: 1229
Joined: Sat Jul 14, 2007 5:16 am
Location: Sydney

Re: Issue With Join Stage while joining header and detail re

Post by SURA »

I am not sure how much this will help.

Add APT_NO_JOBMON for that job and make it as true and give a try.

DS User
ramsubbiah
Participant
Posts: 40
Joined: Tue Nov 11, 2008 5:49 am

Re: Issue With Join Stage while joining header and detail re

Post by ramsubbiah »

Hi SURA,

Thanks, i will test the job by using the above variable and let you know the outcome.

Thanks,
Ram.
Knowledge is Fair,execution is matter!
ramsubbiah
Participant
Posts: 40
Joined: Tue Nov 11, 2008 5:49 am

Re: Issue With Join Stage while joining header and detail re

Post by ramsubbiah »

Hi Sura,

i tried with your approach but still i am geting the same error message.

Thanks,
Ram
Knowledge is Fair,execution is matter!
SURA
Premium Member
Premium Member
Posts: 1229
Joined: Sat Jul 14, 2007 5:16 am
Location: Sydney

Re: Issue With Join Stage while joining header and detail re

Post by SURA »

Sorry friend.

As i remember, in one of the project a job used to get killed because of the volume. Then i was advaised to use this variable and then it went smoothly and i guess this will help. Anyhow Real gurus will give good solution.

Meanwhile ask with your unix admin to track while you run this job. as the kill command is getting from unix, they can tell some useful info.

DS User
ramsubbiah
Participant
Posts: 40
Joined: Tue Nov 11, 2008 5:49 am

Re: Issue With Join Stage while joining header and detail re

Post by ramsubbiah »

Hi SURA,

No issues, thanks for your clarification, i will ask my admin to track the memory utilization.

Thanks,
Ram.
Knowledge is Fair,execution is matter!
Post Reply