Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2004
    Posts
    54

    Unanswered: Instance update problem..

    I installed the last fixpack of DB2 Udb Ese 64-bit (FP17_MI00252.tar) but I can not update the instance with command:
    /opt/IBM/db2/V8.1/instance/db2iupdt db2inst1

    "
    In fact this is the error:
    DBI1250E Applications are still using instance
    db2inst1.

    Explanation:
    There are applications that are still running that are using the
    specified instance. All applications using this instance must be
    terminated before the command can be completed successfully. You
    can get a list of the applications that are currently using the
    instance by issuing the command:

    db2 list applications

    User Response:
    You can either wait for the applications to end by themselves, or
    you can explicitly force the applications to end. You can logon
    as the instance owner and run the command

    db2 force application all

    Note that some applications may have unexpected behaviour when
    terminated using the above command. After all the applications
    have stopped, stop the database manager using "db2istop"
    command.

    DBI1122E Instance db2inst1 cannot be updated.
    "

    but I don't have any DB2 processes and I follow the readme of the FIXPACK, that is:

    as db2inst1:

    db2
    db2stop
    update dbm cfg using sysadm_group db2grp1
    db2start
    force applications all
    db2stop force
    terminate
    db2licd -end
    exit
    db2_kill

    as dasusr1:
    db2admin stop

    as root:
    db2fmcu -d
    db2fm -D
    $HOME/sqllib/bin/ipclean
    ipclean
    slibclean
    ipcrm

    fixpack:
    ./installFixPak -y

    The installation was ok but I can't understand why I have that problem...

    Best regards.
    Fabio

  2. #2
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    Did you run
    Code:
    db2 list applications
    or alternatively try doing
    Code:
    ps -elf|fgrep db2
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

  3. #3
    Join Date
    Apr 2004
    Posts
    54
    Thank you Peter for the answer, but I also did it. In fact there isn't DB2 process:

    iv-db201:~ # ps -ef
    UID PID PPID C STIME TTY TIME CMD
    root 1 0 0 Feb10 ? 00:00:07 init [5]
    root 2 1 0 Feb10 ? 00:00:00 [migration/0]
    root 3 1 0 Feb10 ? 00:00:00 [ksoftirqd/0]
    root 4 1 0 Feb10 ? 00:00:00 [migration/1]
    root 5 1 0 Feb10 ? 00:00:00 [ksoftirqd/1]
    root 6 1 0 Feb10 ? 00:00:00 [events/0]
    root 7 1 0 Feb10 ? 00:00:00 [events/1]
    root 8 6 0 Feb10 ? 00:00:00 [kacpid]
    root 9 6 0 Feb10 ? 00:00:00 [kblockd/0]
    root 10 6 0 Feb10 ? 00:00:00 [kblockd/1]
    root 13 6 0 Feb10 ? 00:00:00 [khelper]
    root 16 1 0 Feb10 ? 00:00:02 [kswapd1]
    root 17 1 0 Feb10 ? 00:00:01 [kswapd0]
    root 18 6 0 Feb10 ? 00:00:00 [aio/0]
    root 19 6 0 Feb10 ? 00:00:00 [aio/1]
    root 127 1 0 Feb10 ? 00:00:00 [kseriod]
    root 196 1 0 Feb10 ? 00:00:00 [scsi_eh_0]
    root 311 6 0 Feb10 ? 00:00:00 [reiserfs/0]
    root 312 6 0 Feb10 ? 00:00:00 [reiserfs/1]
    root 818 6 0 Feb10 ? 00:00:00 [kcopyd]
    root 1162 1 0 Feb10 ? 00:00:00 /usr/sbin/irqbalance
    root 2023 1 0 Feb10 ? 00:00:00 [khubd]
    root 2591 1 0 Feb10 ? 00:00:00 /sbin/syslogd -a /var/lib/dhcp/dev/log -a /var/lib/named/dev/log -a /var/lib/n
    root 2594 1 0 Feb10 ? 00:00:00 /sbin/klogd -c 1 -2 -x
    root 2652 1 0 Feb10 ? 00:00:00 /sbin/resmgrd
    bin 2658 1 0 Feb10 ? 00:00:00 /sbin/portmap
    root 2890 1 0 Feb10 ? 00:00:00 [smbiod]
    root 3045 1 0 Feb10 ? 00:00:00 [hwscand]
    root 3502 1 0 Feb10 ? 00:00:00 /usr/sbin/powersaved -d -e /etc/powersave.conf -n -a resmgr -v 3
    daemon 3731 1 0 Feb10 ? 00:00:00 /usr/sbin/slpd
    lp 4072 1 0 Feb10 ? 00:00:00 /usr/sbin/cupsd
    root 4100 1 0 Feb10 ? 00:00:25 /usr/sbin/nscd
    root 4206 1 0 Feb10 ? 00:00:00 /usr/lib/postfix/master
    postfix 4252 4206 0 Feb10 ? 00:00:00 qmgr -l -t fifo -u
    root 4270 1 0 Feb10 ? 00:00:00 /usr/sbin/cron
    root 4273 1 0 Feb10 ? 00:00:00 /usr/sbin/xinetd
    root 4413 1 0 Feb10 tty1 00:00:00 /sbin/mingetty --noclear tty1
    root 4414 1 0 Feb10 tty2 00:00:00 /sbin/mingetty tty2
    root 4415 1 0 Feb10 tty3 00:00:00 /sbin/mingetty tty3
    root 4416 1 0 Feb10 tty4 00:00:00 /sbin/mingetty tty4
    root 4417 1 0 Feb10 tty5 00:00:00 /sbin/mingetty tty5
    root 4418 1 0 Feb10 tty6 00:00:00 /sbin/mingetty tty6
    root 6551 1 0 Feb11 ? 00:00:00 /usr/sbin/sshd -o PidFile=/var/run/sshd.init.pid
    root 7958 6 0 Feb11 ? 00:00:00 [pdflush]
    root 17967 7 0 Feb11 ? 00:00:05 [pdflush]
    postfix 23821 4206 0 06:37 ? 00:00:00 pickup -l -t fifo -u
    root 17997 6551 0 08:11 ? 00:00:00 sshd: root@pts/0
    root 18000 17997 0 08:11 pts/0 00:00:00 -bash

    I don't understand what, which and where there is a cause of the impossibility to use the db2iupdt command..

    Best regards
    Fabio

  4. #4
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    Seems like your system is not in intensive use.
    Did you consider a reboot?
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

  5. #5
    Join Date
    Apr 2004
    Posts
    54
    I already did it, without startup scripts.. :-(

  6. #6
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    looks like this is on Linux. you may try creating the following link and then update the instance:

    ln -s /opt/IBM/db2/V8.1/lib/libdb2gcf.so /usr/lib/libdb2gcf.so

  7. #7
    Join Date
    Apr 2004
    Posts
    54
    Hi db2girl!

    Hear a part of my directory "lib":
    .
    .
    .
    -r-xr-xr-x 1 bin bin 6740 2008-08-29 14:51 libdb2ehreg.so.1
    lrwxrwxrwx 1 root root 15 2009-02-11 08:19 libdb2eplc.so -> libdb2eplc.so.1
    -r-xr-xr-x 1 bin bin 838074 2008-08-29 14:51 libdb2eplc.so.1
    lrwxrwxrwx 1 root root 12 2009-02-11 08:19 libdb2e.so -> libdb2e.so.1
    -r-xr-xr-x 1 bin bin 55565678 2008-08-29 14:51 libdb2e.so.1
    lrwxrwxrwx 1 root root 15 2009-02-11 08:18 libdb2g11n.so -> libdb2g11n.so.1
    -r-xr-xr-x 1 bin bin 649760 2008-08-29 14:52 libdb2g11n.so.1
    lrwxrwxrwx 1 root root 14 2009-02-11 08:19 libdb2gcf.so -> libdb2gcf.so.1
    -r-xr-xr-x 1 bin bin 68918 2008-08-29 14:51 libdb2gcf.so.1
    lrwxrwxrwx 1 root root 17 2009-02-11 08:18 libdb2genreg.so -> libdb2genreg.so.1
    -r-xr-xr-x 1 bin bin 278630 2008-08-29 14:52 libdb2genreg.so.1
    lrwxrwxrwx 1 root root 15 2009-02-11 08:19 libdb2hmon.so -> libdb2hmon.so.1
    -r-xr-xr-x 1 bin bin 2918418 2008-08-29 14:51 libdb2hmon.so.1
    lrwxrwxrwx 1 root root 15 2009-02-11 08:18 libdb2hrec.so -> libdb2hrec.so.1
    -r-xr-xr-x 1 bin bin 585796 2008-08-29 14:52 libdb2hrec.so.1
    .
    .
    .

    and where I have libdb2gcf in Suse:
    db2inst8@iv-db201:/> locate libdb2gcf
    /opt/IBM/db2/V8.1/das/lib/libdb2gcf.so
    /opt/IBM/db2/V8.1/das/lib/libdb2gcf.so.1
    /opt/IBM/db2/V8.1/das/lib64/libdb2gcf.so
    /opt/IBM/db2/V8.1/das/lib64/libdb2gcf.so.1
    /opt/IBM/db2/V8.1/lib/libdb2gcf.so
    /opt/IBM/db2/V8.1/lib/libdb2gcf.so.1
    /opt/IBM/db2/V8.1/lib64/libdb2gcf.so
    /opt/IBM/db2/V8.1/lib64/libdb2gcf.so.1

    thank you.
    Fabio

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •