Thursday 12 April 2012

AIX Standard Tunnable Parameters

This is standard AIX Tunable Parameters for AIX 5.3 & 6.1 Series,
It's the best practice to use this parameters for the better performance., It's also depends on your environment.

Also 'AIO' is an important tunable parameter in Oracle DB Servers.,
For setting this Minservers & Maxservers value, we have to do such calculations.

minservers = 10 * # cpus
maxservers = (10 * # disks) / # cpus
maxreqs = a multiple of 4096 > 4 * #disks * queue_depth


For Application & DB Servers

Network Related Parameters :

no -a |egrep "tcp_finwait2|tcp_keepidle|tcp_keepinit|tcp_keepintvl|tcp_timewait|sb_max|rfc1323|use_isno|tcp_recvspace|tcp_sendspace|udp_recvspace|udp_sendspace"|sort

Memory Related Parameters :

vmo -a |egrep "lru_file_repage|lru_poll_interval|maxclient%|maxfree|maxperm%|minfree|minperm%"|sort

IO Related Parameters :

ioo -a |egrep "j2_maxPageReadAhead|j2_maxRandomWrite|j2_nBufferPerPagerDevice|j2_nPagesPerWriteBehindCluster|maxpgahead|maxrandwrt|numfsbufs|pv_min_pbuf"|sort

AIO Related Parameters :

aioo -a

Tuesday 20 March 2012

AIX 6 & AIX 7 Day Light Saving - March 25th

URGENT: Recent AIX 6 & AIX 7 Day Light Saving Time Fix for this weekend
Many countries switch to Daylight Saving Time (DST) next weekend March 25th - unfortunately you may need to apply a fix to
AIX 6 and AIX 7 before the change or programs can get inconsistent time from various time function and systems calls.
This could have a major impact on many tools, for example, make, logs and databases ... well just about anything that uses a time value.

There was an earlier temporary fix available but now there is a fully details final fix. Please got to the bellow website for all the details:

    * http://www-01.ibm.com/support/docview.wss?uid=isg3T1013017&myns=paix61&mync=E

Very briefly this involves the following AIX levels (see the website above for the definitive list):

    * AIX 7 TL1 all service packs (i.e. 1 to 3)
    * AIX 6 TL7 all service packs (i.e. 1 to 3)
    * AIX 6 TL 4, 5, 6 - only some recent service packs
    * Other levels are NOT effected and do NOT require any action

 AND only if you are using POSIX time zones - again more info on the website above.

 Then you will need to either install a small downloadable Emergency Fix (efix) and REBOOT - - O R - -  switch to Olson Time and REBOOT.

My systems are at the effect AIX level but I am using Olson time:

    $ echo $TZ
    Europe/London

POSIX time looks like GMT0BST - see the website above for examples.

Wednesday 18 January 2012

File Set "RE-BOOT" - Required (or) Not-Required

To see whether a reboot is mandatory you can look into the .toc and check the fileset line for "b" (bosboot) or "N) (no bosboot). Example for a fileset that requieres bosboot:
Code:

0 032816422609 2
bos.clvm.enh.5.3.0.67.U 4 R S bos.clvm {
bos.clvm.enh 05.03.0000.0067 1 b U en_US Enhanced Concurrent Logical Volume Manager


and no bosboot:

Code:

0 032905193009 2
bos.rte.install.5.3.0.70.U 4 R SF bos {
bos.rte.install 05.03.0000.0070 1 N U en_US LPP Install Commands