DSXchange

Hello All When i execute the Datastage job to export the Datastage project, it ran successfully, but the dsx file size is 42,018 KB. I copied the same command from the Datastage director, executed in the command line. All good, but this time the dsx file size is 244,335 KB. I would like to know why ...

I haven't worked in 11x , still......

Is it happening for this job alone / for all the jobs?

Try to create a new job (without any stages / params) and try it.

chulett wrote:MKS Toolkit was no longer ...

This is really a good point. I always use unix commands, but i need to think twice before us it! At some point it may hit me back.

I know it is there in 11.3, but just checked the latest version and it seems still using.


http://www.ibm.com/support/knowledgecen ... rsion.html

You have MKS tool kit. So you can still run most of the unix commands. One way of doing; get the modified time stamp using command activity stages, cleanse the command output for both files and compare.

In the last project i did the same validation.

It looks like permission issue.

I have included the above options which allowed the Datastage to trigger the script and moved to the next step.

Thanks Criag.

I have modified the executing command to bypass the policy and it is working now as expected.

Thank you so much for your guidance.

Are you taking about the command output / return value / command name?

Sorry for not explaining it properly, though your understood correctly.

I thought this stage bring the trigger status back irrespective of Success or failure.

Anyhow thanks.

Hello All Newly developed Project, just migrated to PROD. As a part of the Master Sequence, it trigger a PowerShell script using Execute Command Activity stage. Triggers is unconditional and was running fine for a day. All of the sudden in the Datastage server , it seems the IT management guys might...

You can try this.

testuser33 wrote:Even a reboot does not help.

On top of the Rays comment, please clear the &PH& etc. I have seen the issue due to not cleaning it.

I am not sure whether this will work for you or not, but still it may help for someone. This solution is using Oracle, but you will get the same output. Then up to you to decide whether you need to use it or not! WITH data AS (SELECT Chr(65 + LEVEL - 1) str FROM dual CONNECT BY LEVEL <= 99) SELECT s...

Yes, that's right. If i recall correctly , as i have mentioned in my initial thread, in total 18 mil+ records. But when i run the first load ETL successfully loaded 12 million records, but didn't given any warnings or error about not loading the rest of the records. Is it how the ETL tool will behav...