Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2008
    Posts
    62

    Unanswered: start/stop sattus

    Anybody knows...

    How to get the status of an instance, [whether it is start or stop.] ?

    Is there any command for this?

  2. #2
    Join Date
    Mar 2008
    Posts
    136
    u can run
    ps -ef|grep db2

    Regards
    pawan

  3. #3
    Join Date
    Mar 2008
    Posts
    136
    db2 get instance

  4. #4
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    You can configure health centre to inform you when instance goes down\quiesced ....
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  5. #5
    Join Date
    Feb 2008
    Posts
    62
    "db2ilist" will show all live & dead instances.

    db2 get instance will show the current instance it may be in stoped state.

    ps -ef|grep db2 will show all db2 processes which r running in background, But even if instance is stopped by db2stop, it will show some db2 processes running. So this option is also not satisfy desired result. .

    And i am working on Unix platform(no GUI). I dont know how to use "Helth Center" in unix.

    Any Other Option to get the start/stop status of instances????

  6. #6
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    You can attach to the instance. If it is running the attach will be sucessful. If it is down, it will say:
    SQL1032N No start database manager command was issued. SQLSTATE=57019
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  7. #7
    Join Date
    Feb 2008
    Posts
    62
    You are right Marcus. Thanx!


    Quote Originally Posted by Marcus_A
    You can attach to the instance. If it is running the attach will be sucessful. If it is down, it will say:
    SQL1032N No start database manager command was issued. SQLSTATE=57019

Posting Permissions

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