DSXchange

There are no materials, per se, on this site itself. Sometimes, you might stumble upon some post here that might be pointing to a resource. However, I have learnt a little bit of administration while reading and answering several issues that have been posted here. However, beware that administration...

ajaykumar wrote:APT_DUMP_SCORE is set to False. So no Info about that.

Please turn on the APT_DUMP_SCORE (Set it to True) and run the job. Then document/post the results here for perusal. This is what "mhester" was suggesting...

Were you able to replicate this problem in other environments?

Thanks kumar_s for your swift response. There is no compilation process going on simultaneously while we are running our Master sequence that we are running as far as I know. Some of the code that we have is complicated. Some jobs have at least 30 stages etc. and Transformers in those jobs have a bu...

In our Test environment, we are facing a repeating issue of jobs or sequences getting stuck in Running status forever, thus delaying the run of other jobs/sequences. The problem is not just with any one in particular, it is completely random. If I do a "Cleanup resources" in the Director a...

I agree with Vincent. When I had to do this, I implemented the change to the .dsx file of the jobs and re-imported them. It kind of sucks that the table definitions and the jobs are loosely tied in a way, but there must be some good explanation as to why they decided to do that.

Did anyone find a solution to this problem? :( Did you at least try searching about Implicit Create Schema online? A simple search yielded me this from the IBM website: Implicit schema authority (IMPLICIT_SCHEMA) considerations When a new database is created, PUBLIC is given IMPLICIT_SCHEMA databas...

arunkumarmm wrote: But by doing this way no one will be able to edit those jobs right?

Yes. I agree. I do not recommend that, but I was just suggesting a way to make them read-only in the project.

Also, what is the NLS?

You could export the jobs that you want, modify the dsx file to change the ReadOnly flag to 1 and re-import it. However, please keep in mind that this is a manual process and having some jobs as read-only and some without will be a little messy.

Gurus, I have a couple of questions in order to get some clarity on the tool. *Edited this question 1 to remove some unnecessary stuff* Question - 1) <Job Name>.fifo file : Does this get created every time a process/job runs? In other words, can someone delete this and then start running the job onc...

Bulk load is another way of loading rows into a table. It is very handy to do huge loads, like the one you have, into the table from the backend. You can learn in detail about Bulk loading into a database from a variety of resources available online and by talking to your DBA. However, you need to l...

ORACLE_1 wrote:The command rund for some time and then returns with the some blink error. Does it mean I have to empty the file and then do it?

Can you post the error that you are getting?

You could also try this post to see if it helps you.

I am assuming you are doing a normal "Insert" operation. This is a logged activity and hence it consumes a lot of time. You could try using Bulk loading.

ORACLE_1 wrote: Computed blink of 0x934 does not match expected blink of 0x0!

Then this Hashed file should be increased to 64-bit, as noted by Craig.

velayuthan wrote:Hi
can any one help me to run this 4 instances parallely at a time through scripts

Is there a reason you are stressing on scripts? As suggested by many here, you can achieve what you described in your first post without using scripts (as in shell scripts...)