DSXchange

It is hard to answer that question, so I'll just "maybe it will". Another option is to try the "RESIZE DS_JOBS * * *" so see if that might force a fix. Please note that it looks like any repair of this file will probably involve losing records in the file if the fixtool cannot re...

How can something that you cannot change be either an "advantage" or a "disadvantage"? This sounds suspiciously like an interview question asked by someone without DS knowledge. There is a DS_AUDIT "trial" for tracking job changes. There are job logs which could be cons...

Since you haven't specified where your problem is occuring it is difficult to guess what the cause might be. If the error is when you are installing the server, how far along does the installation get? There are various userid/passwords used in different places.

The null handling warning is your problem. If the sequential stage gets a null that it cannot handle, the record is dropped and not written to the sequential file. This applies for all columns.

Craig - I just had to run to a designer client and try that out, but now I know that you are correct.

You need 2 separate calls, the first to RESET, then the 2nd to run.

In that case you probably didn't install DS in impersonation mode, so you'll have to run that as root.

DataStage was at one time identical with UniVerse, the two products have split apart and remain almost the same; with much functionality being removed from DataStage (or added to UniVerse). You can download the UniVerse Documentation from IBM's web pages.

You have corruptioni in your DS_JOBS hashed file. You can ensure that no users are logged, then make a backup of the DS_JOBS file from UNIX and try the UVFIXFILE again, this time with the "FIX" option to see if the file can be repaired. Run it two times (the 2nd run should show no more err...

is "name" a column in your excel sheet or data source? It is very hard to guess what is happening since we don't have details.

The date portion of the filename should be passed into the job as a job parameter. It is not quite clear to me whether this date is part of the data or computed elsewhere, though.

dsjob -run -mode RESET

Please cut-and-paste the messages in the log before and after the error. Also, how many rows should the data contain? Is something different in row 31685 - i.e. a null value?

login to UNIX as your datastage user, then go to the path where you'd like to install the project and try "touch testfile" to see if you have sufficient access rights to create the directory.

The Patch always contains at least one README.TXT file, which contains: PATCH APPLICATION PROCEDURE The Patch should be installed using the Patch Installer. NOTE: This patch for Ecase 134074 will only install the PXEngine files mentioned in the PATCHED FILES section. If you have not downloaded the p...