Home » Infrastructure » Other Operating Systems » Massive update processing
Massive update processing [message #113932] Tue, 01 July 2003 11:16 Go to next message
Carol Cloyed
Messages: 2
Registered: July 2003
Junior Member
We are attempting to update a 64 million row table by partition. There are 30 partitions with @ 2 million rows per partition.

It is taking 14+ hours to update if the process completes.

Several times the process seems to "hang up".

Is there any experience that you could pass on to help us overcome this roadblock?

Thank you.
Re: Massive update processing [message #113952 is a reply to message #113932] Wed, 27 August 2003 08:22 Go to previous message
Subhash Roy
Messages: 24
Registered: January 2001
Junior Member
: We are attempting to update a 64 million row table by partition. There are 30 partitions with @ 2 million rows per partition.

: It is taking 14+ hours to update if the process completes.

: Several times the process seems to "hang up".

: Is there any experience that you could pass on to help us overcome this roadblock?

: Thank you.

: 30 partitions meaning 30 tables, each table on the different disk? Are the data distributed evenly across the tables? Have you ever thought of running 30 separate SQL statements, each stataement updating the specific table only? It's just a thought.
Previous Topic: OEM and MVS
Next Topic: Enclaves being left on oracle 9202 (zos 1.4)
Goto Forum:
  


Current Time: Thu Mar 28 17:13:57 CDT 2024