mercredi 25 avril 2007

Current recommended AIX 5.3 Performance Parameters

Network
no -p -o rfc1323=1
no -p -o sb_max=1310720
no -p -o tcp_sendspace=262144
no -p -o tcp_recvspace=262144
no -p -o udp_sendspace=65536
no -p -o udp_recvspace=655360
nfso -p -o rfc_1323=1
nfso -p -o nfs_socketsize=60000
nfso -p -o nfs_tcp_socketsize=600000

Memory Settings

vmo -p -o minperm%=5
Leave maxperm and maxclient at default of 80
Leave strict_maxperm and strict_maxclient at their defaults
vmo -p -o minfree=960
vmo -p -o maxfree=1088
vmo -p -o lru_file_repage=0
vmo -p -o lru_poll_interval=10

IO Settings

Leave mipgahead and J2_minPageReadAhead at their defaults of 2
ioo -p -o j2_maxPageReadAhead=128
ioo -p -o maxpgahead=16
ioo -p -o j2_maxRandomWrite=32
ioo -p -o maxrandwrt=32
ioo -p -o j2_nBufferPerPagerDevice=1024
ioo -p -o pv_min_pbuf=1024
ioo -p -o numfsbufs=2048

If doing lots of raw I/O you may want to change lvm_bufcnt

Default is 9
ioo -p -o lvm_bufcnt=12

Others left to default that you may want to tweak include:

ioo -p -o numclust=1
ioo -p -o j2_nRandomCluster=0
ioo -p -o j2_nPagesPerWriteBehindCluster=32


Tuning a Perfect Note (Jaqui Lynch)

http://www.circle4.com/jaqui/eserver/eserver-AugSep06-AIXPerformance.pdf

Tuning AIX : rapport des paramètres

script générant un rapport des paramètres en cours.

source = http://www.circle4.com/jaqui/perfdata53-latest.sh.txt

HINT For UNIX

| Q: anybody got a one-line command line script that will set your
| display for remote usage without having to go through the
| who | grep uid and setenv commands?

# for C shell
setenv DISPLAY `who am i | cut -d '(' -f 2 | cut -d ')' -f 1`:0.0

# for Korn shell (but not for historic Bourne shell)
export DISPLAY=`who am i | cut -d '(' -f 2 | cut -d ')' -f 1`:0.0



source : http://www.cs.utk.edu/~shuford/terminal/xterm_news.txt

Administration &Tuning AIX

quelques liens :
Tuning
http://www.circle4.com/blosxomjl.cgi/
http://www.circle4.com/jaqui/eserver/aixtra-May05-TuningJFS2.pdf
http://www.circle4.com/jaqui/eserver/eserver-AugSep06-AIXPerformance.pdf

Administration
http://www.ibmsystemsmag.com
  • handy AIX Reference Guide
  • AIX Commands Cheat Sheet, Part 2

http://www.circle4.com/jaqui/eserver/aixtra-FebMar06-SimplifyingwithNIM.pdf

SSH configuration : X11 Forwarding

/etc/ssh/sshd_config
ListenAddress 0.0.0.0
X11Forwarding yes
XAuthLocation /usr/bin/X11/xauth
Subsystem sftp /usr/sbin/sftp-server

/etc/ssh/ssh_config
ForwardAgent yes
ForwardX11 yes
XAuthLocation /usr/bin/X11/xauth

arret/relance du deamon SSH (Commandes AIX)
stopsrc -s sshd

startsrc -s sshd

lundi 23 avril 2007

Documentation technique AIX

http://publib.boulder.ibm.com/infocenter/pseries/v5r3/index.jsp

Documentation technique HP UX

http://docs.hp.com/fr/index.html

Comparatif Oracle et SQL Server sous Windows

simplement intitulé "Oracle, SQL Server, quel SGBD en environnement Windows ?", Calipia emet un livre blanc comparatif intéressant sur ces 2 SGBD.
http://www.calipia.com/sql/SqlOracle.pdf