DSXchange

Detailed responses depend on the question, time available to the premium poster, and the general interest in responding. Why should we repeat what we've often answered so many times? Why should we waste time on what someone could answer for themselves by reading the manual or searching this forum? W...

If your OS allows, you can "domain" the server into two logical servers. But, if you requirement is that you can dynamically shift resources between separate processes, you could consider "processor affinity", which allows processes to be specific for use on a given cpu. By reserving one set of proc...

Run this from SQLPlus or the like. Does the date show up the same? This is what I see in 9i: select to_date('10/14/1582 7:00:00PM', 'YYYY-MM-DD HH24:MI:SS') from dual ORA-01843: not a valid month select to_date('10/14/1582 7:00:00', 'MM/DD/YYYY HH24:MI:SS') from dual 10/15/1582 7:00:...

Batch jobs are NOT eligible for Monitors (no Active stages), so this message actually is wrong. It really means the job is locked.

Without seeing the transformation jobs, it's difficult to tell if multiple cpus are doing you any good. Multiple job instances are the method in Server of dividing-and-conquering large transformation tasks. Your large hash file is the obvious candidate for getting a performance improvement. Consider...

Sweeet

When a query is actively spooling data, it wants to send the data as fast as possible, but if the receiving process is busy doing something, the query slows down because it doesn't have an urgent need to be doing something. When the transformation only job is doing database handshaking for lookups a...

Or use rsh to execute a remote command on another server.

Link partitioners and collectors usually are a method for performance improvement, but dealing with varying logic paths that need to separate and recombine. Consider breaking your design down into Extraction, Transform, and Load specific jobs. You'll see then how long spooling source data requires, ...

Just split your job up into 2 jobs and you won't have the timing issue. Your job control just coordinates the efforts, plus your design will be more modular to boot. :D

I would like to know will the requests(questions ) be answered in this forum..or only for the paid members.. The forum is still FREE. There is just going to be more info and sections available to those who pay for the added access. We're still answering questions, just the longer ones requiring mor...

We answer all questions regardless of the poster. Your answer is that 3 functions are missing from your DS Manager library. In order to compile, all functions referenced will require their object code be available. Double-check you have these functions and if you do, compile them. Then, retry your c...

A high degree of concurrent job execution requires multiple cpus. For Server, the memory usage is very light, so memory is not a premium requirement. Fast disks are a must, as mechanical devices are the achilles heel of computers. Consider a fast SCSI raid 0 with a lot of disks for striping. So in a...

dsadpi and dscs are Client sessions, don't kill them unless they are related to Clients that were tragically disconnected. If "ps -ef|grep phantom" doesn't show any threads with your jobname somewhere in it then that means there are no active threads executing. You need to Clear Status on the job fr...

If you put this in a function it would work great also:



I hope you get the idea. :D