db2iupdt

Gideon22 · #1 (**permalink**) 07-13-11, 17:12

I am trying to run the db2icupdtcommand, but am getting an error:

Code:

[root@power730 instance]# whoami
root
[root@power730 instance]# pwd
/opt/ibm/db2/V9.7/instance
[root@power730 instance]# ./db2iupdt db2inst1
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

So I perform the following:

Code:

[root@power730 instance]# su - db2inst1
[db2inst1@power730 ~]$ db2 list applications
SQL1611W  No data was returned by Database System Monitor.
[db2inst1@power730 ~]$

What should I do at this point

Thanks

sathyaram_s · #2 (**permalink**) 07-13-11, 17:15

Is your instance stopped?

Check if your database is active

db2 list active databases

If a db is listed, then
db2 deactivate db <dbname>

Stop the instance using db2stop and issue ipclean to remove ipcs.

Now su to root and try db2iupdt

HTH

Sathyaram

n_i · #3 (**permalink**) 07-13-11, 17:16

"db2 list applications" shows applications connected to databases, but not those that are attached to the instance. Make sure you stop the instance and all instance processes are gone before updating, as described in the manual.

Gideon22 · #4 (**permalink**) 07-13-11, 18:04

I reread the manual and did as follows:

Quote:

[root@power730 instance]# su - db2user
[db2user@power730 ~]$ . das/dasprofile
[db2user@power730 ~]$ db2admin stop
SQL4407W The DB2 Administration Server was stopped successfully.
[db2user@power730 ~]$ db2admin start
SQL4406W The DB2 Administration Server was started successfully.

But I still get the same response

Quote:

[root@power730 instance]# su - db2user
[db2user@power730 ~]$ . das/dasprofile
[db2user@power730 ~]$ db2admin stop
SQL4407W The DB2 Administration Server was stopped successfully.
[db2user@power730 ~]$ db2admin start
SQL4406W The DB2 Administration Server was started successfully.
[db2user@power730 ~]$
[db2user@power730 ~]$
[db2user@power730 ~]$ exit
logout
[root@power730 instance]# whoami
root
[root@power730 instance]# .db2iupdt db2inst1
-bash: .db2iupdt: command not found
[root@power730 instance]# ./db2iupdt db2inst1
DBI1250E Applications are still using instance db2inst1.

Explanation:

Gideon22 · #5 (**permalink**) 07-13-11, 18:05

I do not understand from where to run the following command:

db2 list active databases

Which user name should I be running this under ? db2inst1 ?

Thanks