Performance problem after replication

[Andy K]

Hi,

After a replication between 2 databases, performance problem has
appeared with the master database.

The database is a 2 tiers application where web frontal is targeting
this database. Before the replication, the delay was acceptable for the
end users.

After the replication and the modification I have done in order to make
it work, the performance are poor.

The frontal applications with the agent seems to use a lot of CPU
ressources on the database server while connecting to the database.

The modifications I made on the master database are recreating the
temporary tablespaces creating one with a 4K pagesize (and a size of
3Go) and an another one with 32K pagesize (and a size of 2Go).

Before thoses tablespaces were SMS and now they are DMS.

The database is on a OLTP mode (small transactions).

In the oracle model, a temporary tablespace even with big size doesn't
seem to be a problem because the sort can use all the space necessary.

My questions are :

- Does thoses temporary tablespaces affect the performance of the
database ?
- If not, what else can it be ? I try to check the db2diag.log and
nothing appears.
- do you have something in mind ?

Regards,
Andy the beginner in DB2.