Results 1 to 9 of 9

Thread: db2iupdt

  1. #1
    Join Date
    Jun 2011
    Posts
    39

    Unanswered: db2iupdt

    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

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    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
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    "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.

  4. #4
    Join Date
    Jun 2011
    Posts
    39
    I reread the manual and did as follows:

    [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

    [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:

  5. #5
    Join Date
    Jun 2011
    Posts
    39
    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

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    yes, db2inst1

    BTW, I don't see you stopping db2inst1 from the commands you have provided.
    You are stopping only db2admin server
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  7. #7
    Join Date
    Jun 2011
    Posts
    39
    How do I kill or stop the db2inst1

    I tried the ipclean command, but I get a command not found

  8. #8
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    from root
    su - db2inst1

    db2stop force
    ipclean

    exit
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  9. #9
    Join Date
    Jun 2011
    Posts
    39
    The db2stop force worked great

    Thanks. I appreciate it

Posting Permissions

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