dbTalk Databases Forums  

Oracle 11g and Ascential DataStage 5.2.1

comp.databases.olap comp.databases.olap


Discuss Oracle 11g and Ascential DataStage 5.2.1 in the comp.databases.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
rapaz
 
Posts: n/a

Default Oracle 11g and Ascential DataStage 5.2.1 - 09-12-2008 , 02:42 AM






Hello,

I´m working in a DataWarehouse enviroment with Ascential DataStage
5.2.1 and Oracle 11g. We are trying to load information in a Oracle
database using DATASTAGE jobs. Our problem is with the commit. When
the job is runnig we dont see any rows in the database, it seems that
DataStage dont commit any change. But we have expecified 500 rows per
transaccion in the OCI component of the job.

With Oracle 9 and Oracle 10 it works but with Oracle 11 fail. In the
Jobs we are using the OCI component provided by Datastage.

Have anyboy seen this problem?

Thank you very much.
-Ramón

Reply With Quote
  #2  
Old   
DA Morgan
 
Posts: n/a

Default Re: Oracle 11g and Ascential DataStage 5.2.1 - 09-12-2008 , 08:37 AM






rapaz wrote:
Quote:
Hello,

I´m working in a DataWarehouse enviroment with Ascential DataStage
5.2.1 and Oracle 11g. We are trying to load information in a Oracle
database using DATASTAGE jobs. Our problem is with the commit. When
the job is runnig we dont see any rows in the database, it seems that
DataStage dont commit any change. But we have expecified 500 rows per
transaccion in the OCI component of the job.

With Oracle 9 and Oracle 10 it works but with Oracle 11 fail. In the
Jobs we are using the OCI component provided by Datastage.

Have anyboy seen this problem?

Thank you very much.
-Ramón
Why don't you take this up with the company that makes the product?
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org


Reply With Quote
  #3  
Old   
DA Morgan
 
Posts: n/a

Default Re: Oracle 11g and Ascential DataStage 5.2.1 - 09-12-2008 , 08:37 AM



rapaz wrote:
Quote:
Hello,

I´m working in a DataWarehouse enviroment with Ascential DataStage
5.2.1 and Oracle 11g. We are trying to load information in a Oracle
database using DATASTAGE jobs. Our problem is with the commit. When
the job is runnig we dont see any rows in the database, it seems that
DataStage dont commit any change. But we have expecified 500 rows per
transaccion in the OCI component of the job.

With Oracle 9 and Oracle 10 it works but with Oracle 11 fail. In the
Jobs we are using the OCI component provided by Datastage.

Have anyboy seen this problem?

Thank you very much.
-Ramón
Why don't you take this up with the company that makes the product?
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org


Reply With Quote
  #4  
Old   
DA Morgan
 
Posts: n/a

Default Re: Oracle 11g and Ascential DataStage 5.2.1 - 09-12-2008 , 08:37 AM



rapaz wrote:
Quote:
Hello,

I´m working in a DataWarehouse enviroment with Ascential DataStage
5.2.1 and Oracle 11g. We are trying to load information in a Oracle
database using DATASTAGE jobs. Our problem is with the commit. When
the job is runnig we dont see any rows in the database, it seems that
DataStage dont commit any change. But we have expecified 500 rows per
transaccion in the OCI component of the job.

With Oracle 9 and Oracle 10 it works but with Oracle 11 fail. In the
Jobs we are using the OCI component provided by Datastage.

Have anyboy seen this problem?

Thank you very much.
-Ramón
Why don't you take this up with the company that makes the product?
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org


Reply With Quote
  #5  
Old   
DA Morgan
 
Posts: n/a

Default Re: Oracle 11g and Ascential DataStage 5.2.1 - 09-12-2008 , 08:37 AM



rapaz wrote:
Quote:
Hello,

I´m working in a DataWarehouse enviroment with Ascential DataStage
5.2.1 and Oracle 11g. We are trying to load information in a Oracle
database using DATASTAGE jobs. Our problem is with the commit. When
the job is runnig we dont see any rows in the database, it seems that
DataStage dont commit any change. But we have expecified 500 rows per
transaccion in the OCI component of the job.

With Oracle 9 and Oracle 10 it works but with Oracle 11 fail. In the
Jobs we are using the OCI component provided by Datastage.

Have anyboy seen this problem?

Thank you very much.
-Ramón
Why don't you take this up with the company that makes the product?
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.