AIX learner's blog

Thursday, June 28, 2012

AIX Administration Command Lists

System and Software Installation Commands

# /usr/bin/tcbck To check if TCB is enabled on your system

# smit alog_show To view logs in the /var/adm/ras directory

# alog –L To view the logs defined in the alog database

# alog -f path of bosinstlog -o To view the content of log file

# alog -o -t boot To view the boot log

# last Shows the previous login and logoffs records from /var/adm/wtmp

# last root console To find when root user login and logoff from console

# last shutdown To determine when system was last shutdown

# /usr/lib/acct/fwtmp </var/adm/wtmp |grep run-level display a history of previous run levels using

# telinit M To change run level

# oslevel To see the current maintenance level of your system

# oslevel –r To see the current maintenance level of your system

# oslevel –s To see the current SP level of your system

# oslevel –sq To see the all SP and maintenance level of your system

# oslevel –g ML To see the greater ML of current ML

# oslevel –rl 5300-07 To see the ML which are less that specified

# cfgmgr –f Configure the devices as a phase 1

# cfgmgr Configure the devices as a phase 2

# cfgmgr –p Configure the devices as a phase 3

# cfgmgr -i /usr/sys/inst.images To find the installation medium to install drivers

# cfgmgr -l scsi0 Specifies the named device to configure along with its children

# bootinfo -s hdiskx It gives the size of the disk

# bootinfo -y System Hardware bit

# bootinfo -K System kernel bit

# bootinfo -p System architecture

# bootinfo -m Shows the memory

# shutdown –Fr To perform a fast shutdown and restart the system

# installp -avX -d/usr/sys/inst.images bos.net To install all filesets within the bos.net

# installp -acpX -d/usr/sys/inst.images bos.net To preview an install of all filesets within the bos.net

# cat /var/adm/sw/installp.summary A record of the installp output can be found

# installp -cgX all To commit all updates

# installp -rBfX ./reject.list To reject all applied updates listed in the file

# installp -ugp -V2 bos.net.ipsec.rte To preview a remove of bos.net.ipsec.rte and its dependents

# installp –C To do a cleanup after a installation failed

# installp -L -d /dev/cd0 To list the software that is on your CD-ROM

# geninstall -d/dev/cd0 R:cdrecord R:mtools To install the cdrecord and mtools open source RPM packages

smitty install_latest. To install software products

smitty install_commit To commit an applied software update

smitty install_reject To reject a service update that you have installed

smitty install_remove Remove installed and committed software

smitty install_software To install open source software

smitty maintain_software To clean up after failed installation

smitty easy_install To install software bundle created

Daily Management

•/etc/passwd Contains the basics of a user

•/etc/security/.profile Providing the user profile

•/etc/security/limits Contains all the ulimits, or users' system resource limitations

•/etc/security/passwd Contains the AIX user's password information

•/etc/security/user Contains the most important settings

•/usr/lib/security/mkuser.default Contains values used when creating user through mkuser

# getconf LOGIN_NAME_MAX To verify the setting in AIX 5.3 and later

# lsattr -El sys0 To verify the setting in AIX 5.3 and later

# chdev -l sys0 -a max_logname=129 To change the value of sys0

# mkuser xander To create a user with default settings

# finger xander Gives the short information of user

# chuser core=1048576 xander To change the User attribute

# chsh xander To change the user login shell

# chfn xander To change GECOS information

# lsuser -f xander List the user in stanza format

# passwd xander To set or change password of user

# passwd -f xander To change user GECOS using passwd command

# passwd -s xander To change the user SHELL using passwd

# rmuser xander Remove the user

# rmuser –p xander To remove fully user information

•/etc/group Contains the basics of a group

•/etc/security/group Contains extended attributes to the specified group

# mkgroup atctest To create a group

# mkgroup -a atcadmin To create an admin group

# mkgroup adms=xander xangroup To create a group and add Xander as the administrator of the group

# chgroup id=204 users=xander,atc,amdc xangroup Change the group's GID and add users

# chgrpmem Another way to modify a group's members is with chgrpmem

# chgrpmem xangroup List the group information

# chgrpmem -m - atc xangroup Remove a user from a group

# lsgroup xangroup List the info of group

# lsgroup -f xangroup List info of group in stanza fromat

# rmgroup atctest Remove the group

•/etc/security/environ Contains the environment attributes for users

•/etc/security/lastlog Contains the last login attributes for users

•/usr/lib/security/mkuser.sys Customizes new user accounts

•/etc/security/login.cfg Contains system default login parameters

•/etc/utmp Contains a record of users logged into the system

•/var/adm/wtmp Contains connect-time accounting records

•/etc/security/failedlogin Records all failed login attempts

•/etc/motd Contains the message to be displayed every time user login

•/etc/environment Specifies the basic environment for all processes.

•/etc/profile Specifies additional environment settings for all users.

•$HOME/.profile Specifies environment settings for a specific user.

# ps -ef To display all processes

# ps -f -l -ujim To list processes owned by specific users

# ps -M To list all the 64-bit processes

# kill 1095 To stop a given process

# kill -kill 2098 1569 To stop several processes that ignore the default signal

# kill -kill 0 To stop all of your processes and log yourself off

# kill -9 -1 To stop all processes that you own

# fuser -u /etc/filesystems List a process numbers and user login names of processes

# fuser -k -x -u -c /dev/hd1 To terminate all of the processes using a given file system

# fuser -kxuc /home To terminate all of the processes using a given file system

# fuser -d /usr To list all processes that are using a file that has been deleted from a given file system

# fuser -xc /tmp List open references within a specified file system

# find /home -type d -exec fuser -u {} \; Process is using a directory within the file system as its current working directory

# topas -i5 -n0 -p10 To view the top 10 processes

The svmon command captures and analyzes a snapshot of virtual memory

The svmon command creates nine types of reports

# svmon -G Global Report

# svmon -U User Report

# svmon -C Command Report

# svmon -W Workload Management Class Report

# svmon -T Workload Management Tier Report

# svmon -P Process Report

# svmon -S Segment Report

# svmon -D Detailed Report

# svmon -F Framed Report

# aclget status To display the access control information of status file

# aclput -i acldefs status To set the access control information of status from acldefs

# aclget plans | aclput status To set the access control information of status from plans

# acledit plans To edit the access control information of the plans

#chown -R john:build /tmp/src To change the owner & group of all files in the directory

# chmod 644 text To use the absolute mode

#chgrp -R staff proposals Change the group ownership of the directory named proposals of dir stuff

# at -f filename -t CCYYMMDDhhmmSS Increment Submit a job to be run at a later time

# at now -f appl/program > /dev/null 2>&1 To start at job now

# atq List the at jobs

# at -r root.1134169200.a Remove the at job

# ls /var/spool/cron/atjobs Location of at jobs

# ls -l /var/spool/cron/crontabs Location of cron jobs

# crontab -l List the all cron jobs

# crontab -e To edit crontab file

# crontab -v username Lists the status of the user's cron jobs

# crontab -r Remove the crontab file

# crontab ~deploy/deploy.schedule Runs the crontab file under user deploy

•/var/adm/cron/log The cron daemon logs file

•/var/adm/cron/cron.deny Deny cron access to user for cron schedular

•/var/adm/cron/cron.allow Allow cron access to user for cron schedular

•/var/adm/cron/at.allow Allow cron access to user for at schedular

•/var/adm/cron/at.deny Deny cron access to user for at schedular

# telinit Directs the actions of the init process

# telinit M Goes into the maintainance mode

# telinit q Tell the init command to reprocess the /etc/inittab

Normally, you do not need to restart srcmstr. If the srcmstr daemon terminates abnormally, the respawn action specified in the /etc/inittab restarts the srcmstr daemon.

A command is a request to perform an operation or run a program. A program or command that is actually running on the computer is referred to as a process.

The common types of processes are:

Foreground and background processes

Processes that require a user to start them or to interact with them are called foreground processes. Processes that are run independently of a user are referred to as background processes. Programs and commands run as foreground processes by default.

Daemon processes

Daemons are processes that run unattended. They are constantly in the background and are available at all times. Daemons are usually started when the system starts, and they run until the system stops. A daemon process typically performs system services and is available at all times to more than one task or user. Daemon processes are started by the root user or root shell and can be stopped only by the root user. For example, the qdaemon process provides access to system resources such as printers. Another common daemon is the sendmail daemon.

Zombie processes

A zombie process is a dead process that is no longer executing but is still recognized in the process table (in other words, it has a PID number). It has no other system space allocated to it. Zombie processes have been killed or have exited and continue to exist in the process table until the parent process dies or the system is shut down and restarted. Zombie processes display as <defunct> when listed by the ps command.

Ctrl-C To intrrupt the process

Ctrl-Z To stop process

# fg 589934 To bring the process in to the foreground

# find / -type f > dir.paths & Run the find command in the background

# nohup find / -type f & To run the find command and leave it running after you log off in Bg

0 Represents standard input (stdin) <

1 Represents standard output (stdout) > or >> (append)

2 Represents standard error (stderr) 2> or 2>> (append)

2>&1 Redirects stderr to stdout.

1>&2 Redirects stdout to stderr

Performance Monitoring

# nice -10 foo Add 10 to current nice value (Lower Priority)

# nice -n 10 foo Add 10 to current nice value (Lower Priority)

# nice - -10 foo Subtract 10 from current value (Higher Priority)

# nice -n -10 foo Subtract 10 from current value (Higher Priority)

# renice -10 –p 563 Add 10 to default nice value (Lower Priority)

# renice –n 10 –p 563 Add 10 to current nice value (Lower Priority)

# renice - -10 –p 563 Subtract 10 from default nice value (Higher Priority)

# renice –n -10 –p 563 Subtract 10 from current nice value (Higher Priority)

# ps –ekl Long listing of kernel processes with priority

# ps –L 483445 –l It list the child the processes of parent process

# ps –kmo THREAD –p 16396 It list the threads of particular processes

# schedo To change the CPU usage priority decay rate

Context Switch : A context switch is when one thread is taken off a CPU and another thread is despatched onto the same CPU.

User Mode : User mode is when thread is executing its own application code or shared library code. Time spent in user mode is reflected as %user time in output of commands such as vmstat, topas, iostat, sar.

System Mode : System Mode is when the CPU is executing code in the kernel. CPU time spent in kernel mode is reflected as system time in output of vmstat, topas, iostat, sar commands. Context switch time, system calls, device interrupts, NFS I/O, and anything else in the kernel is considered as system time.

# time It show the elapsed time in system and user mode

# vmstat 5 3

# vmstat -f To display fork statistics

# vmstat -s To display count of various events

# sar –P ALL 5 1 All CPU related usage

# sar –q 5 3 Queue details

# ps aux Locating the dominant processes

# tprof –x sleep 60 Reports processor usages

# lparstat 2 3 System wide CPU report

# sar –P ALL 2 2 Viewing CPU statistic with SMT

# sar -d 1 2 Disk I/O statistic

# smtctl To check SMT is enabled or not

# smtctl –m on –w now Tern on SMT immediately

# smtctl –m on –w boot Tern on SMT at next reboot

# bindprocessor –q To check logical CPU

# iostat I/O device statistics

# iostat -d hdisk2 2 Continuous disk report

# netstat network statistic

# netstat -rn Network routing table

# netstat -rs Network routing statistic

CPU bound A system is said to be CPU-bound if the total system (sy) and user (us) CPU usage is approaching 100 percent. This would imply that idle time and wait time for CPU are approaching zero.

Memory bound A system is memory-bound if some virtual memory is forced out to disk, meaning the system is waiting on a relatively slow disk instead of relatively fast RAM. This is indicated by a non-zero value in the page-in (pi) and page-out (po) values.

Paging rate is the average number of page-ins and page-outs per CPU cycle.

Idle time calculation:

Total CPU Idle Time % = wait % + Idle Time %

Ex:

Average CPU Idle Time percentage = ((99+1) + (97+2) + (95+4) + (99+1))/4 = 99.5%

Wednesday, June 13, 2012

Just for me

Friday, June 8, 2012

AIX boot process in very simple word !

Could you please describe the booting process of AIX ? this is the frequest question they have been asking for each interview and I used to say if you need all theory I would not be able to tell you but what i knew is .......
So finally decided to write a small post just for my reference, If you feel it's usfull use it :).

BOOT Process :

PHASE-I :
------------
unix4you # BIST - built in self test
unix4you # POST - Power on self test
unix4you # call rc.boot 1 script
unix4you # Locate the boot LV
unix4you # restbase command will be called to copy the partial ODM from BLV to RAMFS.
unix4you # cfgmgr -f ( to configured the base devices)
unix4you # bootinfo -b - to derimine the last boot disk
unix4you # Locate the Boot disk

PHASE-II :
------------
unix4you # call rc.boot 2 script
unix4you # ipl_varyon command will varyon the rootvg ( If fails LED 552,554,556 )
unix4you # fsck -f for root filesystem hd4.
unix4you # Root filesystem will be mounted temparorily as /mnt in RAMFS. (if fails LED 557)
unix4you # /usr will be verified using fsck -f and mounted. (If fails LED 518)
unix4you # /var will be verified using fsck -f and mounted. copy core command will check for the previous dump in /dev/hd6 and the dump will be copied in to the /var/adm/ras.
unix4you # Paging /dev/hd6 will be avtivated
unix4you # mergedev process will be called and all /dev filesystems will be copied from RAMFS to disk.
unix4you # ODM will be copied to the disk.
unix4you # root filesystem will be mounted in rootvg.
unix4you # /var /usr will be mounted on their ordinary mount points.
unix4you # these boot messages will be copied in to the alog.

PHASE-III :
------------
unix4you # Rootvg is activated.
unix4you # /etc/init will call the rc.boot file with argument 3
unix4you # /tmp will be mounted.
unix4you # syncvg command will be invoked and the rootvg get synced.
unix4you # cfgmgr is called with option -p2. if the system booted service mode then option -p3
unix4you # console is configured using cfgcon ( log file : /var/adm/ras/conslog)
unix4you # savebase command will sync the ODM in BLV.
unix4you # syncd daemon & errdemon started.
unix4you # LED is turned off.
unix4you # The execution of rc.boot is now completed. init will continue processing the next commands in /etc/inittab.

Monday, April 23, 2012

Oracle / DBA Training in pune !

Hi Guys,

I think not only AIX but i should try to get all information related to DBA / Oracle

So soon I will update this page with all information of DBA / Oracle training in pune !