SORT stage error

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
avi2kus
Participant
Posts: 4
Joined: Tue Dec 20, 2005 12:32 am
Contact:

SORT stage error

Post by avi2kus »

When iam running the Server Job on windows iam getting below mentioned warnings. i know these warnings came due to the SORT Stage.
but i don't know why these warnings coming.In SORT Stage we are using #$TMPDIR#. Location of TMP DIR is we are using some location.

I mentioned some valid reasons why these warnings coming.but iam not sure about those reasons.any one please look into this and let me know through reply post.

Valid Reasons :

1. May be no more space in that directory.?
Comments on reaosn 1: (But if it space problem it will run at least 1 or 2 records.but for 1 or 2 records also it;s failing. and we deleted all files in that directory and tried to ran..but that time also it's failing due to SORT stage.)

2. May be we don't have write permissions.? (But admin also(which one having the write permissions) getting same warnings)

when iam going to ran the job with out using #$TMPDIR# in SORT stage,then it's ran successfully with out any warnings.


Fatal: Datastage..SORT: File '/etl/dev/common/tmp/solDEkEa/ipf__1' write error
Warning: Attempting to Cleanup after ABORT raised in stage Datastage..SORT
Warning: Datastage..SORT.ILNK_file1_sort: ds_ipcflush() - Error in mutex_unlock() - Not owner
Warning: Datastage..SORT.ILNK_smp_ro_account_sort: DSD.INTClose Error 11 in GCI close.
Warning: DataStage Job 1292 Phantom 16440
Datastage..SORT.ILNK_file1_sort: DSD.INTClose Error 11 in GCI close.
DataStage Phantom Finished.


Can u let me know why these warnings coming.....ASAP....
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The errors appear to be coming from the IPC mechanism rather than from the Sort stage. Are you using row buffering or IPC, Link Collector or Link Partitioner stages? If so, try constructing the job without them, to see whether that cures the problem.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

What is the stage prior and after the Sort stage?
Is this the value "/etl/dev/common/tmp/solDEkEa/" that has been assigned to the Environmental variable?
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Post Reply