DSXchange

/dev/null also means write to a black hole

Normally when both DataStage and JobMonApp are running and JobMonApp stops, you dont have to stop DataStage. You can restart JobMonApp again on its on. The reason why I suggested the clear sockets command, was because you stopped and restarted DataStage. To eliminate any problems before restarted Da...

Sometimes by restart DataStage doesnt always clear the sockets.

Before restart DataStage, issue a uv -admin -clearesockets command. This is because sockets get block and had to force to clear.

See if this works.






-----------------------------------
Many ways to solve a problem

In UV, type listu to find out how many users are connected or in unix, who -R In UV, try this. SELECT @ID FMT '60L' FROM DS_LICENSE; Else call your software provider support, they can tell you. -------------------------------------------------------------------------------------- Throw a lucky man i...

Is row 1,198,231 the last row in the file? Anyway you can do this. 1. $ head -n 1198230 <inputfilename> > <outputfilename> This will give you all the rows except the one that it fails on. If after running, this does work, then you have badly a delimited file, where one of the columns hasnt got a com...

Or better still try

ps -aef | grep APT_ORCHHOME=${DSHOME}/../PXEnginejava/jre/bin/PA_RISC2

You should see this running.



----------------------------------------------------------------------------------
Throw a lucky man in the sea and he would come up with a fish in his mouth

One other thing you can do is select the option "clear file before write" on the hashed file stage. I believe you have run this many time. The other thing is to give the hashed file a different name with the "clear file before write" option and see what happens. Ralleo The only m...

You can also run list_readu on the command line assuming you are using unix and the DataStage is set up correctly. This generates a report to stdout and tells you the user for that job. You can then unlock the userno number Alternatively type who -R. This would tell you datastage users. Ritchie ----...

In your transformer, create a stage variable to test the number of characters in RETAIL column, i.e. if len(trim(RETAIL) > 5 Then "N" else "Y". Use this as a constraint and write to to a sequential file. You can then view the values to see why they are failing. Ritchie. ---------...

With the first error message, I have come across some server error messages where if the fieldname or header , i.e. RETAIL, 6 character is longer than your defined column width 5, you get such errors. Trying increasing it to 6 and see what happens. Are you reading from a comma delimited file to a fi...

In addition to the above, are you running QualityStage as a stand alone or from within DataStage. If from within DataStage, check whether you have registered the plug-in, i.e. Go to DataStage Manager ->Tools -> Register PlugIn. Also as Bob said, what have you got in your mngr.cfg file. This is norma...

Do a ps -ef|grep qs on command line, to find out if QualityStage is running. you should see qsrtmngr - which provides the interfaces between DataStage and QualityStage and qsserv which executes QualityStage Jobs Quote: ---------------------------------------------------------------------------------...

Hi I have a Protected project in v7.1r2, using Protect Project in Administrator .This makes the project read-onlyand no changes can be made to jobs. However, it appears user can delete individual jobs within this protected project. I can verify this as I have tried it myself. Although I have given u...

As Ray said, DSD.RUN is the command DataStage uses to run server jobs. Historically, the DataStage Engine (Universe) was a screen-oriented shell. Consequently, it will periodically send text to stdout and/or stderr. Examples are run-time error messages (divide by zero illegal in Server Jobs for exam...

DSguru2B wrote:Different engines, different methadologies. PX has a stronly typed language like C. It is particular about variable meta data which for us is column metadata. ...

Thanks for for expanding on that.

Ritchie