Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2003
    Posts
    8

    Unanswered: DB2 Ver 7 on AIX 5 - unable to stop database

    The problem I am having is I am unable to stop a database using the normal db2 commands and even by using the force commands.


    Does anyone have any suggestions, on what I could maybe check, appologies for the lack of detail.

    Regards

    MultiD

  2. #2
    Join Date
    Sep 2002
    Posts
    456

    Re: DB2 Ver 7 on AIX 5 - unable to stop database

    There is no such command to stop the database AFAIK. You can however force the applications off the system or quiesce it but it's not synchronous.

    dollar

    Originally posted by MultiD
    The problem I am having is I am unable to stop a database using the normal db2 commands and even by using the force commands.


    Does anyone have any suggestions, on what I could maybe check, appologies for the lack of detail.

    Regards

    MultiD

  3. #3
    Join Date
    Jan 2004
    Location
    Tallahassee, FL, USA
    Posts
    96

    Re: DB2 Ver 7 on AIX 5 - unable to stop database

    Originally posted by MultiD
    The problem I am having is I am unable to stop a database using the normal db2 commands and even by using the force commands.


    Does anyone have any suggestions, on what I could maybe check, appologies for the lack of detail.

    Regards

    MultiD

    if you not able shut down instance , even by db2stop force.

    use

    run

    ipclean as instance owner

    check if ny shared process hanging by using following command


    ipcs | grep instance


    clean those threads by using following command

    ipcrm


    ipcrm -m/q/s pid


    after cleaning all hanging threads

    start instance

    db2start


    that will work for you


    Let me know , if any questions


    Lekharaju Ennam
    Certified Oracle8i & DB2 UDB DBA
    FLorida A& M University

  4. #4
    Join Date
    Jun 2003
    Posts
    8

    Talking in reply

    Cheers, will give that a go

Posting Permissions

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