DSXchange

Hi, Inorder to achieve time upto Microseconds, I am generating a surrogate key and then multiplying with 0.000001 and by using TimestampFromSecondsSince function, I am getting Time untill microseconds i.e (26,6) length. I did this in Transformer stage. When I directly maps from i/p column to o/p col...

Hi Thankyou Andrw and Ray. The Issue is resolved . the Database is not able to handle 999999 Array Size which causes my problem

Hi,
In my Job, I am doing a Lookup on a field which is Date 10 but my source is Date 8 . Will it Pass the record.If not how can i pass the Look up.

[Ask your DBA whether the database can handle a transaction containing 1 crore records, and be prepared to run for cover![/quote] The Transaction handling depends on the table or the entire database? If it depends on entire database, then some Jobs are running successfully with transaction containin...

The message I got is as follows.

main_program: ORCHESTRATE step execution terminating due to SIGINT

So the message is not relted to the Rowcommit interval, right?
If we give a high Row Commit Interval, will it affect ?

The Dba is telling that Swap space is more for this Job.

And one more thing is, I gave the output link of a Funnel stage to a Db2 stage. Can it create any problem.

Hi, In my Job, I am using two datasets and then Funneling it by a Funnel stage (Funnel Type --- Continous Funnel) and then inserting it into a Db2 Table by using a User defined Update (Giving Insert Staement in User defined Update). Partioning type is Db2. The Job is running on 4 nodes and one datas...

Hi, When I run a Job that loads data into a Db2stage it is aborting with the following messages. Db2udbXXX,2: The current soft limit on the data segment (heap) size (2147483645) is less than the hard limit (2147483647), consider increasing the heap size limit Db2udbXXX,2: Fatal Error: Throwing excep...

Hi, I am using a Db2udb API stage to delete the records. In the stage, Input- SQL - User Defined tabpage I used Delete statement and the number of records to be deleted is 6 million. But the job is aborted with the following message APT_CombinedOperatorController(0),0: Operator terminated abnormally...

A parallel job is like an orchestra. There is one conductor process exerting overall control. On each processing node there is a section leader process exerting control over all the player processes ... Under what circumstances this section leader process can die? suppose if i run a job that proces...

Hi,
when I tried to run my DS Sequencer through the script, the sequencer is Aborted with the following message.

main_program: The section leader on bdwux407_udb1.service.com died

Plz clarify what this message is ?

Hi All, My source field consists of Char field. I have to look up on the Varchar field and I will load that field as Varchar. For that there is a need to convert the source char field to Varchar and then trim the white spaces. Can I do that in Modify stage or any other stage other than Transformer s...

Hi, When i tried to load from a dataset to a Db2 table by using Db2 enterprise stage. Initially i used an upsert mode with a never satisfying update condition and always inserting records into the table. But most of the records are rejected with out any warnings. then i used write method option, but...

Hi, while i tried to run my sequencer through the script, sequencer is aborted with the following message for a particular job. Controller problem: Error calling DSSetParam($APT_CONFIG_FILE), code=-3 [ParamName does not reference a known parameter of the job] If any one knows about this kindly help ...

Hi, For my Sequencer Job, I have written a Routine which will log all the information related to the sequencer run into the Audit Table. For a particular Job, 'From stage' is Dataset and 'To stage' is Lookup Stage. So for LinkCount, I gave the ToStage name and link name. It worked fine untill the da...