DSXchange

Indexes are typically left in an UNUSABLE state post load because a unique index is found to have duplicates. You need to ensure nothing like that is going on. There are other reasons, of course, but that's the biggie.

When you have two links going out to the same file and you have links ordered, then a single row will go through the first link first and then to the second link (round robin). This way each record will be appended to a file, one at a time. It will be two seperate operations for the OS, but for the...

Multiple writes to the same file is not allowed by the OS. You will get misaligned data. If this were a server job and you had two links going in then, theoratically, there will be roundrobin process of sending records and in both the sequential file stages the option should be append. I guess you ...

Google. Wiki. The information you seek is out there.

http://en.wikipedia.org/wiki/Server_cluster

So what is your actual problem that you need help with? How to write the 'check the database' job? How to communicate what it found to the downstream jobs? How to build conditional triggers in a Sequence? If you can be more specific as to what parts you have covered and which parts you need help wit...

Yes, the dsjob command. Read the Command Line Interface section of the Server Job Developer's Guide for details.

Answer the question you could see: Is that correct?

So... in other words, there's no problem? Phantom just means DataStage background process, which all jobs run as and SLEEP just means it's very tired. Just how busy is your server? What exactly is your job doing? Could there be other resource issues that are causing the job to stall - database, perh...

pranabdas wrote:You need read some books or some documents to use autosys. Its a very good tool for scheduling.

Maybe so. We use Control-M and I've never felt the need to read any books about it - we've got dedicated "peoples" for that. They read the books. I tell them what I need.

Am I missing something. Where exactly do I specify the Parameter file in the job. I'm not sure how we can be expected to know. That routine is obviously something custom and unique to your shop, you would need to know that. Or figure it out. Or you'd need to post the code, then maybe we could help.

Why not just declare them as External Tables in Oracle then?

Also depends on how often you want to perform the check. The DataStage job with the WFF stage will be running constantly over those days, checking for the file every 8 seconds from what I recall. It may be more appropriate to only check once a day or hour or some other configurable period. Some peop...

Interesting. My man page says "test -z s1" returns "True if the length of string s1 is zero". I generally use "-s" which means the file exists and is greater than zero bytes in size. I guess either way is valid.

1 - No, you stream data into the stage as quickly as you can and it 'loads' it into the database. Only in Manual mode is data landed. 2 - Perhaps 'immediately upon receiving the source data" ? OCI and OCI Load use two different mechanisms. The former are normal inserts same as you would from sqlplus...

Check the online help Index for the various built-in "DSGet" functions available. You would build a routine that took in all the information it needed, called it and then returned the answer.