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

DB2 9.7 Performance Tuning

 7 Replies
 1 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
Chris12
Veteran Member Send Private Message
Posts: 150
Veteran Member
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 Send Private Message
Posts: 1498
Veteran Member
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 Send Private Message
Posts: 1498
Veteran Member
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 Send Private Message
Posts: 150
Veteran Member
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 Send Private Message
Posts: 150
Veteran Member
8/9/2012 6:36 PM
Greg, the attached file comes up blank .... Can you email it too me?
Chris12
Veteran Member Send Private Message
Posts: 150
Veteran Member
8/9/2012 6:39 PM
Greg, we run ADAM ..... it looks like your issue was Tivoli
Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
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 Send Private Message
Posts: 1498
Veteran Member
8/9/2012 7:47 PM
Let's try that document again.
Attachments