DSXchange

Hi, You can write the required parameters to a file as follows: param1=value1 param2=value2.... Now you can write a shell script that reads the "parameter=value" pairs from this file and use the -param flag of the "dsjob command" to specify the values to the datastage job. Regard...

Hi, I need to delete 6million records from a MDC table in DB2. For this i have a job.I am using the MDC and the partition key for deletion in DB2 API stage. I get the following error after executing for sometime. DB2_AGI_UA_SITM_S_Del,7: ERROR during execution of DB2-CLI requests: SQL_ERROR; SQLSTAT...

If you change to a 6- or 8- node configuration does the problem still happen? Does it happen more often (i.e. reproduceable every time). Does the error always occur at the same row? Is it the same data each time, including the lookups? The job fails in the 6-node configuration also. With the same d...

ArndW, how many nodes does your normal and reduced APT.CONFIG file(s) have? The original configuration file was a 4-node config file and the reduced one is a 2-node config file. Is it always the controller for node 0 that fails? Always The controller for node 0 fails Does it fail at job start or aft...

Hi, I had to execute a job 11 times. It executed successfully 7 times but failed 4 times. There is no particular order of failure. Each time the job handles with approximately 40 million records. I got the following error: APT_CombinedOperatorController,0: signalHandler__Fi() at 0xd272ac3c APT_Combi...

Hi,


On searching the forum i can see that upto 7.1 parallel extender is not supported in windows.

In any later versions, Is Parallel extender supported in Windows?

Thanks
Senthil

Hi, PCDATA means parsed character data. It is the text found between the start tag and the end tag of an XML element.This text will be parsed by a parser. eg. <Details> <name>Senthil</name> <address> <street>10 th main road</street> <city>Chennai</city> </address> </Details> If <address> is defined ...

Chulett,

Change the XPath bits in the Description field from #PCDATA to just text()

I tried using text() instead of #PCDATA. It runs successfully.

I thank all of you for your inputs and time!

Thanks
Senthil

Hi, I want to read the data from an XML file. I created a job like the one below. Folder------------->XMLInput--------->Transformer----------------->SeqFile Stage The input XML file is <?xml version="1.0" encoding="UTF-8" ?> <root> <a> ASK </a> <b> BSK </b> </root> I need to extr...

Ray,

There is a difference.

the db2 version in Prod is 8.2.1
In test it is 8.2.3

Thanks
Senthil

Madhavan, Thanks for your inputs I have ensured the following: 1. The key column in the input column is checked. 2. The EXECUTION MODE property in the Advanced options tab of ALL the stages is set to SEQUENTIAL (this is due to business requirements). So the partition property has been DISABLED. I ca...

ArndW, I forgot to add this previously. All the stages in the job are set as "Sequential ". My job looks like this: DB2Primary | | `' Lookup---->DB2Target ^ | | DB2Lkup The same job runs correctly in test environment which is also DS7.5 but it aborts in production. In prod, I have set the ...

Hi,

You can also try using the "Column Import" stage with "." as a delimitter

Regards
Senthil

Hi, I am getting hte following error when executing a job "Failed a keylookup for record" The lookup key is of Integer type. There are 10 primary records and required 10 records key is present in the Lookup table. But still the job fails. Can anyone throw more light on this? Thanks Senthil

Hi, I am getting the following error in 7.5 parallel extender. "APT_CombinedOperatorController(0),0: Conversion error calling conversion routine decimal_from_string data may have been lost" I am using the StringToDate funtion in a transformer. We recently migrated from DateStage7.0 to Data...