DSXchange

Hi, I have a datastage px job like dataset --> Copy -->DB2. The loading method in DB2 is Upsert. While running the job, i am getting a fatal error like main_program: Fatal Error: There are irreconcilable constraints on the number of partitions of an operator: parallel Db2udb_SCR_TYPE_REAS_W. The num...

Hi, I have one datastage job which contains transformer, filter, Funnel and pivot and dataset stages. I ran this job with 4 node configuration file. While monitoring the job through director, transformer and filter stages are running on fur nodes but i think the pivot stage is not running on four no...

Hi, I have a px job containg 3 stages like: DB2 stage --> Copy Stage --> Db2 stage I am loading data from one table to another table. My source table contains 12 million records and my configuration file contains 4 processing nodes. The job is taking very long time to run(0.5 million in 2 hrs). Coul...

Hi, I have a configuration file like / * 1_Node_stage01 - Default Configuration file This Configuration file has 1 processing nodes on DataStage Server etlux201,(stage01_node1) and 4 DB2 Servers (bdwux201 thru bdwux204). Server etlux202, is required for proper execution during DataStage Server Failo...

Hi, I am running one datastage job in my UAT environment, where my source contains 70 lacks rows. Now i am using a congiguration file which contains 5 nodes and its taking very long time to run the job. I have two more configuration files with 9 nodes and 12 nodes. Which configuration file, i have t...

I want to learn, how to write a Parellel routine. Can any one tell me, where can i find the related documets. If any one provides sample code, it will be greatful.
Thanks In advance

Hi Arnd,

Is there any parellel stage where i can call my server routine as before stage routine.


Kindly Help me

Hi,

I have written a before/after server routine. I want to use this routine in the stage level. Can any one tell me, on which stage i can use this before stage routine.

Shall i use this serverr routine in Transformer(PX) stage.

Kindly help me

The option available in transformer (Also available project level). If enabled, DataStage tries to combine all possible orchestrate operator to a single operator while compiling to reduce the over head. Though the funcitons are given in an order, which should also work according to its own preceden...

Hi Kumar, Can you explain in detail. What does this combinability mode does and how it works when i make it to false

Hi Andrw,

I have tried stripwhite spaces also.!! Still i am getting the same problem

Kindly help me

Hi I am using Trim Function,

Still i am getting the same errors.

I am using function as StringToDecimal(Trim("FieldName"))

Kindly Help me in avpoiding this warnings

Hi, I am having a char fiield of length 5( value is "001 ") populating to Decimal of 5. i am applying "string to decimal" and trim function combindly to remove the spaces and to convert to decimal. I am giving as StringToDecimal(Trim("FieldName")). But i am getting warn...

My situation is, I want to fire a JOB2, irrespective of JOB1 gets failed, success, or with warnings. If i use "Unconditional" Trigger for a Job which is aborted, Its not firing the JOB2. Its simply aborting the sequncer job. If i use "Unconditional" Trigger for a Job which is Fin...

An unconditional trigger fires the target activity once the source activity completes, regardless of what other triggers are fired from the same activity. Hi Kumar, Thanks a lot. My situation is, I want to fire a JOB2, irrespective of JOB1 gets failed, success, or with warnings. If i use "Unco...