DSXchange

yxong wrote:that is my concern, file can be locked if all open the same time even though file is just read only.

If you are concerned about it, talk to your SAs. Ask them if it can be an issue with whatever o/s you are running there.

However, when I keep multiple files in the input folder and process it, the job (which is having the after-job routine) is hanging. Typically that would mean your command is prompting for a user response - asking for permission or confirmation of something. There is no user there to answer so it ha...

From what I've seen, a sequential file can support multiple readers just fine, not sure why it would be getting 'locked'. And no, a Shared Container doesn't 'take care' of anything as I've been trying to point out. You'd be having the same issue if the seven jobs were setup the same way without a co...

Welcome. That should be all the information your DBAs need to solve the problem. It is strictly an Oracle problem, not anything to do with DataStage directly. You ran out of space, nothing more to it. Or are you trying to nail down why you ran out of space? If so, would need more information to help...

As Kris notes - yes. This may sound obvious but we've also found that the disk you are installed on can make an enormous difference as well. Found out our initial setup put the DataStage directory on some old, slow SCSI drives that just couldn't keep up with all the requests they were getting. Migra...

Wasn't gonna mention that.

Install Version Control on your PC, the answer will be obvious. You don't need to run it or use it, but you'll need to install the product to get the pdf.

Version Control does come with a .pdf manual that explains how it works and how to use it. Have you taken a peek at that?

You really shouldn't be worried about the internal numbers but using the equivalent whatever in the heck they are called - tags? For example, the help for that function shows: Result may also return error conditions as follows: DSJE.BADHANDLE JobHandle was invalid. DSJE.BADTYPE InfoType was unrecogn...

What happened when you turned trace on? It should have showed you the problem. 'Telnet Prompt 1' you should set back to the default - it is your first logon prompt. Prompt 2 should be for the password. From memory, there should be a 'Telnet Command' box you put the complete 'delete' command in. Also...

There are 'Tracing' parameters in multiple places in the FTP Stage from what I recall. Read the 'Property Help' for them so you understand how they work (additive - so to turn on option 1 and 4 you set it to 5) then bump them up from a zero to something else. You'll get all kinds of information in t...

Me personally, I think a job that logs any warnings or errors is a problem.

How exactly are you doing this? Add 'logging' information to it so you can get some idea where the problem lies...

Ok... there's no reason for the job to throw those.... necessarily. I assume there are no stages on the canvas, so the issue would be the fact that all there is 'code wise' is a before/after subroutine call. That's the only time I recall seeing that warning. What I do is code directly in the Job Con...

stivazzi wrote:i have rights, path is right, but Director just returns me that warning message about active stage and nothing more... and no action is taken

And what message would 'that warning message' be exactly? Please post it.

I have 3 files generated by datastage (through 3 sequences). The next sequence (4th) should start after all these 3 files are available. These 3 files could come within a span of 1 month. Q1) Is it advisable to a) use wait for file activity (3 for each files) in the 4th sequence. The 4th sequence b...