469,927 Members | 1,904 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,927 developers. It's quick & easy.

Performance problem after replication


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 ?

Andy the beginner in DB2.

Feb 21 '06 #1
0 1007

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Andras Kovacs | last post: by
1 post views Thread by Tobias Johansson | last post: by
1 post views Thread by Gert van der Kooij | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.