useful logs

sap:
work directory:

• dev_w#
• dev_disp
• dev_msg
• stderr
• list goes on in this directory...

r3trans -d => for a trans.log to see db connections.

oracle:
$oracle_home/saptrace/background -alert log file
listener.log

db2:
Db2diag.log -> E= External users, I = internal users, D = developers
db2level ->db versioning n patch
db2nodes.cfg

below are found in the DIAGPATH:

• trap files = t###.<partition>/p####.<partition> -> info about db2 if it is stuck due to a trap violation or exception
• dump files -> occurs when there is an error, for extra info on the error.
• stack files
• core files = C###.<partition>
• db2 event log = infra events in db2 engine desc (after restart will be overwritten) read using db2support tool
• db2dart
• db2qpt.nfy = notify log
• db2trc output et al

use of db2support:
db2support <output path> -d <database name> -c

Oper sys log files
usr/bin/errpt -a (aix)
/var/adm/messages* or usr/bin/dmesg(solaris)
var/adm/syslog/syslog.log or usr/bin/dmesg(unix)
windir\drwtsn32.log (windows)
AIX:

• lsps -a = how paging space is being used
• lsattr -l sys0 -E = displays various OS parameters
• topas = reports stats on activities of sys
• xmperf = graphic monitor collects n displays performance data (only for motif)

UNIX/LINUX

• df -h
• truss = tracing system calls
• pstack(solaris) = stack traceback info
• pargs(solaris) = env of certain process pargs -e <pid>
• ldd = dynamic dependencies
• top = monitor sys activities
• vmstat = paging rate pi= page in po = page out
• iostat = i/o activities
• netstat = network traffic
• db2osconf = check hpux/solaris os kernel
• ipcs -l for linux
• prtctl -t privileged <pid> = show setting per process (solaris)

JAVA

• dev_jcontrol = Trace file for the JControl process
• dev_<node name> = Jlaunch process info
• jvm_dispatcher.out = file for JVM outputs.
• std_server#.out = started manafer/services
• std_dispatcher.out = same as above.