Prev: Export utility on a table is taking long time
Next: Export utility is taking long time
From: kavin on 30 Jun 2008 03:28
our Customer used to take backup all the tables of a particular schema
using export utility,
previously the export operation used to finish within 30 Minutes. As
of now it is taking
almost 12 Hours.

mainly while taking the backup of three particular tables.This tables
contains row sizes of 15 lakhs,one lakhs, 75 lakhs records
respectively
From: Serge Rielau on 30 Jun 2008 07:41
kavin wrote:
> our Customer used to take backup all the tables of a particular schema
> using export utility,
> previously the export operation used to finish within 30 Minutes. As
> of now it is taking
> almost 12 Hours.
Could it be that you have I/O contention? I would check that first.
Then I would check lock contention.

> mainly while taking the backup of three particular tables.This tables
> contains row sizes of 15 lakhs,one lakhs, 75 lakhs records
> respectively
A lakh is not a measure commonly known perhaps if you could translate
into a base 10 or base 2 readers may have a better idea of the table
sizes involved.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
 | 
Pages: 1
Prev: Export utility on a table is taking long time
Next: Export utility is taking long time