Performance Issue

ratheeshknair · #1 (**permalink**) 05-20-09, 00:16

Hi Experts,

All the developers are complaining about performance issue that is the whole server is slow.

The server is DB2 9.5C Express

OS:windows XP

2GB RAM

Marcus_A · #2 (**permalink**) 05-20-09, 00:58

Bummer....

stolze · #3 (**permalink**) 05-20-09, 13:08

Obviously, you are using the wrong type of graphics card in the server...

ARWinner · #4 (**permalink**) 05-20-09, 13:55

Quote:

Originally Posted by ratheeshknair

Hi Experts,

All the developers are complaining about performance issue that is the whole server is slow.

The server is DB2 9.5C Express

OS:windows XP

2GB RAM

You really need to ask for specific help. Your statement is so vague, that nobody can help you. All you will get are comments like the ones from Marcus and Stolze.

Andy

ratheeshknair · #5 (**permalink**) 05-21-09, 00:22

I am new to DB2 that y asked sch a question...i found the number of applications connected which is less than 50.

Can anyone please tell how to figure out this type of issues in DB2.

How can we find the the issue is caused by a particular query?
How can we identify locks and deadlocks in DB2?
How to check whether any blocking is there?
How to know the cpu utilisation of each process?
How to know the time connection existed?

Please reply

Marcus_A · #6 (**permalink**) 05-21-09, 01:32

If I were you, I would find someone who has some experience as a DB2 DBA. If you are new, you will need some DB2 education, or start reading all the manuals.

Internet Services

Web Development

Digital Marketing

Consumer Tech