DSXchange

Hello David, the transactions from the other process is independ from the table(s). Importend are only those transactions that use the same rollback segment as your own transaction. Mostly I get ORA-1555 during reading from the source, because my starting SCN was overwritten from other transaction. ...

Hi David, Thanks v. much for that detailed explanation. I think Ill go back to the beginning and get our DBA to put a trace on the DB to prove that my query is the only thing running on that table. The rare scenario that you have explained is the one that I was worried about, but I think that this w...

OK, here goes. 99.9% of the time, ORA-01555 implies that between the start of your generally long running query and the time of the error, another process updated and committed changes to the table you are reading (etc- all covered in other posts). Obviously, the first thing to do is try every way p...

Hi All, I have a job control process which on completion of job, will append log information to the job that just completed. Do do this I am using the following command. echo "test message" | /opt/ascential/DataStage/DSEngine/bin/dsjob -log -info dev jobname Running this from the command line, works...

Hello Stacy If youre still experiencing problems with timeout from FTP stage, why not spilt your job up into separate jobs? This way you can issue telnet instructions in one job and then call the FTP job when its done. I believe this would make for a sounder batch. Also, under NT, consider using the...

You should be able to use standard job parameters in the user generated SQL part, using the #PARAM# notation. This if each component is passed as a param this could be used. Alternatively if you wanted to use some kind of Redbrick side solution you could try creating a macro to handle the inserts. M...

Thanks for the comments guys, I had read the post before, but couldnt relate it to my scenario. The problem I have is that I dont understand how the error could be occurring. This is because it is happening on a test environment that has one user which is under my control. The offending job is one o...

This is a topic for an orphaned message.

By default, most Oracle instances seem to be set up with a lot of rollback segments, this is fine for you average OLTP scenario but not useful for a reporting environment. In a Data Warehouse or Data Mart when you (mostly) have end users running selects and a reletively small number of batch process...

Not having a good day, make that incorrectly Wolfgang. Adam amcguinness@qbe.com.au on 21/08/2002 10:33:18 AM Please respond to datastage-users@oliver.com To: datastage-users@oliver.com cc: (bcc: Adam McGuinness/NSW/QBE/AU) Subject: Re: Dynamic ODBC Stage Update Gavin As I indicated it seemed a good ...

Gavin As I indicated it seemed a good idea. However being reasonably new to RedBrick, I have discovered that RB views are read only! Wofgang, I must apologise for spelling your name correctly earlier. Thems the breaks Adam Gavin.Cooke@vodafone.co.nz on 20/08/2002 10:21:02 AM Please respond to datast...

This is a topic for an orphaned message.

Hello Regu, We have faced this problem several times and have solved it in a crude manner We ask the DBA to take all rollbacksegments except big rollback segments offline. This is becauase, in Datastage 4.x, there is no way of issuing the Oracle command to set a rollbacksegment for a transaction (se...

Thanks for that Chris. You just saved me from another long reply. Regu - if that link still does not answer your question, let me know. There is still one really obscure way to get ORA-01555 which is not covered by those posts, but it is extremely rare and not worth the effort of trying to explain i...

Ive come accross the error before and was helped by the following post found in www.tools4datastage.com: m Chris. www.altis.com.au Quoting Regu.Saliah@astrazeneca.com: > Fellow DS users. > > Im running DS 5.2 on AIX with Oracle 9i and Im getting the above > Oracle error intermittently. Ive come acro...