Wednesday, October 19, 2011

Combining DB2 and OS Diagnostics Part 1

Often there is need to combine DB2 diagnostic data with OS. Here are few useful commands and utilities you can use on different platforms..

AIX HP-UX Solaris Linux
OS level /usr/sbin/oslevel /usr/bin/uname -a /usr/bin/uname -a /bin/uname -a
Software /usr/bin/lslpp -ah /usr/sbin/swlist -v /usr/bin/showrev -p /bin/rpm -qa
CPUs /usr/sbin/lsdev -C (grep proc) /usr/sbin/ioscan (grep processor) /usr/sbin/psrinfo -v /bin/dmesg (grep CPU)
Memory /usr/sbin/lsattr -El sys0 (grep realmem) /usr/samples/kernel/vmtune /usr/sbin/dmesg (grep Physical) /usr/sbin/prtconf (grep Memory) /bin/dmesg (grep Memory) /usr/bin/free
IPC resources Ipcs /usr/sbin/kmtune SAM GUI tool /usr/sbin/sysdef -i /etc/system (file) /usr/bin/ipcs -l
User limits ulimit -a /etc/security/limits (file) ulimit -a ulimit -a ulimit -a
User environment Set Set Set Set

Windows NT has a nice interface for obtaining system information:
winmsd /af

On Windows 2000® and XP®:
<OSdrv>:\Program Files\Common Files\Microsoft Shared\MsInfo\Msinfo32
This command does not report on installed software. One way to obtain this information is
to export the registry (at least the HKEY_LOCAL_MACHINE\SOFTWARE branch) to a
file by using the regedit tool.

System error and message logs on UNIX®
The following table shows where the logs are located on different UNIX platforms.

AIX HP-UX Solaris Linux
Error / Message Logs /usr/bin/errpt -a /var/adm/syslog/syslog.log /usr/sbin/dmesg /var/log/messages* /var/adm/messages*

No comments:

Post a Comment