• Search Forums
    Advanced Search
Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

DB2 9.7 Performance Tuning

 7 Replies
 1 Subscribed to this topic
 28 Subscribed to this forum
Sort:
Author
Messages
Chris12
Veteran Member
Posts: 150
Veteran Member
New Poster
New Poster
Congrats on posting!
8/9/2012 4:43 PM
Does anyone have any type of documentation as it relates to the performance tuning of DB2 on an AIX system.  We seem to be running very slow on data related actviites in both portal and LID ..... Anything is appreciated.

Greg Moeller
Veteran Member
Posts: 1498
Veteran Member
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
8/9/2012 5:30 PM
We had horrible performance upon our go-live. Took us 3 weeks to get it rectified. Here's just one of the places we were referred to: http://www.ibm.com/develo.../library/t-tds-perf/ and then:
http://www.ibm.com/develo...t-tds-perf/#Analysis scripts

Making some adjustments to our DS config file helped as well. I'll see if I can't dig out what Lawson sent us.
Greg Moeller
Veteran Member
Posts: 1498
Veteran Member
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
8/9/2012 5:42 PM
Make a backup copy of you ibmslapd.conf file.  Make the highlighted in yellow changes to your ibmslapd.conf file and restart db2.
Attachments
Chris12
Veteran Member
Posts: 150
Veteran Member
New Poster
New Poster
Congrats on posting!
8/9/2012 6:09 PM
Thanks ... any other information would be great ...... One more fact is that we have an application server and a seperate DB server .... Not sure if that makes a difference ...
Chris12
Veteran Member
Posts: 150
Veteran Member
New Poster
New Poster
Congrats on posting!
8/9/2012 6:36 PM
Greg, the attached file comes up blank .... Can you email it too me?
Chris12
Veteran Member
Posts: 150
Veteran Member
New Poster
New Poster
Congrats on posting!
8/9/2012 6:39 PM
Greg, we run ADAM ..... it looks like your issue was Tivoli
Greg Moeller
Veteran Member
Posts: 1498
Veteran Member
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
8/9/2012 6:53 PM
Chris12: Yes, ours was tivoli... but the perf_tools scripts are for db2. Lawson had us especially look for long running queries on non-indexed values and correct those.
Greg Moeller
Veteran Member
Posts: 1498
Veteran Member
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
8/9/2012 7:47 PM
Let's try that document again.
Attachments