DSXchange

That RAM is doing a lot of other things at the same time!

I have yet to find a reference to 500MB as the limit (per partition?) for the reference Data Set for a Lookup stage, and how to increase that, but I'm fairly sure I've seen it somewhere.

Did you create a "parallel routine" (an interlude to your function) in the Repository?

Have you tried it as fixed width with no line terminator? (You can do this in a Sequential File stage or even while importing its table definition.) The table definition can then be saved as a record schema into a schema file.

This score dump shows that the Aggregator is only operating on one node (node3). op2[2p] {(parallel APT_SortedGroup2Operator in Aggregator_292) on nodes ( node3[op2,p0] node3[op2,p1] )} That does not coincide with your earlier information that the named node pool is node1; are you certain that you e...

Kumar, the client here is the Administrator client, not the Director.

Activity variables - of any kind - are only accessible from upstream activities - that is activities to which the current activity is connected by a series of links. But - if I read your requirement correctly - you don't need a User Variables activity at all. Your "status" could - should - be a job ...

vijaykumar wrote: i want to see the sequence numbers generated, is it possible from sequence, is there any way to see the sequence numbers generated.plz

From sequence, no.

There is no View Data capability in a job sequence.

There is an entire document on remote DB2 available from your support provider or vendor, or you can track it down from here (Vincent has posted the link to it on DeveloperWorks in his blog site as well). It's not as straightforward as it seems - even the document is in its third incarnation!

Possibly it is waiting for the domain controller to return the list of groups for the permissions page, and the domain controller is busy. They usually are.

Or it may be, as I once encountered, everyone watching the cricket live in their browsers totally destroying the network bandwidth.

There is no support in DataStage for "affinity" - tying particular processes to particular CPUs. As Ken notes, affinity is an operating system management thing, but you will not know the DataStage processes in advance, so it's almost impossible to do. And they all run the same executable! DataStage ...

Do it all in SQL. Use a CASE with a nested SELECT COUNT(Key)... to determine whether the reference table is empty. Deliver the results to DataStage.

Here's how I would do it. The Index() function is very efficient. I am assuming that SRVC_TPY_CD_ID is Char(1) data type.

Can also be done in an after-job subroutine, provided you've stored the special character somewhere. But this would be a custom subroutine, not one of the out-of-the-box ones.

No changes should be required in .profile. You are not in charge of a running job. All DataStage processes on UNIX servers execute a script called dsenv that sets their required environment variables, etc.

Please add $APT_DUMP_SCORE as a job parameter, set it to true, run the job and post the score.