IBM Support

75 ways to demystify DB2 #74: Techtip : How to find which environment variables are being used by DB2?

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:
$

 

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

UID

ibm13286815