Professional Web Applications Themes

Instance startup time - Informix

Hi folks, I know, I can find the uptime of an Informix instance in every onstat, but the date and time of the instance startup? Has anyone a nifty solution for that? TIA, Rüdiger...

  1. #1

    Default Instance startup time

    Hi folks,

    I know, I can find the uptime of an Informix instance
    in every onstat, but the date and time of the instance
    startup?

    Has anyone a nifty solution for that?

    TIA,

    Rüdiger
    Rüdiger Mähl Guest

  2. #2

    Default Re: Instance startup time

    Try onstat -g ntt, and use the open time of the poll or listener threads?

    On my system it's a few seconds before On-Line Mode appears in the message
    log.


    --
    [email]Philoninit.com[/email]


    Phil Rule Guest

  3. #3

    Default RE: Instance startup time


    Place the following lines in a file and execute the file ....u'll get the
    Day, Date, Month Year and Time when the Informix engine was last brought
    up...


    grep MSGPATH $INFORMIXDIR/etc/$ONCONFIG|grep -Ev "#.*MSGPATH" |read garb
    logfile
    logfile=`echo $logfile|cut -d"#" -f1`
    N=`grep -n ALARMPROG $logfile|cut -d":" -f1|tail -1`
    N=$(($N-5))
    tail +$N $logfile|head -5



    regards...
    __________________________________________________
    Rulesh Felix Rebello
    Informix DBA
    Off # 1-(876)-927-1125 X 3831
    Cell # 1-(876)-853-5702





    -----Original Message-----
    From: [email]owner-informix-listiiug.org[/email]
    [mailto:owner-informix-listiiug.org]On Behalf Of Rüdiger Mähl
    Sent: Wednesday, October 08, 2003 8:31 AM
    To: [email]informix-listiiug.org[/email]
    Subject: Instance startup time


    Hi folks,

    I know, I can find the uptime of an Informix instance
    in every onstat, but the date and time of the instance
    startup?

    Has anyone a nifty solution for that?

    TIA,

    Rüdiger

    sending to informix-list
    Rulesh Felix Rebello Guest

  4. #4

    Default Re: Instance startup time

    Hi,

    query the table sysshmvals from sysmaster database.
    This should help.

    Dani

    "Rulesh Felix Rebello" <rrebellofsl.org.jm> wrote in message news:<bm1k1u$kl3$1terabinaries.xmission.com>...
    > Place the following lines in a file and execute the file ....u'll get the
    > Day, Date, Month Year and Time when the Informix engine was last brought
    > up...
    >
    >
    > grep MSGPATH $INFORMIXDIR/etc/$ONCONFIG|grep -Ev "#.*MSGPATH" |read garb
    > logfile
    > logfile=`echo $logfile|cut -d"#" -f1`
    > N=`grep -n ALARMPROG $logfile|cut -d":" -f1|tail -1`
    > N=$(($N-5))
    > tail +$N $logfile|head -5
    >
    >
    >
    > regards...
    > __________________________________________________
    > Rulesh Felix Rebello
    > Informix DBA
    > Off # 1-(876)-927-1125 X 3831
    > Cell # 1-(876)-853-5702
    >
    >
    >
    >
    >
    > -----Original Message-----
    > From: [email]owner-informix-listiiug.org[/email]
    > [mailto:owner-informix-listiiug.org]On Behalf Of Rüdiger Mähl
    > Sent: Wednesday, October 08, 2003 8:31 AM
    > To: [email]informix-listiiug.org[/email]
    > Subject: Instance startup time
    >
    >
    > Hi folks,
    >
    > I know, I can find the uptime of an Informix instance
    > in every onstat, but the date and time of the instance
    > startup?
    >
    > Has anyone a nifty solution for that?
    >
    > TIA,
    >
    > Rüdiger
    >
    > sending to informix-list
    dangerer Guest

  5. #5

    Default Re: Instance startup time

    "Rüdiger Mähl" <ruediger.maehlweb.de> wrote:
    > Hi folks,
    >
    > I know, I can find the uptime of an Informix instance
    > in every onstat, but the date and time of the instance
    > startup?
    Someone sent me the following solution by personal e-mail:

    select dbinfo('UTC_TO_DATETIME',sh_boottime) from sysshmvals;

    Which is working for at least 7.31 and 9.30.

    Thanks a lot,

    Rüdiger
    Rüdiger Mähl Guest

Similar Threads

  1. Creating instance to CAcroPDDoc taking time
    By Rajeshrv@adobeforums.com in forum Adobe Acrobat SDK
    Replies: 1
    Last Post: March 25th, 12:05 PM
  2. Administrative Instance now looks like Instance Manager
    By Data_Gladiator in forum Coldfusion Server Administration
    Replies: 2
    Last Post: November 10th, 09:48 PM
  3. Reducing Initial Startup time in Flex 1.5
    By MShehzad in forum Macromedia Flex General Discussion
    Replies: 4
    Last Post: June 9th, 10:01 AM
  4. Trying to track an instance's position relative to the stage - instance is inside an MC
    By _posted.by\(Vern\); in forum Macromedia Flash Actionscript
    Replies: 1
    Last Post: January 20th, 04:52 AM
  5. Sound problems - new instance of sound starts each time a button is clicke
    By et10yl webforumsuser@macromedia.com in forum Macromedia Flash Sitedesign
    Replies: 3
    Last Post: December 13th, 08:46 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139