Search found 182 matches
- Mon Dec 19, 2016 7:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Source is BigInt and Target is Number(38)
- Replies: 0
- Views: 1921
Source is BigInt and Target is Number(38)
Hi All, My source table is DB2 and my target table is Oracle 11g. My ID columns in source tables are BigInt and Target columns are number(38). When I do CDC, can you please let me know the best way to do the conversion and insert/update into the target table(Oracle) to number. Kindly let me know you...
- Wed Dec 07, 2016 10:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: JDBC Connector issue while connecting Oracle Database
- Replies: 1
- Views: 1939
- Wed Dec 07, 2016 10:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: JDBC Connector issue while connecting Oracle Database
- Replies: 1
- Views: 1939
JDBC Connector issue while connecting Oracle Database
Hi All, We have a remote Oracle DB for which we were trying to access using jdbc connector and use oracle thin client to connect to the database.we tried with the below URL: jdbc:oracle:thin@x.x.x.x:1521:SID AND URL: jdbc:oracle:thin@x.x.x.x:1521/SID We were able to find the instance as CD12,CD14 us...
- Tue Jun 14, 2016 1:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error :Resource temporarily unavailable
- Replies: 3
- Views: 4729
Error :Resource temporarily unavailable
Hi All, I am getting the following error as our production jobs (max 20 job) running in parallel. Error: DataStage jobs intermittently fail with the following combination of warning and fatal error messages: Message: APT_CombinedOperatorController(17),1: Adaptive job monitoring feature is disabled; ...
- Mon Apr 11, 2016 3:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need to calculate cumulative value
- Replies: 4
- Views: 2808
Need to calculate cumulative value
Hi All, Kindly let me know your thoughts on how to calculate the cumulative value based on the below scenario A B C Amt 1 1 1 10 1 1 2 10 1 1 3 10 1 1 4 10 1 1 4 10 From the above data i would like to calculate the cumulative as below A B C Amt 1 1 1 10 1 1 2 20 1 1 3 30 1 1 4 10 kindly let me know ...
- Mon Nov 30, 2015 3:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Compilation error in DS 11.3 version
- Replies: 5
- Views: 5404
Compilation error in DS 11.3 version
Hi All, We could face a compilation issue in out production environment. The same job has been compiled successfully in our UAT environment. UAT: APT_COMPILEOPT=-O -fPIC -Wno-deprecated -c APT_LINKPOT=-shared -Wl,-Bsymbolic,--allow-shlib-undefined Production: APT_COMPILEOPT=-c -O -fPIC -Wno-deprecat...
- Fri Sep 11, 2015 3:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle connector stage drop unmatched fields insert issue
- Replies: 1
- Views: 2113
Oracle connector stage drop unmatched fields insert issue
Hi, When i try to insert records into Table A, by using oracle connector stage(Oracle 10g) with Drop unmatched fields option(Set an Yes) i could see a weird response. Using performance statistics / job monitor i could see the records were populated into the target DB table. When i see the table ther...
- Fri Mar 20, 2015 5:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: data truncation issue with the Number field in oracle
- Replies: 9
- Views: 6737
- Thu Mar 19, 2015 8:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: data truncation issue with the Number field in oracle
- Replies: 9
- Views: 6737
- Thu Mar 19, 2015 12:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: data truncation issue with the Number field in oracle
- Replies: 9
- Views: 6737
Hi All, Apologize for the confusion. My source Oracle 9i table column definition defined as Number and Target Oracle 12C is also same. When i try to extract data from DS9.1 and load into target i could see the error message. My ultimate aim is to load the whole data into my target.Kindly guide me. T...
- Wed Mar 18, 2015 9:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: data truncation issue with the Number field in oracle
- Replies: 9
- Views: 6737
data truncation issue with the Number field in oracle
Hi All, I am running the below query SELECT to_char(STUDY_DURATION) - Number as defined source table FROM TableName Result: 893.640636574074074074074074074074074074 TargetTable: STUDY_DURATION defined as number When i try to load the above data by using decimal in DS9.1 PX job the job is aborted. Er...
- Wed Mar 11, 2015 12:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datasatge job performance with version 9.1 and Oracle 12C
- Replies: 13
- Views: 8153
- Tue Mar 10, 2015 7:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datasatge job performance with version 9.1 and Oracle 12C
- Replies: 13
- Views: 8153
- Mon Mar 09, 2015 6:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datasatge job performance with version 9.1 and Oracle 12C
- Replies: 13
- Views: 8153
Datasatge job performance with version 9.1 and Oracle 12C
Hi All, We have a datastage project in version 9.1 and Oracle 12C as an target DB. When we ran the jobs it ran fine for few jobs, but some of the jobs really do underperformance like <10 rows/sec when they do update and then insert using Oracle Connector Stage. When i remove the stage and use Datase...
- Tue Feb 10, 2015 3:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Type mismatch when i try to open Oracle connector stage
- Replies: 1
- Views: 2404
Type mismatch when i try to open Oracle connector stage
Hi All, I have newly installed Datastage9.1 version. Once it gets done, when i try to open oracle connector stage a pop-up window opens and say "Type mismatch" after couple of ok's it will open the connector stage, but can't able to see any property tab values and able to see the column me...