Technical Blog Post
Abstract
75 ways to demystify DB2 #74: Techtip : How to find which environment variables are being used by DB2?
Body
AIX : ps eww <pid_of_the_process>
Linux : strings –a /proc/<pid_of_the_process>/environ
Solaris : pargs -e <pid_of_the_process>
Here is an example on AIX :
$ db2start
SQL1063N DB2START processing was successful.
$ db2pd -edus
Database Member 0 -- Active -- Up 0 days 00:00:03 -- Date 2015-10-28-06.56.18.312890
List of all EDUs for database member 0
db2sysc PID: 36634706
db2wdog PID: 33882184
db2acd PID: 31391768
EDU ID TID Kernel TID EDU Name USR (s) SYS (s)
=====================================================================
1800 1800 19530085 db2resync 0.000307 0.000467
1543 1543 19595607 db2ipccm 0.000183 0.000142
1286 1286 17760565 db2wlmtm 0.001566 0.000981
1029 1029 19136857 db2wlmt 0.000141 0.000053
772 772 18612559 db2licc 0.000148 0.000296
515 515 18940247 db2thcln 0.000130 0.000017
2 2 18743635 db2alarm 0.000300 0.000161
258 258 84606999 db2sysc 0.093777 0.064151
$ ps eww 36634706
PID TTY STAT TIME COMMAND
36634706 - A 0:00 db2sysc DB2LIB=/home/db2inst1/sqllib/lib DB2_TOOLS_BIN= DB2_HOME=/home/db2inst1/sqllib HOME=/home/db2inst1 PWD=/home/db2inst1 TZ=EST5EDT DB2INSTANCE=db2inst1 HOSTNAME=p6db2serv LANG=en_US USER=db2inst1 CLASSPATH=.:/home/db2inst1/sqllib/java/db2java.zip:/home/db2inst1/sqllib/java/sqlj.zip:/home/db2inst1/sqllib/java/db2jcc.jar:/home/db2inst1/sqllib/java/db2jcc_license_cu.jar:.:/home/db2inst1/sqllib/java/db2java.zip:/wsdb/v81/bldsupp/AIX/jdk1.5.0_sr2/lib/classes.zip:/home/db2inst1/sqllib/java/sqlj.zip:/home/db2inst1/sqllib/java/runtime.zip:./test:/home/db2inst1/sqllib/java/db2jcc.jar:.:/home/db2inst1/sqllib/java/db2java.zip:/wsdb/v81/bldsupp/AIX/jdk1.5.0_sr2/lib/classes.zip:/home/db2inst1/sqllib/java/sqlj.zip:/home/db2inst1/sqllib/java/runtime.zip:./test:/home/db2inst1/sqllib/java/db2jcc.jar LOCPATH=/usr/lib/nls/loc ODMDIR=/etc/objrepos AIXTHREAD_SCOPE=S DB2SYSC_EXEC_OWNER=DB2 MALLOCOPTIONS=MULTIHEAP:16,BUCKETS PATH=/home/db2inst1/sqllib/bin:/home/db2inst1/sqllib/adm:/bin: LIBPATH=/home/db2inst1/sqllib/lib64:/home/db2inst1/sqllib/function:/home/db2inst1/sqllib/java/jdk64/jre/lib/ppc64:
$
UID
ibm13286815