STAGE has unexpected STATUS value

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

STAGE has unexpected STATUS value

Post by roy »

Hi,
I have a DRS performing select max for a column to a Xfm poping a user status and outputing to /dev/null.
it was working fine till recently we started getting
the above message and the job aborts.
(searcing for the entire error got 4 results all leading to a forum page but no real post).

Thanks in advance,
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Roy - not sure what you mean by "select max for a column to a Xfm poping a user status and outputing to /dev/null". :? You might want to give more details on that.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

I think he means writing the output to user status and connecting the link output to a (dummy) seq file with name as /dev/null in order to ignore any output from it.

Roy,

Did you check whether any value is populated into the user status?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Ok, I could see that. In addition to what was already asked, how exactly is the value getting 'popped' into the status area?
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Something strange has been written, or failed to be written, to the RT_STATUSnn file record for that stage in the job. Clearing the status file for the job should remedy 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.
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Thank for the replies All,

After some "changes"/recompiles and such it started working.

I'll try clearing the ststus file Ray next time :),
I still need to verify this being persistant and not a random fluke now and then.

(yes you got the idea Sainath.Srinivasan, I can't recall if it did :roll:, if I get the answer to that I'll update this post)

Thaks Guys :),
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Recompiling, among many other things, does have the effect of resetting stage information in the status file. Or causing another wave number to be used next time the job is run, depending on internal conditions, which I'd prefer not to discuss.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply