If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Instance update problem..

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-11-09, 03:51
petitof petitof is offline
Registered User
 
Join Date: Apr 2004
Posts: 54
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
Reply With Quote
  #2 (permalink)  
Old 02-11-09, 11:53
Peter.Vanroose Peter.Vanroose is offline
Registered User
 
Join Date: Sep 2004
Location: Belgium
Posts: 1,079
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/
Reply With Quote
  #3 (permalink)  
Old 02-12-09, 02:20
petitof petitof is offline
Registered User
 
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
Reply With Quote
  #4 (permalink)  
Old 02-12-09, 05:01
Peter.Vanroose Peter.Vanroose is offline
Registered User
 
Join Date: Sep 2004
Location: Belgium
Posts: 1,079
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/
Reply With Quote
  #5 (permalink)  
Old 02-12-09, 06:06
petitof petitof is offline
Registered User
 
Join Date: Apr 2004
Posts: 54
I already did it, without startup scripts.. :-(
Reply With Quote
  #6 (permalink)  
Old 02-12-09, 08:21
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
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
Reply With Quote
  #7 (permalink)  
Old 02-12-09, 09:15
petitof petitof is offline
Registered User
 
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On