IBM Support

IC73564: DB2 ENVIRONMENT VARIABLES MAY NOT SET UP CORRECTLY IF AN INSTANCE IS STARTED AUTOMATICALLY.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • After performing a reboot of the machine on which DB2 resides,
    if there are any instances configured to start automatically
    using the db2iauto command, then they may not have the correct
    environment variables set up.
    
    There was a V97FP3 APAR to address this (IC68689). Issue
    still exists after applying this APAR.
    
    Steps to reproduce:
    
    1) set user profile like below:
    DSMI_CONFIG=/usr/local/etc/db2/dsm.opt.dsmicfg
    
    DSMI_DIR=/opt/tivoli/tsm/client/api/bin64
    DSMI_LOG=/proj/db2/home/dsmicfg/tsm HOSTNAME=serverA
    
    
    2) reboot system
    
    3) db2sysc environment after rebooting machine. However, an
    instance started automatically may only have the following:
    db2inst1@serverA:~> ps eww 8283
      PID TTY      STAT  TIME COMMAND
    8283 ?        Sl    0:01 db2sysc 0
    
    
    HOME=/ PWD=/ DB2INSTANCE=db2inst1 DB2INSTDEF=db2inst1 DB2LPORT=0
    DB2NODE=0 DB2SYSC_EXEC_OWNER=DB2
    PATH=/home/db2inst1/sqllib/bin:/home/db2inst1/sqllib/adm:/bin:/u
    sr/bin:
    LD_LIBRARY_PATH=/home/db2inst1/sqllib/lib32:/home/db2inst1/sqlli
    b/function:/home/db2inst1/sqllib/java/jdk32/jre/bin:/home/db2ins
    t1/sqllib/java/jdk32/jre/bin/classic:/home/db2inst1/sqllib/java/
    jdk32/jre/bin/j9vm
    
    From above, db2 didn't load 3 TSM variables such as DSMI_CONFIG,
    DSMI_DIR, and DSMI_LOG.
    
    4) stop/start instance
    db2inst1@serverA:~> ps eww 9061
      PID TTY      STAT  TIME COMMAND
    9061 pts/1    Sl    0:01 db2sysc 0
    
    
    HOME=/home/db2inst1 PWD=/home/db2inst1 DB2INSTANCE=db2inst1
    DB2INSTDEF=db2inst1 DB2LPORT=0 DB2NODE=0
    DSMI_CONFIG=/usr/local/etc/db2/dsm.opt.dsmicfg
    
    DSMI_DIR=/opt/tivoli/tsm/client/api/bin64
    DSMI_LOG=/proj/db2/home/dsmicfg/tsm HOSTNAME=serverA
    
    LANG=en_US.UTF-8 USER=db2inst1
    CLASSPATH=/home/db2inst1/sqllib/java/db2java.zip:/home/db2inst1/
    sqllib/java/db2jcc.jar:/home/db2inst1/sqllib/java/sqlj.zip:/home
    /db2inst1/sqllib/function:/home/db2inst1/sqllib/java/db2jcc_lice
    nse_cu.jar:.
    DB2SYSC_EXEC_OWNER=DB2
    PATH=/home/db2inst1/sqllib/bin:/home/db2inst1/sqllib/adm:/bin:/u
    sr/bin:
    LD_LIBRARY_PATH=/home/db2inst1/sqllib/lib32:/home/db2inst1/sqlli
    b/function:/home/db2inst1/sqllib/java/jdk32/jre/bin:/home/db2ins
    t1/sqllib/java/jdk32/jre/bin/classic:/home/db2inst1/sqllib/java/
    jdk32/jre/bin/j9vm
    
    Now the 3 TSM variables such as DSMI_CONFIG, DSMI_DIR, and
    DSMI_LOG are loaded on the environment.
    

Local fix

  • Stop/start instance manually
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * UNIX                                                         *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * After performing a reboot of the machine on which DB2        *
    * resides,                                                     *
    * if there are any instances configured to start automatically *
    *                                                              *
    * using the db2iauto command, then they may not have the       *
    * correct                                                      *
    * environment variables set up.                                *
    *                                                              *
    *                                                              *
    *                                                              *
    * There was a V97FP3 APAR to address this (IC68689). Issue     *
    *                                                              *
    * still exists after applying this APAR.                       *
    *                                                              *
    *                                                              *
    *                                                              *
    * Steps to reproduce:                                          *
    *                                                              *
    *                                                              *
    *                                                              *
    * 1) set user profile like below:                              *
    *                                                              *
    * DSMI_CONFIG=/usr/local/etc/db2/dsm.opt.dsmicfg               *
    *                                                              *
    *                                                              *
    *                                                              *
    * DSMI_DIR=/opt/tivoli/tsm/client/api/bin64                    *
    *                                                              *
    * DSMI_LOG=/proj/db2/home/dsmicfg/tsm HOSTNAME=serverA         *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    * 2) reboot system                                             *
    *                                                              *
    *                                                              *
    *                                                              *
    * 3) db2sysc environment after rebooting machine. However, an  *
    *                                                              *
    * instance started automatically may only have the following:  *
    *                                                              *
    * db2inst1@serverA:~> ps eww 8283                              *
    *                                                              *
    *   PID TTY      STAT  TIME COMMAND                            *
    *                                                              *
    * 8283 ?        Sl    0:01 db2sysc 0                           *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    * HOME=/ PWD=/ DB2INSTANCE=db2inst1 DB2INSTDEF=db2inst1        *
    * DB2LPORT=0                                                   *
    * DB2NODE=0 DB2SYSC_EXEC_OWNER=DB2                             *
    *                                                              *
    * PATH=/home/db2inst1/sqllib/bin:/home/db2inst1/sqllib/adm:/bi *
    * n:/u                                                         *
    * sr/bin:                                                      *
    *                                                              *
    * LD_LIBRARY_PATH=/home/db2inst1/sqllib/lib32:/home/db2inst1/s *
    * qlli                                                         *
    * b/function:/home/db2inst1/sqllib/java/jdk32/jre/bin:/home/db *
    * 2ins                                                         *
    * t1/sqllib/java/jdk32/jre/bin/classic:/home/db2inst1/sqllib/j *
    * ava/                                                         *
    * jdk32/jre/bin/j9vm                                           *
    *                                                              *
    *                                                              *
    *                                                              *
    * From above, db2 didn't load 3 TSM variables such as          *
    * DSMI_CONFIG,                                                 *
    * DSMI_DIR, and DSMI_LOG.                                      *
    *                                                              *
    *                                                              *
    *                                                              *
    * 4) stop/start instance                                       *
    *                                                              *
    * db2inst1@serverA:~> ps eww 9061                              *
    *                                                              *
    *   PID TTY      STAT  TIME COMMAND                            *
    *                                                              *
    * 9061 pts/1    Sl    0:01 db2sysc 0                           *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    * HOME=/home/db2inst1 PWD=/home/db2inst1 DB2INSTANCE=db2inst1  *
    *                                                              *
    * DB2INSTDEF=db2inst1 DB2LPORT=0 DB2NODE=0                     *
    *                                                              *
    * DSMI_CONFIG=/usr/local/etc/db2/dsm.opt.dsmicfg               *
    *                                                              *
    *                                                              *
    *                                                              *
    * DSMI_DIR=/opt/tivoli/tsm/client/api/bin64                    *
    *                                                              *
    * DSMI_LOG=/proj/db2/home/dsmicfg/tsm HOSTNAME=serverA         *
    *                                                              *
    *                                                              *
    *                                                              *
    * LANG=en_US.UTF-8 USER=db2inst1                               *
    *                                                              *
    * CLASSPATH=/home/db2inst1/sqllib/java/db2java.zip:/home/db2in *
    * st1/                                                         *
    * sqllib/java/db2jcc.jar:/home/db2inst1/sqllib/java/sqlj.zip:/ *
    * home                                                         *
    * /db2inst1/sqllib/function:/home/db2inst1/sqllib/java/db2jcc_ *
    * lice                                                         *
    * nse_cu.jar:.                                                 *
    *                                                              *
    * DB2SYSC_EXEC_OWNER=DB2                                       *
    *                                                              *
    * PATH=/home/db2inst1/sqllib/bin:/home/db2inst1/sqllib/adm:/bi *
    * n:/u                                                         *
    * sr/bin:                                                      *
    *                                                              *
    * LD_LIBRARY_PATH=/home/db2inst1/sqllib/lib32:/home/db2inst1/s *
    * qlli                                                         *
    * b/function:/home/db2inst1/sqllib/java/jdk32/jre/bin:/home/db *
    * 2ins                                                         *
    * t1/sqllib/java/jdk32/jre/bin/classic:/home/db2inst1/sqllib/j *
    * ava/                                                         *
    * jdk32/jre/bin/j9vm                                           *
    *                                                              *
    *                                                              *
    *                                                              *
    * Now the 3 TSM variables such as DSMI_CONFIG, DSMI_DIR, and   *
    *                                                              *
    * DSMI_LOG are loaded on the environment.                      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7 Fix Pack 5                        *
    ****************************************************************
    

Problem conclusion

  • First fixed in Version 9.7 Fix Pack 5.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC73564

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-12-28

  • Closed date

    2011-12-21

  • Last modified date

    2011-12-21

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC73564

Modified date: 21 December 2011