DSXchange

This error message is misleading. Im guessing that the CLARITY stage in your job is an input to the job, or if that OCI stage has inputs and outputs, it is the link that reads data (an output of the stage) that caused the problem. Changing the transaction size will not help. What you observed was si...

Hi, all My overnight job aborted last week along with the message: ProcessFSEBITClassification.CLARITY: ORA-01555: snapshot too old: rollback segment number 6 with name "RBS5" too small. It seems that the rollback segment is not enough, my oracle DBA thought The RBS are large enough for an OLTP syst...

Hi We are using Datastage 4.0 with Oracle 8.1.7. The plug-in we use is oraoci8.sl (Oracle 8 OCI stage version 2.3, OCI 8.1.6 ). It has a dependency on oraoci8enu.sl. The Datastage user ids should still have ORACLE_HOME set to the 8.1.6 directory (DOnt get rid of this directory while upgrading). Data...

Ah, you are using Unix. The ORAOCI8.DLL is an NT file. I am still of the opinion that you should be fine. -----Original Message----- From: Sudhir Mahendru [mailto:sudhir.mahendru@db.com] Sent: Monday, 6 August 2001 8:06 PM To: datastage-users@oliver.com Subject: RE: SQLCODE detection in Datastage Hi...

Hi I am using oraoci8.so file, I do not think it is Oracle 8i plug-in. pls advice thanks and regards Sudhir Mahendru CTI-Banking Systems- IDMS/IDMS-DataWarehouse (65) 423-7449 ---------------------------------------- Message History ---------------------------------------- From: david@barham.hm on 0...

To the best of my knowledge, there are only 2 variants of version 2.3 (DataStage 3.6 onwards) of the ORAOCI8 plugin. One is for Oracle 8, the other for Oracle 8i, that is, Oracle 8.1.5 onwards. It is my belief that you will not then require a different version of the plugin, provided you selected th...

I have datastage 3.6.3 installed and using Oracle OCI 8.0 plugin to populate the data in Oracle 8.1.5 table. If I upgrade my oracle version to 8.1.7 do i need to upgrade the plugin also, or the older version will work as it is. thanks and regards Sudhir Mahendru CTI-Banking Systems- IDMS/IDMS-DataWa...

Thanks David. Thats exactly what I thought it is! But the DataStage Help confused me! Have you read it? > -----Original Message----- > From: David Barham [SMTP:David.Barham@Anglocoal.com.au] > Sent: Friday, 3 August 2001 11:38 > To: datastage-users@oliver.com > Subject: RE: OCI - Array Size Vs Trans...

It is the opposite of what you have described. Array size is the number of rows transferred between DataStage an Oracle at a time. It applies to both input and output. For reading, Oracle will build up the required number of transactions before sending them to DataStage. On output, DataStage will bu...

Hi All Im a bit confused with the above. The help implies, to me at least, that "Array size" indicates the transaction size in Oracle ie the number of rows to commited by Oracle at a time. The "Transaction size" is the number of rows DataStage process before sending it to Oracle. Can someone confirm...

Hi Vivek You can try to the following. Create a control job or better a script if it is in unix or an app in VB or something like that to be fired off with some parameters where you supply it the time you want to wait for the data to appear before abort and an interval to check say every 60 seconds....

UniVerse (DataStage engine) has an ENV command. You could execute the command ENV DISPLAY LOG and capture its output, perhaps using DSExecute with the shell argument set to "UV", this in a before/after subroutine or in a job control routine. -----Original Message----- From: Nuno Pimenta [mailto:nuno...

rahim, send a list of the column definitions in the stage...it would be helpful to us... -Ken rahimladha@hotmail.com on 01-Aug-2001 17:14 Please respond to datastage-users@oliver.com To: datastage-users cc: Subject: Oracle Decode problem in DataStage I have this query, SELECT BILL_TO, NVL(SUM(expens...

I have this query, SELECT BILL_TO, NVL(SUM(expense.quantity),0.00) qty NVL(SUM(decode(expense.expense_type,REV,expense.total)),0.00) rev FROM expense WHERE expense.id=268435656 GROUP BY bill_to When I run that query in SQL*Plus, it runs perfect but when I try to run in DataStage using Oracle(v. OCI ...

Thanks, gang. Ill get with the DBA tomorrow morning and give it a shot. (I dont have the access rights to Unix.) I goofed creating the file. All I wanted was a simple dynamic file, but the prompts from UniVerse on the Unix box are slightly different from our DataStage NT box. Live and learn. Thanks,...