Enyimba
asked on
How would you as a DBA (DB2) answer this question?
Dear gurus,
A db2 user reports to the DBA team that there is a very noticeable degradation of a critical application - response time taking longer than usual, application not finishing on time.
Usually when I get this type of report from my user clients, I begin by asking the user exactly what the user is experiencing and take notes, check to see that my db2 is up and running by logging in to the instance and DB2 environment, check to see if I have utilities running that may have impact to the application(s), check the state of my tablespace/tables by doing some db2 displays, check the db2diag.log and the db2 notification log for warnings and errors such as contentions and locks, run some tools such as db2top, db2pd, if there is no real-time tools available and try to find what could be causing the slow-down the user is reporting.
My question to this esteemed gurus is this...how would you go about finding the cause and the resolution to such a question as reported by my user?
I would appreciate your comments and insights.
Thanks
Enyimba
A db2 user reports to the DBA team that there is a very noticeable degradation of a critical application - response time taking longer than usual, application not finishing on time.
Usually when I get this type of report from my user clients, I begin by asking the user exactly what the user is experiencing and take notes, check to see that my db2 is up and running by logging in to the instance and DB2 environment, check to see if I have utilities running that may have impact to the application(s), check the state of my tablespace/tables by doing some db2 displays, check the db2diag.log and the db2 notification log for warnings and errors such as contentions and locks, run some tools such as db2top, db2pd, if there is no real-time tools available and try to find what could be causing the slow-down the user is reporting.
My question to this esteemed gurus is this...how would you go about finding the cause and the resolution to such a question as reported by my user?
I would appreciate your comments and insights.
Thanks
Enyimba
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What's your db2 version?
ASKER
waynezhu,
DB2 version is 10.5.3, getting ready to upgrade to 10.5.5
DB2 version is 10.5.3, getting ready to upgrade to 10.5.5
ASKER
Kdo,
Thanks for your response and as always I appreciate your logic. But let me ask you this...what if the slow down is perhaps not SQL related? What/Where would you tend to look for possible clues? What type of tools would you want to use to triage the problem and if possible, why would you want to use that specific tools/utility (db2top,db2pd, SAR, NMON comes to mind). I am interested in your thought process about the issue...so help me and share the way you see it..
Enyimba
Thanks for your response and as always I appreciate your logic. But let me ask you this...what if the slow down is perhaps not SQL related? What/Where would you tend to look for possible clues? What type of tools would you want to use to triage the problem and if possible, why would you want to use that specific tools/utility (db2top,db2pd, SAR, NMON comes to mind). I am interested in your thought process about the issue...so help me and share the way you see it..
Enyimba
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>> what if the slow down is perhaps not SQL related?
That suggests a network or hardware error somewhere between the database server and the user desktop. That's pretty normal desktop troubleshooting and not really in scope with trying to determine why a query's performance has degraded.
That suggests a network or hardware error somewhere between the database server and the user desktop. That's pretty normal desktop troubleshooting and not really in scope with trying to determine why a query's performance has degraded.
Just noticed your question is in the Unix topic.
For OS monitoring, if sar data available, you will have pretty good picture of general health, any pattern change or abnormal.
If sar data not available, I would gather vmstat, iostat, etc on a regular basis for the same.
For OS monitoring, if sar data available, you will have pretty good picture of general health, any pattern change or abnormal.
If sar data not available, I would gather vmstat, iostat, etc on a regular basis for the same.