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

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