DSXchange

Hello NewPX, the search clauses 'range lookup' or 'select BETWEEN' will get you on your way. There really are quite a few threads and many posts on this subject -- is it a particularly common issue found in most implementations and has many different ways of approaching a solution, so you need to ch...

There are industry-wide general estimations for duration of work done by software professionals, but they apply to processes and work done using any product.

You need to define the function within itself,

Yes, the Basic routines are fully recursive, all variables except the parameters and any COMMON block variables are per stack level.

Mandar, the DataStage Server Engine is built on an almost identical copy of the application that IBM now owns and is called UniVerse'. This application is a postrelational database system that is very comprehensive. This is why I pointed you to the documentation on the IBM pages --- almost all of th...

Hello MJ, Although DataStage has it's own integrated version control system it is possible to use CVS. Since DataStage jobs are stored within it's own database system they cannot simply be checked in and out as one could do with source code. A recent project of mine used .dsx datastage export files ...

You can also have an optional "dsdlockd" process running in addition to the "dsrpcd".

Actually, in this case the program is DSD.StageRun - I looked at the compiled code and there is no SQRT statement to be found anywhere in there. Can you clear the &PH& subdirectory before your run and then look at the {text} files in there after an aborted run to see if there is any addition...

Please use an editor that shows undisplayable characters; the "view data" tool is not the right one to use here.

You probably are getting some other filler character in your input. What is your source (db/2? in that case you could also add a CONVERT(CHAR(000),' ',In.Column)). Can you push this to a sequential file and use a binary-displayable editor to find what you are getting.

Ray is quite right, plus the %cpu value does not take multi-cpu systems into account. I had a job yesterday loading 1million rows per minute into Oracle showing a very high %cpu value (sampling interval in PX of 5million rows) but since the system has 10 physical processors the real load on cpu was ...

Mandar,

a good beginning to the system description and commands can be found by downloading the PDF files located at IBM UniVerse Documentation.

I am not really surprised that the problem goes away - if there is a process on the "other" side in DB/2 that got hung up then most likely it got killed or timed out, thus removing the deadlock. I think the Designer opens/closes the sessions and isn't persistent so shouldn't keep a lock (then again,...

All I can answer is that "PX works that way"; due to it's highly parallel working methodology it needs to know quite a bit more about the source/target Oracle instance than a Server job. Notice that only SELECT is required and if you look at the definitions for those table contents it becomes cleare...

This is most likely more of a Database issue that your friendly DB/2 DBA needs to clear up. A deadlock is when one process is waiting on a resource that is held by another process, which in turn is waiting on a resource help by the first. There are other ways of achieving a deadlock as well, but thi...