DSXchange

aakashmalu wrote: ps:Target table has indexes.

Did you get this sorted? You say that the target table has indexes. How many indexes? Do they need to reorged? This would slow down the inserts.

Can the update statement actually use the index that you think it should, or is it doing a TS scan to update 1 row.

select T1.A1 from table T T1 ,T T2" where <join conditions> --- note this is a self join. Why can this query not be used to create a hash file? Just select T2.A2, as well as T1.A1, and make this the key of the hash file. How many rows would this query generate? You say that the lookup has been...

I think this falls into the "Just run it and see what happens" bucket Ray.

Is there a parameter to enable this to append to to_file_name file?

Have you tried Googlisms?
http://www.googlism.com

Yay! It has ended OK. I was not looking forward to the rollback if it crashed.... Have now dissabled 24 RI constraints on the target table and it is running again. Lot less rows today, but a lot faster as well. Now to see how many other tables have useless constraints eneabled on them... Thanks guys.

In excess of 24 hours run time is in no way acceptable. It is doing a lot of work (many rows to process) but it should run quicker than it seems to have been over the last day. It was running at about 8 rows per second when the counts stopped. It usually does run quicker than this. Maybe up to 100 r...

Has there ever been a solution found for this problem? I have a job in the same situation currently. Running for 25:30 hours and the stats stopped updating some time back. It SEEMS to be still running, but I would like to know how far it has got. As far as I can see the two Oracle databases involved...

Thanks Ray. Found the note and passed it on to our DBA.

Kenneth, yes to all of that. Run time was 15 and 20 hours. I have modified the jobs to select only those rows that did not get processed first time round into a sequential file, then to process these. One still had 3.5M to go, the other only 1.9M so I should be able to get them run in a reasonable t...

I have two different (but similar) DS jobs that read data from Oracle 9i (9.2.0.5), perform 3 hash file lookups and 3 Oracle lookups, and write (INSERT) rows into a table on a second Oracle instance. My problem is that after ABOUT 16M rows (16,239,271 for one, 16,497,919 for the other) the job abend...

What was the error code from the DB2 system log (allways assuming there was one)?

You could also ask your DB2 DBA if row level locking might help you. Generally a DB2 table would be created with a number of rows per block, and an update lock will lock the whole block. If the blocks are large, or the rows are short, then the possability of two updates hitting the same block would ...

DISKCACHE = -1 and DCWRITEDEAMON = 0.

Off to do some reading....

Thanks Ray.

-805 error code in DB2 means "DBRM OR PACKAGE NAME NOT FOUND IN PLAN" So go to the DB2 system and find out what package or plan it is complaining about and get the DB2 DBA to rebind it for you. What method of accessing DB2 are you using? DB2 Connect, Oracle Transparent Gateway, something e...