DSXchange

Can you start from scratch, deleting the "D_{file}", "{file}" hashed file objects in the directory and delete the "{file}" record(s) from the VOC. Then re-run the program just once and post the error message?

VLIST is one of the internal debugging tools embedded in the DataStage/UniVerse engine. DataStage BASIC programs are not compiled to machine objects, they are actually compiled into a pseudocode format which, at runtime, is interpreted by the engine and executed. The VLIST program will show the comp...

I think it might be best to contact your support provider for this issue, since you are using a compiler and a version of the OS that are not on the supported list - perhaps they can detect a workaround for the runtime object problem.

Leslie, Although I'm not at a DataStage client right now and can't confirm the CRC32 collision, I must admit that I'm surprised that two such close strings will have an identical CRC32 return value. My faith in the CRC32 method would be greatly diminished if you were to find a second pair of strings...

I have been looking for a way to get the current DataStage version from a DataStage routine but haven't found anything in the API or documentation. Does anyone know of a documented way to get this information? I am aware that I can use an entry in the UV.ACCOUNT file to get a project's version numbe...

The other questions are still unanswered, and I think they apply to solving your problem.

OK, now we know that the job has aborted due to some HEAP problem; most likely it is running out of space. Odd is that it seems to be happening in your TRANS1 stage {which I assume is a TRANsform stage}. This normal does not create any temporary storage - unless you are using stage variables that ar...

The command tells you what you have, not what you need. The original configuration parameters were designed on machines with a lot less physical memory. I used uvconfig settings identical to the current defaults in the 80's on machines with only 16Mb of physical memory - so increasing a non-pagable ...

Bryceson,

I thought he was on windows as well, until I saw the command he used to stop/start DS with.

You will need to modify your DataStage engine configuration, specifically the T30FILES parameters to allocate enough internal table space to handle all of these concurrent open dynamic files. You can use the search facility to locate threads on this topic, including (i think) some recommendations on...

You can define projects to your heart's contents. Each project is in a directory tree, and since many UNIX implementations limit the number of directories to 32Kb, since each job creates (by default) 4 sub-directories (RT_LOG<n>, RT_STATUS<n>, RT_CONFIG<n>, DS_TEMP<n> and also a potential RT_BP<n> a...

What you should do first is to use the Search facility in this forum. If you try to restart the DataStage engine when not all processes have been terminated then the RPC daemon will not initialize and DataStage will not run. Do another stop and make sure that you don't see any DataStage users left l...

Yes, you can do this in an after-job routine. But you will need to execute a UNIX command just as you would normally - if it needs to be done in several commands (i.e. using DB/2) then you would need to issue those commands; plus your after-job routine would also need to know the relevant informatio...

Sheshadri,

you have 2 ODBC files specified in your ENV - one in the project directory and the other in $DSHOME, which one did you list and could you list the [ETL] section of the other to see what is defined there?

Venu, your question, if it were put into car terms, would be "I was driving home and, just as I was turning into the driveway the car stopped running. What is the cause?" You might try to to a reset of your job and see if you have a log entry entitled "from previous run". What are you writing to? If...