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
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
    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
      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
        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
          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
            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
              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
                Posts: 1498
                Veteran Member
                8/9/2012 7:47 PM
                  Let's try that document again.
                  Attachments