DSXchange

While we wait for the experts to provide some guidance, here is some more information/observation. As I had mentioned before the job that creates this dataset never fails but the job that reads it fails; the pattern we have observed is that the datafile/partition size on partition 1 is always 65536 ...

Yes the job which creates the dataset completes successfully each time. Only the jobs that read these datasets have random failures. The job which creates the dataset always overwrites the previous runs dataset, so we have even tried to delete the dataset using orchadmin so that the next run is clea...

We are on Information Server V11.3. We are facing an issue in datastage jobs where some of the jobs that read from a dataset fail randomly with the error Fatal Error: I/O subsystem: partition 0 must be a multiple of 131072 in size (was 851968) (this size is Different with every failed job). The part...

Hi, We have a job which reads multiple sequential files from a specific folder using FilePattern. Additionally these files are read using a Schema File option. The reject Mode on this Sequential File stage is Set to 'Output' and for now we have attached a peek to the reject link output. We have also...

This is a bug for which there is a patch out there. Even when you have the auto-purge setting set at say last 5 runs, the logs related to different instances do not go away. Please install Patch JR46141 and this issue should go away. http://www-01.ibm.com/support/docview.wss?uid=swg1JR46141 We have ...

Rohan, Any update on the above issue? Were you able to fix it? I am possibly having a similar issue, where my jobs with Surrogate key generator stages are hanging intermittently. 2 or 3 times they run fine and then they hang, on killing them and restart they get done in a minute. We are on DS 8.5 on...

In this case how do we track failure of any jobs. Because if we use execute command and it does not wait for the job to complete, how do we know which instance failed?

That Convert() option should work very well too. Just posted an alternative if someone wants to do that in the sql query itself. :D

For those who have similar requirement and the source oracle you can use some thing like the sql stated below: select replace(translate('abc123pqr456','0123456789','~'),'~','') from dual; select replace(translate('abc123pqr456','abcdefghijklmnopqrstuvwxyz','~'),'~','') from dual; just an example you...

Thanks for all your responses gentlemen. Ray I am aware of the DS.TOOLS menu, it is just that I was trying to create a script which would abstract the UV commands, I do not want lot of people fiddling with UV commands as that can mess up things. So I wanted to create a script which would take the jo...

Can someone share a Job Unlock UV script which has automated the process of releasing job locks. That is a script which accepts just the project and job name and release all the locks associated with that job, the list.readu and "unlock user <userno> all " commands in a interactive script ...

There is an FTP PrePUT command option available in the FTP Stage Properties.

You can use that to issue a site command. This site command will be executed before the file is put on the MF Server.

Let me know if this helps.

Regards,
Nirav

In server jobs we could have done it using output as Folder Stage. wonder what's the equivalent for Parellel jobs. Don't hijack the thread - your question ... Ray I did not mean to Hijack this thread with another question. What I meant is I had achieved it in Server Jobs using Folder Stage as outpu...

In server jobs we could have done it using output as Folder Stage. wonder what's the equivalent for Parellel jobs.