Search found 96 matches
- Wed Apr 26, 2017 12:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: MQ Job Failing
- Replies: 1
- Views: 2494
MQ Job Failing
Hi, I have a MQ job and it is failing in production with below error. And there is no pattern for job failure. Sometimes job runs for 2 days without failing and some days it fails 3 to 4 times in an hour. I have similiar job running against other 4 non-prod regions and they have no issues and are ru...
- Wed Nov 30, 2016 3:07 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Continuously Read data from Oracle
- Replies: 4
- Views: 2691
- Tue Nov 29, 2016 8:50 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Continuously Read data from Oracle
- Replies: 4
- Views: 2691
- Tue Nov 29, 2016 7:07 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Continuously Read data from Oracle
- Replies: 4
- Views: 2691
Continuously Read data from Oracle
Hi, I have an MQ Job which reads data from Queue and then does a LKP on table A and then writes into table B. Table A is being populated by some other system in real-time. Table A | | | MQ ------------------ LKP ------------------ Table B Question: System will put message in MQ and other system will...
- Mon Nov 21, 2016 8:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Delay Processing of records
- Replies: 2
- Views: 4366
Hi Andy, Actually I found a logic on dsxchange, but I have to still test it. http://www.dsxchange.com/viewtopic.php?p=425333 And the reason for putting delay is that application sends data to 2 different systems (Java and DataStage). And I depend on getting some data from Java and datastage is proce...
- Mon Nov 21, 2016 3:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Delay Processing of records
- Replies: 2
- Views: 4366
Delay Processing of records
Hi,
I have a requirement where I am reading MQ. And after I read message, I want the job to hold the message for 30 secs before dumping into oracle table.
MQ Read -------------> Transformer -------------> Oracle table
I have a requirement where I am reading MQ. And after I read message, I want the job to hold the message for 30 secs before dumping into oracle table.
MQ Read -------------> Transformer -------------> Oracle table
- Fri Jun 03, 2016 2:56 pm
- Forum: General
- Topic: Sorry, this version of DataStage server has expired.
- Replies: 2
- Views: 2561
Sorry, this version of DataStage server has expired.
Hi, DataStage was working fine but I mistakenly saved uvconfig file in vi editor(No change was made on the file). And then immediately no one was able to log in. So I tried re-starting dataStage after re-generating uvconfig file. And I am getting below error. Sorry, this version of DataStage server ...
- Fri Aug 07, 2015 4:30 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Join in Server Job
- Replies: 3
- Views: 5517
Join in Server Job
i have a requirement for server job. But if there is a solution with parallel job, then i can make a parallel job also. And below is an example. It is tough to put down the requirement in words. So i will explain with an example. For example, Table 1 is the source and table 2 is reference table. For...
- Wed Nov 19, 2014 3:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fatal Error: Added field has duplicate identifier(): X
- Replies: 6
- Views: 9951
I found the issue.... The issue was that on one of the link in the job had Range Look up check box clicked but the key expression was missing. Same job was running fine in DataStage 8.5, but with DS 9.1 release they have tightened the rule and now it is looking for key expression if range look up ch...
- Mon Oct 27, 2014 3:13 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fatal Error: Added field has duplicate identifier(): X
- Replies: 6
- Views: 9951
- Mon Oct 27, 2014 11:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fatal Error: Added field has duplicate identifier(): X
- Replies: 6
- Views: 9951
- Fri Oct 24, 2014 1:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fatal Error: Added field has duplicate identifier(): X
- Replies: 6
- Views: 9951
Fatal Error: Added field has duplicate identifier(): X
Hi,
I am getting below error....
main_program: Fatal Error: Added field has duplicate identifier(): X
The job was created in DataStage 8.5 and it was running fine. But when I moved the job to DataStage 9.1... I started getting error and the job is aborting.
I am getting below error....
main_program: Fatal Error: Added field has duplicate identifier(): X
The job was created in DataStage 8.5 and it was running fine. But when I moved the job to DataStage 9.1... I started getting error and the job is aborting.
- Wed May 21, 2014 12:01 pm
- Forum: General
- Topic: Installing fix pack-1 on DataStage 8.5
- Replies: 1
- Views: 1590
Installing fix pack-1 on DataStage 8.5
Hi.....
I am trying to install fix pack-1 on my new machine. But I am getting some weird error.
Earlier I had the same fix pack installed on my 32 bit machine. But now I got a new 64 bit machine.
So do I need to download 64 bit version of fix pack-1?
I am trying to install fix pack-1 on my new machine. But I am getting some weird error.
Earlier I had the same fix pack installed on my 32 bit machine. But now I got a new 64 bit machine.
So do I need to download 64 bit version of fix pack-1?
- Mon Jul 15, 2013 8:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Alpha characters in Decimal Field
- Replies: 12
- Views: 6928
The source cannot be changed to Zoned Decimal as it is a fixed length file. So I have to break down the input record. Solution: I created a table and then I do a look up on last character. And then get the correct value. And today I noticed that when I use StringToDecimal function then it issues war...
- Sat Jul 13, 2013 9:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Alpha characters in Decimal Field
- Replies: 12
- Views: 6928