DSXchange

Narasimha,

Just out of interest, when you bumped up the trace level did you also change the Data Connection Mode to "Passive"?

J.

narasimha ,

Which version of 7 are you using. I'm currently on a site using 7.1r2 and I've also had sporadic errors with the FTP Stage. In my case it's for a non-production job so I've not taken the time to uncover what's going wrong. Perhaps worth asking IBM about?

J.

I don't suppose those other jobs are also utilising the FTP stage?

J.

Hmmm ... sporadic errors are always the trickiest!

What's your FTP stage's settings for "FTP Data Connection Mode"? If it's the default 'active' then maybe try 'passive' (which will behave differently if you've got some weird firewall issue.)

J.

narasimha ,

Have you tried telnetting to your server and performing the relevant FTP manually from the shell prompt?

J.

You might find some of the jobs available <a href="http://www.tools4datastage.com/partnertools/">here</a> informative. E.g. ETLStats.

J.

I wouldn't choose to modify permissions on the files which form the DataStage repository. If you want to change the read-only flag of individual jobs do it in UV: UPDATE DS_JOBOBJECTS SET READONLY = 'RO' WHERE OBJIDNO = ( SELECT JOBNO FROM DS_JOBS WHERE NAME = '{MyJobName}'); Set the flag to 'NRO' f...

Hi, Have you tried <a href="http://www.dsxchange.com/search.php">searching</a>? There are lots of posts on SAP. Perhaps you could start with <a href="http://www.dsxchange.com/viewtopic.php?t=105206">this one</a>. The only real documents available are the Ascential/IBM docs, which...

Perhaps Ajay is interested in <a href="http://en.wikipedia.org/wiki/List_of_po ... ny">German Postcodes</a>?

(PLZ = "Postleitzahl")

Hi Ajay,

"play around" sounds ominous ... however, for your entertainment the relevant docs can be found <a href="http://www-306.ibm.com/software/data/u2 ... /">here</a>

HTH,
J.

raghav123reddy , So to clarify, you're saying that your survive stage did not create/populate the specified output file in your Project's Data directory? Are you looking in the right place? Within your specified Run Profile's Master Data Directory you will find a directory YOURPROJECTNAME/Data. Do y...

Unfortunately there isn't a "dsjobs -lcategories" option. An easier solution, however, is to use a UV query on the repository: SELECT DISTINCT CATEGORY FMT 60 FROM DS_JOBS; From your project directory you can execute it straight from the command line: uv "SELECT DISTINCT CATEGORY FMT ...

Thank God - I thought this thread was about to reveal some mysterious new "dsjob" behaviour I'd never encountered.

J.

Yeah - I didn't mention the Run Profile as I'd already responded to the poster on a very similar issue earlier today. raghav123reddy: The error you documented in your <a href="http://www.dsxchange.com/viewtopic.php?t=107009">other post</a> also indicates a permissions problem. As Ray sugge...

Can you show us what you get from "dsjob -ljobs Project1"?