DSXchange

Hello, First, a few details about the jobs followed by my questions. Details: Our jobs use DRS stage to insert or update records in Oracle tables. In DRS stage: Transaction level - Read committed Array size - 1000 Transaction size - 10000 SQL type - Either Update rows only OR Insert rows only (since...

Craig,

Got it!

But is the one(Select statement in UV) I mentioned earlier, one of the ways to count or select records from a hashed file?

Thanks.

Thanks for your replies. In one of the jobs, data is loaded into a hashed file. Options selected for this stage are 1) In Stage tab, Use Account Name (checked) and Account Name empty 2) In Inputs tab, General tab, a name, say HX, is provided in File Name and Allow stage write cache is checked. Can I...

This is really strange! Yesterday night the job took 54 minutes to complete. It processed 2000 rows/second. There has been no change in the job, the record count or the hardware. The database and DataStage engine are on the same box. My thought is this job runs slow when CPU and memory are being uti...

Thanks Kim. I'm new to UV tables. Can you please tell me where I can find more information about each column (like what it stores) in DS_JOBOBJECTS table? For my Post question, which of the fields below are relevant i.e., in which column will the SQL query might be stored? Are different forms of SQL...

Kirtikumar,

I missed the long running extraction stage and I've included it in my original post.

Just another thought/question

Does increasing the priority of this job allocate more CPU time(if any) to it? If yes then how can it be achieved?

Thanks.

Hello, We've a job as shown below Hashed File | DRS (Source) -> IPC -> Row merger -> Trans1 -> Trans2 -> Row splitter -> IPC -> Trans3 -> DRS (Target) Source & target table is Oracle. The DRS (source) contains roughly 9 million records and contains a select statement. The reference Hashed file t...

Hello Ray & Craig, I'll still waiting for my membership to be approved. Don't know why it's taking so long. In the meanwhile I have another question - If a Hashed file is created on a 64-bit Sun OS sun4v sparc SUNW,SPARC-Enterprise-T5220 machine, is it by default a 64-bit hashed file? Or is it t...

Forgot to ask -

Once source and target table names are retrieved using the UV query, how can they be differentiated? Is there an indicator flag that tells X table is used in source DRS stage and Y table is used in target DRS stage?

Thanks again.

Hello, Is there a UV query to find all the source and target table names used in source and target DRS stages in a job? I browsed through the Server forum and found that I'd have to query/join DS_JOBS and DS_JOBOBJECTS. I also tried a few ones like the one below but since I don't know the metadata o...

Craig & Ray,

Thanks for your reply. I applied for membership 3-4 days ago and still waiting to get a confirmation. Once I've my membership I'll read through your messages and reply back.

Thanks again.

Craig,

It worked! Thanks. I'm marking this thread as resolved.

Craig, Thanks a ton!

I'll give it a try tomorrow and reply if I face issues else I'll mark this thread resolved.

Thanks again.

Craig, We have around 700 jobs in more than 20 directories(with several sub-directories inside them) in a project in Designer. When a job abends I locate it using the steps mentioned in my previous post. Then open Designer, debug and restart it. So I was wondering if there is a way to run UV command...