DB2INSTANCE error during sapinst 'Start Instance' step.

[Former Member]

Hi everyone,

I've been trying to figure this problem out and unfortunately no forum topics were helpful so far.

I decided to post my problem here.

During my sapinst central system installation, the 'Start instance' step (39/47) pops an error:

"Instance FDV/DVEBMGS10 reached state SHUTDOWN after having state STARTING. Giving up"

see attached screenshot

To dig deeper into the problem, I've learned to check the Db2 trace files (/usr/sap/FDV/DVEBMGS10/work/dev_w0).

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

dev_w0 file:

---------------------------------------------------

trc file: "dev_w0", trc level: 1, release: "720"

---------------------------------------------------

*

*  ACTIVE TRACE LEVEL           1

*  ACTIVE TRACE COMPONENTS      all, MJ

*

M sysno      10

M sid        FDV

M systemid   390 (AMD/Intel x86_64 with Linux)

M relno      7200

M patchlevel 0

M patchno    100

M intno      20020600

M make       single threaded, Unicode, 64 bit, optimized

M profile    /usr/sap/FDV/SYS/profile/FDV_DVEBMGS10_FERPDEV1

M pid        3785

M

M

M Thu Jul 19 16:26:33 2012

M  kernel runs with dp version 131000(ext=118000) (@(#) DPLIB-INT-VERSION-131000-UC)

M  length of sys_adm_ext is 588 bytes

M  ThStart: taskhandler started

M  ThInit: initializing DIA work process W0

M  ***LOG Q01=> ThInit, WPStart (Workp. 0 1 3785) [thxxhead.c   1318]

M

M Thu Jul 19 16:26:34 2012

M  ThInit: running on host FERPDEV1

M  calling db_connect ...

B  Loading DB library '/usr/sap/FDV/DVEBMGS10/exe/dbdb6slib.so' ...

B  Library '/usr/sap/FDV/DVEBMGS10/exe/dbdb6slib.so' loaded

B  Version of '/usr/sap/FDV/DVEBMGS10/exe/dbdb6slib.so' is "720.00", patchlevel (0.92)

C  DbSl trace SM50: switch request to level 1

C  Registering callback for dynamic profile parameters

C  *** ERROR in DbSlConnectDB6[dbsldb6.c, 1292] CON = 0 (BEGIN)

C  &+     DbSlConnectDB6: DB2DBDFT not set in environment

C  DB2INSTANCE not set in environment

C

C  &+

C  &+

C  *** ERROR in DbSlConnectDB6[dbsldb6.c, 1292] (END)

M  ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c   1487]

M  in_ThErrHandle: 1

M  *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c   11295]

M

M  Info for wp 0

M

M    pid = 3785

M    severity = 0

M    status = 0

M    stat = WP_NEW

M    waiting_for = NO_WAITING

M    reqtype = DP_RQ_DIAWP

M    act_reqtype = NO_REQTYPE

M    req.req_info =

M    req.tid = -1

M    req.uid = 4294967295

M    req.mode = 255

M    req.len = 0

M    req.rq_id = 65535

M    req.rq_source =

M    last_tid = 0

M    last_uid = 0

M    last_mode = 0

M    act_cs_count = 0

M    csTrack = 0

M    csTrackRwExcl = 0

M    csTrackRwShrd = 0

M    mode_cleaned_counter = 0

M    control_flag = 0

M    int_checked_resource(RFC) = 0

M    ext_checked_resource(RFC) = 0

M    int_checked_resource(HTTP) = 0

M    ext_checked_resource(HTTP) = 0

M    report = >                                        <

M    action = 0

M    tab_name = >                              <

M    attachedVm = no VM

M

M  ThIErrHandle: current request:

M

M  -IN-- sender_id ?                 tid  -1    wp_ca_blk   -1      wp_id -1

M  -IN-- action    -                 uid  -1    appc_ca_blk -1      type  -

M  -IN-- new_stat  NO_CHANGE         mode 255   len         0       rq_id -1

M  PfStatDisconnect: disconnect statistics

M  Entering TH_CALLHOOKS

M  ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M  *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c   779]

M  *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c  303]

M  ThCallHooks: call hook >ThrBtcCallLgCl< for event BEFORE_DUMP

M  ThCallHooks: hook >ThrBtcCallLgCl< o.k.

M  ThIErrHandle: entering ThSetStatError

M  ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)

M  Entering ThReadDetachMode

M  call ThrShutDown (1)...

M  ***LOG Q02=> wp_halt, WPStop (Workp. 0 3785) [dpuxtool.c   327]

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

I already tried rebooting the server and still no go.

Expecting that SAPINST declare all needed environment variables, i wonder what caused the program to skip over this step.

I'll be happy to post any other info needed.

Thanks and Regards

[Former Member · Accepted solution]

Issue has been resolved. Installation Media has been compromised. I just recopied everything from the CDs and reexecuted the installation steps.

[Former Member]

im using DB2 UDB for RHEL 6.3. This happens on the last 'Start instance' step from my installation. What i don't understand is why does this happen on a fresh installation?

Other than LABEL.ASC verification, does SAPINST verify the integrity of the installation media?

[former_member189725]

can you please login as user fdvadm and run the env command and paste the output here .

Please check under /home/fdvadm the file .dbenv_<hostname>.csh exists and is owned by fdvadm user.

Regards

Ratnajit

[Former Member]

Here's the output of the 'env' command:

[fdvadm@FERPDEV1 ~]$ env

HOSTNAME=FERPDEV1

SHELL=/bin/bash

TERM=xterm

HISTSIZE=1000

QTDIR=/usr/lib64/qt-3.3

QTINC=/usr/lib64/qt-3.3/include

USER=fdvadm

LS_COLORS=rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:mi=01;05;37;41:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lz=01;31:*.xz=01;31:*.bz2=01;31:*.tbz=01;31:*.tbz2=01;31:*.bz=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=01;36:*.au=01;36:*.flac=01;36:*.mid=01;36:*.midi=01;36:*.mka=01;36:*.mp3=01;36:*.mpc=01;36:*.ogg=01;36:*.ra=01;36:*.wav=01;36:*.axa=01;36:*.oga=01;36:*.spx=01;36:*.xspf=01;36:

MAIL=/var/spool/mail/fdvadm

PATH=/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/fdvadm/bin

PWD=/home/fdvadm

LANG=en_US.UTF-8

SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass

HISTCONTROL=ignoredups

SHLVL=1

HOME=/home/fdvadm

LOGNAME=fdvadm

QTLIB=/usr/lib64/qt-3.3/lib

CVS_RSH=ssh

LESSOPEN=|/usr/bin/lesspipe.sh %s

DISPLAY=:0.0

G_BROKEN_FILENAMES=1

_=/bin/env

[fdvadm@FERPDEV1 ~]$

The .dbenv_<hostname>.csh file are owned by the fdvadm user.

What I'm really confused about is why alot of variables are not set? especially during an installation.

For example: User db2adm's DSCDB6HOME and DB6EKEY variables are not set.

[former_member189725]

can you check login as <sid>adm and execute

source .cshrc

then run env command and paste the output .

Regards

Ratnajit

[Former Member]

Hi Brian,

We have encountered same problem with our installation (We are installing Solman 7.1). Have you figured out any solution to that?

Our system is Red Hat Enterprise Linux 5

Regards,

Bablu Yadav.

[Former Member]

hi,

which database you are installating?

there is issue in connecting with database.

so check Db is up and u can connect with it

regards,

Meenakshi