kavin wrote:
Quote:
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.
Quote:
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
