AIX

AIX

Connect with fellow AIX users and experts to gain knowledge, share insights, and solve problems.


#Operatingsystems
#Servers
#AIX
#AIX
#AIX
#AIX
#AppPerformanceManagement
#Power
 View Only

  • 1.  Kernel Tuning

    Posted Fri December 11, 2009 06:06 AM

    Originally posted by: rob101


    Hi All,

    On database machine hosted on AIX 5.3 what should be the optimal settings for following Kernel parameters or default value should be sufficient:

    AIXTHREAD_MINKTHREADS
    AIXTHREAD_SCOPE
    AIXTHREAD_MNRATIO
    SPINLOOPTIME
    MALLOCTYPE
    MALLOCBUCKETS

    Here is the machine specs:

    AIX > 12CPU, 2 core AIX, 128GB RAM.
    Thanks
    ROB
    #AIX-Forum


  • 2.  Re: Kernel Tuning

    Posted Fri December 11, 2009 09:53 AM

    Originally posted by: alethad


    What database and what version are you running?
    Tuning can vary according to which database you're running.
    #AIX-Forum


  • 3.  Re: Kernel Tuning

    Posted Sat December 12, 2009 11:17 AM

    Originally posted by: RobStables101


    Can you let me know optimal settings for Oracle Database and DB2?

    thanks
    #AIX-Forum


  • 4.  Re: Kernel Tuning

    Posted Mon December 14, 2009 09:17 AM

    Originally posted by: alethad


    Sure.
    There is an very good Redbook on the IBM site that I use and you should keep on hand also. It was written a few years ago but it does get updated when new versions of Oracle and AIX are released.
    Here is the link.

    http://www-03.ibm.com/servers/enable/site/peducation/wp/162b6/162b6.pdf

    I am also attaching a copy of the original just in case. Look at page 25.

    Good luck.


Related Content